Transcript Document

Designing and Implementing
Databases with Microsoft SQL
Server 2000 Enterprise Edition
MCP Exam 70-229
Introduction
• Core credit toward MCDBA certification
• Elective credit toward MCSE (Win 2000
and NT 4.0 )certification
• Elective credit toward MCSD (.Net)
certification
• Elective credit toward MCAD (.Net)
certification
Course 2071
• Querying Microsoft SQL Server 2000 with
Transact-SQL
• The goal of this course is to provide
students with the technical skills required to
write basic Transact-SQL queries for
Microsoft SQL Server™ 2000.
• 2 days training (14 hours).
2071: Course Modules
•
•
•
•
•
•
•
•
Module 1: Introduction to Transact-SQL
Module 2: Using Transact-SQL Querying Tools
Module 3: Retrieving Data
Module 4: Grouping and Summarizing Data
Module 5: Joining Multiple Tables
Module 6: Working with Subqueries
Module 7: Modifying Data
Module 8: Querying Full-Text Indexes
Course 2073
• Programming a Microsoft SQL Server 2000
Database
• This course provides students with the
technical skills required to program a
database solution by using Microsoft SQL
Server™ 2000.
• 5 days training (35 hours).
2073: Course Modules
•
•
•
•
•
•
•
•
Module 1: SQL Server Overview
Module 2: Overview of Programming SQL Server
Module 3: Creating and Managing Databases
Module 4: Creating Data Types and Tables
Module 5: Implementing Data Integrity
Module 6: Planning Indexes
Module 7: Creating and Maintaining Indexes
Module 8: Implementing Views
2073: Course Modules
•
•
•
•
•
•
•
Module 9: Implementing Stored Procedures
Module 10: Implementing User-defined Functions
Module 11: Implementing Triggers
Module 12: Programming Across Multiple Servers
Module 13: Optimizing Query Performance
Module 14: Analyzing Queries
Module 15: Managing Transactions and Locks
Contact Details
Name:
LK Soon
Room:
Room #3, 3rd Flr, Blk. B, FOE Building
Tel:
03-8312 5245
E-mail:
[email protected]