Course curriculum

  • 1

    Course Introduction

  • 2

    Module 1: Get Your Gear!

  • 3

    Module 2: What Is SQL?

    • The Breakdown

    • Tweaking Your Settings

    • Adding Comments

    • Loading our Database File

    • Getting Familiar with your Database

    • Breaking Down a Query

    • Using Field Aliases and Sorting with ORDER BY

    • Common Rookie Mistakes

    • Supported Reading Material
  • 4

    Module 3: Chopping Up Data

    • The Breakdown

    • The WHERE clause - Finding Numeric Data

    • More Tricks With the WHERE clause

    • The WHERE Clause - Finding Text Data & Using Wildcards

    • The WHERE Clause - Finding Data Using Dates

    • The WHERE clause - Intro to Date Functions

    • More OPERATORS - Introducing the AND and OR

    • How to Create a Calculated Column

    • More Tricks with Calculated Columns

    • Even more - Some Tips with Calculated Columns

    • The CASE statement

    • Filtering Results Using the CASE statement

    • A Look at Data Types

    • Comprehension Checkpoint Quiz #1

    • Supported Reading Material
  • 5

    Milestone

    • Congratulations! Milestone #1 Achieved
  • 6

    Module 4: Dating and Relationships

    • The Breakdown

    • Intro to Joins

    • How do Tables Relate?

    • Looking at the INNER JOIN

    • Joining more Tables with the INNER JOIN

    • The INNER JOIN Explained

    • The LEFT JOIN Explained

    • The RIGHT JOIN Explained

    • Comprehension Checkpoint Quiz #2

    • Supported Reading Material
  • 7

    Module 5: Dysfunctional Families.

    • The Breakdown

    • Intro to FUNCTIONS

    • More Functions and Understanding Parameters

    • Using One Function With Another (Nesting)

    • Gluing Text together (Concatenating)

    • Concatenating With Different Data Types

    • Breaking Up Text

    • More Tricks to Effectively Break up Text

    • Even More Tricks to Break Up Strings of Text

    • One More Trick - Reformatting Our Broken Up Text

    • Adjusting the Format of Dates

    • Figuring Out The Difference Between Dates

    • Figuring Out the Difference Between Dates *Accurately* - Part 1

    • Figuring Out the Difference Between Dates *Accurately* - Part 2

    • Comprehension Checkpoint Quiz #3

    • Supported Reading Material
  • 8

    Module 6: Group Therapy

    • The Breakdown

    • Aggregate Functions

    • Using Aggregate Functions With Different Data Types (Caution)

    • Grouping Data - The GROUP BY keyword

    • Filtering Grouped Data

    • Grouping By More Than One Column

    • Comprehension Checkpoint Quiz #4

    • Supported Reading Material
  • 9

    Milestone

    • Congratulations! Milestone #2 Achieved
  • 10

    Module 7: Subway Station Sub-query and Views (ADVANCED)

    • The Breakdown

    • Intro to The Sub-Query

    • Sub-Queries In The SELECT Clause

    • More Fun With Sub-Queries - Adding The WHERE Clause

    • Sub-Queries Without An Aggregate Function

    • Using the IN Clause With Sub-Queries

    • SQL Server Views

    • Comprehension Checkpoint Quiz #5

    • Supported Reading Material
  • 11

    CASE SOLVED!

    • Congratulations, You Have Solved The Case!