SELECT

DISTINCT

WHERE

LIKE

ORDER BY

AS

JOIN

UNION

GROUP BY

CASE

DISTINCT

WHERE

LIKE

ORDER BY

AS

JOIN

UNION

GROUP BY

CASE

Basics (functions, classes, clauses)

Join types

Examples (easy to advanced)

Advanced topics:

- recursive queries

- window functions

- common table expressions (CTEs)

- pivot tables

- analytic functions

- triggers

- stored procedures

- indexes

- cursor-based processing

Join types

Examples (easy to advanced)

Advanced topics:

- recursive queries

- window functions

- common table expressions (CTEs)

- pivot tables

- analytic functions

- triggers

- stored procedures

- indexes

- cursor-based processing

1. Finding and deleting duplicate records from a table

2. Querying the most recent set of records from a table

3. Aggregate daily data at monthly or week-beginning/week-ending level

4. Aggregating data on custom (CASE WHEN) categories

5. Find the difference between today and yesterday (or any two dates) in the same table

6. Merge data from one table into another (the easy way)

2. Querying the most recent set of records from a table

3. Aggregate daily data at monthly or week-beginning/week-ending level

4. Aggregating data on custom (CASE WHEN) categories

5. Find the difference between today and yesterday (or any two dates) in the same table

6. Merge data from one table into another (the easy way)

DISTINCT

UNION

ORDER BY

LIMIT and OFFSET

WINDOW

UNION

ORDER BY

LIMIT and OFFSET

WINDOW

1. SQL Views

2. Stored Procedures

3. Scalar functions

2. Stored Procedures

3. Scalar functions