Microsoft SQL Server Certification Training

Module 1: Introduction to SQL Server & Database Concepts

⏳ 0.5 week

• Topics: Relational databases, SQL Server installation, SSMS interface

• Hands-on: Create and query basic databases using SQL Server tools

Module 2: Querying and Filtering Data

⏳ 1 week

• Topics: SELECT statements, WHERE clause, ORDER BY, GROUP BY, HAVING

• Hands-on: Write queries to extract and filter structured data

Module 3: Joins and Subqueries

⏳ 1 week

• Topics: INNER, OUTER, CROSS joins, correlated subqueries, nested queries

• Hands-on: Write complex queries using joins and subqueries

Module 4: Data Modeling and Table Design

⏳ 0.5 week

• Topics: Normalization, constraints, primary & foreign keys

• Hands-on: Design normalized schemas with constraints and relationships

Module 5: Stored Procedures, Triggers, and Views

⏳ 1 week

• Topics: T-SQL scripting, procedures, functions, triggers, views

• Hands-on: Build and execute reusable stored procedures and triggers

Module 6: Indexing and Performance Optimization

⏳ 0.5 week

• Topics: Index types, query optimization, execution plans

• Hands-on: Implement indexing and analyze performance with query plans

Module 7: Backup, Restore, and Security

⏳ 1 week

• Topics: Backup strategies, restore operations, user permissions, roles

• Hands-on: Create scheduled backups and manage database access control

Module 8: Final Project and Certification Prep

⏳ 0.5 week

• Topics: Review of concepts, mock certification exam, real-world project

• Hands-on: Apply full-cycle database development in a capstone project

Get certificate