| |
Aug 06, 2026
|
|
|
|
|
DBMS 240 - Microsoft Database Administration
PREREQUISITES: DBMS 150 - Database Administration .
PROGRAM: Data Analytics
CREDIT HOURS MIN: 3
LECTURE HOURS MIN: 3
TOTAL CONTACT HOURS MIN: 48
DATE OF LAST REVISION: Fall 2025
This course will introduce students to advanced database administration concepts utilizing Microsoft database technologies. Focusing on Microsoft SQL Server and Azure SQL Database , students will learn about administration tasks, performance tuning, advanced security, automation, and high availability configurations unique to Microsoft’s traditional, cloud, hybrid, and cross-platform environments.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course the student will be expected to:
- Deploy and manage Microsoft SQL Server and Azure SQL Database instances.
- Explore the use of performance tuning, query optimization, and index management for efficient database operations.
- Evaluate the configuration of Microsoft-specific High Availability/Disaster Recovery options.
- Configure security measures specific to Microsoft databases.
- Utilize scripting to automate administrative tasks.
- Monitor and troubleshoot database performance using SQL Server tools and Azure Monitor.
- Implement backup, restore, and disaster recovery strategies within SQL Server and Azure environments.
- Manage data migration and synchronization between on-premises and cloud or hybrid Microsoft databases.
- Discuss strategies for auditing Microsoft databases to ensure compliance with data regulation standards.
COURSE CONTENT: Topical areas of study include -
- Microsoft SQL Server, Azure SQL Database, SQL Server on Linux
- Multi-instance configurations
- Query Optimization and Execution Plans
- Indexing and Partitioning Strategies
- Data encryption, data masking, and row-level security.
- User Management and Access Control
- Full, differential, and transaction log backups;
- High Availability and Availability Groups
- Clustering and failover strategies.
- Disaster Recovery Planning and Solutions
- RPO/RTO considerations
- Auditing and Compliance
- Monitoring and Performance Troubleshooting
- SQL Profiler
- Database Engine Tuning
- Task Automation
- Replication and Data Synchronization
- Data Migration
- Hybrid cloud configurations.
Course Addendum - Syllabus (Click to expand)
|
|
