RSS
Select Language


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

Nevyhovuje Vám osnova ?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