This course is targeted at the Technology Specialist Certification of SQL Server 2008 Database Development and Implementation and Maintenance. After the completion of this course, candidates will be able to implement tables and views, implement programmable objects, work with query fundamentals and apply additional query techniques in SQL Server 2008 R2.
They will also learn how to work with additional SQL Server 2008 R2 components, XML data and gather performance information. Apart from that the candidates will be able to install and configure SQL Server 2008 R2, maintain instances, manage security, maintain a database and perform data management tasks. They will also learn how to monitor and troubleshoot SQL Server, optimize performance and implement high availability.