NewEra Technology Facebook
6232 Implementing a Microsoft SQL Server 2008 R2 Database - Virtual Led Training - Course Information
PRINT
SEND TO A FRIEND
Name: 6232 Implementing a Microsoft SQL Server 2008 R2 Database - Virtual Led Training
Category: Microsoft Official Curriculum Courses
Length (Days): 5
Course Price (CAD): 2750
Description:
This 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.
Prerequisites:
N/A
Outline:
Lesson 1 - Introduction to SQL Server and its Toolset
◦Introduction to SQL Server Platform
◦Working with SQL Server Tools
◦Configuring SQL Server Services
◦Lab : Introduction to SQL Server and its Toolset

Lesson 2 - Working with Data Types
◦Using Data Types
◦Working with Character Data
◦Converting Data Types
◦Working with Specialized Data Types
◦Lab : Working with Data Types

Lesson 3 - Designing and Implementing Tables
◦Designing Tables
◦Working with Schemas
◦Creating and Altering Tables
◦Lab : Designing and Implementing Tables

Lesson 4 - Designing and Implementing Views
◦Introduction to Views
◦Creating and Managing Views
◦Performance Considerations for Views
◦Lab : Designing and Implementing Views

Lesson 5 - Planning for SQL Server Indexing
◦Core Indexing Concepts
◦Data Types and Indexes
◦Single Column and Composite Indexes
◦Lab : Planning for SQL Server Indexing

Lesson 6 - Implementing Table Structures in SQL Server
◦SQL Server Table Structures
◦Working with Clustered Indexes
◦Designing Effective Clustered Indexes
◦Lab : Implementing Table Structures in SQL Server

Lesson 7 - Reading SQL Server Execution Plans
◦Execution Plan Core Concepts
◦Common Execution Plan Elements
◦Working with Execution Plans
◦Lab : Reading SQL Server Execution Plans

Lesson 8 - Improving Performance through Nonclustered Indexes
◦Designing Effective Nonclustered Indexes
◦Implementing Nonclustered Indexes
◦Using the Database Engine Tuning Advisor
◦Lab : Improving Performance through Nonclustered Indexes

Lesson 9 - Designing and Implementing Stored Procedures
◦Introduction to Stored Procedures
◦Working With Stored Procedures
◦Implementing Parameterized Stored Procedures
◦Controlling Execution Context
◦Lab : Designing and Implementing Stored Procedures

Lesson 10 - Merging Data and Passing Tables
◦Using the MERGE Statement
◦Implementing Table Types
◦Using Table Types as Parameters
◦Lab : Merging Data and Passing Tables

Lesson 11 - Creating Highly Concurrent SQL Server Applications
◦Introduction to Transactions
◦Introduction to Locks
◦Management of Locking
◦Transaction Isolation Levels
◦Lab : Creating Highly Concurrent SQL Server Applications

Lesson 12 - Handling Errors in T-SQL Code
◦Designing T-SQL Error Handling
◦Implementing T-SQL Error Handling
◦Implementing Structured Exception Handling
◦Lab : Handling Errors in T-SQL Code

Lesson 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
◦Lab : Designing and Implementing User-Defined Functions

Lesson 14 - Ensuring Data Integrity through Constraints
◦Enforcing Data Integrity
◦Implementing Domain Integrity
◦Implementing Entity and Referential Integrity
◦Lab : Ensuring Data Integrity through Constraints

Lesson 15 - Responding to Data Manipulation via Triggers
◦Designing DML Triggers
◦Implementing DML Triggers
◦Advanced Trigger Concepts
◦Lab : Responding to Data Manipulation via Triggers

Lesson 16 - Implementing Managed Code in SQL Server
◦Introduction to SQL CLR Integration
◦Importing and Configuring Assemblies
◦Implementing SQL CLR Integration
◦Lab : Implementing Managed Code in SQL Server

Lesson 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
◦Lab : Storing XML Data in SQL Server

Lesson 18 - Querying XML Data in SQL Server
◦Using the T-SQL FOR XML Statement
◦Getting Started with XQuery
◦Shredding XML
◦Lab : Querying XML Data in SQL Server

Lesson 19 - Working with SQL Server Spatial Data
◦Introduction to Spatial Data
◦Working with SQL Server Spatial Data Types
◦Using Spatial Data in Applications
◦Lab : Working with SQL Server Spatial Data

Lesson 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
◦Lab : Working with Full-Text Indexes and Queries
Guaranteed to run courses