Title Language  : 

Find a Course... Try for Free!

 

Oracle Database Administration Fundamentals I Tutorials

Course Content
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.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
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)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Oracle Database Administration Fundamentals I
Author: Gavin Powell
SKU: 33456
ISBN: 1932072535
Duration: 8 hrs / 100 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products