Implementing a Microsoft SQL Server 2008 Database

(Start)Datum	Locatie	Inschrijven
29 May 2012	Nieuwegein
18 June 2012	Amsterdam
18 June 2012	Amsterdam

Description:
This five-day course provides students 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.

Target Audience:
This course is intended for IT Professionals who administer and maintain SQL Server databases.

Duration:
5 days

Pre-Requisites:

Before attending this course, students must have:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

• Introduction to SQL Server and its Toolset
  • Introduction to 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
  • Introduction to Transactions
  • Introduction to 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
  • Introduction to 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