Please enable JavaScript to use CodeHS

Oklahoma Computer Science I

SQL Part II: The SQL

Continue learning more topics in SQL.

Lessons

11.1 More Filtering Practice

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

11.2 Ordering Results

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

11.3 Renaming Fields

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

11.4 Joining Tables

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

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