1 -Course Contents
2 -What is a Database
3 -Data Warehouse analogy
4 -What is SQL
5 -What is the SQL interview
6 -Coding section format
7 -Creating an Account
8 -UI Explanation
9 -How to create your Database
10 -Select
11 -Data Types
12 -Selecting and Filtering
13 -Selecting and Filtering Example
14 -Ordering
15 -Ordering Example
16 -Selecting and Filtering on multiple conditions
17 -Selecting and Filtering on multiple conditions Example
18 -Ordering and Filtering Example
19 -Limiting
20 -Limiting Example
21 -Limiting and Ordering Example
22 -Advanced Filtering using Like
23 -Advanced Filtering using Like Example
24 -Aggregations
25 -Aggregations Example
26 -Filtering on Aggregations
27 -Filtering on Aggregations Example
28 -Joining Theory
29 -Joining Tables
30 -Case Statements
31 -Case Statements Example
32 -Set Operations
33 -Set Operations Example
34 -Formatting SQL commands
35 -SQL Strategy
36 -Continue your Journey