|
Oracle
A+ Certification
MCSE Certification
MOUS Certification
A+ Training
Exchange Server
IIS4 Training
SQL Server
TCP/IP Training
Windows NT
Windows 2000
Windows 2000 Server
Access 2000
Excel 2000
Excel 2000 Expert
Word 2000
Word 2000 Expert
PowerPoint
Office 2000
Office 97
Cisco CCNA
Cisco CCDA
E-Commerce
Novel
Lotus Notes
Visual Basic
Java
HTML
Visual InterDev
PowerBuilder
FOCUS
UNIX
Sybase
PhotoShop
S.A.S.
QuickBooks
MS Works
Estate Planning
Interview Skils
Investing
Resumess Writing
Home Business
Management
|
The following Oracle Database certification training courses are available online:
- Oracle Architecture and Tools introduces users to the major components of an Oracle server.
- Instances and Creating Databases introduces users to managing an Oracle instance, creating a database, and using globalization parameters.
- the Database Structure introduces users to data dictionaries, control files, and redo log files.
- Tablespaces and Datafiles introduces users to creating and managing tablespaces.
- Storage Structures and Undo Data introduces users to the underlying storage structure of a database and to using undo segments.
- Tables introduces users to creating and managing table structures.
- Indexes and Data Integrity introduces users to indexes and data integrity constraints.
- Users and Profiles introduces users to creating and managing users and to control resources using profiles.
- Privileges and Roles introduces users to system and object priviledges and user roles.
- Exam Preparation allows users to practice answering questions in order to prepare for taking the exam.
After completing our Oracle 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
|