ONCE1189 - Advanced SQL (Online, Self-Paced)
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
- SQL Certificate : SQL Certificate