Oracle 1Z0-031 Admin Fundamentals Tutorial Video

Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac.

These Oracle Database Admin tutorials are a perfect all-in-one solution for understanding the complexities and capabilities of Oracle and are ideally suited to people wishing to sit the Oracle 1Z0 - 031 exam. This training course offers the user a real alterative to reading page upon page of complex text from a manual or reference book. Expert author Gavin Powell brings a high degree of visual clarity and easy to follow step-by-step guidance on the subject, users will benefit greatly from Gavin's expertise and informative teaching style. This Oracle training course should be considered by any user that wishes to get up to speed quickly and take the Oracle certification exam. Related topics All Certification Tutorials .

try for free

Oracle 1Z0-031 Tutorial CD / DVD

Create the best self-paced learning environment
right on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Problems Playing the Demos?
Benefits
  • Professional Tuition from an Expert
  • Free Certificate with Each Tutorial
  • Works on PC or Mac
Just Released This Week
Apple Logic Pro 9 tutorial video
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Welcome
Database Administration
Oracle Database Administration Tools
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
The Architecture of Oracle
  • Oracle Database Architecture
  • Memory Structures
  • Processes
  • Datafiles/Tablespaces/Objects
  • Control Files/Logging/Archiving/Recovery
  • COMMIT vs ROLLBACK
  • Oracle Rollback and Undo
  • Temporary Sort Space
  • How it all Fits Together
  • Oracle Managed Files
  • Partitioning
Installing Oracle and Creating a Database
  • The Oracle Installer Tutorials 1
  • The Oracle Installer 2
  • The Oracle Installer 3
  • Configuration Parameter Files 1
  • Configuration Parameter Files 2
  • SQL*Net Configuration Files
  • Oracle Optimal Flexible Architecture
  • Windows Specifics 1
  • Windows Specifics 2
  • Creating a Database with a Script Tutorials 1
  • Creating a Database with a Script 2
Starting Up and Shutting Down a Database
  • Connecting to a Database
  • STARTUP Command 1
  • STARTUP Command 2
  • SHUTDOWN Command 1
  • SHUTDOWN Command 2
  • Combining STARTUP and ALTER DATABASE
  • The Oracle Enterprise Manager Console
Configuration Parameters
  • What is the Parameter File?
  • Looking at Oracle Parameters
  • The Parameters and What They Do Tutorials 1
  • The Parameters and What They Do 2
  • The Parameters and What They Do 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 1
  • Logfiles and Archives 2
  • The ALTER SYSTEM Command 1
  • The ALTER SYSTEM Command 2
  • Automated Undo/Manual Rollback 1
  • Automated Undo/Manual Rollback 2
  • Metadata Views
DDL and the Logical Database
  • What is the Logical Database?
  • Oracle Tablespace Management Tutorials 1
  • Tablespace Management 2
  • Tablespace Management 3
  • Metadata Views
Expanding Database Objects
  • Tables in Oracle Tutorials 1
  • Tables 2
  • Tables 3
  • Indexes 1
  • Indexes 2
  • Clusters
  • Index Organized Tables
  • Sequences
  • UNDROP, PURGE and the Recycle Bin
  • Partitioning
  • Metadata Views 1
  • Metadata Views 2
Expanding Security for Database Administration
  • Types of Users
  • Grants and Revokes
  • Create and Alter User Syntax
  • Administration Users
  • Database Auditing
Scheduling
  • The DBMS_JOB Package
  • Job Scheduling in Oracle
  • Scheduling/Executing Jobs in Windows and Unix
Utilities
  • Export
  • Import
  • SQL*Loader
  • ORAPWD and ORADIM
Built-In Packages
  • Supplied Packages
Scripting for Automation
  • Some Example Scripts
UK & Europe
Apex Web Media
PO Box 398
Bolton, BL7 9RZ
United Kingdom
T: 01204 592071
USA & Canada
600 17th Street, Suite 2800, Denver CO 80202
Open 8am - 5pm M to F (EST)
Tel - Toll free 1866 402 1903 ( USA )
Tel 434-878-4158
Fax 1 207 433 4356