Visual Basic Courses:
Visual Basic 6.0 Database Programming Training Course


Classroom Courses ~ Closed Courses ~ Onsite Courses ~ Training Passport ~ MCSE Courses ~ CBT Courses
Home Page ~ Contact ~ Training Centre ~ Course Schedule ~ Late Availability ~ Consultancy
   
    PTR Associates Ltd - Classroom Based Courses, Wokingham, Berkshire, uk
21a Peach Street, Wokingham, Berkshire, UK
Tel: 0118 979 4000       Fax: 0118 979 4035
Email:
training@ptr.co.uk      Web: www.ptr.co.uk

Visual Basic 6.0 Database Programming Course


Course Description
You will get the most out of this course if you want to learn how to develop database applications in Visual Basic 6.0. You should have some application experience, ideally in object-oriented programming, but no prior knowledge of data management or querying is assumed. This course is intended for application developers and other computer professionals who will use Visual Basic 6.0 to manage data.

Course pre-requisites:
Previous to taking this course, a student should take the Visual Basic 6.0: Introduction, or possess equivalent knowledge.
scheduled dates / price

Topics covered on the 5 day Visual Basic 6.0 Database Programming course


Database Basics

  • What is a Database?
  • Using the Visual Basic Database Tools to Manage Your Data
  • Relational Database Structures


  • Overview of SQL

  • What is SQL?
  • Optional Clauses
  • Advanced Statements and Resource Management


  • The ActiveX Data Object (ADO) Model

  • Universal Data Access (UDA)
  • The ADO Model
  • Introduction to Data Access


  • The ADO Data Control

  • Properties, Methods, and Events of the ADODC
  • Bound Controls
  • The Data Form Wizard


  • The ADO DataEnvironment

  • The DataEnvironment (DE)
  • Creating Command and Recordset Objects in the DE
  • Using Bound Controls and Data Designing in the DE


  • Working with ADO Code

  • The Connection Object
  • The Recordset Object
  • The Command Object


  • Data Reporting

  • Printing From Within Visual Basic
  • Using the Data Report Designer in the DataEnvironment (DE)
  • Using ADO Code to Display Data Reports
  • Advanced Topics


  • The Data Access Objects (DAO) Model and Data Control

  • The Data Access Objects (DAO) Model
  • Comparing DAO and ADO
  • Intrinsic Controls and DAO


  • Working with DAO Code

  • Writing Code to Store Data
  • Creating a New Database with DAO Code
  • Coding the Project
  • Data Manipulation with DAO Code


  • Migration

  • Making the Decision to Migrate
  • Legacy Upgrade Compatibility Issues
  • Migration Dos and Dont’s


  • Using SQL

  • SQL Overview
  • SELECT Statements
  • Cursors
  • Record-locking
  • Stored Procedures


  • Internet Applications

  • WebBrowser Control
  • What is an Active Document?


  • Appendix A: Applications Used in This Course

    Appendix B: Physical Design of Applications
    This is an instructor led training course taught in a classroom based environment.

    Course Classification: 

    Course Fee = £1475
       (excl.VAT)


    Scheduled course dates
    May 2008 June 2008 July 2008 August 2008 September 2008



    If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Visual Basic Training and bespoke Visual Basic courses


    If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.







    PTR Associates Limited

    21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
    Tel: 0118 979 4000 Fax: 0118 979 4035
    Email: training@ptr.co.uk
    Visual Basic Course Index & Training Schedule
    More Visual Basic Courses

    Introduction to Programming using Visual Basic 2005 Course

    Microsoft Visual Basic 2005: Developing Applications Part 1 Course

    Microsoft Visual Basic 2005: Developing Applications Part 2 Course

    Learning To Program In Visual Basic 2005 Course

    Fundamentals of Visual Basic .NET: Level 1 Course

    Programming Visual Basic .NET: Level 2 Course

    Advanced Visual Basic .NET Programming: Level 3 Course

    ADO.NET using VB.NET Course

    Enterprise Development In Visual Basic .NET Course

    Web Services Using VB.NET & ASP.NET Course

    Programming Fundamentals of Visual Basic - Level 1 Course

    Programming Visual Basic 6.0 Applications - Level 2 Course

    Advanced Visual Basic 6.0 Programming Concepts - Level 3 Course

    C Programming Courses
    Cisco Courses
    Citrix Courses
    CIW Courses
    CompTia Courses
    Database Courses
    Exchange Server Courses
    Fortran Courses
    Internet Courses
    Java Courses
    JSP Courses
    Linux Courses
    MCSD Courses
    MCSE Courses
    Microsoft Courses
    Microsoft .NET Courses
    Microsoft Access Courses
    Microsoft Excel Courses
    Microsoft Outlook Courses
    Microsoft Powerpoint & Visio Courses
    Microsoft Project Courses
    Microsoft Server Products Courses
    Microsoft Word Courses
    Networking Courses
    Oracle Courses
    Perl Courses
    Programming Courses
    Security Courses
    SQL Courses
    SQL Server 2000 Courses
    SQL Server 2005 Courses
    Unix Courses
    VBA Courses
    Visual Basic Courses
    Windows 2000 Courses
    Windows Server 2003 Courses
    Windows Vista Courses
    Windows XP Courses
    XML Courses