FR

SQL Training, Conceptual Data Modeling

SQL

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.

2 days 9:00 a.m. to 4:30 p.m. Online, Montreal, Quebec City
See dates and register Quote for my employer

Updated on

The SQL Training, Conceptual Data Modeling course at a glance

Length
2 days
Schedule
9:00 a.m. to 4:30 p.m.
Format
Live virtual class or in person in Montreal and Quebec City
Price
$919 per participant, or $781 for public bodies and non-profits (plus taxes)
Language
English

Doussou Formation and SQL Training, Conceptual Data Modeling: key facts

Upcoming SQL Training, Conceptual Data Modeling sessions

Online

  • Select
  • Select
  • Select
  • Select
  • Select
  • Select
  • Select

Montreal

Hôtel Zéro 1 · 1, boulevard René-Lévesque Est

  • Select
  • Select

SQL Training, Conceptual Data Modeling course outline

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

Course on LID

  • SELECT FROM
    SELECT WHERE
    SELECT ORDER
    SELECT LIMIT
    SELECT EXPR ...
    SELECT FROM JOIN
    SELECT AGGR GROUP
    SELECT AGGR GROUP HAVING

Course on data manipulation (LMD)

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

Course on the Basics of Data Definition (DDL)

  • CREATE TABLE
    DROP TABLE
    ALTER TABLE

Theory

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

Your SQL Training, Conceptual Data Modeling trainer

Portrait of M. Dumoulin

M. Dumoulin

Fort de 20 ans d'expérience en développement web autant dans de grandes comme petites entreprises, je vous transmet mon bagage complet dans un cours bien structuré. Je vous offre écoute et compréhension mais aussi des conseils avisé basé sur mon…

View full profile

Prices and practical information

Preferred rate

$781 / participant

Public bodies and non-profits · plus taxes

Standard price

$919 / participant

Businesses and individuals · plus taxes

Practical information

  • Length: 2 days
  • Schedule: 9:00 a.m. to 4:30 p.m.
  • Format: Live virtual class or in person in Montreal and Quebec City
  • Payment: online (PayPal or card) when registering, or by invoice for organizations
  • Funding: Doussou Formation is a training organization accredited by the CPMT. For Quebec employers subject to the Act to promote workforce skills development (payroll over $2M), this course can count toward their 1% training obligation.
See dates and register Quote for my employer

Corporate SQL Training, Conceptual Data Modeling training

Train your whole team as a private group, on your own documents, at your premises or in a virtual class, on the dates that suit you.

Request an offer

Participant reviews

97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials

Why take this SQL Training, Conceptual Data Modeling course

Objectives: what you will be able to do

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

Prerequisites

  • Know the computer tool

What is included

  • Course materials and exercise files for each participant
  • Certificate of attendance
  • Optional personalized coaching after the course
  • In public in-person sessions:
    • Tea and coffee
    • Lunch at a nearby restaurant
    • Parking (in some cities)
    • Wi-Fi access

Interested in the SQL Training, Conceptual Data Modeling course?

Quote for my employer Register now