Search for a title:

Oracle Database dba I Tutorial - Training Videos

Training CDs > Certification Tutorial Videos > ORACLE DBA 1Z0-031 ADMIN

Oracle Database dba I Tutorial CD

Affordable Training you can depend on
This Oracle Database dba I video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 8 hours long these Oracle Database dba I tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Oracle dba 1Z0-031 Admin training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

 Description

This Oracle Tutorial video on DVD / CD offers an excellent introductory to this powerful scaleable database solution. The visual nature of these Oracle tutorials remove complexity and cover even the most advanced features in a clear, straightforward manner, this training CD is an essential learning reference for any user working with the Oracle database. The pace of the training is totally controllable and the lessons can be stopped, rewound or fast forwarded at any time. The clear teaching style makes this Oracle training course suitable for novices to experienced developers.

Topics covered on this tutorial include: iSQL, SQL Plus, Database Admin Tools, Rollback, Partitioning, Installing Oracle, Creating a Database, Connecting to a Database, Parameters, Logfiles, Alter Command, Indexes, Tables, Metadata, Database Security, Exporting data, Import function and much more. You may also be intrested in the Oracle Fundmentals 2 Tutorial

 Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Welcome

Database Administration

Oracle Database Administration Tools

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

Oracle dba 1Z0-031 Admin Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days


Title : Oracle Database dba I
Instructor : Gavin Powell
Price : US$ 99.95
Duration : 8 hours - 99 Movies
OS : Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options : Ground / 2 day / Next Day
Product Code : 33456


  392 in Stock

BENEFITS OF THIS TRAINING COURSE

  • Master Oracle dba 1Z0-031 Admin in the shortest time possible
  • Self paced tutorial, training on video, at your own pace
  • Just sit back and watch, no books to read, just easy to follow lessons
  • Training can be viewed from any location, on PC or Mac
  • All training is self-contained; you don’t even need the application you are learning loaded on your machine
  • The most affordable way to learn, benefit from a world-leading expert
  • High quality content for a fraction of the cost of a classroom training course
  • The Tutorials can be rewound, fast forwarded or stopped at any time
  • Learn from the comfort of your own desk.

RELATED TUTORIALS


NEW TRAINING TITLES


CLIENT TESTIMONIALS

Your excellent training courses have been a boon to my business. The fact that I can keep my work force on the job, supporting our customers, and still advance their capability has proven to be one of the best investments I have made since I started my business
Marc Rothwell
Columbus, OH

Site Map | Free Demos


Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:


Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434-878-4158
Fax: 1 207 433 4356
Email: