Let's get to learning.

 
expand your module and click Start to begin.

Get Your Gear!


  1. The Crime
  2. For Mac Users Only
  3. UInstall SQL Server 2017 SP1 Express Edition (5:33)
  4. Download Digital Evidence (1:52)
  5. Environment Orientation (8:12)
  6. Reading the Case Notes
  7. Your Investigation Strategy

MODULE 1: What the #@! is SQL?


  1. The Breakdown
  2. Tweaking Your Settings (4:26)
  3. Adding Comments & why this is sooo important (6:12)
  4. Loading our Database File (6:45)
  5. Getting Familiar with your Database (4:51)
  6. Let's break a query down, back 2 basics (15:25)
  7. Keeping it real by using field Aliases and sorting with ORDER BY (4:08)
  8. Common Rookie mistakes (4:13)
  9. Quiz

MODULE 2: Chopping Up Data.


  1. The Breakdown
  2. The WHERE clause - Finding numeric data (6:40)
  3. Date Criteria
  4. More tricks with WHERE clause (6:05)
  5. The WHERE clause - Finding text data & using Wildcards (8:57)
  6. The WHERE clause - Finding data using Dates (11:16)
  7. The WHERE clause - Intro to Date Functions (4:33)
  8. More OPERATORS. Introducing the AND and OR (6:35)
  9. How to create a Calculated Column (5:36)
  10. More tricks with Calculated Columns (10:30)
  11. Even more - Some tips with Calculated Columns (6:15)
  12. The CASE statement (10:15)
  13. Filtering results using the CASE statement (4:20)
  14. A look at Data Types (4:45)
  15. Data Analysis Quiz

MODULE 3: Dating and Relationships.


  1. The Breakdown
  2. How do Tables Relate - Intro to Joins? (5:02)
  3. How do Tables Relate? (8:16)
  4. Looking at the INNER JOIN (7:09)
  5. Joining more Tables with the INNER JOIN (9:02)
  6. The INNER JOIN Explained (6:33)
  7. The LEFT JOIN Explained (4:55)
  8. The RIGHT JOIN Explained (4:55)
  9. Quiz

MODULE 4: Dysfunctional Families.


  1. The Breakdown
  2. Intro to FUNCTIONS (8:03)
  3. More Functions and understanding Parameters (9:22)
  4. Using one function with another (Nesting) (9:25)
  5. Gluing Text together (Concatenating) (6:28)
  6. Concatenating with different Data Types (14:47)
  7. Breaking up Text (7:51)
  8. More tricks to effectively Break up Text (9:07)
  9. Even more tricks to Break up strings of Text (8:41)
  10. One more trick - Reformatting our broken up text (3:14)
  11. Adjusting the format of Dates (9:26)
  12. Figuring out the difference between dates (6:49)
  13. Figuring out the difference between dates Accurately (6:41)
  14. PT 2 - Figuring out the difference between dates Accurately (6:56)
  15. Quiz

MODULE 5: Group Therapy.


  1. The Breakdown
  2. Aggregate Functions (8:58)
  3. Using Aggregate Functions with different data types (Caution) (12:17)
  4. Grouping Data - The GROUP BY keyword (6:53)
  5. Filtering Grouped Data (6:18)
  6. Grouping By more than one Column (5:28)
  7. Data Analysis Quiz

MODULE 6 (ADVANCED): Subway Station Sub-query and Views.


  1. The Breakdown
  2. Intro to the Sub-Query (12:19))
  3. Sub-Queries in the SELECT clause (5:09)
  4. More fun with sub-queries - Adding the WHERE clause (4:57)
  5. Sub-queries without an Aggregate Function (4:34)
  6. Using the IN clause with Sub-queries (4:35)
  7. SQL Server Views (6:59)
  8. Data Analysis Quiz