LOGO For Immediate Assistance Call 855-211-9361

Open Enrollment

Designing and Implementing a SQL Server 2008 R2 Database

Price: $2,995.00

Call for availability 855-211-9361

In this course, you will gain the knowledge and skills to design and implement a Microsoft SQL Server 2008 database. You will learn how to use SQL Server 2008 product features and tools related to developing and implementing a database.

Course Overview

What You'll Learn

  • Create databases and database files
  • Create data types and tables
  • Use XML-related features in Microsoft SQL Server 2008
  • Plan, create, and optimize indexes
  • Implement data integrity in Microsoft SQL Server 2008 databases by using constraints
  • Implement data integrity in Microsoft SQL Server 2008 databases by using triggers
  • Implement views
  • Implement stored procedures
  • Implement functions
  • Implement managed code in the database
  • Manage transactions and locks
  • Use Service Broker to build a messaging-based solution

Course Outline

  • Introduction to SQL Server and Its Toolset

    • SQL Server Platform
    • Working with SQL Server Tools
    • Configuring SQL Server Services
  • Working with Data Types

    • Using Data Types
    • Working with Character Data
    • Converting Data Types
    • Working with Specialized Data Types
  • Designing and Implementing Tables

    • Designing Tables
    • Working with Schemas
    • Creating and Altering Tables
  • Designing and Implementing Views

    • Introduction to Views
    • Creating and Managing Views
    • Performance Considerations for Views
  • Planning for SQL Server Indexing

    • Core Indexing Concepts
    • Data Types and Indexes
    • Single Column and Composite Indexes
  • Implementing Table Structures in SQL Server

    • SQL Server Table Structures
    • Working with Clustered Indexes
    • Designing Effective Clustered Indexes
  • Reading SQL Server Execution Plans

    • Execution Plan Core Concepts
    • Common Execution Plan Elements
    • Working with Execution Plans
  • Improving Performance through Nonclustered Indexes

    • Designing Effective Nonclustered Indexes
    • Implementing Nonclustered Indexes
    • Using the Database Engine Tuning Advisor
  • Designing and Implementing Stored Procedures

    • Introduction to Stored Procedures
    • Working with Stored Procedures
    • Implementing Parameterized Stored Procedures
    • Controlling Execution Context
  • Merging Data and Passing Tables

    • Using the MERGE Statement
    • Implementing Table Types
    • Using Table Types as Parameters
  • Creating Highly Concurrent SQL Server Applications

    • Transactions
    • Locks
    • Management of Locking
    • Transaction Isolation Levels
  • Handling Errors in T-SQL Code

    • Designing T-SQL Error Handling
    • Implementing T-SQL Error Handling
    • Implementing Structured Exception Handling
  • Designing and Implementing User-Defined Functions

    • Designing and Implementing Scalar Functions
    • Designing and Implementing Table-Valued Functions
    • Implementation Considerations for Functions
    • Alternatives To Functions
  • Ensuring Data Integrity through Constraints

    • Enforcing Data Integrity
    • Implementing Domain Integrity
    • Implementing Entity and Referential Integrity
  • Responding to Data Manipulation via Triggers

    • Designing DML Triggers
    • Implementing DML Triggers
    • Advanced Trigger Concepts
  • Implementing Managed Code in SQL Server

    • SQL CLR Integration
    • Importing and Configuring Assemblies
    • Implementing SQL CLR Integration
  • 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
  • Querying XML Data in SQL Server

    • Using the T-SQL FOR XML Statement
    • Getting Started with XQuery
    • Shredding XML
  • Working with SQL Server Spatial Data

    • Introduction to Spatial Data
    • Working with SQL Server Spatial Data Types
    • Using Spatial Data in Applications
  • Working with Full-Text Indexes and Queries

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