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

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