Course 10152: Creating and Managing Databases in Microsoft SQL Server 2008

Introduction This two-hour course provides you with the skills and knowledge required to create and manage databases in SQL Server 2008. In this course, you will learn how to manage a database after the database is operational. You will also learn how schemas are used in SQL Server 2008.

Topics covered in this course include:

• Overview of SQL Server 2008 Databases
• Filegroups in SQL Server 2008
• Creating a SQL Server 2008 Database
• Managing a SQL Server 2008 Database
• Using Schemas in SQL Server 2008

Student prerequisites:

To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.
Objectives At the end of the course, students will be able to:

• Provide an overview of SQL Server 2008 databases.
• Plan filegroups in SQL Server 2008.
• Create a SQL Server 2008 database.
• Manage a SQL Server 2008 database.
• Use schemas in a SQL Server 2008 database.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Creating and Managing Databases in Microsoft SQL Server 2008 Module Overview Overview of SQL Server 2008 Databases Introduction Types of SQL Server 2008 Databases What Are Data and Transaction Log Files? Optimising the Database by Using RAID Data Storage in SQL Server 2008 Considerations for Selecting Data Files Self Test Filegroups in SQL Server 2008 Introduction 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 Database Introduction 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 Database Introduction Modifying a Database Managing Database Files and Filegroups Changing Database-Level Options How to Modify a Database in SQL Server 2008 Deleting a Database Sources of Database Metadata Querying Database Metadata Self Test Using Schemas in SQL Server 2008 Introduction The Role of Schemas in SQL Server 2008 Creating Schemas in SQL Server 2008 How Object Name Resolution Works Creating Objects in SQL Server 2008 by Using Schemas Self Test Best Practices Best Practices Lab: Creating and Managing Databases in Microsoft SQL Server 2008 Lab Overview 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