Oracle Tutorial Online

Oracle Tutorial
Microsoft Certification
A+ Certification Training
Network+ Certification
CIW Security
PC Computer Security
Crystal Reports
Exchange Server
Exchange 2000
PSP Tutorial
IIS4
SQL Server
TCP/IP
Windows NT
Windows 2000 Professional
Windows 2000 Server
MS Access 2002
Excel 2000
Excel 2000 Expert
Word 2000
Word 2000 Expert
Word 2003
PowerPoint Tutorial
Microsoft Project
Office 2000
Office 97
Outlook 2002
Macromedia Flash MX
Dreamweaver
Visio 2002
Cisco CCNA
Cisco CCDA
Cisco Networking
Windows Server 2003
Oracle 8i
E-Commerce
Linux
Lotus Notes
Visual Basic
FrontPage
Java Training
HTML
Visual Studio
Visual Basic
Visual InterDev
PowerBuilder
FOCUS
UNIX
Sybase
PhotoShop
S.A.S.
S.A.P.
QuickBooks
MS Works
XML
ColdFusion MX
Business Management
Project Management
RPG IV Programming

Fruta Vida
Business Opportunity

This course is for anyone who is interested in learning about the Oracle relational database management system, its main components, and how to install it.

• Introduction to PL/SQL provides an introduction to the PL/SQL procedural language extension to SQL.
• Overview of Developer/2000 presents the common features shared by the suite of tools in Developer/2000. These tools include Forms 4.5; Reports 2.5; Graphics 2.5 and Procedure Builder 1.5.
• Forms 4.5 and Reports 2.5 provides an overview of Forms 4.5 and Reports 2.5.
• Graphics 2.5 and Procedure Builder 1.5 provides an overview of Graphics 2.5 and Procedure Builder 1.5.
• Developer/2000 Applications explores the development of applications using Forms and Reports.
• Developer/2000 Integration explores the incorporation of Graphics displays into an application and the integration of Forms, Reports, Graphics and Procedure Builder applications through a single point of entry for the user.
• Installing Oracle introduces users to administration and shows how to install Oracle8.
• 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
• Install Oracle
• 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 Oracle processes
• Monitor Oracle processes
• Manage Oracle job queues
• Use Oracle Auditing for security monitoring
• Describe Oracle 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 Oracle8 product
• An Oracle8 glossary