Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     

Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft SQL Server 2000: Accelerated Training
with Mary Chipman & Andy Baron

View the Course Outline

In SQL Server 2000 - Accelerated Training, you'll see the new graphical tools, learn how performance and maintainability have been improved, and learn how SQL Server 2000's features position it as a powerful .NET server.

Course includes 12+ hours of total training time...

  • 3 CDs
  • Over 4 hours of media run time
  • Over 250 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs
  • Sample code
SQL Server 2000: Accelerated Training
Format Modules Retail Price



Buy Now!

CD-ROM & Books

3 CD-ROMs + Printed Books

Buy Now!

Order online 

Read about Mary Chipman & Andy Baron

Course Outline(Outlines are subject to change.)

Microsoft SQL Server 2000: Accelerated Training

Modules Run Time Pages
3 CDs 4 hours 250

SQL Server 2000 Accelerated Training is a course for experienced SQL Server Professionals. This course provides an overview of the features and functionality introduced in SQL Server 2000. The choice of a database engine is a crucial one, and to make that choice effectively you need to understand the many important new features and enhancements in SQL Server 2000. In this course, you'll learn about the new features and enhancements in Microsoft SQL Server 2000. You'll see the new graphical tools that were added and learn how they improve programmability. You'll see how performance and maintainability have been improved. And you'll see how the new XML and HTTP support position SQL Server 2000 as a powerful .NET server.

In this course, you will...

  • Use the new Query Analyzer and Profiler tools to program and monitor SQL Server 2000
  • Take advantage of the new recovery models to simplify data backups
  • Improve data manipulation and maintenance using new features such as cascading referential integrity, column-level collation settings, new data types, and improved storage of text
  • Speed up performance using new indexing capabilities
  • Increase scalability by distributing data across multiple servers
  • Improve programmability by creating user-defined functions
  • Streamline Internet applications using new support for XML and HTTP
  • Create custom rules for resolving replication conflicts
  • Import and export data more effectively with improved Data Transformation Services
  • Spot patterns and make predictions using Data Mining
Prerequisites :

SQL Server 2000 Accelerated Training is a course for experienced SQL Server Professionals. This course provides an overview of the features and functionality introduced in SQL Server 2000.

SESSION 1 (79 min)

Graphical Tools
  • Query Analyzer
  • SQL Profiler Enhancements
Server Enhancements
  • Overview
  • SQL Server Editions
  • Pricing and Licensing
  • Multiple Instances
  • Increased Memory Support
  • Security Enhancements
  • Active Directory Integration
Maintenance and Backup
  • Backup and Restore Enhancements
  • Log Shipping
  • Scalability Improvements for Utility Operations
  • Failover Clustering Enhancements
SESSION 2 (104 min)

Databases and Data
  • Copy Database Wizard
  • New Data Types
  • Column-Level Collation Order
  • Setting Database Options
  • Text in Row Data
  • Cascading Updates/Deletes
  • Extended Properties
Queries and Views
  • Index Enhancements
  • Indexed Views
  • Distributed Query Enhancements
  • Federated Servers
  • Distributed Partitioned Views
  • User-Defined Functions
  • Trigger Enhancements
XML/HTTP Support
  • Overview of XML Features
  • Generating XML from SQL Queries with FOR XML
  • Using the FOR XML EXPLICIT Clause
SESSION 3 (88 min)

XML/HTTP Support Cont.
  • Setting Up IIS for SQL Server
  • Accessing SQL Server Using a URL
  • Creating XML Views with Annotated Schemas
  • Using XPath to Retrieve SQL Server Data Directly
  • Using OpenXML to Work with XML Documents in Transact-SQL
  • Using Updategrams
Additional Features
  • Replication Enhancements
  • DTS Enhancements
  • Analysis Services Enhancements

back to top

Your Instructor

Andy Baron and Mary Chipman are co-authors and your instructors. They are both Senior Consultants with MCW Technologies, a Microsoft Certified Solution Provider. Mary and Andy specialize in database application development, training, and writing about SQL Server, Visual Basic, the .NET framework and related technologies. They are Contributing Editors at Advisor Media and at Pinnacle Publishing, contributing writers for SQL Magazine, and frequent speakers at industry conferences. Mary and Andy have both received Microsoft's Most Valuable Professional (MVP) award every year since 1995, based on their contributions to Microsoft's online support newsgroups. They are co-authors of The Access Developer's Guide to SQL Server, published by Sams, and Mary co-authored SQL Server 7.0 in Record Time, published by Sybex.

back to top

About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac

Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$

Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy