A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(2210) Updating Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(8036) Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(2092) Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services - Microsoft Training Courses in London and South West
Course:(2786) Designing a Microsoft SQL Server 2005 Infrastructure - Microsoft Training Courses in London and South West
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(2278) Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure - Microsoft Training Courses in London and South West
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2954) First Look: Microsoft BizTalk Server 2006 for Developers - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Course:(5927) Managing Projects Using Microsoft Office Project 2007 - Microsoft Training Courses in London and South West
Course:(2794) Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(6232) Implementing a Microsoft SQL Server 2008 R2 Database - Microsoft Training Courses in London and South West
Course:(2019) Building Solutions in Microsoft Exchange 2000 with the Web Storage System - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(2553) Designing, Planning, and Managing a SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(5119) Supporting Windows Vista Computers with Desktop Images and Application Packages - Microsoft Training Courses in London and South West
Course:(2014) Customizing Microsoft Office SharePoint Portal Server 2003 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(1634) Accelerated Training for Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2400) Implementing and Managing Microsoft Exchange Server 2003 - Microsoft Training Courses in London and South West
Course:(5116) Configuring Windows Vista Mobile Computing and Applications - Microsoft Training Courses in London and South West
Course:(10175) Microsoft SharePoint 2010, Application Development - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(2788) Designing High Availability Database Solutions Using Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(2933) Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(5058) Deploying Microsoft Office 2007 Professional Plus - Microsoft Training Courses in London and South West
Course:(1582) Building Web Applications Using Microsoft Visual InterDev 6 - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(1609) Designing Data Services and Data Models - Microsoft Training Courses in London and South West
Course:(2934) Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1017) Visual FoxPro 8.0 Intensive - Microsoft Training Courses in London and South West
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2276) Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts - Microsoft Training Courses in London and South West
Course:(2299) Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSA on Windows 2000 - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(50050) Architecting Documents and Records Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5105) Deploying Microsoft Windows Vista Business Desktops - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Course:(10174) Configuring and Managing Microsoft SharePoint 2010 - Microsoft Training Courses in London and South West
Course:(3374) First Look: First Look: Getting Started with Microsoft Office 2007 SharePoint Server Hands-On Lab - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Course:(5929) Managing Projects and Programs Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(2778) Writing Queries Using Microsoft SQL Server 2008 Transact-SQL - Microsoft Training Courses in London and South West
NET Framework Development Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Course:(F1016) Upgrading to Visual FoxPro 8.0 from Visual FoxPro 7.0 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(2013) Optimizing Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Systems Management Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(50354) Microsoft SharePoint 2010 SharePoint Designer - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50219) Introduction to Microsoft Windows 7 for Developers - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(50049) Architecting Web Content Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(2277) Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services - Microsoft Training Courses in London and South West
Course:(2733) Updating Your Database Administration Skills to SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(2827) Deploying Microsoft Windows Rights Management Services - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2795) Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services - Microsoft Training Courses in London and South West
Course:(2275) Maintaining a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2723) Microsoft SQL Server 2000 for Experienced Database Professionals - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(5115) Installing and Configuring the Windows Vista Operating System - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(50352) Microsoft SharePoint 2010 Overview for End Users - Microsoft Training Courses in London and South West
Course:(2823) Implementing and Administering Security in a Microsoft Windows Server 2003 Network - Microsoft Training Courses in London and South West
Course:(F1012) Visual FoxPro 7.0 Programming - Microsoft Training Courses in London and South West
Course:(3370) First Look: Getting Started with Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2274) Managing a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Course:(1017) Developing Web Applications with Visual Interdev - Microsoft Training Courses in London and South West
Course:(5928) Managing Projects Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(2783) Designing the Data Tier for Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(4001) Team Collaboration Using Microsoft Windows SharePoint Services - Microsoft Training Courses in London and South West
Course:(F1013) Visual FoxPro 7.0 Intensive - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(2591) Implementing Replication Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2780) Maintaining a Microsoft SQL Server 2005 Database - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(50046) Introduction to Development Using Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(2279) Planning Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(6158) Updating Your SQL Server 2005 Skills to SQL Server 2008 - Microsoft Training Courses in London and South West
Course:(2208) Updating Support Skills from Windows NT 4.0 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2073) Programming a Microsoft SQL Server 2000 Database - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2273) Managing and Maintaining a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2787) Designing Security for Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(2297) Planning Implementing Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSE on Windows 2000 - Microsoft Training Courses in London and South West
Course:(2209) Updating Systems Administrator Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(F1014) Visual FoxPro 7.0 Enterprise - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50051) Architecting Microsoft Office SharePoint Server 2007 Portals and Collaboration Solutions - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(5179) Implementing and Maintaining Telephony Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(2091) Building XML-Enabled Applications Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(5117) Installing, Configuring, Troubleshooting, and Maintaining Windows Vista - Microsoft Training Courses in London and South West
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Course:(2355) Upgrading from Microsoft Exchange Server 5.5 to Microsoft Exchange 2000 - Microsoft Training Courses in London and South West
Course:(2779) Implementing a Microsoft SQL Server 2005 Database - Microsoft Training Courses in London and South West
Course:(5177) Implementing and Maintaining Instant Messaging Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(6236) Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2552) Designing, Planning, and Managing a Windows SharePoint Services Infrastructure - Microsoft Training Courses in London and South West
Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2955) First Look: Microsoft BizTalk Server 2006 for IT Professionals - Microsoft Training Courses in London and South West
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(50218) Microsoft Windows 7 Training for Developers - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(5178) Implementing and Maintaining Audio/Visual Conferencing and Web Conferencing Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2207) Updating Systems Administrator and Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(F1015) Visual FoxPro 7.0 Upgrade - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West

