Please enable JavaScript to use CodeHS

Advanced Cybersecurity

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. They will then deepen their skills by practicing advanced filtering, sorting, and data presentation using logical operators, compound conditions, and clauses like ORDER BY and AS. Finally, students will learn how to join multiple tables to solve complex data problems and simulate real-world database scenarios.

Lessons

11.1 Databases and Cybersecurity

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

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

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

11.4 Filtering Queries in SQL

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

11.5 Advanced Filters

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

11.6 Ordering Results

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

11.7 Renaming Fields

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

11.8 Joining Tables

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

11.9 Databases Quiz

  • Databases Quiz

Courses that include this module