EQ SQL (Microsoft Environment) – Advanced
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.
Course Price: $135.00
Spring 2024
Evening Sessions
Apr 18 - Jun 13Thu
Thursday, Apr 18 - Thursday, Jun 13
Day | Time | Room Number |
---|---|---|
Thursday | 18:00 - 21:00 | 2F.20 |
Additional Information
Teacher: | Jonathan Perlman |
Course Number: | 922049 |
Registration Start Date: | Tuesday, Aug 01, 2023 |
Maximum Class Size: | 12 |
Total Hours: | 27 |
Status: | Cancelled |