Toll Free: 800-735-7418
Local: 303-377-9333
info@hartmannsoftware.com
 
 

 
MICROSOFT SQL SERVER 7.0 - LEVEL 3

Course Description  
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.

Course Length: 3 Days
Course Tuition: $1190 (US)
Prerequisites
Introduction to SQL Server 7.0 - Level 2.
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

Contact us for course schedules or more information.
 

Registration and Pricing
The Virtual Classroom
Mentoring Services


Fresh Off The Press MySQL Admin/Dev
Sharepoint for Developers
Advanced XML
Securing Java Web Services
Exploring Design Patterns
Fast Track to Java EE
Ajax using C# (VS 2008) Oracle 11G New Features Complete LINQ