Month 37: SQL Server Administration
Week 1: Introduction to SQL Server Administration
- Day 1: Overview of SQL Server Administration
- Day 2: Installing and Configuring SQL Server
- Day 3: SQL Server Management Studio (SSMS) Basics
- Day 4: Introduction to SQL Server Security
- Day 5: SQL Server Backup and Recovery Basics
Week 2: Advanced SQL Server Administration Techniques
- Day 1: Advanced SQL Server Security Techniques
- Day 2: SQL Server Performance Tuning
- Day 3: Advanced SQL Server Backup and Recovery Techniques
- Day 4: SQL Server Replication and High Availability
- Day 5: SQL Server Disaster Recovery Planning
Week 3: T-SQL in SQL Server Administration
- Day 1: Using T-SQL for SQL Server Administration
- Day 2: Managing SQL Server Objects with T-SQL
- Day 3: SQL Server Monitoring with T-SQL
- Day 4: Troubleshooting SQL Server with T-SQL
- Day 5: Automating SQL Server Tasks with T-SQL
Week 4: SQL Server Administration Best Practices
- Day 1: SQL Server Administration Documentation and Change Management
- Day 2: SQL Server Administration Policies
- Day 3: Capacity Planning and Scaling for SQL Server
- Day 4: SQL Server Administration Tools and Software
- Day 5: Career Paths and Certifications for SQL Server Administrators
dowhatkennydoes.com 