Breadcrumb
  1. Training
  2. Education & Training Catalog
  3. Cybrary
  4. Intermediate SQL

Intermediate SQL

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

Course Overview

Overall Proficiency Level
2 - Intermediate
Course Prerequisites

This course expects the student to already be familiar with development environment set up, basic queries, inner join, left join, right join, cartesian products, basic schema design, views, functions, and table expressions. If all these concepts are foreign, it is suggested that the student enroll in the introduction to SQL course here at Cybrary.

Training Purpose
Skill Development
Specific Audience
All
General Public
Delivery Method
Online, Self-Paced
  • Online, Self-Paced

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 NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Feedback

If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov. Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.

Last Published Date: