Find a Course...Try for FREE

Oracle IZO-031 Admin Fundamentals I Training Information
Author: Gavin Powell
Duration: 8 hrs
Video Lessons: 99
Click here to sign up to the Online University
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9


Training Categories
    Graphics & Page Layout
    Internet & Web Design
    Animation & 3D
    Multi Media & Video
    Business
    Certification
    Operating Systems
    Databases
    Programming
    Music & Audio
    Tutorials Coming Soon

Oracle IZO-031 Admin Fundamentals I Training - FREE Tutorials

FREE Oracle IZO-031 Admin Fundamentals I Training
Learn Oracle IZO-031 Admin Fundamentals I in the shortest time possible, start now with the linked tutorials below:   (Please allow a few seconds to load)
To ensure the FREE tutorials below run smoothly, please view our short checklist - CLICK HERE

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

Database Administration
Oracle Database Administration? - Tuition 1
Oracle Database Administration? - Tuition 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 - Tuition 1
Database Configuration Assistant - Tuition 2
Oracle Enterprise Manager Console 1
Oracle Enterprise Manager Console 2
The Management Server and the Agent
Net Configuration Assistant Net Manager
Oracle Enterprise Manager Console 3
Oracle Enterprise Manager Console 4

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON 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 - Tuition 1
The Oracle Installer - Tuition 2
The Oracle Installer - Tuition 3
Configuration Parameter Files - Tuition 1
Configuration Parameter Files - Tuition 2
SQL*Net Configuration Files
Oracle Optimal Flexible Architecture
Windows Specifics - Tuition 1
Windows Specifics - Tuition 2
Creating a Database with a Script - Tuition 1
Creating a Database with a Script - Tuition 2

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

DDL and the Logical Database
What is the Logical Database?
Tablespace Management - Tuition 1
Tablespace Management - Tuition 2
Tablespace Management - Tuition 3
Metadata Views

Expanding Database Objects
Tables - Tuition 1
Tables - Tuition 2
Tables - Tuition 3
Indexes - Tuition 1
Indexes - Tuition 2
Clusters
Index Organized Tables
Sequences
UNDROP, PURGE and the Recycle Bin
Partitioning
Metadata Views - Tuition 1
Metadata Views - Tuition 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 TUTORIAL ON CD




Sign up to the Online University and view over 400 titles for only $30/£15 per month
BENEFITS:
  1 Minimum Sign Up: ONLY ONE MONTH! - Cancel at any Time
  2 Unlimited Viewing
  3 Downloadable Working Files
  4 Learn from Expert Authors
  5 View on any Computer in the World
  6 Works on PC and Mac
  7 Full Support Offered
  8 450+ Courses for a Low Monthly Fee
  9 New Titles Added Weekly
  10 A Truely Professional Study Guide

Click here to sign up to the Online University

CLICK HERE TO BUY THIS TUTORIAL ON CD

Multi user options available for large organistions and education
CLICK Here for further info

Free Certificates available when each course has been completed


RECENTLY ADDED TUTORIALS
  ADOBE INDESIGN CS3
  ADOBE PHOTOSHOP CS3
  ADREAMWEAVER CS3
  APPLE FINAL CUT PRO 6
  MAYA 8.5 FOR BEGINNERS
  POSER 7
  AUTOCAD 2007
  MS PROJECT 2007
  ADOBE ILLUSTRATOR CS3
  MICROSOFT ACCESS 2007
  MICROSOFT VISTA
  ADOBE FLASH CS3
  AUTOCAD 2009