|
Microsoft Courses 2071 Querying MS SQL 2000 with Transact SQL — A 2-Day
Course Synopsis
The goal of this SQL training course is to provide students with the
technical skills required to write basic Transact-SQL queries for Microsoft SQL
Server™ 2000.
Course Objectives
On completion of this SQL Server training course, delegates should be able to:
- Describe the uses of and ways to execute the Transact-SQL language.
- Use querying tools.
- Write SELECT queries to retrieve data.
- Group and summarize data by using Transact-SQL.
- Join data from multiple tables.
- Write queries that retrieve and modify data by using subqueries.
- Modify data in tables.
- Query text fields with full-text search.
- Describe how to create programming objects.
Intended Audience
This SQL training course is intended for:
- SQL Server database administrators
- SQL Server implementers
- SQL Server system engineers
- SQL Server developers
- IT professionals who are responsible for writing Transact SQL queries for SQL Server.
Course Prerequisites
Before attending this course, delegates are expected to have:
- Experience using a Microsoft Windows operating system.
- An understanding of basic 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.
Certification
This course will help the student prepare for the following Microsoft Certified Professional exam:
- Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Course Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.
The following software is provided in the student kit:
- Microsoft SQL Server 2000, Enterprise Edition Evaluation Copy
Publicly scheduled dates, locations, and prices
Central London — £395 (+VAT)
- 2–3 Jun 2008
- 23–24 Jun 2008
- 30 Jun–1 Jul 2008
- 14–15 Aug 2008
- 29–30 Sep 2008
- 27–28 Oct 2008
- 24–25 Nov 2008
- 19–20 Jan 2009
- 12–13 Feb 2009
- 10–11 Mar 2009
- 6–7 Apr 2009
- 7–8 May 2009
- 3–4 Jun 2009
Leeds — £395 (+VAT)
- 3–4 Jul 2008
- 3–4 Nov 2008
- 2–3 Mar 2009
Birmingham — £395 (+VAT)
- 2–3 Jun 2008
- 3–4 Jul 2008
- 25–26 Sep 2008
- 5–6 Jan 2009
- 2–3 Apr 2009
Reading — £395 (+VAT)
- 5–6 Jun 2008
- 2–3 Oct 2008
- 12–13 Feb 2009
- 1–2 Jun 2009
Edinburgh — £395 (+VAT)
- 5–6 Jun 2008
- 4–5 Dec 2008
- 9–10 Mar 2009
- 8–9 Jun 2009
Glasgow — £395 (+VAT)
- 28–29 Aug 2008
- 2–3 Dec 2008
- 14–15 Apr 2009
Milton Keynes — £395 (+VAT)
- 16–17 Oct 2008
- 2–3 Mar 2009
Outline Course Contents
Introduction to Transact-SQL
- The Transact-SQL Programming Language
- Types of Transact-SQL Statements
- Transact-SQL Syntax Elements
- Using SQL Server Books Online
Using Transact-SQL Querying Tools
- SQL Query Analyzer
- Using the Object Browser Tool in SQL Query Analyzer
- Using the osql Utility
- Executing Transact-SQL Statements
- Creating and Executing Transact-SQL Scripts
Retrieving Data
- Retrieving Data by Using the SELECT Statement
- Filtering Data
- Formatting Result Sets
- How Queries Are Processed
- Performance Considerations
- Retrieving Data and Manipulating Result Sets
Grouping and Summarizing Data
- Listing the TOP n Values
- Using Aggregate Functions
- GROUP BY Fundamentals
- Generating Aggregate Values Within Result Sets
- Using the COMPUTE and COMPUTE BY Clauses
- Grouping and Summarizing Data
Joining Multiple Tables
- Using Aliases for Table Names
- Combining Data from Multiple Tables
- Combining Multiple Result Sets
- Querying Multiple Tables
Working with Subqueries
- Introduction to Subqueries
- Using a Subquery as a Derived Table
- Using a Subquery as an Expression
- Using a Subquery to Correlate Data
- Using the EXISTS and NOT EXISTS Clauses
- Working with Subqueries
Modifying Data
- Using Transactions
- Inserting Data
- Deleting Data
- Updating Data
- Performance Considerations
- Modifying Data
Querying Full-Text Indexes
- Introduction to Microsoft Search Service
- Microsoft Search Service Components
- Getting Information About Full-Text Indexes
- Writing Full-Text Queries
- Querying Full-Text Indexes
Introduction to Programming Objects
- Displaying the Text of a Programming Object
- Introduction to Views
- Advantages of Views
- Creating Views
- Introduction to Stored Procedures
- Introduction to Triggers
- Introduction to User-defined Functions
- Working with Views
|
Publicly Scheduled Training Locations
We currently run public training courses in the following locations:
- London, UK
- Leeds, West Yorkshire, UK
- Birmingham, West Midlands, UK
- Carshalton, Surrey, UK
- Chester, North West, UK
- Coventry, West Midlands, UK
- Edinburgh, Scotland, UK
- Glasgow, Scotland, UK
- Harwell, Oxfordshire, UK
- Manchester, North West, UK
- Milton Keynes, Buckinghamshire, UK
- Newark, Nottinghamshire, UK
- Reading, Berkshire, UK
- Slough, Berkshire, UK
- Stevenage, Hertfordshire, UK
- Wakefield, West Yorkshire, UK
- Wokingham, Berkshire, UK
Most UK public training courses are available on a monthly basis.
Please see the individual course outlines or our public
training schedule
for details.
In-house (on-site) training locations
We deliver in-house courses at client premises and/or training facilities in
any part of the world which is practically and commercially accessible.
Our In-house training guidelines
outline our basic requirements and our UK pricing structure. To estimate costs
for training in other countries, simply convert to your local currency and then
make a rough calculation of our tutor's costs for travelling to and staying at
your location.
|
