Prerequisites : SQL Beginner, or equivalent knowledge
Required Material: 2 GB (or higher) Flash (USB) Drive
Take note that if this course is online , you will need a computer with Windows 10 or MacOS X or higher, a headset with a microphone and high-speed internet connection.

The course focuses on teaching individuals how to use SQL Server product features and tools related to implementing a database server. It is designed for students who already possess the technical skills required to write basic Transact-SQL queries.

This course serves as the foundation for all SQL Server-related disciplines, including Database Administration, Database Development, and Business Intelligence

Topics covered in this course:

• Introduction to SQL Server and its Toolset
• Introduction to T-SQL Querying
• Creating Databases and Database Files
• Designing and Implementing Tables
• Working with SQL Server Data Types
• Writing SELECT Queries
• Querying Multiple Tables
• Sorting and Filtering Data
• Using Built-In Functions
• Grouping and Aggregating Data
• Using Subqueries
• Designing and Implementing Views

Courses subsidized by Emploi-Québec

Eligibility:

You are eligible to take these courses if you are:

• a seasonal worker who is not currently working, but retains ties with his/her employer;
• self-employed;
• overqualified for the position you currently hold and the course is relevant to your area of study.

You are not eligible to take these courses if you are:

• employed in the public or para-public sector;
• a full-time student;
• unemployed and/or receiving employment insurance or welfare;
• receiving CSST (worker’s compensation) from the SAAQ.

Maximum of two (2) courses per person.
Maximum of three (3) registrations per establishment.