|
Training Library CBT CDs |
or8lib |
$945.00 |
|
The Oracle8 Library introduces you to Oracle 8 and gives you the programming and administration skills you need to be an Oracle expert.
ORACLE8 Library packs over 39 hours of highly interactive self paced instruction delivered over the following 6 titles:
- An Overview to Oracle 8
- Basic SQL Programming
- Advanced SQL Programming
- Server Programming in ORACLE8
- Basic Administration in ORACLE8
- Advanced Administration in ORACLE8
Each title uses the "Learn by Doing" paradigm to ensure that as a part of your learning experience, you practice concepts and procedures covered in this
library in a real life environment. Practice sessions consist of hints that guide a learner towards the correct solution to a problem. Practice sessions also
contain sample solutions. All practice sessions contain diagnostic and/or prescriptive feedback that reinforces learning and enables remedial learning.
The titles simulate software so you do not have to purchase expensive software to complete the learning experience. Each title in this library consists of job aids such as quick reference guides and
glossary of terms. Quick reference guides are used to detail new features, comparisons, additional facts / data / information. The glossary provides
definitions of terms used in the learning material. Each glossary item has related terms available as hyperlinks to provide for easy navigation while you reference.
Benefits:
After completing this library you will be able to:
- Define the structure of an ORACLE database
- Insert, update, and delete data from tables
- Add, modify, and delete tables from a database
- Perform simple and complex queries on database tables
- Identify primary and foreign key in tables
- Enable, disable, and delete integrity constraints
- Create user interfaces, menus, and reports
- Identify the features and elements of SQL
- Identify the features of SQL*Plus
- Commit and rollback transactions
- Define savepoints in transactions
- Create, alter, and delete views and sequences
- Create and delete indexes
- Initialize and manipulate object types
- Identify different control-of-flow constructs
- Handle exceptions and create subprograms and packages
- Create and manage triggers
- State the role of distributed databases in distributed processing
- Identify the tools used in accessing distributed data
- Describe the role of the two phase commit mechanism in a distributed transaction
- State the role of Net8 and SQL*Connect in connecting distributed databases
- List the features and uses of tools used by a database administrator
- Identify the ORACLE8 features used to secure a database
- Identify the need for monitoring a server
- List the tips for tuning a server
- Use the Enterprise Manager, Storage Manger, and Oracle Security Manager
Outline:
An Overview to Oracle 8
- Introduction to ORACLE
- Application Development in ORACLE
- Distributed Processing in ORACLE
- Database Administration in ORACLE
Basic SQL Programming
- Introducing SQL
- Managing Tables
- Making Simple Queries in Tables
Advanced SQL Programming
- Adding Integrity Constraints
- Managing Conditional Queries
- Making Complex Queries
- Managing Schema Objects
Server Programming in ORACLE8
- PL/SQL Fundamentals
- Working with PL/SQL datatypes
- Programming in PL/SQL
- Subprograms and Packages
- Triggers
- Working with Cursors
Basic Administration in ORACLE8
- Managing Oracle Server
- Managing Tablespaces and Datafiles
- Securing the Server
Advanced Administration in ORACLE 8
- Managing the Physical Database
- Improving Data Access
- Improving Server Performance
Backing Up and Recovering Data System Requirements
The minimum system requirements are:
- 80486 DX processor or higher
- 8 MB RAM (more RAM improves performance)
- VGA or higher monitor
- MS-Windows mouse
- 15 MB free disk space
- MS Windows 3.1 or higher
Training Library CBT CD-ROMs |
$945.00 |
#or8lib |
|
|
