This
2-day
course
is suitable
for programmers
who are
already
familiar
with the
basics
of Visual
Basic
programming
and wish
to use
it for
accessing
local
or remote
databases.
It assumes
familiarity
with Visual
Basic
and can
be taken
together
with our
'Visual
Basic
6 Programming'
('GN-101')
course
to provide
full 5-day
coverage.
The standard
course
covers
Visual
Basic
version
6 and
concentrates
on the
newer
ADO technologies.
Alternative
courses
for older
versions
can also
be accommodated.
Course
Content
The
Database
Object
Models
&
Technologies -
The
acronyms
and
what
they
mean
-
-
SQL,
JET,
DAO,
RDO,
ODBC,
ODBC
Direct
and
ADO.
ActiveX
Data
Objects
-
ADO -
ADO
and
OLEDB
-
Providers
and
consumers
-
ADO
as
the
future
The
Data
Control
&
the
Wizards The
data
control
and
its
associated
data
bound
controls
provide
the
simplest
way
of
interfacing
an
application
to
a
database
and
tools
like
the
Data
Form
Wizard
can
simplify
this
even
further
-
Discusses
what
can
be
achieved
and
the
limitations
A
Quick
Guide
to
SQL -
Where
Structured
Query
Language
has
come
from
and
how
it
is
used
-
The
basic
syntax
for
SELECT
-
and
action
queries
-
Joins
and
aggregates
Using
ADO
&
SQL
-
Using
a
Data
Environment
and
using
the
ADO
object
model
directly
-
Recordset
manipulation
-
The
SQL
Builder
utility
-
Commands,
queries
and
parameter
passing
-
Dynamic
SQL
-
Queries
involving
multiple
tables
and
joins
-
Executing
action
queries
The
Report
Designer -
How
the
designer
works
-
Creating
sophisticated
reports
from
your
database
information
using
the
Report
Designer
and
SQL
Multi-User
Considerations -
Sharing
database
data
-
Record
locking
and
why
we
need
it
-
Optimistic,
batch
optimistic
and
pessimistic
locking
-
Why
we
need
transactions
and
how
these
are
implemented
Using
Enterprise
Data -
Open
DataBase
Connectivity
(ODBC)
and
OLEDB
-
Connecting
to
remote
databases
-
Using
stored
procedures
-
Client
and
server-side
cursors
-
2
and
3-tier
architectures
