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 
Visual Basic and SQL Server
with Mary Chipman & Andy Baron


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
Format Sessions Retail Price
Visual Basic and SQL Server
CD-ROM

 6 CD-ROMs

$495.00  
CD-ROM & Books

 6 CD-ROMs + Printed Books

$555.00  
Read about Mary Chipman & Andy Baron.
Course Outline (Outlines are subject to change.)

Developing Visual Basic Applications for SQL Server 2000

Sessions Run Time Pages
6 CDs 10 hours 450

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


Your Instructor

Andy Baron and Mary ChipmanAndy 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