Microsoft SQL Server 2000: Database Design

PT2549
Summary
This course teaches students how to use the Transact-SQL language to query and program Microsoft SQL Server 2000 in a Windows 2000 Server environment. This course also assists students in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
Prerequisites
To ensure success, students should take the Windows 2000: Installation and Administration, or the Windows 2000 for Windows NT Administrators courses or have equivalent knowledge. Students should also know the basics of querying a SQL server by using the SELECT, INSERT, and UPDATE SQL statements. Students who aren't familiar with using these commands should first take the Microsoft SQL Server 2000: Querying with Transact-SQL course.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for SQL programmers
Topics
  • An Overview of SQL Server
  • Exploring Transact-SQL
  • Designing and Implementing Databases
  • Creating and Managing Tables
  • Designing and Implementing Data Integrity
  • Implementing Indexes
  • Joining Tables
  • Designing Views
  • Creating Stored Procedures
  • Using Functions
  • Creating Triggers
  • Understanding Transactions and Locks
  • Implementing Distributed Queries
  • Optimizing Queries
  • Analyzing Queries
  • The Movies Database Structure
  • Course Script Files

Related Scheduled Courses