Complete Microsoft SQL Server Database Administration Course
Course Description
Microsoft SQL Server continues to be one of the world's most popular and top databases. Database is a heart of IT which is needed to stored all critical data and information.
If you want to become SQL database administrator then this is the PERFECT course for YOU. This training course will provide you all the necessary skills you need to be a successful database administrator. The "Complete Microsoft SQL Server Database Administration Course" is designed to provide a comprehensive understanding of database administration using Microsoft SQL Server. This course is ideal for IT professionals, database administrators, and anyone interested in learning about SQL Server infrastructure. It covers key aspects such as installation, configuration, maintenance, security, and performance tuning of SQL Server databases
Course Curriculum
- 1 Introduction
- 2 What is Database & about RDBMS
- 3 What is SQL & NoSQL Database – comparative study with examples
- 4 About MS SQL Server Database
- 5 Hands-on via SSMS (Microsoft SQL Server Management Studio)
- 6 Explore an SQL Sample Database
- 7 Data definition - Create , Alter , Drop , Truncate - Part 1
- 8 Data definition - Create , Alter , Drop , Truncate - Part 2
- 9 Select Into, Rename & Synonym - Part 1
- 10 Select Into, Rename & Synonym - Part 2
- 1 Constraints - PK , FK , Null, UNIQUE constraint , CHECK constraint
- 2 Modifying data - Insert, Update , Delete & Merge - Part 1
- 3 Modifying data - Insert, Update , Delete & Merge - Part 2
- 4 Joining tables - Inner, Left, Right , Inner, Full Outer, Cross , Self
- 5 Grouping data - GroupBy, OrderBy, Grouping sets, Cube, Rollup
- 6 Subquery - Subquery, Correlated subquery,Exists , Any and All
- 1 Set Operators - Union , Intersect , Except - Part 1
- 2 Set Operators - Union , Intersect , Except - Part 2
- 3 Common Table Expression - CTE & Recursive CT
- 4 Pivot - Part 1
- 5 Pivot - Part 2
- 6 Indexes - Clustered,Nonclustered, Rename, Enablr , Disable, Drop , Filtered
- 7 Expressions - CASE, COALESCE ,NULLIF - Part 1
- 8 Expressions - CASE, COALESCE ,NULLIF - Part 2
- 9 SQL Server Views
- 10 SQL Injection – examples
- 11 Useful Tips - Find duplicates, Delete duplicates
- 12 Performance Tuning - Query filters, WHERE and JOIN, Using constraints