Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Implementing a Microsoft SQL Server 2008 Database

In 20 hands-on labs, learn how to design and implement a SQL Server 2008 R2 database.

Vendor# M6232

GK# 6187

Course Overview

In this course, you will gain the knowledge and skills to design and implement a Microsoft SQL Server 2008 database. You will learn how to use SQL Server 2008 product features and tools related to developing and implementing a database.

This course incorporates material from the Official Microsoft Learning Product 6232: Implementing a Microsoft SQL Server 2008 R2 Database.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.

    From

    $2995 CAD

    5 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

    From

    $2995 CAD

    5 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • 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 relational databases (database design skills)
  • Core Windows Server skills
  • Basic programming language

or

Who Needs To Attend

IT professionals who administer and maintain SQL Server databases

Course Outline

Download Course Outline

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more