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 77
- Quizzes 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 67
- Assessments Yes
Curriculum
- 9 Sections
- 77 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- DBA Interview Articles environment4
- DBA HR Recruiter Folder4
- Chapter 09 SLA, RPO, RTO, and DBA General4
- Chapter 12 SQL Azure4
- Chapter 13 MYSQL2
- Company Project document3
- DBA Certification Dump file2
- Class record VM_HA_Azure5
- Class_record_ DBA_Saturday49
- 9.1Saturday_Advance_DBA_03/16/2024
- 9.2Domain controller and active directory set up 03/17/2024
- 9.3Saturday_Advance_DBA_03/30/2024
- 9.4Saturday_Advance_DBA_05/19/2024
- 9.5Saturday_Advance_DBA_05/25/2024
- 9.6Thursday_Advance_DBA_05/30/2024
- 9.7Saturday_Advance_DBA_06/01/2024
- 9.8Thursday_Advance_DBA_06/06/2024
- 9.9Saturday_Advance_DBA_06/08/2024
- 9.10Thursday_Advance_DBA_06/13/2024
- 9.11Saturday_Advance_DBA_06/15/2024
- 9.12Thursday_Advance_DBA_06/20/2024
- 9.13Saturday_Advance_DBA_06/22/2024
- 9.14Saturday_Advance_DBA_07/13/2024
- 9.15Saturday_Advance_DBA_07/20/2024
- 9.16Saturday_Advance_DBA_07/27/2024
- 9.17Saturday_Advance_DBA_08/01/2024
- 9.18Thrusday_Advance_DBA_08/03/2024
- 9.19Saturday_Advance_DBA_08/10/2024
- 9.20Thrusday_Advance_DBA_08/15/2024
- 9.21Saturday_Advance_DBA_08/24/2024
- 9.22Thrusday_Advance_DBA_09/05/2024
- 9.23Saturday_Advance_DBA_09/10/2024
- 9.24Saturday_Advance_DBA_09/28/2024
- 9.25Thrusday_Advance_DBA_10/03/2024
- 9.26Saturday_Advance_DBA_10/05/2024
- 9.27Thrusday_Advance_DBA_10/17/2024
- 9.28Thrusday_Advance_DBA_10/24/2024
- 9.29Thrusday_Saturday_DBA_10/26/2024
- 9.30Thrusday_Saturday_DBA_11/07/2024 update statistics wait status
- 9.31Saturday_Advance_DBA_11/09/2024
- 9.32Thrusday_Saturday_DBA_11/14/2024
- 9.33Thrusday_Class_Record DBA_12/05/2024 Data Load
- 9.34Saturday_Advance_DBA_12/07/2024
- 9.35Saturday_Advance_DBA_12/12/2024 Powershell
- 9.36Saturday_Advance_DBA_12/14/2024 Trace flag extended event sql profiler
- 9.37Saturday_Advance_DBA_12/22/2024
- 9.38Thrusday_Class_Record DBA_12/19/2024
- 9.39Saturday_Advance_DBA_01/04/2025 FCI apply patch
- 9.40Saturday_Advance_DBA_001/05/2025 active directory domain controller and WSFC setup
- 9.41Thrusday_Class_Record DBA_01/09/2024
- 9.42Saturday_Advance_DBA_01/11/2025
- 9.43Saturday_Advance_DBA_02/09/2025
- 9.44Thursday_Advance_DBA_SSIS
- 9.45Saturday_Advance_DBA_02/22/2025
- 9.46Saturday_Advance_DBA_02/27/2025 SSRS
- 9.47Saturday_Advance_DBA_03/01/2025 Visu
- 9.48Saturday_Advance_DBA_03/09/2025 ( health check tool , parameter sniffing )
- 9.49Saturday_Advance_DBA_03/23/2025 ( PowerShell CMD)
