TRAINING CONTENTS
Module 1: Creating Databases and Database Files
- Creating Databases
- Creating Filegroups
- Creating Schemas
- Creating Database Snapshots
Lab : Creating Databases and Database Files
- Creating a Database
- Creating Schemas
- Creating a Database Snapshot
Module 2: Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
Lab : Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
Module 3: Using XML
- Retrieving XML by Using FOR XML
- Shredding XML by Using OPENXML
- Introducing XQuery
- Using the xml Data Type
Lab : Using XML
- Mapping Relational Data and XML
- Storing XML Natively in the Database
- Using XQuery with xml Methods
Module 4: Creating and Tuning Indexes
- Planning Indexes
- Creating Indexes
- Optimizing Indexes
- Creating XML Indexes
Lab : Creating and Tuning Indexes
- Creating Indexes
- Tuning Indexes
- Creating XML Indexes
Module 5: Implementing Data Integrity by Using Constraints
- Data Integrity Overview
- Implementing Constraints
Lab : Implementing Data Integrity by Using Constraints
- Creating Constraints
- Disabling Constraints
Module 6: Implementing Data Integrity by Using Triggers and XML Schemas
- Implementing Triggers
- Implementing XML Schemas
Lab : Implementing Data Integrity by Using Triggers and XML Schemas
- Creating Triggers
- Implementing XML Schemas
Module 7: Implementing Views
- Introduction to Views
- Creating and Managing Views
- Optimizing Performance by Using Views
Lab : Implementing Views
- Creating Views
- Creating Indexed Views
- Creating Partitioned Views
Module 8: Implementing Stored Procedures
- Implementing Stored Procedures
- Creating Parameterized Stored Procedures
- Working With Execution Plans
- Handling Errors
Lab : Implementing Stored Procedures
- Creating Stored Procedures
- Working With Execution Plans
Module 9: Implementing Functions
- Creating and Using Functions
- Working with Functions
- Controlling Execution Context
Lab : Implementing Functions
- Creating Functions
- Controlling Execution Context
Module 10: Implementing Managed Code in the Database
- Introduction to the SQL Server Common Language Runtime
- Importing and Configuring Assemblies
- Creating Managed Database Objects
Lab : Implementing Managed Code in the Database
- Importing an Assembly
- Creating Managed Database Objects
Module 11: Managing Transactions and Locks
- Overview of Transactions and Locks
- Managing Transactions
- Understanding SQL Server Locking Architecture
- Managing Locks
Lab : Managing Transactions and Locks
- Using Transactions
- Managing Locks
Module 12: Using Service Broker
- Service Broker Overview
- Creating Service Broker Objects
- Sending and Receiving Messages
Lab : Using Service Broker (Optional)
- Creating Service Broker Objects
- Creating Service Broker Objects
- Implementing the Target Service
Module 13: Using Notification Services (Optional)
- Introduction to Notification Services
- Developing Notification Services Solutions