Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials please do not hesitate to contact us for help.
- See right for full details on this Oracle dba Tutorial
- See far right to purchase this Oracle dba Training CD
Oracle Database Administration Fundamentals I Tutorial
This Oracle 1Z0-031 tutorial is aimed at those
who are preparing for the 1Z0-031 Oracle certification
exam. Expert author Gavin Powell guides you
form the basics to the more advanced aspects
of this language in an easy to follow manner.
If you want to feel confident with this language
and on the day of the exam, then you might like to take a look at this comprehensive Oracle dba tutorial.
Try this training now - See below for FREE tutorials
All Courses on 1 or 2 CDs
For Mac and PC
Complete CD Contents and FREE Video Tutorials
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD. CLICK HERE TO BUY THIS CD
The Architecture of Oracle
Oracle Database Architecture
Memory Structures
Processes
Datafiles/Tablespaces/Objects
Control Files/Logging/Archiving/Recovery
COMMIT vs ROLLBACK
Rollback and Undo
Temporary Sort Space
How it all Fits Together
Oracle Managed Files
Partitioning
Installing Oracle and Creating a Database
The Oracle Installer - Lesson 1
The Oracle Installer - Lesson 2
The Oracle Installer - Lesson 3
Configuration Parameter Files - Lesson 1
Configuration Parameter Files - Lesson 2
SQL*Net Configuration Files
Oracle Optimal Flexible Architecture
Windows Specifics - Lesson 1
Windows Specifics - Lesson 2
Creating a Database with a Script - Lesson 1
Creating a Database with a Script - Lesson 2
Starting Up and Shutting Down a Database
Connecting to a Database
STARTUP Command - Lesson 1
STARTUP Command - Lesson 2
SHUTDOWN Command - Lesson 1
SHUTDOWN Command - Lesson 2
Combining STARTUP and ALTER DATABASE
The Oracle Enterprise Manager Console
Configuration Parameters
What is the Parameter File?
Looking at Parameters
The Parameters and What They Do - Lesson 1
The Parameters and What They Do - Lesson 2
The Parameters and What They Do - Lesson 3
DDL and the Physical Database
DDL and the Physical Database?
The ALTER DATABASE Command
Looking at the Database
Changing Datafiles
Sizing of Datafiles
Datafiles and Tempfiles
Control Files
Logfiles and Archives - Lesson 1
Logfiles and Archives - Lesson 2
The ALTER SYSTEM Command - Lesson 1
The ALTER SYSTEM Command - Lesson 2
Automated Undo/Manual Rollback - Lesson 1
Automated Undo/Manual Rollback - Lesson 2
Metadata Views
DDL and the Logical Database
What is the Logical Database?
Tablespace Management - Lesson 1
Tablespace Management - Lesson 2
Tablespace Management - Lesson 3
Metadata Views
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841
US & Canada
Marrutt Software Training
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649
UK & Europe
US & Canada