Microsoft Course 2071- Querying Microsoft SQL Server 2000 with Transact-SQL

2071 - Querying Microsoft SQL Server 2000 with Transact-SQL

Course duration: 2 days

Course 2071 Locations

Course outline:

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 ServerT 2000.

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.

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.

Objectives:

On completion of this SQL Server training course, students 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 summarise 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.

Unit 1: Introduction to Transact-SQL

The Transact-SQL Programming Language
Types of Transact-SQL Statements
Transact-SQL Syntax Elements
Using SQL Server Books Online

Unit 2: Using Transact-SQL Querying Tools

SQL Query analyser
Using the Object Browser Tool in SQL Query analyser
Using the osql Utility
Executing Transact-SQL Statements
Creating and Executing Transact-SQL Scripts

Unit 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

Unit 4: Grouping and Summarising 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 Summarising Data

Unit 5: Joining Multiple Tables

Using Aliases for Table Names
Combining Data from Multiple Tables
Combining Multiple Result Sets
Querying Multiple Tables

Unit 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

Unit 7: Modifying Data

Using Transactions
Inserting Data
Deleting Data
Updating Data
Performance Considerations
Modifying Data

Unit 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

Unit 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

Top

Course Schedule

Unfortunately we do no have any courses scheduled at this time. Please email us your requirements and we will endeavour to provide this course for you.