Implementing a Microsoft SQL Server 2005 Database
This course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Audience
This course is intended for Engineering/IT Students who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.
Prerequisites
- 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
Course Price
Rs.3500/-
Course Duration
Five Weeks
Course Outline
Creating Databases and Database Files
Creating Data Types and Tables
Using XML
Creating and Tuning Indexes
Implementing Data Integrity by Using Constraints
Implementing Data Integrity by Using Triggers and XML Schemas
Implementing Views
Implementing Stored Procedures and Functions
Managing Transactions and Locks
Implementing Managed Code in the Database
Using Service Broker
For detailed Course Contents please click on download brochure
