PTR - People, Training ResultsPeople, Training, Results

Independent Technical IT Computer Training Courses

   

SQL Server 2008 Course Index & Training Schedule


More SQL Server 2008 Courses

SQL Server 2008 Reporting Services CourseSQL Server 2008 Integration Services CourseSQL Server 2008 Analysis Services CourseMicrosoft SQL Server 2008 for Developers CourseImplementing a Microsoft SQL Server 2008 Database CourseMaintaining a Microsoft SQL Server 2008 Database CourseUpdating Your SQL Server Administration Skills to SQL Server 2008 CourseSQL Server 2008 Essential Administration CourseSQL Server 2008 Advanced Administration CourseAccelerated Implementing and Maintaining a Microsoft SQL Server 2008 Database Course


Late Availability Courses:


Training Course Subjects:

Applications Training Courses C Programming Courses C# Programming Courses Cisco Courses Citrix Courses CIW Courses CompTia Courses Database Courses Exchange Server Courses Fortran Courses Internet Courses ITIL Service Management Courses Java Courses Linux Courses Microsoft Courses Microsoft .NET Courses Microsoft Access Courses Microsoft Excel Courses Microsoft Outlook Courses Microsoft Powerpoint & Visio Courses Microsoft Project Courses Microsoft Server Products Courses Microsoft Word Courses Networking Courses Oracle Courses Perl Courses Programming Courses Security Courses SQL Courses SQL Server 2005 Courses SQL Server 2008 Courses Unix Courses VBA Courses Visual Basic Courses Visual Basic 2008 Courses Visual Studio Courses Visual Studio 2008 Courses Visual Studio 2010 Courses VMWare Courses Web Design Courses Windows Server 2003 Courses Windows Server 2008 Courses Windows 7 Courses Windows Vista Courses Windows XP Courses XML Courses

Online e-Learning Courses

Scheduled Classroom based Training Courses

Implementing a Microsoft SQL Server 2008 Database Course

Course Description

Course Code: M6232

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.

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.
£1495

5 day course

Scheduled Dates:

Course pre-requisites:

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

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



Topics covered on the 5 day Implementing a Microsoft SQL Server 2008 Database course

Creating Databases and Database Files

  • Creating Databases
  • Creating Filegroups
  • Creating Schemas
  • Creating Database Snapshots

Creating Data Types and Tables

  • Creating Data Types
  • Creating Tables
  • Creating Partitioned Tables

Creating and Tuning Indexes

  • Planning Indexes
  • Creating Indexes
  • Optimizing Indexes

Implementing Data Integrity by Using Constraints and Triggers

  • Data Integrity Overview
  • Implementing Constraints
  • Implementing Triggers

Using XML

  • Using the XML Data Type
  • Retrieving XML by Using FOR XML
  • Shredding XML by Using OPENXML
  • Creating XML Indexes
  • Implementing XML Schemas

Implementing Views

  • Introduction to Views
  • Creating and Managing Views
  • Optimizing Performance by Using Views

Implementing Stored Procedures

  • Implementing Stored Procedures
  • Creating Parameterized Stored Procedures
  • Working With Execution Plans
  • Handling Errors

Implementing Functions

  • Creating and Using Functions
  • Working with Functions
  • Controlling Execution Context

Implementing Managed Code in the Database

  • Introduction to the SQL Server Common Language Runtime
  • Importing and Configuring Assemblies
  • Creating Managed Database Objects

Managing Transactions and Locks

  • Overview of Transactions and Locks
  • Managing Transactions
  • Understanding SQL Server Locking Architecture
  • Managing Locks

Using Service Broker

  • Service Broker Overview
  • Service Broker Objects
  • Sending and Receiving Messages

Course Classification:  Technical Training Course

This is an instructor led training course taught in a classroom based environment.


Course Fee = £1495   (excl.VAT)



Scheduled course dates



View full schedule of Generic courses

View full schedule of SQL Server 2008 courses

Print / Download PDF Version of full course schedule

If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2008 Training and bespoke SQL Server 2008 courses