Username: 
Password: 
Oracle Database Administration Fundamentals I Tutorials

Online Contents For This Title

We have made some of the video tutorials for Oracle Database Administration Fundamentals I freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
   Title Description
This is the second in a series of courses, aimed at preparing the user for Oracle Certification Exam # 1Z0-031. This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, managing objects in the database and more. This course expands on the first course offered by VTC (Introduction to Oracle SQL and PL/SQL). Following courses will include: Oracle Database Administration Fundamentals II and Oracle Database Performance Tuning. To get started, click one of the movie topics below.

Choose your media type:

Welcome
  Welcome (01:27)
  Prerequisites for this Course (02:20)
  About this Course (04:52)
  Technet Database Administration Manuals (05:54)
Database Administration
  Oracle Database Administration? pt. 1 (04:46)
  Oracle Database Administration? pt. 2 (05:34)
  The Basic Architecture of Oracle (07:29)
Oracle Database Administration Tools
  What are the Tools? (05:33)
  SQL*Plus (03:30)
  SQL*Plus Worksheet (02:01)
  iSQL*Plus (02:27)
  All the Other Oracle Tools (01:42)
  Database Configuration Assistant pt. 1 (07:59)
  Database Configuration Assistant pt. 2 (06:43)
  Oracle Enterprise Manager Console pt. 1 (06:22)
  Oracle Enterprise Manager Console pt. 2 (04:55)
  The Management Server and the Agent (03:03)
  Net Configuration Assistant and Net Manager (05:39)
  Oracle Enterprise Manager Console pt. 3 (04:23)
  Oracle Enterprise Manager Console pt. 4 (04:41)
The Architecture of Oracle
  Oracle Database Architecture (03:20)
  Memory Structures (06:54)
  Processes (07:17)
  Datafiles/Tablespaces/Objects (07:59)
  Control Files/Logging/Archiving/Recovery (06:48)
  COMMIT vs ROLLBACK (06:22)
  Rollback and Undo (05:11)
  Temporary Sort Space (05:39)
  How it all Fits Together (07:03)
  Oracle Managed Files (05:45)
  Partitioning (05:46)
Installing Oracle and Creating a Database
  The Oracle Installer pt. 1 (04:58)
  The Oracle Installer pt. 2 (01:52)
  The Oracle Installer pt. 3 (03:27)
  Configuration Parameter Files pt. 1 (03:51)
  Configuration Parameter Files pt. 2 (07:02)
  SQL*Net Configuration Files (05:24)
  Oracle Optimal Flexible Architecture (05:45)
  Windows Specifics pt. 1 (03:58)
  Windows Specifics pt. 2 (06:26)
  Creating a Database with a Script pt. 1 (04:54)
  Creating a Database with a Script pt. 2 (04:33)
Starting Up and Shutting Down a Database
  Connecting to a Database (04:54)
  STARTUP Command pt. 1 (05:46)
  STARTUP Command pt. 2 (05:40)
  SHUTDOWN Command pt. 1 (06:51)
  SHUTDOWN Command pt. 2 (05:27)
  Combining STARTUP and ALTER DATABASE (01:34)
  The Oracle Enterprise Manager Console (01:43)
Configuration Parameters
  What is the Parameter File? (04:41)
  Looking at Parameters (02:17)
  The Parameters and What They Do pt. 1 (05:26)
  The Parameters and What They Do pt. 2 (06:53)
  The Parameters and What They Do pt. 3 (04:29)
DDL and the Physical Database
  DDL and the Physical Database? (03:54)
  The ALTER DATABASE Command (02:31)
  Looking at the Database (05:23)
  Changing Datafiles (05:19)
  Sizing of Datafiles (04:15)
  Datafiles and Tempfiles (04:22)
  Control Files (07:21)
  Logfiles and Archives pt. 1 (04:03)
  Logfiles and Archives pt. 2 (06:44)
  The ALTER SYSTEM Command pt. 1 (06:12)
  The ALTER SYSTEM Command pt. 2 (04:53)
  Automated Undo/Manual Rollback pt. 1 (05:45)
  Automated Undo/Manual Rollback pt. 2 (02:27)
  Metadata Views (03:49)
DDL and the Logical Database
  What is the Logical Database? (03:08)
  Tablespace Management pt. 1 (06:03)
  Tablespace Management pt. 2 (07:32)
  Tablespace Management pt. 3 (05:49)
  Metadata Views (01:27)
Expanding Database Objects
  Tables pt. 1 (03:57)
  Tables pt. 2 (03:10)
  Tables pt. 3 (04:48)
  Indexes pt. 1 (05:38)
  Indexes pt. 2 (06:21)
  Clusters (02:27)
  Index Organized Tables (01:53)
  Sequences (02:39)
  UNDROP, PURGE and the Recycle Bin (01:29)
  Partitioning (07:04)
  Metadata Views pt. 1 (05:58)
  Metadata Views pt. 2 (06:16)
Expanding Security for Database Administration
  Types of Users (01:52)
  Grants and Revokes (01:15)
  Create and Alter User Syntax (03:28)
  Administration Users (07:48)
  Database Auditing (00:54)
Scheduling
  The DBMS_JOB Package (01:51)
  Job Scheduling in Oracle (02:06)
  Scheduling/Executing Jobs in Windows and Unix (05:10)
Utilities
  Export (02:42)
  Import (01:48)
  SQL*Loader (03:54)
  ORAPWD and ORADIM (01:30)
Built-In Packages
  Supplied Packages (03:37)
Scripting for Automation
  Some Example Scripts (07:47)
Credits
  About the Author (02:00)

This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.


Tutorial Information

Title: Oracle Database Administration Fundamentals I
Author: Gavin Powell
SKU: 33456
ISBN: 1932072535
Release Date: 2003-09-30
Duration: 8 hrs / 100 lessons
Captions: No
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7, Flash 8

Subscription / Purchase Information

This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.


Also Available in CD format

Single User: US$ 99.95      Purchase/Add to Cart

Related Titles

 

Select Bandwidth