|
Provided by: Serebra Learning Corporation Visual Basic 6 0 Database Access Part IMicrosoft Visual Basic (VB) |
 |
Training
Provided by Serebra Learning Corporation
This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing and modifying information in databases using the industry standard Structured Query Language (SQL). It explains how SQL is used with client tools built in Visual Basic, to create powerful queries and statements for a server-side database. Finally, this course describes how you can use data controls to access database information. It explains how you can use the Data Environment Designer to create connections, commands, and data-bound forms. Also described are the Data Form Wizard and the ADO Data Control, which are additional tools that can be used to create data-bound forms." Related Exam: Microsoft Exam #070-175: D This course is designed for intermediate to advanced Visual Basic application programmers.
|
|
||||||||||
Visual Basic 6 0 Database Access Part I
Audience
This course is designed for intermediate to advanced Visual Basic application programmers.
Topics
Unit 1: Introduction to Databases
- Database Concepts
- Accessing and Manipulating Data
- Database Interoperability
Unit 2: Introduction to SQL
- SQL Programming Essentials
- Retrieving Database Data
- Modifying Database Data
Unit 3: Using Data Controls in Visual Basic
- Understanding Data Controls
- Connecting to a Database
- Creating Commands
- Displaying Recordsets in Forms
Objectives
Upon completion of this course, the student will be able to:Describe the components of a relational database Explain how data is accessed and manipulated in a relational database Explain the role that SQL plays in a Visual Basic client tool that is used to access databases Using the proper syntax and structure, write SQL script to retrieve, modify, and delete data in a database Connect to a data source and create data-bound forms using the Data Environment Designer Create data-bound forms using the Data Form Wizard or the ADO Data Control
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
