Advanced SQL

Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.

Students should have a competency in the Introductory and Intermediate levels of SQL.

Requirements:
- Windows 10 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.

CEUs: 1.6
Length (in hours): 16
Price in USD $245
Price in CAD $329

Agenda

Unit 9

Creating Advanced Subqueries

Structured Query Language Review
Using the IN keyword to link queries
Using the EXISTS keyword to link queries
Using the ANY keyword to link queries
Using the ALL keyword to link queries

Unit 10

Creating Advanced Joins

Creating inner joins review
Creating outer joins review
Creating joins with aggregate functions
Creating nested joins

Unit 11

Creating Union Queries

Creating UNION queries
Creating UNION ALL queries
Creating a WHERE clause and multiple UNION queries

Unit 12

Transaction Processing, Stored Procedures, Triggers

Implementing transaction processing
Implementing stored procedures
Implementing triggers

Hear from our past students

I enjoyed the Advanced SQL class. I feel that it built nicely on the topics from the Intro and Intermediate classes. I feel like I have a good understanding of a broad spectrum of topics in SQL. It was great having Cecelia as the instructor, she is extremely knowledgeable and is able to explain complicated queries/statements in a clear manner. I would recommend the certificate program to anyone interested in learning about SQL. Thank you.
- Jason S

The instruction was clear and easy to understand. Great course.
- Jessica G

I liked the layout of the course, and how the videos explained the reading query examples. This was helpful to see the examples visually, which worked well for me.
- Jake

Montgomery College