On-line training course catalogue

Querying Microsoft SQL Server 2000 with Transact-SQL

Type of course: Classroom

Course details
Fee	£750
Days	2
Course code	MS2071

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

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.

Course 4326: Getting Started with Databases and Transact-SQL in Microsoft® SQL Server™ 2005

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):

Link to this page: http://www.xpertise.co.uk/MS2071

Xpertise – Querying Microsoft SQL Server 2000 with Transact-SQL training courses

Xpertise provides Querying Microsoft SQL Server 2000 with Transact-SQL training courses from 22 UK locations: in Aberdeen Scotland, Altrincham Manchester, Birmingham West Midlands, Bristol South West, Edinburgh Scotland, Glasgow Scotland, Hinckley East Midlands, Leeds Yorkshire, Leeds Yorkshire (Ring Road), London King William Street, London Middlesex Street, London Rosebery Avenue, London Tabernacle Street, Maidenhead Berkshire, Malmesbury Wiltshire, Manchester (Exchange Quay), Milton Keynes Buckinghamshire, Newcastle Tyne and Wear, Reading Berkshire, Stockport Manchester, Swindon Wiltshire and Washington Tyne and Wear – and at 44 partner locations nationwide.

Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.