A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2014) Customizing Microsoft Office SharePoint Portal Server 2003 - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Premier
SQL Server

Querying Microsoft SQL Server 2000 with Transact-SQL.
(Microsoft Training Course: 2071) - 2 days - £1015 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000. It is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries
> Course outline
  1. Introduction to Transact-SQL
  2. Using Transact-SQL Querying Tools
  3. Retrieving Data
  4. Grouping and Summarizing Data
  5. Joining Multiple Tables
  6. Working with Subqueries
  7. Modifying Data
  8. Querying Full-Text Indexes
  9. Introduction to Programming Objects
Supplementary Information Please note that this course was written for SQL Server 2000. Similar content for SQL Server 2008 is covered in Course 2778, but unfortunately there is no Microsoft Official Curriculum on this subject for SQL Server 2005. However both novice users and users with a fair amount of experience of SQL Server 2000 or 2005 often find this course provides a useful grounding in Transact-SQL.
Module 1: Introduction to Transact-SQL
  • The Transact-SQL Programming Language
  • Types of Transact-SQL Statements
  • Transact-SQL Syntax Elements
  • Using SQL Server Books Online
Skills
  • Differentiate between Transact-SQL and ANSI-SQL.
  • Describe the basic types of Transact-SQL.
  • Describe the syntax elements of Transact-SQL.
top
Module 2: 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
Skills
  • Describe the basic functions of SQL Query Analyzer.
  • Describe how to use the Object Browser tool in SQL Query Analyzer.
  • Describe how to use the templates in SQL Query Analyzer.
  • Describe how to use the osql command-line utility.
  • Execute Transact-SQL statements in various ways.
top
Module 3: 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
Skills
  • Retrieve data from tables by using the SELECT statement.
  • Filter data by using different search conditions to use with the WHERE clause.
  • Format result sets.
  • Describe how queries are processed.
  • Describe performance considerations that affect retrieving data.
top
Module 4: 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
Skills
  • Use the TOP n keyword to retrieve a list of the specified top values in a table.
  • Generate a single summary value by using aggregate functions.
  • Organize summary data for a column by using aggregate functions with the GROUP BY and HAVING clauses.
  • Generate summary data for a table by using aggregate functions with the GROUP BY clause and the ROLLUP or CUBE operator.
  • Generate control-break reports by using the COMPUTE and COMPUTE BY clauses.
top
Module 5: Joining Multiple Tables
  • Using Aliases for Table Names
  • Combining Data from Multiple Tables
  • Combining Multiple Result Sets
  • Querying Multiple Tables
Skills
  • Use aliases for table names.
  • Combine data from two or more tables by using joins.
  • Combine multiple result sets into one result set by using the UNION operator.
top
Module 6: 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
Skills
  • Describe when and how to use a subquery.
  • Use subqueries to break down and perform complex queries.
top
Module 7: Modifying Data
  • Using Transactions
  • Inserting Data
  • Deleting Data
  • Updating Data
  • Performance Considerations
  • Modifying Data
Skills
  • Describe how transactions work.
  • Write INSERT, DELETE, and UPDATE statements to modify data in tables.
  • Describe performance considerations related to modifying data.
top
Module 8: 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
Skills
  • Describe Microsoft Search service function and components.
  • Get information about full-text indexes.
  • Write full-text queries.
top
Module 9: 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
Skills
  • Display the text of a programming object.
  • Describe the concepts of views.
  • List the advantages of views.
  • Describe stored procedures.
  • Describe triggers.
  • Describe user-defined functions.
top
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • 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).
  • For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills: Course 1609, Designing Data Services and Data Models
  • Familiarity with the role of the database administrator.
> Purpose
At the end of the course, students will 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
> Supplementary Information
Please note that this course was written for SQL Server 2000. Similar content for SQL Server 2008 is covered in Course 2778, but unfortunately there is no Microsoft Official Curriculum on this subject for SQL Server 2005. However both novice users and users with a fair amount of experience of SQL Server 2000 or 2005 often find this course provides a useful grounding in Transact-SQL.
> EXAMS
There are no exams directly associated with this course