Manage and support Microsoft SQL Server database servers and databases to ensure smooth day-to-day operations and administration. This includes detailed planning, implementation, monitoring, and management of SQL Server environments, encompassing tasks such as:
- Installation, configuration, and storage management
- Backup, restore, disaster recovery (DR) solutions, and high availability (HA) solutions
- SQL/T-SQL programming, data migration, and server/database monitoring
- SQL Database Security, auditing, and maintenance
- Setting up jobs, alerts, and managing relevant tools and technologies.
- Business Intelligence (BI) services, including ETL processes and SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS), including report development, deployment, and management
- Manage Azure database systems across both PaaS (Platform as a Service) and IaaS (Infrastructure as a Service) environments. This includes overseeing deployment, configuration, monitoring, and maintenance of databases, ensuring optimal performance, security, and scalability within Azure’s cloud infrastructure.
Course Features
- Lectures 76
- Quizzes 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 59
- Assessments Yes
