Like us and Save! Join our Mailing List and Save!
FULL CONTACT INFO

Oracle Database Administration Fundamentals I Tutorial

A professionally created, self-study video training course
Includes 8 hours of easy to follow Oracle Database Administration Fundamentals I video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Oracle Database Administration Fundamentals I tutorial videos by clicking a blue link below:
  • Tutor: Gavin Powell
  • Duration: 8 hours
  • Video lessons: 99
  • Product code: 33456
  • In stock: YES
  • Available on: Online Subscription
  • Work files included: No
  • Works on: MS Windows PC & Mac
  • Latest Oracle Course: Oracle 12c tutorial
This Oracle 1Z0-031 tutorial is aimed at those who are preparing for the 1Z0-031 Oracle certification exam.

Using step by step video training movies, expert author Gavin Powell guides you from the basics to the more advanced techniques and concepts of this language and covers the main exam objectives.

If you want to feel confident with this language and on the day of the exam, then you should take a look at this comprehensive Oracle DBA tutorial.

Click any of the blue linked lessons below for FREE evaluation tutorials...
What Our Customers Are Saying

"Congratulations on building such a fine company - Your work is very professional in a world of sloppy and half baked pseudo professionals who think they are real professionals. Have an excellent weekend."Rick Cander. CA, USA
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the full course via online subscription.
Paid Content
Section

Get all lessons with purchase
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

Expanding Database Objects
Tables - Lesson 1
Tables - Lesson 2
Tables - Lesson 3
Indexes - Lesson 1
Indexes - Lesson 2
Clusters
Index Organized Tables
Sequences
UNDROP, PURGE and the Recycle Bin
Partitioning
Metadata Views - Lesson 1
Metadata Views - Lesson 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
Purchase Info
This course is available via a 3 month and a 1 year online subscription and is priced as below:
CURRENCY
 
3 Month Online Subscription (90 days)

1 Year Online Subscription
30% OFF!

Item(s):
Once subscribed, you will receive 99 Oracle Database Administration Fundamentals I training videos (listed left), lasting a total of 8 hours.

*no further discounts can be applied to the online subscription.

Worldwide
Shipping
Delivery Details
Subscription Access codes will be sent when payment processed (within one hour average)
|
Need to Train Multiple Users?
This Oracle Database Administration Fundamentals I course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Oracle Database Administration Fundamentals I course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
Multi users are sold in 10 user licenses. For each 10 user licenses, you can have up to 10 people viewing that training at any one time.
Closely Related Courses
See our complete range of MYSQL and PHP Video Tutorials
See our complete range of Oracle Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Oracle Database Administration Fundamentals I. Show your boss or potential employer!
Weekly Specials
    Get 10% Off Today! Join our Email Newsletter
     
This Weeks Special Offer
See the new and discounted
QuickBooks 2015
Recommended courses to watch next
Beginners Oracle PL/SQL | Oracle SQL | Oracle Application Express | Oracle 11g | Real Application Clusters in Oracle 11g | Oracle Database Administration Fundamentals II | Oracle: Performance Tuning (1Z0-033) | Data Modeling | FileMaker Pro Tutorials | Complete Range of Oracle tutorials | Crystal Reports 2011
A recent customer speaks out...
"It was nice speaking with you last week. I received the training software and have already used it for a few hours. I'm very happy with it, very good instructor, superior quality product. Regards."Mike Evans, California