Loading Course Schedule...
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