left
left left
PTR

People, Training, Results
Independent Technical IT Computer Training Courses

Call: 0118 979 4000 | Contact us

left
  Home | Schedule | Classroom Courses | Closed Courses | Onsite Courses | One-to-one Training | SaveIT Passport |
spacer
spacer
spacer

Visual Basic Courses > Visual Basic 6.0 Database Programming Training Course


Course Fee = £1475   (excl.VAT)


Visual Basic 6.0 Database Programming Course Outline


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.


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
    July 2009 August 2009 September 2009 October 2009 November 2009



    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 please get in touch as we may well be able to add additional dates to those published or to re-arrange the course. Additionally, you could take advantage of one-to-one training with our SoloIT Training packages that also enables you to attend this course on dates that suit.





    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

    Introduction To Object Oriented Programming Course

    Learning To Program In Visual Basic 2005 Course

    Fundamentals of Visual Basic .NET: Level 1 Course

    Advanced Visual Basic .NET Programming: Level 3 Course

    Programming Visual Basic .NET: Level 2 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

    ASP.NET Using Visual Basic 2005 Part 1 Course

    ASP.NET Using Visual basic 2005 Part 2 Course

    Applications Courses
    C Programming Courses
    Cisco Courses
    Citrix Courses
    CIW Courses
    CompTia Courses
    Database Courses
    Exchange Server Courses
    Fortran Courses
    Internet Courses
    ITIL Service Management 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
    Unix Courses
    VBA Courses
    Visual Basic Courses
    Visual Basic 2008 Courses
    Windows 2000 Courses
    Windows Server 2003 Courses
    Windows Server 2008 Courses
    Windows Vista Courses
    Windows XP Courses
    XML Courses
    PTR

    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

    Privacy Policy | © PTR Associates Ltd

    PTR Associates Ltd is a company registered in England and Wales. Company number 2442290.
    Registered Office: Grenville Court, Britwell Road, Burnham SL1 8DF. VAT Registration Number: GB 532 1929 56

    left