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

Autre(s) cours dans cette catégorie

→ 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

Préalables :

Objectifs :

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.

Classe virtuelle (en ligne) :

Aucune date prévue.

Montréal :

Aucune date prévue.

Québec :

Aucune date prévue.

Gatineau / Ottawa :

💰 Pricing

✔ Preferential rate
381 $ / participant

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

💼 Regular 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 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.

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