|
FREE Online Training Courses
Video and CD's Info and Order!

Oracle
Oracle 8
Microsoft certification
Windows 2000 Tutorial
Windows NT
MS Exchange
SQL Server
IIS 4
TCP/IP
Office 2000
Office XP
PowerBuilder
QuickBooks
HTML
Java 1.2
Java 2
Cisco CCNA
Cisco CCDA
RPG IV
Crystal Reports 8
XML Programming
SAP R/3
GroupWise 5.5
GUI Programming
Novell 560 CNE
Novell 570 CNE
SAS Tutorial
SAS 8
LAN
UNIX
Sybase
Web Design
Contact Us
Internet Business Opportunity
|
This course is for anyone who is interested in learning about the Oracle8 relational database management system its main components and how to install it.
This is self-paced, internet-based course -- there are no books to purchase and no scheduled classes to attend.
- Installing introduces users to Oracle8 administration and shows how to install it.
- Database Management shows users how to manage the databases and servers.
- Building Databases shows users how to create and set up new databases.
- Files, Data, and Users shows users how to manage files, import and export data, and manage user accounts.
- Database Schema Objects shows users how to manage tables and indexes.
- Processes and Security explains server processes and discusses how to use security features.
- Backup and Recovery shows users how to protect database data by creating and using backups. It also shows them how to recover from hardware or software failure through various recovery and restoration processes.
After completing our courses, the user should be able to:
- Define the job of Administration
- Explain basic operation
- List the factors that affect performance
- Prepare for installation
- Identify the major components
- Plan for database capacity and size
- Calculate the system requirements of a database and server
- Calculate the disk requirements of a database and server
- Manage a database
- Use Server Manager and Database Assistant
- Start and shut down instances of databases
- Connect to and modify instances of databases
- Plan and design a database
- Prepare for a new database
- Create a new database and catalog
- Modify a database
- Create and modify tablespaces
- Manage tablespaces
- Use redo log files
- Describe control files and rollback segments
- Create user accounts
- Manage user accounts
- Manage user roles
- Create tables
- Manage different table views and types
- Create indexes
- Identify and use index types
- Export and import data using Export/Import
- Load data using the SQL*Loader Utility
- Describe the types of processes
- Monitor processes
- Manage job queues
- Use Auditing for security monitoring
- Describe backups
- Configure systems for maximum protection of data
- Create backup and recovery strategies
- Back up databases
- Recover data from backups
- Replicate databases
This course is distributed with:
- Simulations that allow users to practice course skills, even if they don't have access to the product
- An glossary
All courses are included in "Tech General Pack"
All courses are design so that new knowledge and skills will be remembered and retrieved for future use. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth and stimulate job satisfaction.
|