![](_page_0_Picture_0.jpeg)

#### **Module 1: What is SQL?**

- Types of databases
- Keys, Primary Keys, Foreign Keys
- Data Types
- Constraints

#### **Module 2: SQL Commands**

DDL (Data Definition Language)

- Create
- Drop
- Alter
- Truncate

### DML (Data Manipulation Language)

- Insert
- Update
- Delete

DCL (Data Control Language)

- Grant
- Revoke

TCL (Transaction control statement)

- Commit
- Roll back
- Save Point

DQL (Data Query Language)

• Select

# **Module 3: Constraints**

- NOT NULL
- DEFAULT
- UNIQUE
- PRIMARY
- CHECK

![](_page_1_Picture_0.jpeg)

#### **Module 4: The SELECT statement**

- Select Query Basics
- Select with Where clause
- Select data (In & Between)
- Select data (With Sorting)
- Select Unique data (Distinct)
- Aggregate Function (SUM, AVERAGE, COUNT, MAX and MIN)

## **Module 5: Joins, Grouping**

### **GROUPS**

- Group By Clause
- Having Clause
- Order By Clause

## **JOINS**

- Cross Join
- Inner Join
- Outer Joins (Left, Right and full outer join)

# **VIEW**

• Introduction