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

Vendor:

Subject:

Database [2]

Overview:

Length:2.00 hours - Excluding labs and assessments
Published:Feb 15, 2011
Language:English
Audiences:Developer
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents:

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.

Objective:

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

Prerequisites:

None

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

Business Analysis (BA)

Six Sigma

Project Management (PMP®)

ITIL®

Quality Assurance (QA)