Chapter 1: Intro & The Basics

0: Intro & Setup

1: Limit & Top

2: Data Types & Cast

3: String Manipulation

4: Arithmetic Operators

Chapter 2: Filtering Datasets & Wildcards

1: Filtering w/ WHERE

2: Boolean Logical Operators

3: Between & NOT Between

4: IN & NOT IN

5: Is Null, If Null, & Is Not Null

6: Wildcards

7: Like vs. iLike & Wildcard Variations

Chapter 3: Functions, Dates, & Grouping

1: Aggregate Functions

2: Count(*) vs. Count(column)

3: Current Date & Time

4: Basic Date Functions

5: DateDiff()

6: Date_Add()

7: Date_Trunc()

8: Group By & Aggregate Functions

9: Having (vs. Group By)

Chapter 4: Bridging the Gap to Intermediate SQL

1: Coalesce & Isnull()

2: Case & Categorizing Data

3: Data Dictionaries

4: Data Models & Fact vs. Dimension Tables

5: Inner Joins

Chapter 5: Case Studies & Wrap Up

1: Case Study Calculate a Percent in SQL

2: Case Study Visualizing Data

3: Next Steps & Finding Data to Practice