Objectives : 
- Knowing how to create databases and database files
- Knowing how to create stored procedures and functions
- Knowing how to implement managed code in the database
- Knowing how to implement data integrity in Microsoft SQL Server 2016
- Understand how to use indexes to guarantee the performance of the database
- Knowing how to use Transact SQL to handle exceptions, create triggers
- Learn to use SQL Server’s specialized data types to manipulate hierarchical XML data or to manage spatial location data

Objectives : 
- Understand how to install or update a SQL Server instance
- Have the necessary skills for database maintenance
- Know how to optimize aspects relating to information storage
- Be able to migrate a local database to SQL Azure

Objectives : 
- Carry out any schemas and queries for MS-SQL
- Know the main functionalities offered by MS SQL Server
- Install, maintain, administer an MS SQL server
- Create and maintain an MS SQL server optimally

Objectives : 
- Optimally create and maintain an MS SQL server

Objectives : 
- Mastering Transact SQL

Objectives : 
- Write SELECT queries
- Write queries on multiple tables
- Sort and filter data
- Modify data with Transact-SQL
- Program with T-SQL

Objectives : 
- Describe the main administration tasks and database tools
- Install and configure SQL Server 2014
- Configure SQL Server databases and storage
- Monitor SQL Server
- Audit data access and encrypt data

Objectives : 
- Describe data warehouse concepts and architectural needs
- Select the appropriate hardware platform for a data warehouse
- Design and implement a data warehouse
- Debug and troubleshoot SSIS packages
- Deploy and configure SSIS packages