Level 3 covers how to use ADO and how to begin building client/server applications with Visual Basic / SQL Server. You'll also learn how to scale your Visual Basic / SQL Server applications to n-tier and the Internet.
SQL Training Audience:
Database developers and administrators
SQL Training Prerequisites
Developing Databases with SQL Server 7.0 – Level 2.
SQL Training Course duration
3 days
SQL Training Course outline
Introduction to ADO
- Understanding ADO
- The Recordset Object
- The Connection Object
Advanced ADO
- Using the Command Object
- Using Action Queries
Using Stored Procedures with ADO
- ADO and Stored Procedures
- Stored Procedures and the Recordset Object
- Stored Procedures and the Connection Object
- Stored Procedures and the Command Object
Building Client/Server Applications Part I: Displaying Data
- Planning a Client/Server Application
- Shark Client/Server Application
Building Client/Server Applications Part II: Modifying Data
- Modifying Data in a Client/Server Application
- Adding, Editing and Deleting Orders
Building Stored Procedure-Driven Client/Server Applications
- Stored Procedures in Client/Server Applications
- Stored Procedures in the Shark Application
Building Three-Tier Applications
- Evolution of Application Building
- Understanding N-Tier Architecture
- Tools for Building N-Tier Applications
Designing the Middle Tier
- Designing a Middle Tier
- The Shark Application Middle Tier
Converting a Client/Server Application to N-Tier
- Converting the Shark Application
- Building the Shark Middle Tier
Moving the Middle Tier to the Server with MTS and DCOM
- Separating the Middle Tier
- Microsoft Transaction Server
- Distributed COM
Appendix Topics
- Taking N-Tier Applications to the Web
