Introduction to SQL

Lessons

1. Hour of SQL

1. 1.1 What is SQL?

   • Lesson Plan
2. Description
3. Objective

4. 1.2 Structuring Data in SQL

   • Lesson Plan
5. Description
6. Objective

7. 1.3 Basic Querying in SQL

   • Lesson Plan
8. Description
9. Objective

10. 1.4 Filtering Queries in SQL

    • Lesson Plan
11. Description
12. Objective

13. 1.5 Advanced FIlters

    • Lesson Plan
14. Description
15. Objective

2. SQL Part II: The SQL

1. 2.1 More Filtering Practice

   • Lesson Plan
2. Description
3. Objective

4. 2.2 Ordering Results

   • Lesson Plan
5. Description
6. Objective

7. 2.3 Renaming Fields

   • Lesson Plan
8. Description
9. Objective

10. 2.4 Joining Tables

    • Lesson Plan
11. Description
12. Objective

13. 2.5 More Joining Tables

    • Lesson Plan
14. Description
15. Objective

3. SQL Functions

1. 3.1 Counting in SQL

   • Lesson Plan
2. Description
3. Objective

4. 3.2 Grouping

   • Lesson Plan
5. Description
6. Objective

7. 3.3 Filtering Calculations

   • Lesson Plan
8. Description
9. Objective

10. 3.4 Limiting

    • Lesson Plan
11. Description
12. Objective

4. Data Aggregation

1. 4.1 House Points

   • Lesson Plan
2. Description
3. Objective

4. 4.2 Summing Points

   • Lesson Plan
5. Description
6. Objective

7. 4.3 Point Distributions

   • Lesson Plan
8. Description
9. Objective