Popular Training Courses
- Microsoft Office 2010 Training
- PMP Training
- MCSE Certification Training
- CompTIA A+ Certification Training
- Cisco CCNA CertificationTraining
- Windows 7 Training
- Microsoft Excel Training
- CISSP Training
- Microsoft Office Training
- CompTIA Network+ Training
- MCITP Training
- Microsoft Project Training
- Project Management Training
- QuickBooks Pro Training
- Microsoft Windows Server Training
CBT Training Courses
Resources
Learning Partners
In the News
Computer Careers
- Network System Administrator
- Computer Network Engineer
- Computer Security Specialist
- System Analyst
- Database Administrator
- Database Programmer
- Project Management
- Computer Repair Tech
- IT Support Technician
- IT Support Analyst
- Graphic Designer
- Web Designer
- Web Developer
- Software Developer
- Computer Software Engineer
Microsoft CBT Training Courses
Microsoft SQL Server 2000: Querying with Transact SQL CBT Training Suite
Microsoft SQL Server 2000: Querying with Transact SQL Suite Online Training Course
Price: $258.00
Online Training Course ID:CBT 88-73470D
Training Course Description / Outline
Microsoft SQL Server 2000: Querying with Transact SQL Suite Computer Based Training CBT will cover manipulating data with Transact-SQL, how to work with queries, introduce views, understand stored procedures, triggers, and user-defined functions.
Sever 2000 CBT Total Training Time
2 courses - 16 hours
| /mcse2003.htm<Server 2000 CBT Training Modules - 2 Training Modules | <Training Hours |
|
| Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data |
8 |
|
| Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries |
8 |
|
Learn To
- Identify the basic types of statements used in Transact-Structured Query Language (SQL).
- Identify the functions of Data Definition Language (DDL) statements.
- Identify the functions of Data Control Language (DCL) statements.
- Identify the guidelines for selecting columns within a table.
- Identify the guidelines for using the WHERE clause to retrieve rows in a table.
- Retrieve specific columns from a table.
- Identify the characteristics of aggregate functions.
- Identify the considerations for using the GROUP BY clause.
- Identify the guidelines for using the GROUP BY clause with the HAVING clause.
- Identify advantages of using aliases for table names.
- Identify the guidelines for using joins.
- Identify the considerations for using inner joins.
- Identify considerations for using subqueries.
- Create a derived table by using a subquery.
- Create a single-value subquery.
- Identify the functions of views.
- Identify the considerations for defining views.
- Create a view by using an SQL Query Analyzer template.
Audience
This Microsoft SQL Server 2000: Querying with Transact SQL Suite Computer Based Training CBT for this course 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.