Advanced SQL Course

€3,000.00

Advanced SQL course

Course Description:

SQL is the cornerstone of all relational database operations. In this hands-on Writing Advanced SQL Queries course, you will learn how to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation.

Course Outline:

Introduction and Overview
Querying Multiple Tables
Aggregate Functions
Performing Extensive Analysis with Analytic Functions
Building Subqueries
Breaking Down Complex Queries

For a detailed course outline, kindly click here.

Learning Outcomes:

Maximise the potential of SQL to build powerful, complex and robust SQL queries
Query multiple tables with inner joins, outer joins, and self joins
Construct recursive common table expressions
Summarise data using aggregation and grouping
Execute analytic functions to calculate ranks
Build simple and correlated subqueries
Thoroughly test SQL queries to avoid common errors
Select the most efficient solution to complex SQL problems

Key Features of this Advanced SQL Course:

One-on-one after-course instructor coaching
Learning Tree end-of-course exam included
After-course computing sandbox included

Prerequisites:

This is an advanced course, and knowledge of the basics of SQL at the level of Introduction to SQL Programming Training or equivalent is assumed.

Dates:

This course runs for 3 days and, in order to provide you with more flexibility, you may opt for the morning to afternoon option or the afternoon to evening option. Contact us by email on kla@kpmg.com.mt or by telephone on 2563 6363 for further information on the upcoming dates.