Querying Microsoft SQL Server 2000 with Transact-SQL.(Microsoft Training Course: 2071) - Microsoft Training Courses London South West UK

Exchange Server

Office (inc Access)

SQL Server

Visual Studio .NET

Windows

Web Development

Visual FoxPro

Programming

Business

Knowledge Management

Certification

Learning Options

Reserve a Place
06 May London
27 May Bath
02 Jun London
23 Jun Bath
07 Jul London
28 Jul Bath
04 Aug London
26 Aug Bath
01 Sep London
23 Sep Bath
06 Oct London
21 Oct Bath
03 Nov London
18 Nov Bath
01 Dec London
16 Dec Bath
05 Jan London
13 Jan Bath
02 Feb London
02 Feb London
02 Feb London
10 Feb Bath
10 Feb Bath
10 Feb Bath

View Other Courses in Same Category

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

Target Audience		Pre-requisites
Purpose		Print 2 Page Flyer
Exams		Price Options

COURSE OUTLINE

Introduction to Transact-SQL		Using Transact-SQL Querying Tools
Retrieving Data		Grouping and Summarizing Data
Joining Multiple Tables		Working with Subqueries
Modifying Data		Querying Full-Text Indexes
Introduction to Programming Objects

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

.

Microsoft recommends this course in preparation for the following exams:

Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Price Options ex VAT:

Classroom Training ?	Distance Learning ?	eLearning Options ?	Book Learning ?
£ 700 (€994)	£ 449.00 (€638)	-	MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition
	Call Free on 0800 169 1890 Print 2 Page Flyer Last Modified 01 May 2008