MS 6232: Implementing a Microsoft SQL Server 2008 R2 Database
Presently, this class does not have a scheduled time. Please email email@example.com for information on the next available offering or to request a course.
This course provides participants 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 and is intended for IT Professionals who administer and maintain SQL Server databases.
MS 2778 or equivalent knowledge
Official Microsoft Curriculum provided.
Introduction to SQL Server and its Toolset.
Working with Data Types.
Designing and Implementing Tables and Views.
Planning for SQL Server Indexing.
Implementing Table Structures in SQL Server.
Reading SQL Server Execution Plans.
Improving Performance through Non-clustered Indexes.
Designing and Implementing Stored Procedures.
Merging Data and Passing Tables.
Creating Highly Concurrent SQL Server Applications.
Handling Errors in T-SQL Code.
Designing and Implementing User-Defined Functions.
Ensuring Data Integrity through Constraints.
Responding to Data Manipulation via Triggers.
Implementing Managed Code in SQL Server.
Storing XML Data in SQL Server.
Querying XML Data in SQL Server.
Working with SQL Server Spatial Data.
Working with Full-Text Indexes and Queries.
Work with the data types supported by SQL Server.
Design and implement tables and work with schemas.
Design and implement views and partitioned views.
Describe the concept of an index and determine the appropriate data type for indexes and
composite index structures.
Identify the appropriate table structures and implement clustered indexes and heaps.
Describe and capture execution plans.
Design and implement non-clustered indexes, covering indexes, and included columns.
Design and implement stored procedures.
Implement table types, table valued parameters, and the MERGE statement.
Describe transactions, transaction isolation levels, and application design patterns for highly-concurrent applications.
Design and implement T-SQL error handling and structured exception handling.
Design and implement scalar and table-valued functions.
Design and implement constraints.
Design and implement triggers.
Describe and implement target use cases of SQL CLR integration.
Describe and implement XML data and schema in SQL Server.
Use FOR XML and XPath queries.
Describe and use spatial data types in SQL Server.
Implement and query full-text indexes.
Corporate College West
25425 Center Ridge Road
Westlake, OH 44145
Map & Directions
Corporate College East
4400 Richmond Road
Warrensville Hts., OH 44128
Map & Directions
© 2011 Corporate College, a division of
Cuyahoga Community College.
All rights reserved.