|
 Querying Microsoft SQL Server 2000 with Transact-SQL
Course Details:
- Days: 2
- Course Code: MS2071
- Booking: Please ring 08450 50 45 05
Warning: include() [function.include]: URL file-access is disabled in the server configuration in D:\inetpub\vhosts\mcse-courses.com\httpdocs\ms2071.php on line 71
Warning: include(http://www.microsoft-certification.co.uk/get.php?csid=2754) [function.include]: failed to open stream: no suitable wrapper could be found in D:\inetpub\vhosts\mcse-courses.com\httpdocs\ms2071.php on line 71
Warning: include() [function.include]: Failed opening 'http://www.microsoft-certification.co.uk/get.php?csid=2754' for inclusion (include_path='.;./includes;./pear') in D:\inetpub\vhosts\mcse-courses.com\httpdocs\ms2071.php on line 71
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
|