CartConfirm registration and payPersonal FileQuit
Mia Registration Portal
Courses
Computer & Technology
Courses

Data Analytics
Courses

Emploi Quebec
Emploi Quebec (Online registration only)

Languages
English
French
German
Italian
Japanese
Spanish
Korean
Russian
Arabic

Confucius Institute in Quebec
Chinese Language Courses

Photography
Courses

General & Professional Interests
Courses

Testing Center
TEF/TEFAQ

EQ SQL (Microsoft Environment) - Advanced  

Services Québec

Cost 135.00$
Age from 16 years
Available places YES
Duration 27 hours


Add to your cart


EQ SQL (Microsoft Environment) - Advanced
(922049)
From Apr 18th to Jun 13th, 2024
Thursday 18:00 to 21:00, room 2F.20 Laboratory - Computer - Business Admin
Group number S24-922049-1


Prerequisite: SQL - Intermediate

Required Material: 2GB (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.


Back