Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print Page
Click here for other MS SQL CoursesSQL Server 2000: Querying with Transact SQL (T-SQL)
Description:
This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2000 database. In addition, this course assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
- Cost: Price on application
- Duration: 2 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
To ensure your success, we recommend you have previous knowledge:
Windows 2000: Introduction
Windows 2000: Transition from Windows 98
Windows Millennium Edition: Introduction
Windows 98: Introduction
Windows 98: Transition from Windows 3.1
Windows 98: Transition from Windows 95
Windows 2000: Introduction
Windows 2000: Transition from Windows 98
Windows Millennium Edition: Introduction
Windows 98: Introduction
Windows 98: Transition from Windows 3.1
Windows 98: Transition from Windows 95
Exploring Transact-SQL:
An Overview of SQL Server and Transact-SQL
Programming in Transact-SQL
Programming in Transact-SQL
Querying Data:
Using the SELECT Statement
Formatting the Results Set
Formatting the Results Set
Changing Data through Queries:
Inserting Data
Deleting Data
Updating Data
Deleting Data
Updating Data
Summarising Data:
Working with Aggregate Functions
Grouping Data
Grouping Data
Joining Tables:
Querying Multiple Tables
Implementing Advanced Table Joins
Implementing Advanced Table Joins
Implementing Subqueries:
Designing Subqueries
Working with Full-text Indexes:
Implementing the Microsoft Search Service
Querying Full-text Indexes
Querying Full-text Indexes
Programming Transact-QL:
Programming Transact-QL:
Creating and Managing Views
Implementing Stored Procedures, Triggers and User-defined Functions
Implementing Stored Procedures, Triggers and User-defined Functions