Admission Now

  • Skill Level: Beginners
  • Duration: 4 Months
  • Class Per Week: 2 Day
  • Total Class: 32
  • Certificate: Yes
  • Provide Class Video
  • Language: Bangla & English

Opening Hours

  • Saturday               : Remote office.
  • Sunday, Moday    : Close
  • Tuesday                : 10.00 am - 6.00 pm
  • Wednesday          : 10.00 am - 6.00 pm
  • Thursday              : 10.00 am - 6.00 pm
  • Friday                    : 08.00 am - 8.00 pm
MS-SQL-SERVER-2022-1024x683

MS SQL Server 2022

Course Fee: ৳ 15,000
Enroll Now
Overview:
What is MS SQL Server 2022?
Microsoft SQL Server 2022 is the latest version of Microsoft’s enterprise-grade relational database management system (RDBMS). It features deep Azure integration, enhanced performance, improved security, and built-in query intelligence.

What You’ll Learn
  • Advanced T-SQL queries & stored procedures
  • Performance tuning & query optimization
  • Backup, recovery, and high availability solutions
  • Azure integration & cloud database management
  • Security features (encryption, auditing, row-level security)
Who Should Join?
  • Database administrators (DBAs) & data engineers
  • SQL developers & business intelligence professionals
  • System architects & data analysts
  • IT professionals managing on-premise or cloud databases
Why This Course?
  • Latest SQL Server version with cutting-edge features
  • Seamless Azure cloud integration for hybrid environments
  • Improved performance & security for enterprise data
  • High demand skill in data-driven industries
πŸ“Œ COURSE DURATION
  • 20 – 40 Hours (Recommended)
  • Level: Beginner β†’ Advanced

πŸ“š MODULE 1: Introduction to SQL Server & DBA Role

  • What is RDBMS & DBMS
  • Overview of Microsoft SQL Server Ecosystem
  • SQL Server Editions (Express, Standard, Enterprise)
  • SQL Server Architecture (Engine, Instance, Database)
  • Roles & Responsibilities of a DBA
  • On-Premises vs Cloud DBA

πŸ›  MODULE 2: Installation & Configuration (SQL Server 2022+)

  • Installing SQL Server (Standalone & Cluster)
  • Installing SSMS (SQL Server Management Studio)
  • SQL Server Configuration Manager
  • Instance Configuration & Best Practices
  • Database File Structure (MDF, NDF, LDF)
  • Working with Docker / Virtual Machine

🧱 MODULE 3: Database Design & Storage

  • Database Creation & Configuration
  • Filegroups & Data Files
  • TempDB Configuration Best Practices
  • Capacity Planning & Growth Strategy
  • Data Types & Table Design
  • Partitioning Concepts

πŸ” MODULE 4: Security Management

  • Authentication Modes (Windows / SQL)
  • Logins, Users, Roles
  • Server-Level vs Database-Level Security
  • Encryption (TDE, Always Encrypted)
  • Auditing & Compliance
  • Vulnerability Assessment

πŸ’Ύ MODULE 5: Backup & Restore Strategy

  • Recovery Models (Full, Simple, Bulk Logged)
  • Full, Differential, Log Backups
  • Point-in-Time Recovery
  • Backup Compression & Encryption
  • Automated Backup Strategy
  • Disaster Recovery Planning

βš™οΈ MODULE 6: SQL Server Agent & Automation

  • SQL Server Agent Jobs
  • Scheduling Tasks
  • Alerts & Operators
  • Database Mail Configuration
  • Maintenance Plans
  • Automation Scripts

πŸ“Š MODULE 7: Monitoring & Troubleshooting

  • SQL Server Logs & Error Logs
  • Dynamic Management Views (DMVs)
  • Activity Monitor
  • Blocking & Deadlocks
  • Wait Types Analysis
  • Troubleshooting Performance Issues

πŸš€ MODULE 8: Performance Tuning (Core Module)

  • Query Optimization Techniques
  • Execution Plans (Actual vs Estimated)
  • Indexing Strategy (Clustered / Non-clustered / Columnstore)
  • Index Fragmentation & Maintenance
  • Query Store Usage
  • Statistics & Cardinality Estimation
  • Memory & CPU Optimization
  • TempDB Performance Tuning

πŸ‘‰ This is a key moduleβ€”modern courses heavily focus on tuning using indexes, Query Store, and DMVs

πŸ”„ MODULE 9: High Availability & Disaster Recovery (HA/DR)

  • Log Shipping
  • Database Mirroring
  • Replication (Snapshot, Transactional, Merge)

πŸ‘‰ These are critical enterprise skills for production DBAs

πŸ” MODULE 10: Data Migration & Integration

  • Import/Export Data
  • Backup & Restore Migration
  • Detach & Attach Database

Β 

🧠 MODULE 11: Advanced DBA Topics

  • SQL Server Internals (Pages, Extents)
  • Locking, Blocking, Isolation Levels
  • Transaction Management
  • Resource Governor
  • Extended Events

πŸ”§ MODULE 12: Scripting & Automation (T-SQL for DBA)

  • Dynamic SQL
  • Stored Procedures for Admin Tasks
  • PowerShell for DBA
  • Automation Scripts

πŸ§ͺ MODULE 13: Real-Time DBA Scenarios

  • Production Issue Handling
  • Performance Troubleshooting Case Studies
  • Backup Failure Recovery
  • Server Crash Recovery
  • Interview Scenario Questions

πŸŽ“ MODULE 14: Project & Interview Preparation

  • Real-Time DBA Project
  • Resume Preparation (DBA Profile)
  • Interview Questions (Beginner β†’ Advanced)
  • Mock Interview

Trainer: MD. Rowson Al Mamun (MCT, MCSA, MCP)

Total Duration:Β 60 Hours