Compare Recently Viewed Course Dates


Standard
SQL Server 2008

Implementing a Microsoft SQL Server 2008 R2 Database
(Microsoft Training Course: 6232) - 5 days - £1640 exc VAT

Save up to 50% of the cost of some courses: check our Certification Packages or buy F1 Training Vouchers


> Target Audience
This course provides students with the knowledge, skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server. It is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database.
> Course outline
  1. Introduction to SQL Server 2008 R2 and its Toolset
  2. Working with Data Types
  3. Designing and Implementing Tables
  4. Designing and Implementing Views
  5. Planning for SQL Server Indexing
  6. Implementing Table Structures in SQL Server
  7. Reading SQL Server Execution Plans
  8. Improving Performance through Non-clustered Indexes
  9. Designing and Implementing Stored Procedures
  10. Merging Data and Passing Tables
  11. Creating Highly Concurrent SQL Server Applications
  12. Handling Errors in T-SQL Code
  13. Designing and Implementing User-Defined Functions
  14. Ensuring Data Integrity through Constraints
  15. Responding to Data Manipulation via Triggers
  16. Implementing Managed Code in SQL Server
  17. Storing XML Data in SQL Server
  18. Querying XML Data in SQL Server
  19. Working with SQL Server Spatial Data
  20. Working with Full-Text Indexes and Queries
Supplementary Information This course is now running as a B version, which means that some of the content may have changed from the previous release. Please check the content for details.
Module 1: Introduction to SQL Server 2008 R2 and its Toolset
  • This module introduces you to the entire SQL Server platform and its major tools.
  • Working with SQL Server Tools
  • Configuring SQL Server Services
  • Lab: Introduction to SQL Server and its Toolset
Skills
  • Describe the SQL Server Platform.
  • Work with SQL Server Tools.
  • Configure SQL Server Services.
top
Module 2: Working with Data Types
  • This module describes the data types supported by SQL Server.
  • Using Data Types
  • Working with Character Data
  • Converting Data Types
  • Working with Specialized Data Types
  • Lab: Working with Data Types
Skills
  • Work with data types.
  • Work with character data.
  • Convert between data types.
  • Use specialized data types.
top
Module 3: Designing and Implementing Tables
  • This module describes the design and implementation of tables.
  • Designing Tables
  • Working with Schemas
  • Creating and Altering Tables
  • Lab: Designing and Implementing Tables
Skills
  • Design tables.
  • Work with schemas.
  • Create and alter tables.
top
Module 4: Designing and Implementing Views
  • This module describes the design and implementation of views.
  • Creating and Managing Views
  • Performance Considerations for Views
  • Lab: Designing and Implementing Views
Skills
  • Explain the role of views in database development.
  • Implement views.
  • Describe the performance related impacts of views.
top
Module 5: Planning for SQL Server Indexing
  • This module describes the concept of an index and discusses composite index structures.
  • Core Indexing Concepts
  • Data Types and Indexes
  • Single Column and Composite Indexes
  • Lab: Planning for SQL Server Indexing
Skills
  • Explain core indexing concepts.
  • Describe the effectiveness of each data type common used in indexes.
  • Plan for single column and composite indexes.
top
Module 6: Implementing Table Structures in SQL Server
  • This module covers clustered indexes and heaps.
  • SQL Server Table Structures
  • Working with Clustered Indexes
  • Designing Effective Clustered Indexes
  • Lab: Implementing Table Structures in SQL Server
Skills
  • Explain how tables can be structured in SQL Server databases.
  • Work with clustered indexes.
  • Design effective clustered indexes.
top
Module 7: Reading SQL Server Execution Plans
  • This module introduces the concept of reading execution plans.
  • Execution Plan Core Concepts
  • Common Execution Plan Elements
  • Working with Execution Plans
  • Lab: Reading SQL Server Execution Plans
Skills
  • Explain the core concepts related to the use of execution plans.
  • Describe the role of the most common execution plan elements.
  • Work with execution plans.
top
Module 8: Improving Performance through Non-clustered Indexes
  • This module explains non-clustered indexes.
  • Designing Effective Non-clustered Indexes
  • Implementing Non-clustered Indexes
  • Using the Database Engine Tuning Advisor
  • Lab: Improving Performance through Non-clustered Indexes
