• Online, Self-Paced
Course Description

As with any development skill in the industry, learning the core fundamentals creates a foundation. In this course, you will take your first steps in learning about relational databases and Structured Query Language (SQL). This course covers concepts of a database and an introduction to SQL, diving into the architecture, creating and managing tables, and queries. This course looks at the various basic components and how to create a standard query. By the end of these courses, you will be well on your way to creating efficient and easily manageable databases and have fun while doing it.

Learning Objectives

SQL Database in a Nutshell

  • start the course
  • identify a database and how it relates to SQL
  • describe the relational concepts of SQL, various database types, and when and why they are used
  • use SQL to describe the differences between SQL and other languages
  • describe in high level, structured query language and its use
  • use SQL to create a simple statement
  • describe data types and their relation to SQL
  • use SQL to create a simple database example

Playing with Tables

  • describe tables and how to create them in SQL
  • use tables to further dive into the complexities of SQL
  • use the INSERT statement in SQL
  • use SQL to create more complex tables
  • use SQL to alter an existing table
  • use SQL to delete an existing table
  • use SELECT to take a look at a table
  • use the NULL statement in SQL
  • use the DEFAULT statement in SQL

Managing Data the SQL Way

  • use the SELECT statement in SQL queries
  • use SELECT to retrieve data from more than one table in SQL
  • use SQL to create several data types
  • use DELETE to remove data from a table in SQL
  • use UPDATE to change data in SQL
  • use ORDER BY with results to sort data in SQL
  • use WHERE to filter data and retrieve requested results in SQL
  • use all data management components in an example in SQL

Practice: Basics of SQL

  • describe SQL and the query while demonstrating how to create a table and manipulate it

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.