View the Course Outline

This course teaches programming with SQL Server 2000. You’ll learn the fundamentals of how to write code to work with SQL Server 2000 and ActiveX Data Objects (ADO). This course also focus on building client/server applications. You’ll learn how to build true middle-tier applications that scale up to the Web.

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

• 6 CDs or videos
• Over 10 hours of media run time
• Over 450 pages of courseware on CD-ROM
• Step-by-step hands-on-labs
• Sample code

Developing Visual Basic Applications for SQL Server 2000

This course teaches programming with SQL Server 2000. You’ll learn the fundamentals of how to write code to work with SQL Server 2000 and ActiveX Data Objects (ADO). This course also focus on building client/server applications. You’ll learn how to build true middle-tier applications that scale up to the Web.

Prerequisites:

To get the most out of Developing Visual Basic Applications for SQL Server 2000, you should be familiar with the VB6 language and programming environment. Some experience with relational databases will be helpful, but is not required. No prior experience with SQL Server 2000 is assumed.

SESSION 1 (103 min)

N-Tier Architecture

• Building N-Tier Applications
• Exploring the Shark Application

SQL Server Essentials

• Know the Server

SESSION   2 (108 min)

SQL Server Essentials (cont.)

• Database Design
• Understanding Transactions
• Intelligent Indexing
• Monitoring Performance

Stored Procedures and Functions

• Using Stored Procedures and User-Defined Functions
• Data Retrieval
• Action Stored Procedures

SESSION   3 (104 min)

Stored Procedures and Functions (cont.)

• More on Action Stored Procedures

Visual Database Tools

• Using the Visual Basic Data Tools
• The Data View Window
• Debugging Stored Procedures

The Middle Tier

• Using ADO with Stored Procedures
• Using the ADO Stored Procedure Add-In

SESSION   4 (100 min)

The Middle Tier (cont.)

• Using Interface Classes

Displaying Data in the Presentation Tier

• Data Binding Options
• Extending Combo Box Functionality

SESSION  5 (109 min)

Displaying Data in the Presentation Tier (cont.)

• More on Extending Combo Box Functionality
• Using Local Storage for Lookup Data
• Presenting Transactional Data

Searching and Paging

• Searching for Records
• The Stored Procedures

Editing Data in the Presentation Tier

• Building Data Entry Applications
• Working with the MSHFlexGrid Control
• Creating a New Order
• Handling Multi-User Editing
• Deleting Orders
• Managing Form State
• Allowing Users to Tab Through the Grid

SESSION   6 (117 min)

Deploying Components with COM+

• Overview of COM+
• Configuring a Middle Tier DLL under COM+
• Configuring Components in COM+
• Deploying the Completed Application

Marshaling Data as XML Over HTTP

• A Quick Overview of HTTP and XML
• XML Examples
• Building an XML-Based Middle Tier

back to top

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