• 14 CD-ROMs with over 22 hours of instruction by Andy Baron and Mary Chipman
• Courseware including hands-on labs to reinforce important concepts
• Corresponding disks with sample code
• Focused on practical solutions to real-world development problems
• Comprehensive, understandable, and reusable as reference material.

Our Instructors:

Andy Baron, Mary Chipman are Senior Consultants with MCW Technologies, a Microsoft Solution Provider. All have been Microsoft MVPs since 1995. When not creating applications for clients, Andy and Mary write articles for technical journals such as MSDN, Visual Basic Programmer's Journal, asp.netPRO, Access-VB-SQL Advisor, MsOfficePro, and SQL Server Magazine, and have written over 10 technical books on various development topics. All three authors speak regularly at industry conferences, including Microsoft's Tech-Ed and DevDays, DevConnections, VBITS, and Advisor Devcon.

Training with CareerAcademy CD-ROMs is a cost effective method that meets the critical demands of computer users. Experience expert-led courses in a comfortable and convenient environment. You get the feel of classroom delivered through flexible and familiar technology.

Training comes to life with our full motion video, challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. See the steps, hear the explanations then put your skills to work. Our proven methodology provides an unequalled training experience with exceptional results.

CD-ROMs feature:

• Full Motion Video: John Durant takes you step-by-step through the learning experience including interactive simulations.
• Pre and Post Testing: Comprehensive testing lets you diagnose the best areas for concentration and helps you track your improvement.
• Coach Feature: At any point in the course you can select the "Coach" button for focused learning on specific topics.
• Printed Courseware: The CD-ROM set comes complete with printed courseware, a valuable reference tool after your training is complete.

SQL Server Training

CD-ROM 1 (95 min) SQL Server Tour SQL Server Editions Graphical Tools Exploring the Enterprise Manager Working with SQL Server Books Online Installing SQL Server Multiple Instances Installing an Instance of SQL Server Configuring the Server Designing and Creating a Database Relational Database Design Principles CD-ROM 2 (95 min) Designing and Creating a Database (continued) Implementing the Design Basic Querying Introduction to the Query Analyzer Retrieving Data CD-ROM 3 (64 min) Basic Querying (continued) Joining Tables Action Queries Modifying Data Inserting Data Updating Data Deleting Data CD-ROM 4 (112 min) Using the Query Analyzer Query Analyzer Features The File Menu Items The Edit Menu Query Menu Items Tools Menu Items Window Menu Items Help Menu Items Programming With Transact-SQL Overview of Transact-SQL Using Built-In Functions CD-ROM 5 (85 min) Programming With Transact-SQL (continued) Control of Flow Error Handling Transaction Processing Transactions Working with Locks Monitoring Processes and Locks Transaction Isolation Blocking and Deadlocks Creating Views What is a View? CD-ROM 6 (115 min) Creating Views (continued) Creating Views Updating Views Backups and Maintenance Creating a Backup Strategy Implementing Backups Restoring from a Backup The Database Maintenance Plan Wizard Stored Procedures and Triggers Building Stored Procedures CD-ROM 7 (115 min) Stored Procedures and Triggers (continued) Building Stored Procedures (continued) Building Triggers Using INSTEAD OF Triggers User-Defined Functions User-Defined Functions in SQL Server 2000 Scalar Functions Inline Table-Valued Functions Multi-Statement Table-Valued Functions Functions, Views, and Stored Procedures CD-ROM 8 (93 min) Advanced Queries and Linked Servers Dynamic SQL Transact-SQL Cursors Handling Large Data Sets Distributed Queries Security Security Overview Authentication Understanding Roles Assigning Permissions CD-ROM 9 (75 min) Security (continued) Application Roles Monitoring, Tuning, and Configuration Evaluating Performance Monitoring with SQL Server Profiler Tuning Queries Working with Indexes Indexed Views Using the Index Tuning Wizard Data Caching The System Monitor CD-ROM 10 (100 min) Using System Objects Exploring System Objects DBCC Automating Administration with SQL Agent Configuring SQL Server Agent Operators Jobs Alerts Create an Alert Data Transformation Services (DTS) Introduction The DTS Import/Export Wizard CD-ROM 11 (107 min) Data Transformation Services (DTS) (continued) DTS Packages Controlling DTS Workflow Replication Introduction to Replication Implementing Replication Publish SQL Server Data to the Web Publishing Data to the Web The Web Assistant Wizard The SQL Server Web Stored Procedures Scheduling Web Jobs XML Features, Part I XML Fundamentals CD-ROM 12 (97 min) XML Features, Part I (continued) Generating XML from SQL Queries with FOR XML Using FOR XML Explicit Setting Up IIS for SQL Server Accessing SQL Server Using a URL XML Features, Part II Creating XML Views with Annotated Schemas Using Xpath to Retrieve SQL Server Data Directly Using OpenXML to Work with XML Documents in Transact-SQL CD-ROM 13 (103 min) XML Features, Part II (continued) Using Updategrams Full Text Search What is Full-Text Search? Configuring Full-Text Search Writing Full-Text Queries Using Full-Text Search with Documents Stored in SQL Server CD-ROM 14 (91 min) Analysis Services Understanding Analysis Services Building a Simple Cube Browsing Data from a Cube Exploring MDX Data Mining English Query Overview of English Query Before You Start – Preparing Your Database Creating and English Query Application Deploying an English Query Application Outlines are subject to change.