Module 2: Database Design & Storage: Modeling, indexing, architecture (3×4) — 12 hrs – DB Tech Training Center

Course Content

Module 1: DBA Fundamentals: Installations, roles, service accounts, security (1×4) — 4 hrs

0/8

Module 1: DBA Fundamentals: Installations, roles, service accounts, security (1×4) — 4 hrs

Module 2: Database Design & Storage: Modeling, indexing, architecture (3×4) — 12 hrs

Module 3: Backup, Restore & Maintenance Plans (2×4) — 8 hrs

Module 4: T-SQL, Agent Jobs & Encryption (TDE, SSL, Masking: 4×4) — 16 hrs

Module 5: High Availability & Cloud (Always On AG, WSFC, AWS, Azure – 6×4) — 24 hrs

Module 6: Performance Tuning: Queries, indexes, DMVs, tuning tools (3×4) — 12 hrs

Module 7: SSIS, SSRS, SSAS & Migration (4×4) — 16 hrs

Module 8: Final Review, Certification Prep & Career Help (2×4) — 8 hrs

Microsoft SQL Server Database Administration

0% Complete