077463 - Microsoft SQL Server 2000: Querying with Transact-SQL

Code: 077463
Course duration: 5 days
Price:

077463 - Microsoft SQL Server 2000: Querying with Transact-SQL(5 Days)

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:

  • Windows 2000: Introduction
  • Windows 2000: Transition from Windows 98
  • Windows Millennium Edition: Introduction
  • Windows 98: Introduction
  • Windows 98: Transition from Windows 3.1
  • Windows 98: Transition from Windows 95


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

Hardware/Software Requirements

You will need:

  • At least 128 MB of RAM for each student computer (256 MB strongly recommended). At least 256 MB for the instructor's computer.
  • A 2 GB or larger hard drive for each of the student computers, and a 4 GB or larger hard drive for the instructor's computer.
  • A Pentium 166 MHz processor or faster.
  • A VGA or higher resolution video card and monitor.
  • A mouse or compatible tracking device.
  • A 12 X (or faster) CD-ROM drive.
  • A network adapter and network cabling.
  • A licensed copy of Windows 2000 Server or Advanced Server for each student and the instructor.
  • Windows 2000 Service Pack 1 or later.
  • A licensed copy of Microsoft SQL Server 2000 Enterprise Edition for each student and the instructor.
  • For the instructor's computer only, a display system to project the instructor's computer screen and PowerPoint slides.

Performance-Based Objectives

  • Identify the features of Transact-SQL and use the Transact-SQL utilities to query a SQL server.
  • Retrieve data by using the SELECT statement.
  • Modify data by using the INSERT, UPDATE, and DELETE statements.
  • Summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses.
  • Query multiple tables through the use of joins.
  • Design subqueries.
  • Work with full-text indexes.
  • Describe the types of programming objects in Transact-SQL.

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

Course Reviews

No reviews found for this course.

Be the first to write a review