- Introduction Free
- Why Learn SQL Free
- Brief History & SQL Flavors Free
- MySQL Installation Overview Free
- MAC Download: Community Server Free
- MAC Download: MySQL Workbench Free
- PC Download: Community Server + Workbench Free
- Connecting Workbench to the Server Free
- MySQL Workbench Interface Free
- Preparing Workbench for the Course Pro
- Creating the Maven Movies Database Pro
- QUIZ: MySQL Intro & Setup Pro
- Introduction Pro
- Getting to Know the Database Pro
- The Big 6 Pro
- The SELECT Statement Pro
- The FROM Clause Pro
- SELECT * FROM Pro
- The Use Statement Pro
- Selecting Specific Columns Pro
- ASSIGNMENT: SELECT & FROM Pro
- SOLUTION: SELECT & FROM Pro
- SELECT DISTINCT Pro
- ASSIGNMENT: SELECT DISTINCT Pro
- SOLUTION: SELECT DISTINCT Pro
- The WHERE Clause Pro
- Common WHERE Operators Pro
- ASSIGNMENT: The WHERE Clause Pro
- SOLUTION: The WHERE Clause Pro
- Combining WHERE & AND Pro
- ASSIGNMENT: WHERE & AND Pro
- SOLUTION: WHERE & AND Pro
- Combining WHERE & OR Pro
- ASSIGNMENT: Combining WHERE & OR Pro
- SOLUTION: Combining WHERE & OR Pro
- Combining WHERE & IN Pro
- The LIKE Operator Pro
- LIKE Wildcard Examples Pro
- ASSIGNMENT: The LIKE Operator Pro
- SOLUTION: The LIKE Operator Pro
- The GROUP BY Clause Pro
- GROUP BY Example Pro
- PRO TIP: Using Comments & Aliases Pro
- ASSIGNMENT: GROUP BY Pro
- SOLUTION: GROUP BY Pro
- Multiple Dimension GROUP BY Clauses Pro
- Aggregate Functions Pro
- ASSIGNMENT: Aggregate Functions Pro
- SOLUTION: Aggregate Functions Pro
- The HAVING Clause Pro
- HAVING Example Pro
- ASSIGNMENT: The HAVING Clause Pro
- SOLUTION: The HAVING Clause Pro
- The ORDER BY Clause Pro
- ORDER BY Example Pro
- ASSIGNMENT: The ORDER BY Clause Pro
- SOLUTION: The ORDER BY Clause Pro
- RECAP: The Big 6 Pro
- QUIZ: Single Table Analysis (PART 1) Pro
- Introduction Pro
- Normalization & Cardinality Pro
- Relationship Diagrams Pro
- Multi-Table Querying Pro
- Reviewing the Maven Movies Database Pro
- Common JOIN Types Pro
- INNER JOIN Pro
- INNER JOIN Example Pro
- ASSIGNMENT: INNER JOIN Pro
- SOLUTION: INNER JOIN Pro
- LEFT JOIN Pro
- LEFT JOIN Example Pro
- ASSIGNMENT: LEFT JOIN Pro
- SOLUTION: LEFT JOIN Pro
- RIGHT JOIN Pro
- LEFT vs. INNER vs. RIGHT JOIN Pro
- FULL OUTER JOIN Pro
- PRO TIP: Bridging Unrelated Tables Pro
- ASSIGNMENT: Bridging Tables Pro
- SOLUTION: Bridging Tables Pro
- Multi-Condition Joins Pro
- ASSIGNMENT: Multi-Condition Joins Pro
- SOLUTION: Multi-Condition Joins Pro
- The UNION Operator Pro
- UNION Example Pro
- ASSIGNMENT: The UNION Operator Pro
- SOLUTION: The UNION Operator Pro
- QUIZ: Multi-Table Analysis Pro