About Us|Contact Us|Learn Now: Find a Course
Like us and Save!  Join our Mailing List and Save!
Connect with us for News & Exclusive Offers:
View Cart
Contact Us
GET UP TO 30% OFF WITH ENHANCED PROMOTION CODES! CLICK HERE TO GET YOURS (UNTIL SUNDAY 27th JULY)




- 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

 Professionally created, self-study video training.

About this Tutorialshow details
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...
Learn this Software - See below for FREE TUTORIALS
RECOMMENDED COURSES
We also have the
Beginners Oracle 12c Tutorial
and the
Beginners Oracle PL/SQL Tutorial


Each Course on 1 or 2 CDs
For Mac and PC


FREE Shipping on ALL Orders
Oracle 1Z0-031 Tutorial - Oracle DBA Tutorial Info

CLICK HERE TO BUY THIS CD
Tutor: Gavin Powell
Duration: 8 hrs / 99 video lessons
UK Price: £79.95 + VAT

EU Price: €84.95 + VAT

US & Canada: $124.95
Product Code: 33456
Delivery:   Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 8, 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Share |


Don't take our word for it, see our CUSTOMER TESTIMONIALS
Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers provide a beginners guide using simplistic terms and minimal jargon.
  Personal Tutoring - Step-by-step video training from your own desktop. Delivered via best selling DVD/CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses, seminars, workshops & classes.
  You can jump to and from lessons allowing you to learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals, basic handbooks, and for dummies books.
Customer Testimonials
Associated Training CDs:
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
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials have a higher sound & video quality.

Welcome
Welcome
Prerequisites for this Course
About this Course
Technet Database Admin Manuals

Database Administration
Oracle Database Administration? - Lesson 1
Oracle Database Administration? - Lesson 2
The Basic Architecture of Oracle

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

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below and above, 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

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


CLICK HERE TO BUY THIS CD