• Back to Microsoft Courses

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.

Please note : whilst this course utilizes SQL Server 2000, it would be valuable for those who need to learn TSQL for use in a SQL 2005 environment. The course includes Microsoft elearning course Course 4326: Getting Started with Databases and Transact-SQL in Microsoft SQL Server 2005 for those working in a 2005 environment. You must specify you would like this title at the time of placing the booking.

• Course 4326: Getting Started with Databases and Transact-SQL in Microsoft SQL Server 2005

Leads to examination

• 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

Related Certifications

This course forms part of the following certification track(s):

• MCAD Windows Development: C# .NET
• MCAD Web Development: Visual Basic .NET
• MCAD Web Development: C# .NET
• MCAD Windows Development: Visual Basic .NET
• MCSD C# .NET
• MCSD Visual Basic .NET
• MCSE Windows Server 2003

• Back to Top
• Back to Microsoft Courses