Please enable JavaScript to use CodeHS

Introduction to SQL - Outline

  1. Hour of SQL

    1. 1.1 What is SQL?

    2. Video 1.1.1 Intro to SQL
    3. Quiz 1.1.2 Quiz: What is SQL?

    4. 1.2 Structuring Data in SQL

    5. Video 1.2.1 How to Structure Data in SQL

    6. 1.3 Basic Querying in SQL

    7. Video 1.3.1 The SELECT Statement
    8. Example 1.3.2 Our first SELECT statement
    9. Exercise 1.3.3 Your first SELECT statement
    10. Video 1.3.4 More SELECT Statement
    11. Example 1.3.5 Selecting specific columns examples
    12. Exercise 1.3.6 Harry Potter Names
    13. Exercise 1.3.7 Harry Potter Last Names

    14. 1.4 Filtering Queries in SQL

    15. Video 1.4.1 The WHERE Clause
    16. Example 1.4.2 Ravenclaw House
    17. Example 1.4.3 People in Gryffindor
    18. Example 1.4.4 Filter By ID
    19. Exercise 1.4.5 The Weasleys
    20. Exercise 1.4.6 The Potters
    21. Quiz 1.4.7 Quiz: Condition Operators

    22. 1.5 Advanced FIlters

    23. Video 1.5.1 Compound and Advanced Filters
    24. Example 1.5.2 Compound Filters Example
    25. Example 1.5.3 BETWEEN, LIKE, IN Examples
    26. Exercise 1.5.4 The Patil in Ravenclaw
    27. Exercise 1.5.5 Using BETWEEN
    28. Badge 1.5.6 Hour of SQL Badge

  2. SQL Part II: The SQL

    1. 2.1 More Filtering Practice

    2. Exercise 2.1.1 Initials
    3. Exercise 2.1.2 Compound Queries with BETWEEN
    4. Exercise 2.1.3 Gryffindors With G Names
    5. Exercise 2.1.4 R First Names
    6. Exercise 2.1.5 FF Houses

    7. 2.2 Ordering Results

    8. Video 2.2.1 The ORDER BY Keyword
    9. Notes 2.2.2 ORDER BY
    10. Example 2.2.3 ORDER BY First Name
    11. Example 2.2.4 Reverse Order
    12. Example 2.2.5 Order By Multiple Fields
    13. Exercise 2.2.6 House Ordering
    14. Exercise 2.2.7 Sort the P Names

    15. 2.3 Renaming Fields

    16. Notes 2.3.1 Renaming Fields with AS
    17. Example 2.3.2 Renaming in the House Table
    18. Exercise 2.3.3 Changing Column Names

    19. 2.4 Joining Tables

    20. Video 2.4.1 The JOIN command
    21. Notes 2.4.2 Basic Joining
    22. Example 2.4.3 Letters and Numbers
    23. Example 2.4.4 Person and House
    24. Example 2.4.5 Person and House (Correct)
    25. Example 2.4.6 Person and House (with namespacing)
    26. Exercise 2.4.7 List All Gryffindors
    27. Video 2.4.8 JOIN With Yourself
    28. Notes 2.4.9 Renaming Tables
    29. Example 2.4.10 Quidditch Matchups
    30. Exercise 2.4.11 Quidditch Matchups: Ravenclaw Away Games

    31. 2.5 More Joining Tables

    32. Example 2.5.1 The Course Table
    33. Exercise 2.5.2 Courses and Professors
    34. Exercise 2.5.3 Courses, Professors, and Houses
    35. Exercise 2.5.4 Courses Taught By Gryffindors
    36. Example 2.5.5 The Enrollment Table
    37. Exercise 2.5.6 Students Taking Potions
    38. Exercise 2.5.7 Non-Slytherins Taking Potions
    39. Exercise 2.5.8 Defense Students by House
    40. Exercise 2.5.9 Neville's Courses

  3. SQL Functions

    1. 3.1 Counting in SQL

    2. Notes 3.1.1 The COUNT Function
    3. Example 3.1.2 Number of Houses
    4. Exercise 3.1.3 Number of Weasleys
    5. Exercise 3.1.4 Number of Students in Transfigurations
    6. Exercise 3.1.5 People with Z names

    7. 3.2 Grouping

    8. Video 3.2.1 The GROUP BY Clause
    9. Notes 3.2.2 Grouping Results
    10. Example 3.2.3 People in Houses
    11. Exercise 3.2.4 Course Enrollments
    12. Exercise 3.2.5 How Many Hufflepuffs?
    13. Exercise 3.2.6 Houses of Professors

    14. 3.3 Filtering Calculations

    15. Notes 3.3.1 How to Filter with HAVING
    16. Example 3.3.2 Popular Houses
    17. Exercise 3.3.3 Full Courses
    18. Exercise 3.3.4 Families
    19. Exercise 3.3.5 C-Courses

    20. 3.4 Limiting

    21. Notes 3.4.1 LIMIT
    22. Example 3.4.2 LIMIT Examples
    23. Exercise 3.4.3 Graduation
    24. Exercise 3.4.4 Bookworms
    25. Exercise 3.4.5 Rate My Professor

  4. Data Aggregation

    1. 4.1 House Points

    2. Notes 4.1.1 The HousePoint Table
    3. Example 4.1.2 HousePoint Table
    4. Exercise 4.1.3 HousePoints With Houses
    5. Exercise 4.1.4 Gryffindors With House Points
    6. Exercise 4.1.5 Negative Points

    7. 4.2 Summing Points

    8. Notes 4.2.1 The SUM Function
    9. Example 4.2.2 SUM Example
    10. Exercise 4.2.3 Harry's Points
    11. Exercise 4.2.4 Snape, Snape, Severus Snape
    12. Exercise 4.2.5 Ravenclaw Points

    13. 4.3 Point Distributions

    14. Exercise 4.3.1 Best Students
    15. Exercise 4.3.2 Debbie Downer
    16. Exercise 4.3.3 House Cup Standings
    17. Exercise 4.3.4 House Cup Winner
    18. Exercise 4.3.5 The Best Weasley
    19. Exercise 4.3.6 Inter-House Points
    20. Badge 4.3.7 SQL Badge