Overview of SQL Syllabus

Select Statement

Select Distinct

Select Where Clause

Order By

Limit

Like, Between and In operators

Wildcard Operators

And, Or and Not

Group By

Aggregate Functions (Count, Min, Max, Sum & Avg)

Having

Overview of Joins

Inner Join

Left Outer Join

Right Outer Join

Full Outer Join

Union and Union All

Overview of Advanced SQL Commands

Timestamps and Extract

To_CHAR

Subquery

Self-Join

Primar Key and Foreign Key

Constraints

Create Table

Insert, Update and Delete

Alter Table

Delete, Drop and Truncate

Case

Coalesce and Nullif

Views

Rank, Dense Rank and Row Number

Lead and Lag

Listagg and Lateral Flattern

Pivot Table

Cast and Convert

SQL Functions