Length:2.00 hours - Excluding labs and assessments
Published:Aug 25, 2009
Language:English
Audiences:IT Professional
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course
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
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..
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.