### Please enable JavaScript to use CodeHS

Introduction to SQL

#### Points

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.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
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.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