Day 1 : (2-3 hours)
- Model databases
- User databases
- File groups and files
- File stream
- File table
- Data compression
Day 2 : (2- 3 hours)
- Data import export
- Login, roles and users
- Securities
- Change tracking
Day 3 : (2 hours)
- Day 2 review
- Mirroring
- Log shipping
Day 4 : (2 – 3 hours)
- Review day 3
- Replication
- Snapshot
- Transactional
Day 5: (2 hours)
- Day 4 review
- Sql server agent
- Sql server error log
- Linked server
Day 6 : (2 – 3 hours)
- Backup recovery
- Monitoring
- Extended events
Day 7 : (1 hours) --
- Sql server DBA overall review
- Interview tips
- Other useful resources