MS 6232: Implementing a Microsoft SQL Server 2008 R2 Database

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.

ZMCP

1088