The SQL Training for SQL Server course at a glance
- Length
- 1 day
- 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
- $449 per participant, or $381 for public bodies and non-profits (plus taxes)
- Language
- English
Doussou Formation and SQL Training for SQL Server: 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 for SQL Server sessions
SQL Training for SQL Server course outline
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
Prices and practical information
Preferred rate
$381 / participant
Public bodies and non-profits · plus taxes
Standard price
$449 / participant
Businesses and individuals · plus taxes
Practical information
- Length: 1 day
- 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 for SQL Server 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 for SQL Server course
Objectives: what you will be able to do
- 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.
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