Microsoft SQL Server 2000: Querying with Transact-SQL

Course Specifications

Course number: 077463
Course length: Two days of training.
Software: Microsoft_SQL_Server 2000

Course Description

This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2000 database. In addition, this course assists you 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 your success, we recommend you first take any of the following Element K courses or have equivalent knowledge:

Delivery Method:  Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Hardware/Software Requirements

You will need:

Performance-Based Objectives

Course Content

Lesson 1: Exploring Transact-SQL
Topic 1A: An Overview of SQL Server and Transact-SQL
Topic 1B: Programming in Transact-SQL

Lesson 2: Querying Data
Topic 2A: Using the SELECT Statement
Topic 2B: Formatting the Results Set

Lesson 3: Changing Data Through Queries
Topic 3A: Inserting Data
Topic 3B: Deleting Data
Topic 3C: Updating Data

Lesson 4: Summarizing Data
Topic 4A: Working with Aggregate Functions
Topic 4B: Grouping Data

Lesson 5: Joining Tables
Topic 5A: Querying Multiple Tables
Topic 5B: Implementing Advanced Table Joins

Lesson 6: Implementing Subqueries
Topic 6A: Designing Subqueries

Lesson 7: Working with Full-text Indexes
Topic 7A: Implementing the Microsoft Search Service
Topic 7B: Querying Full-text Indexes

Lesson 8: Programming Transact-SQL
Topic 8A: Creating and Managing Views
Topic 8B: Implementing Stored Procedures, Triggers, and User-defined Functions

Appendix A: The Movies Database Structure
Table DesignTopic