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.

Schedule description
No class April 11th

Costs description
does this show up on web?