Visual Basic And Sql Server

Developing Visual Basic Applications for SQL Server 2000 Pages of Courseware 450 pages

Hours of Hands-On Content 24 hours

Days of Hands-On Content 3 days

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. N-Tier Architecture • Building N-Tier Applications • Exploring the 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 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 • 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 Through the Grid 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

For information, or to register, call (888) Bridge-B or email [email protected]