Course 10361: Creating and Managing Databases in Microsoft SQL Server 2008 R2

Introduction 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.

Objectives At the end of the course, students will be able to:

• Provide an overview of SQL Server 2008 R2 databases.
• Plan filegroups in SQL Server 2008 R2.
• Create a SQL Server 2008 R2 database.
• Manage a SQL Server 2008 R2 database.
• Use schemas in a SQL Server 2008 R2 database.
• List best practices for creating and managing databases in SQL Server 2008 R2.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Creating and Managing Databases in Microsoft SQL Server 2008 R2 Module Overview Overview of SQL Server 2008 R2 Databases Overview of SQL Server 2008 R2 Databases Types of SQL Server 2008 R2 Databases What Are Data and Transaction Log Files? Optimizing the Database by Using RAID Data Storage in SQL Server 2008 R2 Considerations for Selecting Data Files Self Test Filegroups in SQL Server 2008 R2 Filegroups in SQL Server 2008 R2 What Are Filegroups? Using Filegroups for Performance Using Filegroups for Maintenance Using Filegroups for Table Partitioning Using Filegroups with the FILESTREAM Self Test Creating a SQL Server 2008 R2 Database Creating a SQL Server 2008 R2 Database Options for Creating a Database Creating a Database by Using SQL Server Management Studio Creating a Database by Using Transact-SQL Creating User-Defined Filegroups Self Test Managing a SQL Server 2008 R2 Database Managing a SQL Server 2008 R2 Database Modifying a Database Managing Database Files and Filegroups Changing Database-Level Options How to Modify a Database in SQL Server 2008 R2 Deleting a Database Sources of Database Metadata Querying Database Metadata Self Test Using Schemas in SQL Server 2008 R2 Using Schemas in SQL Server 2008 R2 Role of Schemas in SQL Server 2008 R2 Creating Schemas in SQL Server 2008 R2 How Object Name Resolution Works Creating Objects in SQL Server 2008 R2 by Using Schemas Self Test Best Practices Best Practices Lab: Creating and Managing Databases in Microsoft SQL Server 2008 R2 Lab: Creating and Managing Databases in Microsoft SQL Server 2008 R2 Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled