Both practical and complete, this SQL course, Conceptual Data Modeling is for anyone wishing
work with a Relational Database Management System (RDBMS). At the end of this course, participants will be able to build data schemas and evaluate quality, create tables, insert, query, edit, and delete data from tables.

Course details

Introduction to SQL training

Definition of a database

Definition of a Database Management System

Define a relational model

Presentation of different SQL languages: LID, DML, LDD

Module 1: Course on LID

SELECT FROM
SELECT WHERE
SELECT ORDER
SELECT LIMIT
SELECT EXPR …
SELECT FROM JOIN
SELECT AGGR GROUP
SELECT AGGR GROUP HAVING

Module 2: Course on data manipulation (LMD)

Beginning of the DML
INSERT
INSERT SELECT
MULTI TABLE INSERT
UPDATE
UPDATE MULTI TABLE
DELETE
DELETE MULTI TABLE

Module 2: Course on the Basics of Data Definition (DDL)

CREATE TABLE
DROP TABLE
ALTER TABLE

Module 3: Theory

Indexes and types of indexes
FK constraints
Basic modeling, explanation of normal forms 1, 2 and 3
Natural key versus complex key

Autre(s) cours dans cette catégorie

→ SQL Training, Conceptual Data Modeling

→ Course – SQL and PL / SQL Training

→ Course – Access 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

Préalables :

Know the computer tool

Objectifs :

Discover SQL
Be able to create queries to retrieve, create and modify data from a database

Classe virtuelle (en ligne) :

22/09/2025 au 24/09/2025
27/10/2025 au 29/10/2025
24/11/2025 au 26/11/2025
02/02/2026 au 04/02/2026
02/03/2026 au 04/03/2026
11/05/2026 au 13/05/2026
01/06/2026 au 03/06/2026
15/06/2026 au 17/06/2026

Montréal :

22/09/2025 au 24/09/2025
30/03/2026 au 01/04/2026
15/06/2026 au 17/06/2026
31/08/2026 au 02/09/2026
09/11/2026 au 11/11/2026

Québec :

05/01/2026 au 07/01/2026
20/07/2026 au 22/07/2026
08/02/2027 au 10/02/2027

Gatineau / Ottawa :

11/05/2026 au 13/05/2026

💰 Pricing

✔ Preferential rate
781 $ / participant

Eligibility:
- Public organizations
- Nonprofits
- Or any company registering 2 or more participants

💼 Regular price

919 $ / participant

📅 Practical Information

Duration: 2 day(s)

Schedule:
9:00 a.m. to 4:30 p.m. (2 coffee breaks + 1 hour lunch)

Format:
Online (live virtual classroom with instructor)

📄 Download course outline (PDF)

Registration Details

Interested in this training course?

Request a quote for my employer Register now

Free quote without obligation

Check if you are:
You work for a government organization or a nonprofit (NPO)

Select the location and date:

Name *

Company

Number of participants

Comments

Enter the code

Click the image to generate a new one.

Registration with credit card payment

Check if you are:
You work for a government organization or a nonprofit (NPO)

Select the location and date:

Name *

Company

Number of participants

I have read and agree to the terms and conditions of sale

Enter the code

Click the image to generate a new one.

Formation en ligne

Vidéos de formations sur les logiciels en bureautique

Accéder

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!“