Activity | Points | Item Type |
---|---|---|

Hour of SQL | ||

1.1 What is SQL? | Lesson | |

1.1.1 Intro to SQL | 1 | Video |

1.1.2 Quiz: What is SQL? | 1 | Quiz |

1.2 Structuring Data in SQL | Lesson | |

1.2.1 How to Structure Data in SQL | 1 | Video |

1.3 Basic Querying in SQL | Lesson | |

1.3.1 The SELECT Statement | 1 | Video |

1.3.2 Our first SELECT statement | 1 | Example |

1.3.3 Your first SELECT statement | 5 | Exercise |

1.3.4 More SELECT Statement | 1 | Video |

1.3.5 Selecting specific columns examples | 1 | Example |

1.3.6 Harry Potter Names | 5 | Exercise |

1.3.7 Harry Potter Last Names | 5 | Exercise |

1.4 Filtering Queries in SQL | Lesson | |

1.4.1 The WHERE Clause | 1 | Video |

1.4.2 Ravenclaw House | 1 | Example |

1.4.3 People in Gryffindor | 1 | Example |

1.4.4 Filter By ID | 1 | Example |

1.4.5 The Weasleys | 5 | Exercise |

1.4.6 The Potters | 5 | Exercise |

1.4.7 Quiz: Condition Operators | 1 | Quiz |

1.5 Advanced FIlters | Lesson | |

1.5.1 Compound and Advanced Filters | 1 | Video |

1.5.2 Compound Filters Example | 1 | Example |

1.5.3 BETWEEN, LIKE, IN Examples | 1 | Example |

1.5.4 The Patil in Ravenclaw | 5 | Exercise |

1.5.5 Using BETWEEN | 5 | Exercise |

1.5.6 Hour of SQL Badge | 0 | Badge |

SQL Part II: The SQL | ||

2.1 More Filtering Practice | Lesson | |

2.1.1 Initials | 5 | Exercise |

2.1.2 Compound Queries with BETWEEN | 5 | Exercise |

2.1.3 Gryffindors With G Names | 5 | Exercise |

2.1.4 R First Names | 5 | Exercise |

2.1.5 FF Houses | 5 | Exercise |

2.2 Ordering Results | Lesson | |

2.2.1 The ORDER BY Keyword | 1 | Video |

2.2.2 ORDER BY | 1 | Notes |

2.2.3 ORDER BY First Name | 1 | Example |

2.2.4 Reverse Order | 1 | Example |

2.2.5 Order By Multiple Fields | 1 | Example |

2.2.6 House Ordering | 5 | Exercise |

2.2.7 Sort the P Names | 5 | Exercise |

2.3 Renaming Fields | Lesson | |

2.3.1 Renaming Fields with AS | 1 | Notes |

2.3.2 Renaming in the House Table | 1 | Example |

2.3.3 Changing Column Names | 5 | Exercise |

2.4 Joining Tables | Lesson | |

2.4.1 The JOIN command | 1 | Video |

2.4.2 Basic Joining | 1 | Notes |

2.4.3 Letters and Numbers | 1 | Example |

2.4.4 Person and House | 1 | Example |

2.4.5 Person and House (Correct) | 1 | Example |

2.4.6 Person and House (with namespacing) | 1 | Example |

2.4.7 List All Gryffindors | 5 | Exercise |

2.4.8 JOIN With Yourself | 1 | Video |

2.4.9 Renaming Tables | 1 | Notes |

2.4.10 Quidditch Matchups | 1 | Example |

2.4.11 Quidditch Matchups: Ravenclaw Away Games | 5 | Exercise |

2.5 More Joining Tables | Lesson | |

2.5.1 The Course Table | 1 | Example |

2.5.2 Courses and Professors | 5 | Exercise |

2.5.3 Courses, Professors, and Houses | 5 | Exercise |

2.5.4 Courses Taught By Gryffindors | 5 | Exercise |

2.5.5 The Enrollment Table | 1 | Example |

2.5.6 Students Taking Potions | 5 | Exercise |

2.5.7 Non-Slytherins Taking Potions | 5 | Exercise |

2.5.8 Defense Students by House | 5 | Exercise |

2.5.9 Neville's Courses | 5 | Exercise |

SQL Functions | ||

3.1 Counting in SQL | Lesson | |

3.1.1 The COUNT Function | 1 | Notes |

3.1.2 Number of Houses | 1 | Example |

3.1.3 Number of Weasleys | 5 | Exercise |

3.1.4 Number of Students in Transfigurations | 5 | Exercise |

3.1.5 People with Z names | 5 | Exercise |

3.2 Grouping | Lesson | |

3.2.1 The GROUP BY Clause | 1 | Video |

3.2.2 Grouping Results | 1 | Notes |

3.2.3 People in Houses | 1 | Example |

3.2.4 Course Enrollments | 5 | Exercise |

3.2.5 How Many Hufflepuffs? | 5 | Exercise |

3.2.6 Houses of Professors | 5 | Exercise |

3.3 Filtering Calculations | Lesson | |

3.3.1 How to Filter with HAVING | 1 | Notes |

3.3.2 Popular Houses | 1 | Example |

3.3.3 Full Courses | 5 | Exercise |

3.3.4 Families | 5 | Exercise |

3.3.5 C-Courses | 5 | Exercise |

3.4 Limiting | Lesson | |

3.4.1 LIMIT | 1 | Notes |

3.4.2 LIMIT Examples | 1 | Example |

3.4.3 Graduation | 5 | Exercise |

3.4.4 Bookworms | 5 | Exercise |

3.4.5 Rate My Professor | 5 | Exercise |

Data Aggregation | ||

4.1 House Points | Lesson | |

4.1.1 The HousePoint Table | 1 | Notes |

4.1.2 HousePoint Table | 1 | Example |

4.1.3 HousePoints With Houses | 5 | Exercise |

4.1.4 Gryffindors With House Points | 5 | Exercise |

4.1.5 Negative Points | 5 | Exercise |

4.2 Summing Points | Lesson | |

4.2.1 The SUM Function | 1 | Notes |

4.2.2 SUM Example | 1 | Example |

4.2.3 Harry's Points | 5 | Exercise |

4.2.4 Snape, Snape, Severus Snape | 5 | Exercise |

4.2.5 Ravenclaw Points | 5 | Exercise |

4.3 Point Distributions | Lesson | |

4.3.1 Best Students | 5 | Exercise |

4.3.2 Debbie Downer | 5 | Exercise |

4.3.3 House Cup Standings | 5 | Exercise |

4.3.4 House Cup Winner | 5 | Exercise |

4.3.5 The Best Weasley | 5 | Exercise |

4.3.6 Inter-House Points | 5 | Exercise |

4.3.7 SQL Badge | 0 | Badge |

Sign up for a free teacher account to get access to curriculum, teacher tools and teacher resources.

Teacher SignupSign up as a student if you are in a school and have a class code given to you by your teacher.

Student Signup