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