Please enable JavaScript to use CodeHS

Introduction to SQL

SQL Part II: The SQL

Students will deepen their understanding of SQL by practicing advanced filtering, sorting, and data presentation techniques. They will explore the use of logical operators, compound conditions, and the ORDER BY and AS clauses. Additionally, students will learn how to join multiple tables to answer complex data questions and simulate real-world database scenarios.

Lessons

2.1 More Filtering Practice

  • Initials
  • Compound Queries with BETWEEN
  • Gryffindors With G Names
  • R First Names
  • FF Houses

2.2 Ordering Results

  • The ORDER BY Keyword
  • ORDER BY
  • ORDER BY First Name
  • Reverse Order
  • Order By Multiple Fields
  • +2 more

2.3 Renaming Fields

  • Renaming Fields with AS
  • Renaming in the House Table
  • Changing Column Names

2.4 Joining Tables

  • The JOIN command
  • Basic Joining
  • Letters and Numbers
  • Person and House
  • Person and House (Correct)
  • +6 more

2.5 More Joining Tables

  • The Course Table
  • Courses and Professors
  • Courses, Professors, and Houses
  • Courses Taught By Gryffindors
  • The Enrollment Table
  • +4 more

Courses that include this module