6232A: Implementing a Microsoft SQL Server 2008 Database

HOME

View our latest list of promotions and specials. Check out the latest bargains in the bargain bin.

SOLUTIONS

FOR INDIVIDUALS

FOR ORGANISATIONS

We have a wide variety of training solutions for both individuals and organisations.

SERVICES

FOR INDIVIDUALS

FOR ORGANISATIONS

We offer a variety of services related to training - each one uniquely tailored to either the individual or organisation.

We have a wide variety of training solutions for both individuals and organisations.

DEMOS

VIDEO

FREE COURSES

Take a look at our video's section, as well as take a free course to test drive us!

FORUMS

DISCUSSIONS

JOBS

Use our forum and jobs sections to have your say, or see what other users are saying about us and other industry related news.

Get the latest news from us as well as news from the ICT industry.

Need to find out more about Netcampus, who we are, and what we do? Need to get into contact with us? Get all this info here.

SHOPPING CART |

0 ITEM(S)

SEARCH NETCAMPUS

Products

Job Roles

Technologies

Certifications

Help Me Decide Wizard

Implementing a Microsoft SQL Server 2008 Database

Type: Course
Vendor: Microsoft
Code: 6232A

<< Back

Add To Cart

Check My Skills

Price: 3995.00 ZAR

On this page:

Overview
Target Audience
Training Outcomes
Prerequisites
Course Outline
People who purchased this product also purchased

Overview

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

Target Audience

This course is intended for IT Professionals who administer and maintain SQL Server databases.

Training Outcomes

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

Prerequisites

Working knowledge of Transact-SQL. Working knowledge of Relational databases. Core Windows Server skills. Database design skills. SQL Server skills - ability to write Transact-SQL queries or completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

Course Outline

Module 01 - Creating Databases and Database Files
Estimated Study Time: 4 hour(s) and 0 minute(s)

Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots
Lab - Creating Databases and Database Files

Module 02 - Creating Data Types and Tables
Estimated Study Time: 4 hour(s) and 0 minute(s)

Creating Data Types
Creating Tables
Creating Partitioned Tables
Lab - Creating Data Types and Tables

Module 03 - Creating and Tuning Indexes
Estimated Study Time: 4 hour(s) and 0 minute(s)

Planning Indexes
Creating Indexes
Optimizing Indexes
Lab - Creating and Tuning Indexes

Module 04 - Implementing Data Integrity by Using Constraints and Triggers
Estimated Study Time: 4 hour(s) and 0 minute(s)

Data Integrity Overview
Implementing Constraints
Implementing Triggers
Lab - Implementing Data Integrity by Using Constraints and Triggers

Module 05 - Using XML
Estimated Study Time: 4 hour(s) and 0 minute(s)

Using the XML Data Type
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Introducing XQuery
Creating XML Indexes
Implementing XML Schemas
Lab - Using XML

Module 06 - Implementing Views
Estimated Study Time: 4 hour(s) and 0 minute(s)

Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views
Lab - Implementing Views

Module 07 - Implementing Stored Procedures
Estimated Study Time: 4 hour(s) and 0 minute(s)

Using Stored Procedures
Creating Parameterized Stored Procedures
Working With Execution Plans
Handling Exceptions
Lab - Implementing Stored Procedures

Module 08 - Implementing Functions
Estimated Study Time: 4 hour(s) and 0 minute(s)

Introducing Functions
Working with Functions
Controlling Execution Context
Lab - Implementing Functions

Module 09 - Implementing Managed Code in the Database
Estimated Study Time: 3 hour(s) and 0 minute(s)

Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects
Lab - Implementing Managed Code in the Database

Module 10 - Managing Transactions and Locks
Estimated Study Time: 3 hour(s) and 0 minute(s)

Overview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks
Lab - Managing Transactions and Locks

Module 11 - Using Service Broker
Estimated Study Time: 3 hour(s) and 0 minute(s)

Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages
Lab - Using Service Broker

- Module 01 - Creating Databases and Database Files
- Module 02 - Creating Data Types and Tables
- Module 03 - Creating and Tuning Indexes
- Module 04 - Implementing Data Integrity by Using Constraints and Triggers
- Module 05 - Using XML
- Module 06 - Implementing Views
- Module 07 - Implementing Stored Procedures
- Module 08 - Implementing Functions
- Module 09 - Implementing Managed Code in the Database
- Module 10 - Managing Transactions and Locks
- Module 11 - Using Service Broker

(detailed outline...)

People who purchased this product also purchased

- MCTS_SQL2K8_IMP_MAINT_F: Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Implementation and Maintenance
- 6231A: Maintaining a Microsoft SQL Server 2008 Database
- 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL