Statement
1
Getting Started
1.1
What is SQL?
2
Data Models and Diagrams
2.1
Think Before Code
2.2
What is Data Model?
2.3
Retrive Data with
SELECT
2.4
Create Table
2.5
SQL Comments
2.6
Summary
3
Filtering, Sorting, and Calculating Data with SQL
3.1
Filter
3.1.1
WHERE
3.1.2
IN
,
OR
and
NOT
3.2
Sort
3.3
Math Operations
3.4
Aggregrate Functions
3.5
Group Data
3.6
Summary
4
Subqueries and Joins
4.1
Subqueries
4.2
Joins
5
Modifying and Analyzing Data with SQL
5.1
Text Strings
5.2
Date and Time Strings
SQL for Data Science
Chapter 4
Subqueries and Joins