Visual Basic 4.0 E.E. Client Server Development
Length: 4 Days
Course Description
This course is aimed at corporate developers looking to build mission-critical applications using Visual Basic 4.0, Enterprise Edition. Using Remote Data Objects and advanced Remote OLE Automation, students get hands-on experience creating applications that run on both the client and server machines. The course goes beyond the Visual Basic environment and introduces students to Windows NT, Microsoft SQL Server 6.0, Visual Source Safe and three tiered system architecture. Students ideally should be well versed in Visual Basic before attending the class.
Audience
Programmers who need to design and develop 32 bit enterprise applications in Visual Basic 4.0.
Student Prerequisites
Course
TopicsCoding and Controls, Properties, Creating, Opening and Saving Projects, Working with Visual Basic Files, Creating New Forms and Modules, Adding and Removing Custom Controls, Event-Driven Language, Referencing Control and Form Properties, Methods, Control Editing Techniques, Control Arrays and Container Controls, Visual Basic Menus, Message Box Function/Statement, Declaring Variables, Scope of Variables, Visual Basic Modules, Procedures, Language Syntax, Objects and Collections.
Changes to the IDE, The Tools Menu, The Tools/Options Menu, New VBA Code Features, OLE Automation, Reusable Objects and Collections, Property Procedures, Object Browser, 32-bit Support and Conditional Compilation, Windows 95 Help File Support.
New Database Features, New Data-Bound Controls, The Data Grid Control, Windows 95 Custom Controls, Resource Files, The Enterprise Edition, Visual Source Safe.
Object - Oriented Design, Classes and Objects, Properties, Property Get Procedures, Property Let/Set, Creating a Class Module, Creating an OLE Server, Setting the Class Module Properties, Compiling Your OLE Server, Object Browser.
The Power of Classes, Review Picture Box and Printer Objects, Abstracting a Control with an Object, Using a Collection to Store Print Pages, Encapsulating the Print Logic, Introducing a Class, Creating the External Object, Testing the Server, Enhancing the MyPrinter Object.
How Remote Automation Works, Setting up a Remote Automation Server, Using the Remote Automation Connection Manager, Using the Client Registration Utility.
Synchronous vs. Asynchronous Servers, MultiThreading and Preemptive MultiTasking, Asynchronous Callbacks, The Sample Application - A Remote Text Searcher, Executing the Sample Program, Examining the Client Program, The CallBack Method, How to Handle Collisions, Reviewing the Server Code, How Data is Passed Back, Testing the Server Program, Deployina Remote Asynchronous Server.
Introduction, Windows NT Features, Workgroups and Domains, Architecture Overview, User Accounts, Groups, Managing Security Policies, File Systems, Windows NT Resource Security Model.
Administration Tools, Working with the User Manager (USRMGR.EXE), Working with the Server Manager (SVRMGR.EXE), NT Services Structure, Working with Services.
Product Family Overview, SQL Server RDBMS, Symmetric Server Architecture, DBMS - Enforced Data Integrity, Data Types, Defaults, Rules, Programmable Server Architecture, Triggers, Declarative Referential Integrity, Security, Managing Data Security, High Application Availability, Distributed Data Processing, Replication, Systems Management, SQL Server Enterprise Administrator, Open Client - Server Integration, Client Interfaces, Open Data Services, Summary.
Creating the Student Device, Creating a Database using the Enterprise Manager, Using W/ISQL to Create a Database, How to Create Tables, Creating a Table using the Enterprise Manager.
Overview, Data Access Objects versus Remote Data Objects, Exercise using the Remote Data Control, The Remote Data Control, Binding Controls to the Data Control, Additional Properties and Methods of the RDC, Understanding Cursors, The Current Row and the Resultset, Properties of the Resultset, Methods of the Resultset, MoveMethods, Deleting Records, Using RDOs.
What is Visual Source Safe?, Visual Source Safe Definitions and Terminology, Visual Source Safe Explorer, The File List, Working with Files, File Basics, Project Basics.
New Tools, Data Access Explorer, Using the Data Explorer, Visual Basic Code Profiler, Resource Compiler, API Viewer, PSS Tools, MSDN Starter Kit, System Info Control, Other Tools.