Loading...

Course Description

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.

Course Outline

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

Learner Outcomes

Course outcomes

  • Be able to create advanced SQL subqueries.
  • Be able to create advanced SQL join queries.
  • Learn how to create union queries in SQL.
  • Discover how transaction processing, stored procedures, and triggers are implemented in SQL.

Course objectives

  • Create advanced subqueries
  • Create advanced join
  • How to create union queries
  • How to implement transaction processing, stored procedures, and triggers

 

Notes

This course is part of the online SQL Certificate Program.

Instructor: Dr. Cecelia Allison is an experienced software tester and technical specialist with more than 15 years of hands-on experience using and teaching SQL. She is also a technical writer, a published author, and a university professor. She holds a Bachelor of Science in finance, a Master of Science in information systems and a Doctor of Business Administration in management information systems.

Prerequisites

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

ONCE1187: Introduction to SQL

ONCE1188: Intermediate SQL

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced SQL (Online Self-Paced)
Type
Online, self paced
Dates
Mar 06, 2023 to Mar 31, 2023
Delivery Options
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
Potential Discount(s)
Section Notes

This LERN/UGotClass online course is scheduled for March 6 to 31, 2023. (Online, Self-Paced, No Live-Zoom meetings).

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom (the Wednesday before class begins). You will have a password and use your email address and password to gain access. You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.

NOTE: That activation Email will come from LERN/UGotClass.

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.

Section Title
Advanced SQL (Online Self-Paced)
Type
Online, self paced
Dates
Apr 03, 2023 to Apr 28, 2023
Delivery Options
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
Potential Discount(s)
Section Notes

This LERN/UGotClass online course is scheduled for April 3 to 28, 2023. (Online, Self-Paced, No Live-Zoom meetings).

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom (the Wednesday before class begins). You will have a password and use your email address and password to gain access. You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.

NOTE: That activation Email will come from LERN/UGotClass.

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.

Section Title
Advanced SQL (Online Self-Paced)
Type
Online, self paced
Dates
May 01, 2023 to May 26, 2023
Delivery Options
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
Potential Discount(s)
Section Notes

This LERN/UGotClass online course is scheduled for May 1 to 26, 2023. (Online, Self-Paced, No Live-Zoom meetings).

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom (the Wednesday before class begins). You will have a password and use your email address and password to gain access. You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.

NOTE: That activation Email will come from LERN/UGotClass.

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.

Section Title
Advanced SQL (Online Self-Paced)
Type
Online, self paced
Dates
Jun 05, 2023 to Jun 30, 2023
Delivery Options
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
Potential Discount(s)
Section Notes

This LERN/UGotClass online course is scheduled for June 5-30, 2023. (Online, Self-Paced, No Live-Zoom meetings).

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom (the Wednesday before class begins). You will have a password and use your email address and password to gain access. You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.

NOTE: That activation Email will come from LERN/UGotClass.

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.

Section Title
Advanced SQL (Online Self-Paced)
Type
Online, self paced
Dates
Jul 04, 2023 to Jul 28, 2023
Delivery Options
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
Potential Discount(s)
Section Notes

This LERN/UGotClass online course is scheduled for July 4-28, 2023. (Online, Self-Paced, No Live-Zoom meetings).

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom (the Wednesday before class begins). You will have a password and use your email address and password to gain access. You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.

NOTE: That activation Email will come from LERN/UGotClass.

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.

Section Title
Advanced SQL (Online Self-Paced)
Type
Online, self paced
Dates
Aug 07, 2023 to Sep 01, 2023
Delivery Options
Course Fee(s)
Course Fee non-credit $245.00 Click here to get more information
Potential Discount(s)
Section Notes

This LERN/UGotClass online course is scheduled for August 7- September 1, 2023. (Online, Self-Paced, No Live-Zoom meetings).

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom (the Wednesday before class begins). You will have a password and use your email address and password to gain access. You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.

NOTE: That activation Email will come from LERN/UGotClass.

There are no live real-time requirements or meetings. You decide when you participate. For the best learning, participants should log into the course on 2-3 different days of the week.