SQL syntax tested under DB Browser for SQLite.

I. SQL Introduction

1. SELECT

2. WHERE

3. GROUP BY

4. HAVING

5. ORDER BY

6. JOIN

7. AGGREGATE FUNCTIONS

8. WINDOW FUNCTIONS

8.1. AGGREGATE WINDOW FUNCTION

8.2. RANKING WINDOW FUNCTION

8.3. VALUE WINDOW FUNCTION

9. COMMON TABLE EXPRESSION (CTE)

10. VIEWS

11. CREATE TABLE as SELECT (CTAS)

12. CREATE DROP ALTER

13. DATE and TIME FUNCTIONS

14. NULL FUNCTIONS

II. SQL Intermediate

1. SQL Function: COMING SOON

2. Stored Procedure: COMING SOON

2. INDEXING: COMING SOON

3. TRIGERING: COMING SOON

II. Problem and Solution

1. NULL in JOINING Table

2. NULL in SORTING

3. JOINING GROUPING and AGGREGATING

4. COMING SOON

III. Best Practices

1. WHERE Before JOIN

2. Avoid Function in WHERE Clause

3. Filtering Before Joining

4. UNION vs OR

5. Aggregating Before Joining

6. JOIN vs EXISTS vs IN

IV. Projects

1. COMING SOON

2. COMING SOON

3. COMING SOON

4. COMING SOON