Querying Microsoft SQL 2000 with Transact SQL

Course Code: MS2071
Duration: 2 Days

Bookmark and Share

Overview

This course provides delegates with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000. It is intended for Microsoft SQL Server database administrators, implementers, system engineers and developers.

Please note : whilst this course utilizes SQL Server 2000, it would be valuable for those who need to learn TSQL for use in a SQL 2005 environment. The course includes Microsoft elearning course Course 4326: Getting Started with Databases and Transact-SQL in Microsoft SQL Server 2005 for those working in a 2005 environment. You must specify you would like this title at the time of placing the booking.

Leads to examination

  • 70-229 – Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Prerequisites

Delegates should have experience of using a Microsoft Windows operating system and have an understanding of relational database concepts including:

  • Logical and physical database design.
  • Data integrity concepts.
  • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
  • How data is stored in tables (rows and columns).
  • Familiarity with the role of the database administrator

Delegates will learn how to

  • Use querying tools
  • Write SELECT queries to retrieve data
  • Write queries that retrieve and modify data by using subqueries
  • Describe the uses of and ways to execute the Transact-SQL language
  • Query text fields with full-text search
  • Modify data in tables
  • Group and summarise data by using Transact-SQL
  • Join data from multiple tables
  • Describe how to create programming objects

Outline

  • 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
  • Module 9: Introduction to Programming Objects

Related Certifications

This course forms part of the following certification track(s):