Microsoft SQL Server DBA Professional — Advanced Administration & Enterprise Management
Price
৳ 45,000.00৳ 29,999.00
Description
This comprehensive SQL Server DBA course is designed to build practical skills in database administration, performance optimization, security, backup and recovery, high availability, migration, monitoring, and enterprise-level SQL Server management.
Learners will start with SQL Server fundamentals and database architecture, then progress into server configuration, security and user management, backup and restore strategies, disaster recovery, SQL Server Agent automation, database maintenance, performance monitoring, indexing, blocking and deadlock troubleshooting, TempDB and transaction log management.
The course also covers advanced DBA responsibilities including High Availability with Always On Availability Groups and Log Shipping, SQL Server Replication, database migration, Windows Server and SQL Server networking, remote connectivity, monitoring and alerting.
A major focus of the course is practical, production-oriented DBA work. Learners will work with real-world administration scenarios involving backup and recovery, performance troubleshooting, security configuration, automated maintenance, monitoring, disaster recovery, and application-to-database connectivity.
The course concludes with a complete production-style DBA project based on an HR Management System, covering database setup, security, backup strategy, SQL Server Agent automation, maintenance, performance monitoring, troubleshooting, TempDB configuration, disaster recovery, and documentation.
By completing this course, learners will develop the practical foundation required to manage, maintain, monitor, troubleshoot, and support SQL Server environments in professional and enterprise settings.
Class Schedule
Sunday, Tuesday, Thursday
From 6:00 PM to 8:30 PM
What you'll learn
1. SQL Server Fundamentals
- Introduction to SQL Server and Its Core Concepts
- Understanding the SQL Server Database Engine
- SQL Server Instance Architecture and Management
- SQL Server Editions and Their Use Cases
- Understanding SQL Server Services
- SQL Server Agent and Job Automation Overview
- SQL Server Management Studio (SSMS) Environment
- Windows Authentication and Access Management
- SQL Server Authentication and Login Methods
- Understanding the Difference Between Server and Database
- Overview of SQL Server Architecture
2. SQL Server Database Architecture
- Understanding SQL Server Database Files: MDF, NDF and LDF
- Filegroups and Database Storage Organization
- Understanding Data Pages and Data Storage
- Understanding Extents and Storage Allocation
- Transaction Log Architecture and Management
- Understanding Different Database States
- Database Properties and Configuration
- Database Auto-Growth Configuration and Management
3. SQL Server Configuration
- SQL Server Instance Configuration and Management
- Configuring Maximum Server Memory
- Configuring Minimum Server Memory
- MAXDOP Configuration for Query Performance
- Cost Threshold for Parallelism Configuration
- Database Compatibility Level Management
- SQL Server Recovery Model Configuration
- SQL Server Configuration Best Practices
4. SQL Server Security & User Management
- Understanding SQL Server Logins and Authentication
- Database Users and User Account Management
- Schemas and Database Object Organization
- Roles and Role-Based Access Management
- SQL Server Permissions and Access Control
- GRANT Permission Management
- DENY Permission Management
- REVOKE Permission Management
- Server-Level Roles and Administrative Access
- Database-Level Roles and User Permissions
- Implementing the Principle of Least Privilege
- Managing Application Database Accounts
5. Backup & Restore
- SQL Server Full Backup Strategies
- Differential Backup and Incremental Data Protection
- Transaction Log Backup and Recovery
- Copy-Only Backup and Special Backup Scenarios
- Backup Compression and Storage Optimization
- Backup Verification and Integrity Checking
- SQL Server Recovery Models and Backup Strategy
- Backup History and Backup Management
- Database Restore and Recovery Procedures
- Differential Backup Restoration
- Transaction Log Restoration and Recovery
6. Disaster Recovery & Point-in-Time Recovery
- SQL Server Disaster Recovery Concepts and Strategies
- Understanding RPO and RTO Requirements
- Designing a SQL Server Recovery Strategy
- Tail-Log Backup for Data Protection
- Point-in-Time Database Recovery
- SQL Server Database Recovery Procedures
- Emergency Database Restore and Recovery
- Disaster Recovery Planning and Preparedness
7. SQL Server Agent
- Introduction to SQL Server Agent and Job Automation
- Creating and Managing SQL Server Agent Jobs
- Configuring Job Steps and Execution Tasks
- Job Scheduling and Automated Execution
- SQL Server Alerts and Event-Based Notifications
- Operators and Notification Management
- Job History and Execution Monitoring
- Automating Daily Full Database Backups
- Automating Differential Backup Operations
- Automating Transaction Log Backups
- Automating Database Integrity Checks
- Automating Index Maintenance Tasks
- Automating Statistics Update Operations
- Automating Old Backup Cleanup
8. Database Maintenance
- Database Integrity Checking with DBCC CHECKDB
- Identifying and Managing Index Fragmentation
- Index Rebuild Operations and Optimization
- Index Reorganize Operations and Maintenance
- SQL Server Statistics and Query Optimization
- Updating Database Statistics for Performance
- Database Maintenance Plans and Automated Maintenance
9. SQL Server Performance Monitoring
- SQL Server CPU Performance Monitoring
- Memory and RAM Usage Monitoring
- Disk I/O Performance Analysis
- Wait Statistics and Performance Bottleneck Analysis
- Identifying and Resolving Blocking
- Deadlock Detection and Analysis
- Monitoring Long-Running Queries
- Identifying Expensive and Resource-Intensive Queries
- Dynamic Management Views (DMVs) for Performance Analysis
- SQL Server Activity Monitor for Real-Time Monitoring
- Query Store for Query Performance Analysis
- Extended Events for Advanced Performance Monitoring
10. Query Performance & Indexing
- Understanding and Analyzing SQL Server Execution Plans
- Clustered Index Design and Management
- Nonclustered Index Design and Optimization
- Included Columns and Covering Indexes
- Designing Effective Covering Indexes
- Index Seek Operations and Query Optimization
- Index Scan Operations and Performance Impact
- Table Scan Analysis and Optimization
- Statistics and Their Role in Query Performance
- Identifying and Evaluating Missing Index Recommendations
11. Blocking & Deadlocks
- Understanding SQL Server Blocking and Concurrency
- Locks and Locking Mechanisms in SQL Server
- Different Types of SQL Server Locks
- Transactions and Transaction Management
- Identifying Long-Running Transactions
- Understanding and Troubleshooting Deadlocks
- Analyzing SQL Server Deadlock Graphs
- Transaction Isolation Levels and Concurrency Control
12. TempDB Administration
- Understanding TempDB Architecture and Usage
- Temporary Tables and Temporary Data Management
- TempDB Usage During Sorting Operations
- TempDB Usage in Hash Operations
- Version Store Management in TempDB
- Identifying and Managing TempDB Contention
- Configuring Multiple TempDB Data Files
- TempDB Sizing and Capacity Planning
- TempDB Auto-Growth Configuration
13. Transaction Log Management
- Understanding SQL Server Transaction Log Architecture
- Transaction Log Growth and Capacity Management
- Virtual Log Files (VLF) and Log Structure
- Transaction Log Truncation and Management
- Understanding Log Reuse Wait Conditions
- Simple Recovery Model and Log Management
- Full Recovery Model and Log Management
- Bulk-Logged Recovery Model and Use Cases
14. SQL Server High Availability
- Introduction to SQL Server High Availability Concepts
- SQL Server Failover Concepts and Strategies
- Log Shipping Configuration and Management
- Always On Availability Groups Overview and Management
- Primary Replica Configuration and Management
- Secondary Replica Configuration and Management
- Synchronous Commit and Data Protection
- Asynchronous Commit for Distributed Environments
- Automatic Failover Configuration and Testing
15. SQL Server Replication
- SQL Server Replication Concepts and Architecture
- Publisher Configuration and Management
- Distributor Configuration and Management
- Subscriber Configuration and Management
- Snapshot Replication Configuration
- Transactional Replication Configuration
- Replication Monitoring and Troubleshooting
16. SQL Server Migration
- SQL Server Version Migration: 2014 to 2019
- SQL Server Version Migration: 2019 to 2022
- Database Migration Using Backup and Restore
- Database Migration Using Detach and Attach
- SQL Server Login Migration and Security Preservation
- SQL Server Agent Job Migration
- Linked Server Configuration During Migration
- Database Compatibility Level Management After Migration
- Application Compatibility Testing After Migration
17. Windows Server + SQL Server
- Windows Server Fundamentals for SQL Server Administration
- Disk Management and Storage Configuration
- NTFS Permissions and File System Security
- Windows Services Management for SQL Server
- Windows Event Viewer for Server Troubleshooting
- Windows Firewall Configuration for SQL Server
- TCP/IP Networking Fundamentals for SQL Server
- DNS Configuration and Name Resolution
- Remote SQL Server Connectivity
- SQL Server Port 1433 Configuration
- SQL Server Browser Service and Instance Discovery
18. SQL Server Networking
- TCP/IP Configuration for SQL Server Connectivity
- SQL Server Port 1433 and Network Communication
- Named SQL Server Instances and Connectivity
- Dynamic Port Configuration and Management
- SQL Server Browser Service
- Firewall Rules for SQL Server Connectivity
- Remote SQL Server Connection Configuration
- SQL Server Connection Strings
- Application-to-SQL Server Connectivity Architecture
- Troubleshooting SQL Server Connection Failures
19. SQL Server Monitoring & Alerting
- CPU and Resource Utilization Monitoring
- RAM and Memory Usage Monitoring
- Disk Space and Disk Performance Monitoring
- Database Size and Growth Monitoring
- Transaction Log Usage Monitoring
- Database Backup Status Monitoring
- SQL Server Agent Job Monitoring
- Blocking Detection and Monitoring
- Deadlock Detection and Monitoring
- SQL Server Service Availability Monitoring
- Backup Failure Alert Configuration
- Low Disk Space Alert Configuration
- SQL Agent Job Failure Alert Configuration
- Database Offline Alert Configuration
- Transaction Log Growth Alert Configuration
20. Real Production DBA Project
- Production-Style Windows Server Environment Setup
- SQL Server Instance and Database Configuration
- SQL Server Agent Job Automation
- Production Database Backup Strategy
- Database Monitoring and Maintenance
- ASP.NET Core Application and SQL Server Integration
- HR Management System Database Design
- Employee Data Management
- Department Data Management
- Designation Management
- Salary Management
- Attendance Management
- Leave Management
- User Account Management
- Audit and Activity Tracking
- Production Database Creation
- Filegroup Configuration and Storage Management
- User and Login Creation
- Database Permission Configuration
- Backup Strategy Implementation
- SQL Server Agent Job Configuration
- Full Backup Implementation
- Differential Backup Implementation
- Transaction Log Backup Implementation
- Database Restore and Recovery Testing
- Database Integrity Verification with DBCC CHECKDB
- Index Maintenance and Optimization
- Statistics Maintenance and Optimization
- Query Performance Monitoring
- Blocking Investigation and Troubleshooting
- Deadlock Investigation and Troubleshooting
- TempDB Configuration and Optimization
- Disk Usage and Capacity Monitoring
- Database Security Configuration
- Disaster Recovery Testing
- Production DBA Documentation
Features
- SQL Server 2022
- Installation and Configuration
- Database Management, Security and User Management
- Backup and Recovery
- Monitoring and Performance Tuning
Target Audiences
- IT professionals
- Anyone preparing for advanced Microsoft SQL Server
- Businesses and Organization
- Individual Learners
- Students
Requirements
- Basic understanding of computers and operating systems
- A PC or laptop with Windows installed
- Internet connection to access course materials
- Familiarity with databases or SQL fundamentals (optional but helpful)
FAQs
Yes, you’ll receive a certificate of completion once you finish all course modules and assessments.
Absolutely. The course covers topics aligned with Microsoft SQL Server certifications, helping you strengthen your technical foundation.
The course primarily uses Microsoft SQL Server 2022, but the concepts apply to most modern versions of SQL Server.
You’ll work on real-world DBA tasks such as performance tuning, backup & recovery, replication, and high-availability configuration.
Instructor
Md. Rifaul Karim
136 Students2 Courses
Reviews
Price
৳ 45,000.00৳ 29,999.00
You might be interested in
-
In-person class
-
Intermediate
৳ 15,000.00৳ 10,000.00
-
3rd Floor, House#2/2, Block#A, Lalmatia, Dhaka-1207
-
13 Students
-
24 lessons
-
In-person class
-
Intermediate
৳ 15,000.00৳ 10,000.00
-
3rd Floor, House#2/2, Block#A, Lalmatia, Dhaka-1207
-
13 Students
-
24 lessons
Learn to create powerful AI agents, automations, and voice bots using n8n—all without writing a single line of code.
৳ 45,000.00৳ 29,999.00