Please enable JavaScript to use CodeHS

Introduction to SQL

Introduction to SQL

Students will be introduced to the fundamentals of SQL and relational databases. They will learn how to structure data into tables, write basic SELECT queries, and apply simple filters to retrieve relevant information.

Lessons

1.1 What is SQL?

  • Intro to SQL
  • Quiz: What is SQL?

1.2 Structuring Data in SQL

  • How to Structure Data in SQL

1.3 Basic Querying in SQL

  • The SELECT Statement
  • Our first SELECT statement
  • Your first SELECT statement
  • More SELECT Statement
  • Selecting specific columns examples
  • +2 more

1.4 Filtering Queries in SQL

  • The WHERE Clause
  • Ravenclaw House
  • People in Gryffindor
  • Filter By ID
  • The Weasleys
  • +2 more

1.5 Advanced Filters

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

Courses that include this module