Installing the working environment

SQL syntax theory

SELECT Statement theory

SELECT Statement hands-on

SELECT DISTINCT Theory

SELECT DISTINCT hands-on

WHERE Statement theory

WHERE Statement hands-on

Count rows theory

Count rows hands-on

Insert data theory

Insert data hands-on

NULL OP Theory

NULL and Not OP hands-on

UPDATE DATA RECORDS theory

UPDATE DATA RECORDS hands-on

DELETE Data theory

DELETE Data hands-on

Operators IN – NOT IN theory

Operators – IN and Not IN

SQL Logical Operators theory

Operators- logical op hands-on

Operators – Arithmetic op hands-on

Operators – Comparisons hands-on

Operators- SQL BETWEEN and NOT hands-on

Data Types

Ordering theory

LIMIT with Conditions hands-on

Smallest and Largest Values hands-on

Counting records with different ways hands-on

Average of numeric columns hands-on

Total sum for numerics hands-on

Create DB and Tables hands-on

Deleting new Orders hands-on

ALTER ADD OR DELETE fields hands-on

Renaming tables hands-on

Constraints theory

Constraints hands-on

Joining tables hands-on

Combining result-sets hands-on

Power of Aliases hands-on

Set conditions hands-on

About Exercise

Exercise solution