Creating and Managing Databases in Microsoft SQL Server 2008 R2 (E-Learning)

This two-hour course provides you with the knowledge and skills to create and manage databases in Microsoft SQL Server 2008 R2.

This course covers the following topics.
Overview of SQL Server 2008 R2 databases
Planning filegroups in SQL Server 2008 R2
Creating and managing a SQL Server 2008 R2 database
Using schemas in a SQL Server 2008 R2 database
Best practices for creating and managing databases in SQL Server 2008 R2

This course helps you prepare for the exams 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance and 70-433: Microsoft SQL Server 2008, Database Development.

The prerequisites for this course are as follows:
A good general knowledge of database concepts.
Experience working with Windows and programming concepts.
Understanding of server management concepts such as roles and tracing.
A basic understanding of XML.