|
|
|
Back To Microsoft Training Courses
Microsoft SQL Server 2000: Querying with Transact SQL Training CBT Suite
Price: $258.00
CBT Course Overview:
The Self Study Store Computer Based Training Microsoft SQL Server 2000: Querying with Transact SQL will cover manipulating data with Transact-SQL, how to work with queries, introduce views, understand stored procedures, triggers, and user-defined functions.
Total Training Duration:
16 hours
CBT Course Modules:
- Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data Course Training
- Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries Training
Training Course Topics:
- Learn the basic types of statements used in Transact-Structured Query Language (SQL).
- Learn the functions of Data Definition Language (DDL) statements.
- Learn the functions of Data Control Language (DCL) statements.
- Learn the guidelines for selecting columns within a table.
- Learn the guidelines for using the WHERE clause to retrieve rows in a table.
- Retrieve specific columns from a table.
- Learn the characteristics of aggregate functions.
- Learn the considerations for using the GROUP BY clause.
- Learn the guidelines for using the GROUP BY clause with the HAVING clause.
- Learn advantages of using aliases for table names.
- Learn the guidelines for using joins.
- Learn the considerations for using inner joins.
- Learn considerations for using subqueries.
- Create a derived table by using a subquery.
- Create a single-value subquery.
- Learn the functions of views.
- Learn the considerations for defining views.
- Create a view by using an SQL Query Analyzer template.
The Self Study Store Computer Based Training Microsoft SQL Server 2000: Querying with Transact SQL course is aim for audience who operate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are expected to have an understanding of basic relational database concepts and should be familiar with the role of the database administrator.
|
