Prerequisite: SQL - Intermediate

Required Material: 2 GB (or higher) Flash (USB) Drive

***Online courses require, Computer with Windows 10 or MacOS X or higher, microphone & headset, high-speed internet connection.

This advanced course will give participants the opportunity to learn advanced techniques for building and designing databases using Microsoft SQL server.

In this course, you will cover the creation and management of views, including T-SQL view statements, alterations, and encryption. You will also delve into stored procedures, both system-defined and user-defined, exploring their creation, modification, and execution.

Additionally, the course will address triggers, encompassing their creation, adjustment, and handling of Data Manipulation Language (DML) triggers, along with an examination of built-in and custom functions, and the practical use of SQL Server's built-in functions.

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.