Oracle 1Z0-031 Admin Fundamentals Tutorial Video

Details

This Oracle 1Z0-031 tutorial offers users an cost effective way to master this application it days. Presented using narrated QuickTime videos that work on both PC and Mac platforms. This training CD uses practical examples and easy to follow step by step instructions to convey knowledge and accelerate the learning process, users of this training product will benefit from a degree of clarity and retention that other forms of training fail to match. Most of the tutorials are suitable for beginner to intermediate users.
Close

Oracle 1Z0-031 Video Training

Contents

All the topics covered by this Oracle 1Z0-031 Training CD are listed below. The blue links are FREE Demos. Suitable for use on PC or MAC.

Try for FREE - NOW

QuicktimeInformation on the free demos.
So you can sample the high quality of this training product we have made available the first free chapters for free. On the purchased product the entire listing below is included. Please note the sound and video quality of the free demos has been compressed for faster internet delivery, the audio and video on the purchased CDs is much higher. In order to play the free demos Apple QuickTime 7 or above is needed if required

Click here to Buy This Video DVD

Welcome
Welcome Demo
Prerequisites for this Course Demo
About this Course Demo
Technet Database Admin Manual Demo

Database Administration
Oracle Database Administration? pt. 1 Demo
Oracle Database Administration? pt. 2 Demo
The Basic Architecture of Oracle Demo

Oracle Database Administration Tools
What are the Tools? Demo
SQL*Plus Demo
SQL*Plus Worksheet Demo
iSQL*Plus Demo
All the Other Oracle Tools Demo
Database Configuration Assistant pt. 1 Demo
Database Configuration Assistant pt. 2 Demo
Oracle Enterprise Manager Console 1 Demo
Oracle Enterprise Manager Console 2 Demo
The Management Server and the Agent Demo
Net Configuration Assistant Net Manager Demo
Oracle Enterprise Manager Console 3 Demo
Oracle Enterprise Manager Console 4 Demo


If you purchase the CD all the contents listed below are also included.


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 pt. 1
The Oracle Installer pt. 2
The Oracle Installer pt. 3
Configuration Parameter Files pt. 1
Configuration Parameter Files pt. 2
SQL*Net Configuration Files
Oracle Optimal Flexible Architecture
Windows Specifics pt. 1
Windows Specifics pt. 2
Creating a Database with a Script pt. 1
Creating a Database with a Script pt. 2

Starting Up and Shutting Down a Database
Connecting to a Database
STARTUP Command pt. 1
STARTUP Command pt. 2
SHUTDOWN Command pt. 1
SHUTDOWN Command pt. 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 pt. 1
The Parameters and What They Do pt. 2
The Parameters and What They Do pt. 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 pt. 1
Logfiles and Archives pt. 2
The ALTER SYSTEM Command pt. 1
The ALTER SYSTEM Command pt. 2
Automated Undo/Manual Rollback pt. 1
Automated Undo/Manual Rollback pt. 2
Metadata Views

DDL and the Logical Database
What is the Logical Database?
Tablespace Management pt. 1
Tablespace Management pt. 2
Tablespace Management pt. 3
Metadata Views

Expanding Database Objects
Tables pt. 1
Tables pt. 2
Tables pt. 3
Indexes pt. 1
Indexes pt. 2
Clusters
Index Organized Tables
Sequences
UNDROP, PURGE and the Recycle Bin
Partitioning
Metadata Views pt. 1
Metadata Views pt. 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 1Z0-031 Tutorial Video Information

Product Title: Oracle 1Z0-031
Trainer: Gavin Powell
Other Training courses by this author
Movie Details: 99 Lessons- Video run time: 8 Hours
Price North America $99.95
Price for Europen Sales £71.95 ( + Vat )
Delivery: 3 working days ( UK / USA and Canada )
Suitable for: Win 95, 98, 2000, NT, XP, Mac OS, OSX

106 In Stock

BUY THIS VIDEO


Benefits of this training method
  • Unique accelerated learning, master Oracle 1Z0-031 in days.
  • All training courses are taught by leading experts
  • Highly informative with an unmatched level of retention
  • Easy to follow step-by-step instructions
  • Ideal for single of multi users,
  • Users control the pace of the training, lessons can be stopped, rewound or fast-forwarded at any time.
  • More cost effective than a classroom training course, learn when it suits you.

Unrestricted Access to every training video - $30.00

Not sure which training CD to purchase? Why not have unlimited access to the entire range of training videos featured on this site for an unbelievable price of just $30 per month, that’s a massive 4,500 hours worth.

online people

Over 4000 hours of high quality training videos covering more than 350 of the most sort after software experts, accessible right from your own desk top, and all for just $30 per month.
No minimum sign up period
For Companies and Schools we offer a Multi User version complete with control panel, monitor usage, download reports, grant access and more.

Once signed up access is granted instantly to over 350 different titles with totally no restrictions, you can view as many different titles as you wish, there are no limits on how long you can log in for, you can even access from any computer.

This is without a doubt the most comprehensive source of high quality training on the web, and all at an unbelievable low price.

Learn even the most complex applications without having to read a manual or attend expensive classroom type training, learn when it’s convenient to you.

New titles are added each month, and as a member you will also have unlimited access to these as well.l.

Most of the training titles also have exercise files, these are included at no extra charge.

On completion of each course users can obtain a certification to verify the training.

Free Training Newsletter

Sign up for our free newsletter and get updated on when new titles are realised, and or when special offers are available
Your details are secure we never traded, sell or otherwise exchange your data with any third parties.