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.