Training: SQL – Advanced Queries

Ref. SQL-02

Download PDF

Duration:

3

days

Exam:

Not certifying

Level:

Advanced

Funding:

Temptraining

Home > Trainings > IT Pro > Analytics and Data Management > SQL – Advanced Queries

SQL Training - Advanced Queries

SQL Training: Master Advanced Database Management Techniques

Do you want to learn SQL and master advanced techniques to optimize your databases? Our SQL training guides you step by step through the key features of SQL Server. From developing views to managing partitions, including stored procedures and user-defined functions, this course provides all the skills you need to tackle complex data challenges.

With a practical and detailed approach, you will learn how to manage SQL transactions, implement triggers, and optimize performance through query plan analysis. Join us to build solid and lasting expertise, allowing you to handle your databases with efficiency and precision.

Participant profiles

Developers, administrators, and advanced users who have to implement complex queries with SQL Server

Objectives

Use decisional grouping functions
Implement analytical and windowing functions
Use complex update commands with the MERGE instruction
Insert, modify and delete data with INSERT, UPDATE, DELETE statements

Prerequisites

SQL user with a few years of experience in SQL or having taken the following course: SQL – Fundamentals and Queries

Course content

Module 1 : Views

Creating a new view
Listing views in SQL Server
Removing a view
Creating an indexed view

Module 2 : Triggers

Creating a trigger in SQL Server
Creating a DDL trigger
Disabling triggers
Viewing the definition of a trigger
Listing all triggers in SQL Server
Removing triggers

Module 3 : Computed Columns

Introduction to SQL Computed Columns
Persisted computed columns
Adding computed columns to a table

Module 4 : Stored Procedures

Introduction to stored procedures
Parameters
Variables
Output Parameters

Module 5 : User Defined Functions

Introduction to SQL User Defined Functions
Scalar Functions
Table-Valued Functions
System Functions

Module 6 : Transactions and Error Handling

Introduction to SQL Transactions and Error Handling
How to handle exceptions gracefully in stored procedures
How to generate user-defined error messages
Raising an exception and transferring the execution

Module 7 : SQL Grouping Sets and Common Table Expressions

SQL Grouping Functions
Introduction to SQL Ranking Functions
What is a Common Table Expression?
Non-Recursive CTEs
Recursive CTE
Multiple CTE

Module 8 : Partitions

Introduction to SQL Partitions
Creating Table Partitions
Removing Table Partitions

Module 9 : Optimization

Describe SQL Server query plans
Explain estimated and actual query plans
Identify problematic query plans
Identify issues with a database design

Documentation

Digital courseware included

Complementary courses

SQL – Fundamentals and Queries | SQL-01

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

SQL Training – Advanced Queries: Become an SQL Expert

Master SQL with Our SQL Training

Learning SQL is an essential skill today for anyone who wants to efficiently manage databases. Whether you’re a beginner or already have some basic IT knowledge, our SQL training guides you step by step to become an expert in relational data management. This SQL course will help you fully understand and utilize the SQL language, used to manipulate and query SQL databases.

What is SQL and How Can It Help You?

SQL language (Structured Query Language) is essential for interacting with relational databases. Through our database training, you will learn how to perform queries, manipulate data, and organize it according to your needs. SQL allows not only retrieving data but also organizing, updating, or deleting it, making databases more dynamic and efficient.

Build Effective Queries with Conditions and Criteria

At the core of our SQL course, you will learn SQL by performing both simple and complex queries. You will learn to use specific criteria to query your databases and manipulate the results according to your needs. Whether querying a SQL database with multiple conditions or conducting more precise searches, you will be able to interact with data independently and efficiently.

Data Manipulation and Advanced Functions

One of the strengths of this SQL training is the use of mathematical and string manipulation functions. You will learn to summarize and analyze data sets with aggregation functions, as well as manipulate textual results through string functions. These skills will allow you to efficiently leverage your data and extract maximum value from it.

Organize and Structure Your Results with SQL

In this SQL course, you will learn how to organize your results clearly and precisely. You will master clauses such as Order By, Group By, and the Rank function to structure your data according to your needs. You will also be introduced to advanced data grouping techniques with PIVOT and UNPIVOT operators, allowing you to present your results in the form of dynamic pivot tables.

Harness the Power of SQL Joins

Understanding SQL joins is essential for learning the SQL language in depth. Through our database training, you will learn how to combine data from multiple tables and extract relevant information. Whether you need to perform inner joins, outer joins, or subqueries, this module will provide you with all the tools to efficiently manipulate complex data.

Data Export

Once the data is properly queried and analyzed, it’s essential to know how to export it. Whether to create a report, share results with a team, or simply store your information, this SQL course will teach you how to export query results to Excel or text files, making it easier to use in other contexts.

Why Choose Our SQL Training?

Our SQL training is designed to be accessible to everyone, even if you’ve never worked with SQL databases before. Through structured modules, you will be guided step by step to learn the SQL language and become autonomous in managing your data. You will develop concrete skills that are directly applicable in the professional world, whether you are a developer, data analyst, or database administrator.