The primary audience of this course is IT professionals who design and maintain SQL Server databases. The audience can also comprise technical architects and consultants who design and implement SQL Server solutions. Students taking this course are expected to have three or more years of experience working on databases for two or more of the following phases in the product lifecycle - design, development, deployment, optimization, maintenance, or support.
The students should have experience in the following areas:
- Administering databases
- Designing logical database schema solutions
- Defining high-availability solutions
- Automating administrative tasks
- Defining security solutions
- Monitoring and troubleshooting the database server
- Designing and executing deployments
- Defining the infrastructure (storage, hardware, and number of servers or instances, etc.)