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

Show Details

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.

View All Titles

Learn More

Email this Page

Send us Feedback

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.

View All Titles

Learn More Know More

Also Available in CD format

Single User: US$ 99.95

Purchase/Add to Cart

Related Titles

Select Bandwidth

Now Shipping

Carrara 6 Pro

View the first three chapters of this tutorial FREE!

Client Testimonials

The FileMaker tutorials are fantastic! So glad they are available. Don't know how I would have learned as much from just the manual alone. John...

Geoff Petlowany

Select a Category

Special Groups

Publisher or Products