Overview:

The Querying Microsoft SQL Server 2000 with Transact SQL training 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.

There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server. The course is aimed at both non-technical “power users” and IT Professionals who will be writing queries for use with Microsoft SQL Server.

Benefits:

Benefits of the Querying Microsoft SQL Server 2000 with Transact SQL training course: 

• 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

Course details:

Course details of the Querying Microsoft SQL Server 2000 with Transact SQL training course:

• 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

Usual duration: Two days

Training buyers can use comparecourse.com to compare Querying Microsoft SQL Server 2000 with Transact SQL training courses or to compare training for IT from across the UK, by finding IT training companies who deliver in key cities including London, Manchester, Leeds, Sheffield, Birmingham, Bristol, Swindon, Cardiff, Liverpool, Newcastle, Nottingham, Leicester, Coventry, Norwich, Cambridge, Ipswich, Reading, Southampton, Oxford, Glasgow, Edinburgh and Belfast.