Skills
  • Design effective non-clustered indexes.
  • Implement non-clustered indexes.
  • Use the Database Engine Tuning Advisor to design indexes.
top
Module 9: Designing and Implementing Stored Procedures
  • This module describes the design and implementation of stored procedures.
  • Introduction to Stored Procedures
  • Working With Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Controlling Execution Context
  • Lab: Designing and Implementing Stored Procedures
Skills
  • Describe the role of stored procedures and the potential benefits of using them.
  • Work with stored procedures.
  • Implement parameterized stored procedures.
  • Control the execution context of a stored procedure.
top
Module 10: Merging Data and Passing Tables
  • This module covers table types, table valued parameters and the MERGE statement.
  • Using the MERGE Statement
  • Implementing Table Types
  • Using Table Types as Parameters
  • Lab: Merging Data and Passing Tables
Skills
  • Use the MERGE statement.
  • Implement table types.
  • Use TABLE types as parameters.
top
Module 11: Creating Highly Concurrent SQL Server Applications
  • This module covers transactions, isolation levels, and designing for concurrency.
  • Introduction to Transactions
  • Introduction to Locks
  • Management of Locking
  • Transaction Isolation Levels
  • Lab: Creating Highly Concurrent SQL Server Applications
Skills
  • Describe the role of transactions.
  • Explain the role of locks.
  • Manage locking.
  • Work with transaction isolation levels.
top
Module 12: Handling Errors in T-SQL Code
  • This module describes structured exception handling.
  • Designing T-SQL Error Handling
  • Implementing T-SQL Error Handling
  • Implementing Structured Exception Handling
  • Lab: Handling Errors in T-SQL Code
Skills
  • Design and implement T-SQL error handling.
  • Implement structured exception handling.
top
Module 13: Designing and Implementing User-Defined Functions
  • This module describes the design and implementation of 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
Skills
  • Design and implement scalar functions.
  • Design and implement table-valued functions.
  • Describe implementation considerations for functions.
  • Describe alternatives to functions.
top
Module 14: Ensuring Data Integrity through Constraints
  • This module describes the design and implementation of constraints.
  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity
  • Lab: Ensuring Data Integrity through Constraints
Skills
  • Explain the available options for enforcing data integrity.
  • Describe how domain integrity can be maintained.
  • Describe how entity and referential integrity can be maintained.
top
Module 15: Responding to Data Manipulation via Triggers
  • This module describes the design and implementation of triggers.
  • Designing DML Triggers
  • Implementing DML Triggers
  • Advanced Trigger Concepts
  • Lab: Responding to Data Manipulation via Triggers
Skills
  • Design and implement DML triggers.
  • Explain advanced DML trigger concepts.
top
Module 16: Implementing Managed Code in SQL Server
  • This module describes the implementation of and target use-cases for SQL CLR integration.
  • Introduction to SQL CLR Integration
  • Importing and Configuring Assemblies
  • Implementing SQL CLR Integration
  • Lab: Implementing Managed Code in SQL Server
Skills
  • Explain the importance of SQL Server CLR Integration.
  • Import and configure assemblies.
  • Implement objects that have been created within .NET assemblies.
top
Module 17: Storing XML Data in SQL Server
  • This module covers the XML data type and appropriate use cases for XML 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
Skills
  • Describe XML and XML schemas.
  • Store XML data and associated XML schemas in SQL Server.
  • Implement the XML data type within SQL Server.
top
Module 18: Querying XML Data in SQL Server
  • This module covers the basics of FOR XML and XPath Queries.
  • Using the T-SQL FOR XML Statement
  • Getting Started with XQuery
  • Shredding XML
  • Lab: Querying XML Data in SQL Server
Skills
  • Use the T-SQL FOR XML statement.
  • Work with basic XQuery queries.
  • Shred XML to a relational form.
top
Module 19: Working with SQL Server Spatial Data
  • This module describes spatial data and how this data can be implemented within SQL Server.
  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications
  • Lab: Working with SQL Server Spatial Data
Skills
  • Describe the importance of spatial data and the industry standards related to it.
  • Explain how to store spatial data in SQL Server.
  • Perform calculations on and query SQL Server spatial data.
top
Module 20: Working with Full-Text Indexes and Queries
  • This module covers 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
Skills
  • Describe why user interfaces in existing applications are not sufficient for end user search needs.
  • Implement full-text indexes in SQL Server.
  • Query SQL Server using full-text queries.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Working knowledge of Transact-SQL, or completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.
  • Core Windows Server skills.
  • Working knowledge of relational databases.
  • Basic programming language skills.
> Purpose
After completing this course, students will be able to understand the SQL Server 2008 R2 product; work with data types; design and implement tables and schemas; design and implement views and partitioned views; describe the concept of indexes; identify the appropriate table structures and implement clustered indexes and heaps; describe and capture execution plans; design and implement non-clustered indexes; design and implement stored procedures; 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; use spatial data types in SQL Server.
> Supplementary Information
This course is now running as a B version, which means that some of the content may have changed from the previous release. Please check the content for details.
> EXAMS