Introduction to mySQL

Introduction to Structured Query Language (SQL)

S.Q.L

SQL Data Definition Commands

SQL Data Definition Commands
(continued)

SQL Data Definition Commands
(continued)

SQL Statements

SELECT Statement

Example : SELECT Statement

Projection (π)

Projection (π) continued..

Selection (σ)

Selection (σ) continued...

SELECT Statement - Aggregates

SELECT Statement - Aggregates
(continued)

Example: Use of COUNT(*)

Example : Use of COUNT and SUM

Example : Use of MIN, MAX, AVG

Example : Use of HAVING