|
 Querying Microsoft SQL Server 2000 with Transact-SQL
Course Details:
- Days: 2
- Course Code: MS2071
- Booking: Please ring 08450 50 45 05
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..
Leads to examinations
- 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
|