Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-6232 - Implementing a SQL Server 2008 Database

This five-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server.

Click here to print this page »

Prerequisites


Before attending this course, students must have:
  • Working knowledge of Transact-SQL (ability to write Transact-SQL queries) or Course 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
  • Working knowledge of relational databases (database design skills).
  • Core Windows Server skills.
  • Basic programming language.

Detailed Class Syllabus


Module 1: Introduction to SQL Server and its Toolset


Introduction to SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services

Module 2: Working with Data Types


Using Data Types
Working with Character Data
Converting Data Types
Working with Specialized Data Types

Module 3: Designing and Implementing Tables


Designing Tables
Working with Schemas
Creating and Altering Tables

Module 4: Designing and Implementing Views


Introduction to Views
Creating and Managing Views
Performance Considerations for Views

Module 5: Planning for SQL Server Indexing


Core Indexing Concepts
Data Types and Indexes
Single Column and Composite Indexes

Module 6: Implementing Table Structures in SQL Server


SQL Server Table Structures
Working with Clustered Indexes
Designing Effective Clustered Indexes

Module 7: Reading SQL Server Execution Plans


Execution Plan Core Concepts
Common Execution Plan Elements
Working with Execution Plans

Module 8: Improving Performance through Nonclustered Indexes


Designing Effective Nonclustered Indexes
Implementing Nonclustered Indexes
Using the Database Engine Tuning Advisor

Module 9: Designing and Implementing Stored Procedures


Introduction to Stored Procedures
Working With Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context

Module 10: Merging Data and Passing Tables


Using the MERGE Statement
Implementing Table Types
Using Table Types as Parameters

Module 11: Creating Highly Concurrent SQL Server Applications


Introduction to Transactions
Introduction to Locks
Management of Locking
Transaction Isolation Levels

Module 12: Handling Errors in T-SQL Code


Designing T-SQL Error Handling
Implementing T-SQL Error Handling
Implementing Structured Exception Handling

Module 13: Designing and Implementing User-Defined Functions


Designing and Implementing Scalar Functions
Designing and Implementing Table-valued Functions
Implementation Considerations for Functions
Alternatives To Functions

Module 14: Ensuring Data Integrity through Constraints


Enforcing Data Integrity
Implementing Domain Integrity
Implementing Entity and Referential Integrity

Module 15: Responding to Data Manipulation via Triggers


Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts

Module 16: Implementing Managed Code in SQL Server


Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration

Module 17: Storing XML Data in SQL Server


Introduction to XML and XML Schemas
Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type

Module 18: Querying XML Data in SQL Server


Using the T-SQL FOR XML Statement
Getting Started with XQuery
Shredding XML

Module 19: Working with SQL Server Spatial Data


Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications

Module 20: Working with Full-Text Indexes and Queries


Introduction to Full-Text Indexing
Implementing Full-Text Indexes in SQL Server
Working with Full-Text Queries