Please enable JavaScript to use CodeHS

Fundamentals of Cybersecurity

SQL Part II: The SQL

Continue learning more topics in SQL.

Lessons

16.1 Advanced Filters

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

16.2 More Filtering Practice

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

16.3 Ordering Results

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

16.4 Renaming Fields

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

16.5 Joining Tables

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

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