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