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. 

 

Course Outline

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

About Your 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.

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.

Notes

Course Objectives

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

Requirements:

- Windows 8 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced SQL
Type
Online-Self Paced
Dates
Dec 06, 2021 to Dec 31, 2021
Course Fee(s)
Tuition non-credit $245.00
Section Notes

Requirements:

- Windows 8 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

 

For further information on this course, please contact Darby Lanpher at dlanpher@harpercollege.edu.

Section Title
Advanced SQL
Type
Online-Self Paced
Dates
Apr 04, 2022 to Apr 29, 2022
Course Fee(s)
Tuition non-credit $245.00
Section Notes

Requirements:

- Windows 8 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

 

For further information on this course, please contact Darby Lanpher at dlanpher@harpercollege.edu.

Section Title
Advanced SQL
Type
Online-Self Paced
Dates
May 02, 2022 to May 27, 2022
Course Fee(s)
Tuition non-credit $245.00
Section Notes

Requirements:

- Windows 8 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

 

For further information on this course, please contact Darby Lanpher at dlanpher@harpercollege.edu.

Required fields are indicated by .