Please enable JavaScript to use CodeHS

South Carolina IT Fundamentals

SQL Part II: The SQL

Continue learning more topics in SQL.

Lessons

17.1 Advanced Filters

  • Compound and Advanced Filters
  • Compound and Advanced Filters
  • Compound Filters Example
  • BETWEEN, LIKE, IN Examples
  • The Patil in Ravenclaw
  • +1 more

17.2 More Filtering Practice

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

17.3 Ordering Results

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

17.4 Renaming Fields

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

17.5 Joining Tables

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

17.6 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