|
|
 |
 |
|
Database Courses
Data
Modeling [DBM-G2]
2 day. This course consists of interactive
lectures, hands-on labs, and facilitated sessions. Upon completion
of the course, students will have a good understanding of the
various types of data models (conceptual, logical, physical,
dimensional), key components (entities, attributes, relationships,
business rules), basic notation, functional dependencies, normalization,
methodologies (re-engineering, structured interview, forms analysis),
and CASE tools. Examples and uses of various models will be
discussed in detail. |
| |
|
|
| Fundamentals
|
DB2 Query Manager and SQL [DBU-D2]
2 day. Structured Query Language (SQL) is a universal
language available on most computing platforms, and is used
widely in larger AS/400-iSeries environments |
Database
Administration |
DB2
UDB Administration for UNIX/Windows [DBA-D2]
5 day. This course combines lectures and
hands-on labs to teach the participant how to administer a DB2
UDB database environment. It includes information on the overall
architecture of DB2 UDB, plus enables the student to perform
an array of administration tasks including the creation of a
database, tables, views, indexes; the extraction and insertion
of data, backup and restore, problem determination and performance
tuning.
|
| Programming
|
DB2 Stored Procedures [DBP-D2]
2 day. This course will provide the student with the skills
necessary to create stored procedures using DB2's SQL Procedure
Language, Java and other programming languages. Students will
also learn to create the necessary code in client applications
to invoke the stored procedures.
|
| Data Warehouse/OLAP
|
Introduction
to Data Warehousing [DBW-D2]
4 day. The course takes a role-based approach. People have different
skills, experience, and interests. DBAs, for example, may be
very detailed and very technical. Project managers, on the other
hand, may be more socially oriented and be able to see the big
picture. Data warehousing requires specific roles. The course
takes the view that the material should expose everyone in the
course to the key concepts, but it should deepen the skills
and experience of the various roles, including project managers,
data architects, business analysts, DBAs, database programmers,
and data warehouse managers. |
Hyperion ESSBASE
(see www.thinkfast.com for
details on ESSBASE courses) |
| |
Oracle
|
Introduction
to Oracle [DBU-01]
5 day. This lecture and lab course provides the student with
a basic understanding of databases in general and Oracle databases
specifically. The student will learn how to retrieve and format
data using SQL, plus manipulate views, indexes and joins. Potential
administrators will learn how to back up and secure the database.
|
Oracle Basics for Power Users
[DBU-02]
5 day. This lecture and lab course provides the student with
a basic understanding of databases in general and Oracle databases
specifically. The student will learn how to retrieve and format
data using SQL, plus manipulate views, indexes and joins. This
class condenses the material from the Introduction to Oracle
course into three days, then adds two days on PL/SQL.
|
Oracle Developer
[DBP-02]
5 day. This lecture and lab course provides the student with
a good understanding of Oracle Forms and Oracle Reports. The
student will learn how to create a form using alerts, menus,
toolbars and triggers. Many of the major types of Oracle Reports
are also covered including Tabular, Group, Master, Detail and
Matrix.
|
Oracle Database Administration
[DBA-02]
4 day. This practical course is an essential tool kit for all
Database Administrators covering the practical skills needed
by the DBA to perform Oracle administration functions within
the enterprise. The course is hands-on oriented. All exercises
are short and simple to show a technique or consolidate the
knowledge in a certain area. [MEN] |
Oracle Forms
[DBF-03]
4 day. In this course, the students will develop a minimum
of eight separate forms (including master/detail forms), compile
and modify the forms, and test them using Oracle Forms Runtime.
Particular attention is paid to using the new GUI features in
DEVELOPER 2000 unique to Forms 4.5. [MEN] |
Oracle Reports [DBR-03]
This course provides Oracle Reports users with the skills necessary
to use the GUI report design interface and new DEVELOPER 2000
features to create and modify six basic types of reports: simple
tabular, break report, master/detail report, label report, summary
report, and matrix (cross-referenced grid) report. In addition,
students will build a report using parameters and graphics,
a group filter report, an OLE report, a drill-down report, a
report using Oracle Graphics, and an envelope report. [MEN] |
|
Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus [DBS-02]
5 day. This course introduces students to the concepts of
relational databases, the SQL*Plus interface tool, and the
powerful SQL and PL/SQL programming languages. [EMK]
|
Advanced Oracle9i Database Administration [DBA-03]
5 day.This course introduces students to the concepts of relational
databases, the SQL*Plus interface tool, and the powerful SQL
and PL/SQL programming languages. [EMK]
|
| |
|
|
| Administration |
| Network Administration |
| Advanced Network Administration
|
| Performance Tuning |
| Forms/Reports |
| Financials |
| |
SQL
Server
|
| Please call EduCorp at 800-668-0943
or Fill out the Information Request Form
|
| |
SYBASE
|
| Please call EduCorp at 800-668-0943
or Fill out the Information Request Form
|
| |
INFORMIX
|
| Pleasel EduCorp at 800-668-0943,
or Fill out the Information Request Form
|
| |
Mainframe
(DB2, CICS, IMS)
|
| Pleasel EduCorp at 800-668-0943,
or Fill out the Information Request Form
|
If you are interested in something beyond what is listed here,
please call us today! We are always adding new courses!
For more training information, please fill out the Information
Request Form
Call EduCorp at 800-668-0943, or
E-mail us at educorp@educorptraining.com.
|
|
|
