Microsoft
Access | SQL
| Database
Design | Data
Warehouses
| HTML
| Java
| VBA
| Private
Training | Custom
Courses | Discounts
& Training Passports | Registration
and other Fees | Classrooms
& Equipment |
(Final prices will reflect tuition,
registration, applicable discounts and charges.) |
Microsoft
Access (Curriculum Suggestions...)
Click
on the course number or title for a full description with price. |
Back | Top |
AIN100
|
Introduction
to Microsoft Access
Introductory course covering databases, tables, the
datasheet, sorting and manipulating tables, import/export, queries,
reports, forms, and macros. |
2 days
|
AIN100A
|
Introduction
to Microsoft Access - I
Introductory course covering databases, tables, the
datasheet, relationships, filters, queries, basic reports and forms.
(Day 1 of AIN100 sequence). |
1 day
|
AIN100B
|
Introduction
to Microsoft Access - II
Introductory course covering reports, subreports,
forms, subforms, advanced queries, import/export, and macros. (Day 2
of AIN100 sequence). |
1 day
|
AIA101 |
Accelerated
Introduction to Microsoft Access
Faster paced
course covering databases, tables, import/export, queries, reports,
forms and macros. |
1 and 1/2 days |
AIN100T |
Microsoft
Access Database
Design
Relational
database design principles plus first session of AIN100. Can be used
to precede AIN104, etc. |
1 day
|
AIN102
|
Microsoft
Access Queries
Unique, full day course. Intensive hand-on practice
with queries. All forms of queries including Action Queries. |
1 day |
AIN104 |
Microsoft
Access Reports and Forms
Intermediate Reports and Forms. Includes forms, sub-forms,
unbound forms, reports, sub-reports and using queries as data sources. |
1 day |
AMP110 |
Microsoft
Access Macros
Macro
programming course showing how to use macros to automate database functions. |
1 day |
AVB201 |
Beginning
Access VBA
Beginning
Access VBA programming course. |
1 day |
AVB202 |
Intermediate
Access VBA
Intermediate
Access VBA programming course focused on ADO and DAO for data manipulation. |
1/2 day |
APV100 |
Microsoft
Access Private Training
One-on-one
Private Training or tutoring. Can be taken at your office or ours in
San Juan Capistrano. Available at standard tuition plus registration
or as arranged. |
by
arrangement |
SQL
(Curriculum Suggestions...)
Click
on the course number or title for a full description with price. |
Back | Top |
SQL200 |
Accelerated
Introduction to SQL
Introduction
to ANSI standard SQL. Intensive, hands-on SQL class featuring data
manipulation, queries, data modification, construction of tables,
indexes, views. and constraints, etc. |
1 and 1/2 days |
SQL200S |
Introduction
to SQL Queries
Introduction
to standard SQL. Intensive, hands-on SQL class focusing on SQL data
retrieval. Same as first two modules of SQL200. |
1 day |
SQL200A |
Introduction
to Microsoft Access SQL
Slightly
shorter version of SQL200 SQL course specifically for MS Access
users. Hands-on class focusing on SQL data retrieval. (Advanced
version of AIN102). |
1 day |
SQL201W
|
Introduction
to MySQL on Windows
Hands-on
introduction to MySQL. Version of SQL200 for MySQL users. Covers
MySQL programming specifics. |
1 and 1/2 days |
SQL202 |
Introduction
to Transact-SQL
Introduction
to Transact SQL used in Microsoft SQL Server and Sybase. Hands-on
class featuring data manipulation, queries, data modification,
construction of tables, indexes, views. and constraints, variables,
stored procedures, triggers and cursors. |
2 days |
SQL212 |
Introduction
to Oracle SQL
Introduction
to the PL/SQL SQL programming language used in Oracle database
systems. Similar course to SQL202. |
2 days |
Database
Design
Click
on the course number or title for a full description with price. |
Back | Top |
DBD200 |
Relational
Database Design
Introductory
course on the basics of relational database design including tables,
fields, keys, indexes, views, normalization, entity relationship
diagrams, and SQL. |
2 days |
DBD201 |
Accelerated
Relational Database Design
Slightly
shorter version of DBD200 with minimal SQL. Ideal as a complement to
one of the Microsoft Access or SQL courses. |
1 day |
DataWarehouses
Click
on the course number or title for a full description with price. |
Back | Top |
DWI301 |
Data
Warehouse Introduction/Kickoff
Introduction to what a data
warehouse is and is not, its benefits and pitfalls. This course is
perfect as a kickoff for getting everyone on the same page. |
1 day |
DWX311 |
Data
Warehouse Design
Class for IT
Management, Technical members of a new data warehouse or data mart
initiative or power users. |
1 week |
DWX320 |
Data
Warehouse Private Training
DataWarehouse
and Business Objects specific one-on-one private classes. 4 hour minimum. |
by arrangement |
Web
Development
Click
on the course number or title for a full description with price. |
Back | Top |
HTM100 |
Introduction
to HTML
One day quick
introduction to HTML covering document structure, basic paired and
unpaired tags, images, tables, frames and forms. |
1 days |
JVX301 |
Getting
Started with Java
Accelerated
introduction to Java. Intensive hands-on course. Starts with
orientation to Java and object-orientation. Covers Applets, Swing,
graphics, I/O, database access, and a very brief introduction
to SQL. |
2 days |
Private
Training
(see also Open
Enrollment) |
Back | Top |
IND100 |
Individual
Private
Training
One-on-one
private classes or tutoring. We can still come to your facility or
you may come to ours in San Juan Capistrano. |
by arrangement |
Custom
Courses |
Back | Top |
CUS100 |
Custom Module
Do your
training needs differ from the standard courses? Let us custom
develop one or more half-day modules as required. And we'll base it
on your database and files if you like. |
free quote |
Microsoft
Access | SQL
| Database
Design | Data
Warehouses
| HTML
| Java
| VBA
| Private
Training | Custom
Courses | Discounts
& Training Passports | Registration
and other Fees | Classrooms
& Equipment |