Dates/Locations:
No upcoming dates scheduled
Duration:
5 Days
Course Overview:
This five-day instructor-led 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.
Course Objectives:
- Creating Databases an Databases Files
- Creating Data Types and Tables
- Creating and Tuning Indexes
- Implementing Data Integrity by Using Constraints and Triggers
- Using XML
- Implementing Views
- Implementing Stored Procedures
- Implementing Functions
- Implementing Managed Code in the Database
- Managing Transactions and Locks
- Using Service Broker
Prerequisites:
Basic knowledge of the Microsoft Windows operating system and its core functionally.
Working knowledge of Transact-SQL
Working knowledge of relational databases.
Some experience with database design
Related posts:
- MS-6231: Maintaining a Microsoft SQL Server 2008 Database
- MS-5027: Querying and Processing SQL Server Data Using Microsoft SQL Server
- MS-5047: Introduction to Installing and Managing Microsoft Exchange Server 2007
- MS-2279: Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure
- MS-2277: Implementing, Managing and Maintaining a Microsoft Windows Server 2003: Network Infrastructure: Network Services
