Course details

Introduction to SQL Server Training

Overview of the SQL Server course

Definition of a database and the different types of objects

Data Manipulation Language (DML)

Inserting rows (INSERT)
Inserting multiple rows
Inserting from a SELECT statement
Updating with UPDATE
UPDATE with subqueries
Deleting records (DELETE)
Practical workshop: Modifying the content of our database

Data Query Language (DQL)

Data types (date, float, etc.)
Selecting data: SELECT
TOP, WHERE, HAVING, and other criteria
Joins: INNER / LEFT / RIGHT / OUTER
Creating and modifying data: INSERT / UPDATE / DELETE

Other course(s) in this category

→ SQL Training: Mastering SQL Queries

→ SQL Training for SQL Server

→ FileMaker Pro Training

Benefits:

A course material for each participant.
Coaching available after the training.
We offer you in public session:
- Tea, coffee
- Dinner at a nearby restaurant
- Wireless internet connection

Prerequisites:

Objectives:

Understand the fundamentals of relational databases and SQL Server architecture.
Learn to create, modify, and manage database objects efficiently.
Master the use of SQL commands for data manipulation (INSERT, UPDATE, DELETE).
Develop skills to query and filter data using SELECT, WHERE, HAVING, and JOIN clauses.
Gain hands-on experience through practical exercises on real SQL Server databases.
Optimize queries and understand the impact of data types and indexing.
Prepare to design, maintain, and troubleshoot SQL databases in a professional environment.

- 02/01/2026
- 16/01/2026
- 13/02/2026
- 27/02/2026
- 27/03/2026
- 10/04/2026
- 08/05/2026
- 22/05/2026
- 19/06/2026
- 03/07/2026
- 31/07/2026

- 19/12/2025
- 13/03/2026
- 05/06/2026

- 30/01/2026
- 24/04/2026
- 17/07/2026

Pricing

Preferential rate

381

$ / participant

Public orgs, NPOs

Public price

449 $ / participant

Practical information

Duration: 1 day(s)
Schedule: 9:00 a.m. to 4:30 p.m. (2 coffee breaks + 1-hour lunch)
Format: - Online (live virtual classroom)
- Or in person, depending on availability

📄 Download course outline (PDF)

Registration details

Interested in this training?

Free quote with no obligation

Check if you are: You work for a government organization or a non-profit (NPO)

Select location and date

Name *

Email *

Company (optional)

Number of participants

I have read the terms and conditions

Enter the code

Registration with credit card payment

Check if you are: You work for a government organization or a non-profit (NPO)

Select location and date

Name *

Email *

Company (optional)

Number of participants

I have read the terms and conditions

Enter the code

Mark Plouffe, Gouvernement du Canada/ Government of Canada

“ I want to thank you both for providing my resources some excellent training(Cobol) over the past 3 days. Mamadou, thank you for being so accommodating on such short notice and for sending your facilitator to Gatineau for this customised and personalised training course. We’ll look forward to continuing our partnership for future training needs. “

Maryse Duguay - Analyste fonctionnelle Base de donnée - Montréal

“J’ai grandement apprécié les méthodes d’enseignement du prof. Le fait que nous soyons un petit groupe a grandement facilité les apprentissages. Il s’adapte à son audience et les exercices sont formateurs. Je recommande fortement. “

Martin Côté - Analyste Assurance Qualité - Travailleur autonome – Montréal

“ Ce fut un plaisir de faire affaires avec Doussou Formation. Ce qui fait LA différence est le service personnalisé totalement à l'écoute des participants ainsi que l'adaptation aux besoins de formation. Flexibilité / Adaptabilité / Professionnalisme / Courtoisie. Merci!“

SQL Training for SQL Server