Course curriculum

  • 1

    Course Introduction

    • Welcome to SQL QuickStart Course
  • 2

    Module 1: Get Your Gear!

    • The Crime
    • For Mac Users Only
    • Install SQL Server 2017 SP1 Express Edition
    • Download Digital Evidence
    • Environment Orientation
    • Reading the Case Notes
    • Your Investigation Strategy
    • Supported Reading Material
  • 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!