| Description: |
Elements of this syllabus are subject to change. This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database. Audience Profile: This course is intended for IT Professionals who administer and maintain SQL Server databases. After completing this course, students will be able to: - Create databases and database files.
- Create data types and tables.
- Use XML-related features in Microsoft SQL Server 2008.
- Plan, create, and optimize indexes.
- Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
- Implement data integrity in Microsoft SQL Server 2008 by using triggers.
- Implement views.
- Implement stored procedures.
- Implement functions.
- Implement managed code in the database.
- Manage transactions and locks.
- Use Service Broker to build a messaging-based solution.
|
|
|
|
 View
the Course Outline
|
|
| |
|
|
| Prerequisite: |
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.
- Some experience with database design.
|
|
|
|
|
|
| |
|
|
| Duration: |
5 Days |
|
| |
|
|
| |
|
|
|
View Printer Friendly Page
|
Course Schedule
|
|
Start Date |
City |
Price |
|
|
9/13/2010
|
|
$2250
|
|
|
9/13/2010
|
|
$2495
|
|
|
10/11/2010
|
|
$2250
|
|
|
10/11/2010
|
|
$2495
|
|
|
11/8/2010
|
|
$2250
|
|
|
11/8/2010
|
|
$2495
|
|
|
12/6/2010
|
|
$2250
|
|
|
12/6/2010
|
|
$2495
|
|
|
1/10/2011
|
|
$2250
|
|
|
1/10/2011
|
|
$2495
|
|
To Inquire About Future Classes |
|
|
