Implementing a SQL Server 2008 Database

Understand how to implement SQL Server 2008 databases using product features and tools.

Info Support course code	MS6232	Price	€ 2.200,00
Supplier (code)	Microsoft (6232)	Length	5 days

Course date by location

Maand	Veenendaal (NL)	Utrecht (NL)	Mechelen (B)	Partner (NL)	Partner (B)
September			20-21-22-23-24
Oktober		11-12-13-14-15	25-26-27-28-29
November	15-16-17-18-19		29-30-1-2-3
December		20-21-22-23-24
Januari	24-25-26-27-28
Februari			14-15-16-17-18
Maart		28-29-30-31-1

Click on a date to enlist yourself for this course or click here if no suitable date can be found.

Prerequisites

Before attending this course, students must have Basic knowledge of the Microsoft Windows operating system and its core functionality, working knowledge of Transact-SQL, working knowledge of relational databases and some experience with database design.

• Writing Queries using Advanced Features of Microsoft SQL Server 2008 Transact SQL (ADVSQL)
• Writing Queries using Microsoft SQL Server 2008 Transact SQL (MS2778)

Course outline

This course provides you with product knowledge and skills needed to implement a Microsoft SQL Server 2008 database. You will learn how to use SQL Server 2008 product features and tools related to implementing a database.

Course content

• Creating Databases, Filegroups, Schemas and Database Snapshots
• Creating Data Types and Tables
• Creating and Tuning Indexes
• Implementing Data Integrity by using Constraints and Triggers
• Using XML
• Implementing Stored Procedures, Functions and Views
• Implementing Managed Code in the Database
• Managing Transactions and Locks
• Using Service Broker

Course material

Coursematerial from Microsoft with Labs and CD-ROM.

Related courses

• Maintaining a SQL Server 2008 Database (MS6231)
• Updating your SQL Server 2005 Developer Skills to SQL Server 2008 (SQL2K8DEV)

Follow up courses

• Designing, Developing and Optimizing SQL Server 2008 Databases (SQLDEVPRO)