SQL SERVER 2008

This 16-hour collection provides you with the skills and knowledge required for implementing and maintaining Microsoft SQL Server 2008. You will learn how to install and configure SQL Server 2008. You will also learn how to manage databases, create indexes, automate administrative tasks, and implement high availability in SQL Server 2008.

This 18-hour, 9-course online collection is comprised of a rich multimedia experience coupled with comprehensive technical labs. This collection introduces you to Transact-SQL starting with basic SELECT queries, then advancing to grouping, joins, subqueries, data modification, transactions, and heterogeneous data sources. This collection is intended for IT Professionals who must access and manipulate data in SQL Server 2005 databases and other data sources. After completing this collection, you will be able to: Get started with databases and Transact-SQL. Perform basic queries. Group and summarize data. Join data from multiple tables. Work with subqueries. Modify data. Query metadata, XML, and full-text indexes. Use programming objects for data retrieval. Use advanced querying techniques. To get the most out of this collection, you should: Be familiar with a programming or scripting language. Understand relational databases and the concept of data normalization This collection also helps prepare you for certification exam 70-431.