• Online, Self-Paced
Course Description

This free course introduces the student to intermediate concepts found in the implementation and application of Structured Query Language (SQL) within professional business environments.

Learning Objectives

In this Intermediate SQL training course, students will expand their SQL knowledge, learning more about the standard programming language. Students will become more confident in their ability to understand and write SQL queries. By the end of this course, students should be able to:
- Perform intermediate queries using multiple joins, table expressions, and views
- Perform complex aggregation queries and subqueries
- Develop moderately complex database schemas
- Develop complex triggering for enforcing business rules
- Develop complex events, procedures, and functions
- Implement solutions and transactions that preserve data integrity
- Utilize tools that speed up and protect development

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.