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

  • Creating Advanced Subqueries
  • Creating Advanced Joins
  • Creating Union Queries
  • Transaction Processing, Stored Procedures, Triggers
For more information click here.                                                                                                 

Notes

* Instructor: Dr. Cecelia Allison

* Requirements:

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

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

    ONCE1187: Introduction to SQL
    ONCE1188: Intermediate SQL                                                                                                                                         
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.