MSDB440: MS SQL Server Database Administration

Students will learn Microsoft SQL Server Database Server and databases to support day to day operations and administration of the environment.

This would include planning, implementation, monitoring and managing SQL Server Database in very details including installation, configuration, storage management, backup, restore, DR solution, HA solutions, BI (Business Intelligence), ETL, SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS), Report development, deployment and management, SQL/TSQL Programming, moving data, monitoring servers/databases, security, auditing, maintenance, setting jobs, alerts, and other related tools and technologies.

This program also heavily focus on different high availability (HA) options, disaster recovery (DR) solutions, configuring and managing HA and DR solutions and technologies using SQL Server using SLA (Service Level Agreement) including planning, implementation, monitoring and managing different high availability (HA) options, and disaster recovery (DR) solutions available in SQL Server.

Prerequisites:
There are no prerequisites for this class. However, the basic knowledge of Microsoft Windows operating system, relational databases, and database design would be helpful.