About Database System Technology
    Home  |  Access     Visual Basic   |  Access/SQL Server    VB/SQLServer    Development   |   About     Contact     Prices
 

Visual Basic with SQL Server

  

Prerequisites: Experience with Visual Basic and familiarity with SQL Server. This is an advanced course that requires both programming and database skills.

Text: Visual Basic and SQL Server 2000 by Andy Baron and Mary Chipman,  Application Developers Training Company, Minneapolis, MN.

Schedule:  3 days

Max enrollment: 12
Lab Requirements: Visual Basic 6.0 and SQL Server running on NT Workstation, NT Server, Windows 2000 Professional or Windows 2000 Server. Don't have a lab. Email DBST and they may be able to help you hook up with a technical college.
Developing Visual Basic Applications for SQL Server 2000

N-tier Architecture

  • Building N-Tier Applications
  • Exploring Shark Application

SQL Server Essentials

  • Know the Server  
  • Database Design  
  • Understanding Transactions  
  • Intelligent Indexing  
  • Monitoring Performance  

Stored Procedures and Functions

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

    Visual Basic Tools

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

The Middle Tier

  • Using ADO with Stored Procedures
  • Using ADo with Stored Procedure Add-In
  • Using Interface Classes

Displaying Data in the Presentation Tier

  • Data Binding Options
  • 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 Though Records as a String

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

You can email DBST at: gmw@dbst.com or call: (507) 896-4488 and Gary will be happy to answer any questions you may have about the services offered by DBST.

 
       Home  |  Access     Visual Basic   |  Access/SQL Server    VB/SQLServer    Development   |   About     Contact     Prices

DBST is the trademark of Database System Technology. All other products mentioned are registered trademarks or trademarks of their respective companies. 
Copyright ©  2000-2007 Database System Technology. All rights reserved. Questions or problems regarding this site should be directed to: gmw@dbst.com
Web site development comments can be referred to:  webdeveloper@webstudiosecrets.com