Skip to main content
Your browser does not support JavaScript!
Please check if javascript is disabled or use a different browser.
Home
›
Contact Us
›
advanced search options ›
menu
search
advanced search options ›
Y
ou are not logged in.
Login/Create account
checkout
view cart (
0
)
Shopping cart is empty !
Y
ou are not logged in.
Login/Create account
checkout
view cart (
0
)
Shopping cart is empty !
browse
All Classes
›
Program
›
Featured Classes & Specials
›
Student Resources
›
FAQ
›
Search
›
Teach for Us
›
Contact Us
›
Home
›
Last Viewed
UGotClass: Advanced SQL
Course number :
2170011
ID :
22675
Section Number :
04E
« back to classes page
Learn@Home: Online, on your own time
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.
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
No discounts or promotions can be applied to this class.
Add To Cart »
Send to Friend »
Class Details
Session(s)
Online 24/7
Location
NA - Online
CEUs
: 1.6
Notice
Please read:
Learn@Home: Online, on your own time -
This class is 100% online. You do not need to be on your computer or device at a specific day or time. Reliable internet access and a computer are required. You will receive information via email on how to access your online classroom.
Tuition:
$245.00
Schedule Information
Date(s)
Class Days
Times
Location
Instructor(s)
4/6/2026 - 5/1/2026
Online 24/7
12:00 AM - 12:00 AM
N/A - Online
Other Class Offerings
UGotClass: Advanced SQL
ID:
22672
01/05/26 - 01/30/26
Online 24/7
Location
Instructor
Cecelia Allison
Add To Cart »
Send to Friend »
UGotClass: Advanced SQL
ID:
22673
02/02/26 - 02/27/26
Online 24/7
Location
Instructor
Cecelia Allison
Add To Cart »
Send to Friend »
UGotClass: Advanced SQL
ID:
22674
03/02/26 - 03/27/26
Online 24/7
Location
Instructor
Cecelia Allison
Add To Cart »
Send to Friend »
UGotClass: Advanced SQL
ID:
22676
05/04/26 - 05/26/26
Online 24/7
Location
Instructor
Cecelia Allison
Add To Cart »
Send to Friend »
Featured Classes
No Featured Classes today.
You may also be interested in these classes
UGotClass: Advanced SQL
»
Recommended Classes
Healthcare Orientation
»
LPN Information & Application ...
»
Financial Eligibility Applicat...
»
More recommendations
»
Info
Discover NOVA Workforce:
Check out this new online orientation!
×