Course Implementing a Microsoft SQL Server 2005 Database

Duration (days): 3
Price (CZK): 12000

Implementing a Microsoft SQL Server 2005 Database topics:

• Creating Databases
• Creating Filegroups
• Creating Schemas
• Creating Database Snapshots
• Creating Data Types
• Creating Tables
• Creating Partitioned Tables
• Retrieving XML by Using FOR XML
• Shredding XML by Using OPENXML
• Introducing XQuery
• Using the xml Data Type
• Planning Indexes
• Creating Indexes
• Optimizing Indexes
• Creating XML Indexes
• Data Integrity Overview
• Implementing Constraints
• Implementing Triggers
• Implementing XML Schemas
• Introduction to Views
• Creating and Managing Views
• Optimizing Performance by Using Views
• Implementing Stored Procedures
• Creating Parameterized Stored Procedures
• Working With Execution Plans
• Handling Errors
• Creating and Using Functions
• Working with Functions
• Controlling Execution Context
• Introduction to the SQL Server Common Language Runtime
• Importing and Configuring Assemblies
• Creating Managed Database Objects
• Overview of Transactions and Locks
• Managing Transactions
• Understanding SQL Server Locking Architecture
• Managing Locks
• Service Broker Overview
• Creating Service Broker Objects
• Sending and Receiving Messages
• Introduction to Notification Services
• Developing Notification Services Solutions

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs