Ready to go beyond SELECT statements? SkillForge's Advanced SQL course takes experienced SQL users into the deeper capabilities of the language — stored procedures, functions, triggers, views, indexing, and query optimization. This live, instructor-led class is designed for developers, analysts, and DBAs who want to write more powerful, efficient SQL.
What this course covers: Subqueries and correlated subqueries, common table expressions (CTEs), window functions, stored procedures and user-defined functions, triggers, views and indexed views, indexing strategies and query optimization, execution plans, transactions and error handling, and database administration fundamentals. Completion of the Introduction course or equivalent experience is required.
Available as a public online session or private on-site training.
1 course available — all taught live by expert instructors.
In this SQL Querying Advanced Training course, students will learn how to use subqueries; how to insert, modify and delete data using a SQL statement; how to create, backup and delete tables and how to work with views, indexes and transactions.
We've been delivering expert-led training since 2010. Here's what sets us apart.
Every class is taught live by a certified expert — not a recording. Ask questions and get real answers in real time.
We cap enrollment to ensure every student gets personal attention and the pace that works for them.
Follow along with exercises in the actual software so skills stick long after class ends.
Select courses include six months of follow-up instructor support so you can apply what you learned with confidence.
Join a public online session from anywhere, or book a private on-site class for your whole team.
Receive a SkillForge certificate upon completing your course to share with your employer or add to your LinkedIn profile.
Join thousands of professionals who've advanced their careers with SkillForge training.