SQL Training: Mastering SQL Queries
This SQL training gives you the opportunity to learn the theory and immediately practice SQL queries directly on a course server, allowing you to apply your knowledge at your own pace.
Updated on
The SQL Training 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
- Audience
- Tous
- Price
- $781 per participant, or $663 for public bodies and non-profits (plus taxes)
- Language
- English
Doussou Formation and SQL Training: key facts
- Since 2016Doussou Formation has been delivering professional training in Quebec
- 300+specialized courses in our catalogue
- 97 %satisfaction according to client evaluations
- RAP · CPMTAccredited supplier and recognized training organization
Upcoming SQL Training sessions
SQL Training course outline
Introduction to SQL Training
- Definition of a database
- Definition of a Database Management System
- Defining a relational model
- Overview of the different SQL languages: DDL, DML, DCL
Course on DCL (Data Control Language)
- SELECT FROM query
- SELECT WHERE query
- SELECT ORDER query
- SELECT LIMIT query
- SELECT EXPR ... query
- SELECT FROM JOIN query
- SELECT AGGR GROUP query
- SELECT AGGR GROUP HAVING query
Course on Data Manipulation (DML)
- Introduction to DML
- INSERT query
- INSERT SELECT query
- INSERT MULTI TABLE query
- UPDATE query
- UPDATE MULTI TABLE query
- DELETE query
- DELETE MULTI TABLE query
Course on Data Definition (DDL)
- CREATE TABLE query
- DROP TABLE query
- ALTER TABLE query
Theory on Advanced SQL Concepts
- Indexes and index types
- Foreign key constraints
- Basic modeling, explanation of 1st, 2nd, and 3rd normal forms
- Natural keys versus complex keys
- SQL Triggers and Stored Procedures
Prices and practical information
Preferred rate
$663 / participant
Public bodies and non-profits · plus taxes
Standard price
$781 / 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.
Corporate SQL Training 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.
Participant reviews
97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials
Why take this SQL Training course
Objectives: what you will be able to do
- Understand and interpret different types of diagrams that define and represent a database.
- Grasp the basic concepts of a relational database.
- Create, modify, delete, and populate a database with tables and data.
- Retrieve the data you need from your database using the appropriate queries.
Prerequisites
- Basic computer literacy
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