Please enable JavaScript to use CodeHS

IB Computer Science SL Resources

Databases

In this module, students will explore the fundamentals of SQL and relational databases, including structuring data into tables and writing basic SELECT queries with filters.

Lessons

17.1 Databases and Cybersecurity

  • Databases and Cybersecurity
  • Databases
  • FERPA
  • Personally Identifiable Information (PII)
  • Databases and Cybersecurity Quiz

17.2 Getting Started in SQL

  • What is SQL?
  • How to Structure Data in SQL
  • How to Structure Data in SQL
  • SQL Table: Tiktok
  • Customer List

17.3 Basic Querying in SQL

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

17.4 Filtering Queries in SQL

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

17.5 Advanced Filters

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

17.6 Ordering Results

  • The ORDER BY Keyword
  • ORDER BY
  • The ORDER BY Keyword
  • ORDER BY First Name
  • Reverse Order
  • +3 more

17.7 Renaming Fields

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

17.8 Joining Tables

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

17.9 Designing Databases for Business

  • Mini-Project Introduction
  • Brainstorm and Planning
  • Entities and Attributes
  • Design Your Database Schema
  • Present Your Database!

17.10 Databases Quiz

  • Databases Quiz

Courses that include this module