|
|
 |
Microsoft SQL Server 2000
Querying MS SQL Server 2000 with Transact-SQL (2071)
|
|
|
Who Should Attend
| SQL Server database and Windows 2000 network administrators and developers who are responsible for writing queries and the management and technical support of Windows 2000 networks, support engineers, MCP and MCSE candidates. |
Prerequisites
| Completion of course (1609) Designing Data Services and Data Models or experience using a Microsoft Windows operating system, an understanding of database fundamentals and familiarity with the role of the database administrator or eqilivelent experience. |
Course Objectives
| This course provides the necessary knowledge and skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000. Participants will learn to describe the use of and ways to execute the Transact-SQL language, use querying tools, write SELECT queries to retrieve data and group and summarise data by using Transact-SQL. Students will also link data from multiple tables, write queries that retrieve and modify data by using sub-queries, modify data in tables and query text fields with full-text search. |
Course Content
| 1. Overview of the Transact-SQL language
|
| 2. Using Transact-SQL querying tools such as the object browser and osql utility
|
| 3. Retrieving Data and format result sets
|
| 4. Grouping and summarising data
|
| 5. Combine data from two or more tables by using joins
|
| 6. Using sub-queries to break down and perform complex queries
|
| 7. Inserting data, deleting data and updating data within a SQL 2000 database
|
| 8. Querying full-text Indexes
|
| 9. Introduction to programming objects such as views, stored procedures, triggers and user-defined functions |
|
|
|
|
Top