|
Microsoft
Access | SQL
| Database
Design | HTML
| Java | Microsoft
Office | Web
Development | VBA
| Visio
| C/C++
| Custom
Courses | Discounts
& Training Passports | Registration
and other Fees | Classrooms
& Equipment |
(Final prices will reflect tuition
and registration, materials, discounts and
charges as applicable.) |
|
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. (Classes available in both Access 2003
and Access 2007). |
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; classes available in both Access 2003 and
Access 2007). |
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; classes available in both Access 2003 and Access 2007). |
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 |
|
AIN104F |
Microsoft
Access Form Design
Same as module 2 of AIN104. Intermediate Form design.
Includes forms, sub-forms, charts and unbound forms. |
1/2 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. Covers VBA language, variables, subs,
functions, etc. |
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 on an hourly basis. Take just what you
need. 2 hour minimum. |
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 |
Accelerated
Introduction to SQL Using Microsoft SQL Server
Introduction
to SQL used in Microsoft SQL Server and Sybase. Intensive, hands-on
class featuring data manipulation, queries, data modification,
construction of tables, indexes, views. and constraints, etc. Same
content as SQL200. |
1 and 1/2 days |
|
SQL204 |
Introduction
to Transact SQL
Brief
introduction to the Transact SQL programming language used in
Microsoft SQL Server. Adds Transact SQL specifics such as variables,
control statements, cursors, stored procedures, etc. |
1/2 day |
|
SQL212 |
Accelerated
Introduction to SQL Using Oracle
Introduction
to the SQL programming language used in Oracle database systems.
Similar course to SQL202 except for Oracle users. |
1 and 1/2 days |
|
SQL214 |
Introduction
to Oracle PL/SQL
Brief
introduction to the PL/SQL SQL programming language used in Oracle
database systems. Adds PL/SQL specifics such as variables, cursors,
blocks, stored procedures, etc. |
1/2 day |
|
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
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 |
|
Web
Development
Click
on the course number or title for a full description with price. |
Back | Top |
|
FRP101X |
Microsoft
FrontPage Basic
Introduction
to Microsoft FrontPage fundamentals. |
1 day |
|
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 |
|
Custom
Courses |
Back | Top |
|
CUS100 |
Custom Module
Do your
computer 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 |
|
Most
courses are offered in three formats: 1) open enrollment in our San
Juan Capistrano, Orange County, California facility, 2) on-site at
your location in the Greater Los Angeles and San Diego areas (or
elsewhere in the U.S.),
and 3) Private
one-one-training as arranged. |
|
|
