StarCom Group Software/Networking Training Center |
Advanced Visual Basic & Database Programming (50 Hours) |
Course Objective:
|
Course
Syllabus: 1. Database Developer Overview The Database Developer Designing Database Creating and Managing Database Objects Accessing Data in databases ODBC Data Access Model for Visual Basic DAO RDO ADO OLE DB VBSQL Oracle Objects for OLE Optimizing Database Application 2. Using Data Access Objects DAO Overview Connecting to SQL Server Working with Recordsets Modifying Data Finding Records Using Queries Using SQL Pass-Through Queries Working with Stored Procedures Handling SQL Server Messages 3. Using Remote Data Objects RDO Overview Connecting to SQL Server with RDO Building Result Sets Data manipulation Working with Stored Procedures Using RDO UserConnection Designer Using the Transact-SQL Debugger Using RemoteData Control 4. Using Oracle with Visual Basic Oracle Overview Using Oracle Objects for OLE Data Processing Samples 5. Creating ActiveX Clients The Component Object Model Implementing Automation Characteristics of Server Components Creating a Client in Visual Basic Receiving Notifications from Servers Creating a Client that Uses Microsoft Excel 6. Creating ActiveX Code Components Overview Creating Objects in Visual Basic Working with ActiveX Code Component Projects Testing ActiveX Code Components Using Events Implementing an Interface Additional Features of Code Components 7. Using ActiveX Components on a Web Page Overview Downloading Controls Scripting a Control Providng Security for Components 8. Creating and Using ActiveX Documents Overview Working with ActiveX Document Projects Testing and Debugging ActiveX Documents Multiple Document Projects The User Interface and User Documents 9. Introducing Active Server Page Web Server Scripting ADO for Data Access |
back |