Microsoft SQL Server Certification Training

Syllabus of PHP & MyMicrosoft SQL Server Certification Online Training Course in

Module 1: Introduction To Microsoft SQL Server

• 1. Introduction To Database
• 2. Microsoft SQL Server 2017 Installation
• 3. Overview Of SQL Server Management Studio
• 4. Summary

Module 2: Cloud DataBase

• 1. Introduction
• 2. Amazon AWS
• 3. Microsoft Azure

Module 3: ;Introduction To Database

• 1. Introduction
• 2. Create, Alter, Drop Database Using SQL Syntax
• 3. Drop Database Issue
• 4. Create, Alter, Drop Database Using GUI
• 5. Summary
• 6. Self Practice

Module 4: Introduction To Tables

• 1. Introduction
• 2. Tables
• 3. Create, Alter, Drop Table Using SQL Syntax
• 4. Create, Alter, Drop Table Using GUI
• 5. Summary
• 6. Self Practice

Module 5: Data Manipulation Language (DML)

• 1. Introduction
• 2. Insert Command
• 3. Update Command
• 4. Delete Command
• 5. Select Command Part 1
• 6. Select Command Part 2
• 7. Select Command Part 3
• 8. Select Command Part 4
• 9. Select Command Part 5
• 10. Self Practice

Module 6: Advance Table Concepts

• 1. Advance Table Concepts Part 1
• 2. Advance Table Concepts Part 2
• 3. Advance Table Concepts Part 3
• 4. Self Practice

Module 7: SQL Comments

• 1. Introduction To Joins
• 2. Inner Join
• 3. Left Outer Join
• 4. Right Outer Join
• 5. Full Outer Join
• 6. Cross Join
• 7. Self Join
• 8. Self Practice

Module 8: Stored Procedure

• 1. Stored Procedure Part 1
• 2. Stored Procedure Part 2
• 3. Self Practice

Module 9: SQL Injection And Advantages of Stored Procedure

• 1. SQL Injection And Advantages of Stored Procedure Part 1

Module 10: Functions

• 1. Built-in Functions Part 1
• 2. Built-in Functions Part 2
• 3. User Defined Function

Module 11: Temp Tables

• 1. Trigger
• 2. Self Practice

Module 12: Quiz

• 1. How to Find Your SQL Server Instances or Server Name
• 2. Convert or transform rows into columns in SQLL Server
• 3. How to get all objects in SQL Server

Module 13: Stored Procedure Extended

• 1. Introduction
• 2. Input Parameter
• 3. Output Parameter
• 4. Return Value
• 5. Output Clause In Insert, Update and Delete
• 6. Dynamic Output Parameter
• 7. Parameter as optional and default value
• 8. Retrieving identity column value
• 9. Summary

Module 14: Exception Handling

• 1. Introduction
• 2. Exception Handling Part 1
• 3. Exception Handling Part 2
• 4. Exception Handling Part 3

Module 15: Import

• 1. Introduction
• 2. Import data from excel file
• 3. Import data from flat file
• 4. Import data from another SQL server database
• 5. Filter data while importing
• 6. Import data from MySQL
• 7. Summary
• 8.Self Practice

Module 16: Export

• 1. Introduction
• 2. Export data to excel file
• 3. Export multiple table data to excel file
• 4. Export data to flat File
• 5. Export data to another SQL server database
• 6. Filter data while exporting
• 7. Summary
• 8. Self Practice

Module 17: Bulk Insert

Module 18: Cursors

Module 19: Table Variable

Module 20: Derived tables and Except operator

• 1. Derived tables
• 2. Except operator

Module 21: Common table expressions (CTE)

Module 22: SQL Server Backup & Restore

• 1. Full Backup
• 2. Differential Backup
• 3. Restore Database