computer training  


it certification software

Search Courses by Keywords

Computer Based Training - CBT Library Suites Online Computer Training Distance Learning IT Boot Camps Contact Us
computer training cd
IT Certification IT Training Desktop Office Training Soft Skills Training Course Demos
mcse cbt
 
Unlimited Online Training Libraries
Unlimited Online IT Training
Unlimited Desktop Office Training
All Access Pre-Paid Card
 
IT CBT Training Library Suites
Corporate All-In-One Enterprise Library
Corporate IT Enterprise Training Library
Computer Desktop Enterprise Training
Basic Computer Training (Small to Medium Size Businesses)
Soft Skills (Professional Development)
Adobe CS3 / CS4 Library
Cisco Certification Library
CompTIA Certification Training Library
Microsoft Developer CBT Library
Microsoft Exchange CBT Library
Microsoft Office Server 2007 Library
Microsoft Office Ultimate Training
Microsoft SQL 2005 CBT Library
Microsoft Vista Business / Office 2007
Microsoft Server 2008 CBT Library
Microsoft Server 2003 CBT Library
Network Security Suite
Oracle 10g Suite
Oracle 11g Suite
Project Management Suite
 
Cisco Certification Courses
Cisco CCNA - CCNP - CCIE - CCENT
CompTIA
A+ Training - Security+ - Linux+
Network+ - Server+ - Project+
Linux
RH033, RH133, RH253
Microsoft Certifications
MCSE Training 2003
MCSA 2003 Update to 2008
MCSE 2003 Upgrade to 2008
MCTS Training CDs
  Exchange 2007 Configuration
  Office SharePoint Server 2007
  SQL 2005 Implementation and Maintenance
  SQL 2005 Business Intelligence
  Windows Server 2008 Active Directory
  Windows Server 2008 Network Infrastructure
  Windows Server 2008 Application Platforms
  Windows Vista Configuration
MCITP Training CDs
  Business Intelligence Developer
  Consumer Support
  Database Administrator
  Database Developer
  Enterprise Messaging Administrator
  Enterprise Project Management
  Enterprise Support Techncian
  Server Administrator
MCPD Training Courses
  Windows Developer
  Web Developer
  Enterprise Applications Developer
Network IT Security
Hacking, Penetration Testing and Countermeasures
CISSP Training - SSCP - ISC2 CAP
CEH - CISA - CISM
ECSA - SCNP - SCNS
Oracle
Oracle 10g DBA - Oracle 11g DBA
Project Management
ITIL v3 Training - PMP - CAPM
Virtualization
VMWare
Windows Server 2008 Training
 
IT Certification Boot Camp Classes
MCSE Boot Camp
MCPD Boot Camp
MCITP Boot Camp
CCNA Bootcamps
CCNP Boot Camp
CISSP Bootcamps
VMware Boot Camp
 
More Links:
K Alliance
Atlanta Boot Camps
Tampa / Sarasota Boot Camps
8570 DOD Training
MCSE 2008
IT Career Tracks
Computer Training Courseware
Free Tutorials and Articles
Onsite Computer Training
Custom CBT Development
 


Home Page :: Microsoft Technical Training Courses :: Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries Training CBT

Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries Training CBT

Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries Training CBT

Price: $150.00

Training Course ID: CBT 88-73471

Training Course Description / Outline:

The Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries Computer Based Training CBT course will teach students how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions.

Sever 2000 CBT Total Training Time
8 hours

Learn To:

  • 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.

Training Audience

The Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries Computer Based Training CBT target audience 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.

Training Objectives

Unit 1: Joining Multiple Tables 2 - 3 hours

  • Identify advantages of using aliases for table names.
  • Identify the guidelines for using joins.
  • Identify the considerations for using inner joins.
  • Identify the functions of the types of outer joins.
  • Identify the guidelines for joining more than two tables.
  • Identify the guidelines for using self-joins.
  • Identify the guidelines for combining multiple queries into a single result set with the UNION operator.
  • Use the UNION operator to combine result sets.

Unit 2: Subqueries and Full-Text Indexes 2 - 3 hours

  • Identify considerations for using subqueries.
  • Create a derived table by using a subquery.
  • Create a single-value subquery.
  • Create a multiple-value subquery.
  • Identify the steps involved in the evaluation of a correlated subquery.
  • Identify the syntax of a correlated subquery to mimic a JOIN clause.
  • Identify the syntax of a correlated subquery to mimic a HAVING clause.
  • Identify the features of the EXISTS and NOT EXISTS operators.
  • Correlate data by using a subquery.
  • Identify the characteristics of Microsoft Search service.
  • Identify the components of Microsoft Search service.
  • Identify the procedures and functions used to obtain information about full-text search.
  • Retrieve information about full-text indexes.
  • Identify the syntax elements used to write full-text queries.
  • Identify the uses of the CONTAINS predicate.
  • Identify the characteristics of the FREETEXT predicate.
  • Identify the characteristics of the CONTAINSTABLE and FREETEXTTABLE functions.
  • Write full-text queries.

Unit 3: Introduction to Programming Objects/ 2 hours

  • Identify the functions of views.
  • Identify the considerations for defining views.
  • Create a view by using an SQL Query Analyzer template.
  • Alter a view by using the Object Browser in SQL Query Analyzer.
  • Identify the characteristics of stored procedures.
  • Identify the advantages of stored procedures.
  • Identify the features of sp_helptext for displaying the text of a programming object.
  • Identify the characteristics of user-defined functions.
  • Identify the characteristics of the CREATE FUNCTION statement.

Copyright © 2001-2009 CBT Planet All rights reserved. - Computer Based Training