Become a member
Online Access to 1000+ Courses!
  1. vtc.com
  2. online courses
  3. Certification
  4. Oracle Database Administration Fundamentals I Course

Oracle Database Administration Fundamentals I Course

8hrs (100 Lessons) 2003-09-30

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
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.

Transcription not available

  • Course: Oracle Database Administration Fundamentals I
  • Author: Gavin Powell
  • SKU: 33456
  • ISBN: 1932072535
  • Work Files: No
  • Captions: No
  • Subject: Certification
  • The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.
Course outline
Welcome
Welcome (01:27)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Prerequisites for this Course (02:20)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
About this Course (04:52)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Technet Database Administration Manuals (05:54)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Database Administration
Oracle Database Administration? pt. 1 (04:46)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Oracle Database Administration? pt. 2 (05:34)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Basic Architecture of Oracle (07:29)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Oracle Database Administration Tools
What are the Tools? (05:33)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
SQL*Plus (03:30)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
SQL*Plus Worksheet (02:01)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
iSQL*Plus (02:27)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
All the Other Oracle Tools (01:42)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Database Configuration Assistant pt. 1 (07:59)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Database Configuration Assistant pt. 2 (06:43)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Oracle Enterprise Manager Console pt. 1 (06:22)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Oracle Enterprise Manager Console pt. 2 (04:55)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Management Server and the Agent (03:03)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Net Configuration Assistant and Net Manager (05:39)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Oracle Enterprise Manager Console pt. 3 (04:23)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Oracle Enterprise Manager Console pt. 4 (04:41)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Architecture of Oracle
Oracle Database Architecture (03:20)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Memory Structures (06:54)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Processes (07:19)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Datafiles/Tablespaces/Objects (07:59)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Control Files/Logging/Archiving/Recovery (06:48)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
COMMIT vs ROLLBACK (06:22)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Rollback and Undo (05:11)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Temporary Sort Space (05:39)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
How it all Fits Together (07:03)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Oracle Managed Files (05:45)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Partitioning (05:45)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Installing Oracle and Creating a Database
The Oracle Installer pt. 1 (04:58)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Oracle Installer pt. 2 (01:52)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Oracle Installer pt. 3 (03:27)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Configuration Parameter Files pt. 1 (03:51)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Configuration Parameter Files pt. 2 (07:02)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
SQL*Net Configuration Files (05:24)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Oracle Optimal Flexible Architecture (05:45)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Windows Specifics pt. 1 (03:57)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Windows Specifics pt. 2 (06:27)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Creating a Database with a Script pt. 1 (04:54)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Creating a Database with a Script pt. 2 (04:33)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Starting Up and Shutting Down a Database
Connecting to a Database (04:54)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
STARTUP Command pt. 1 (05:46)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
STARTUP Command pt. 2 (05:40)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
SHUTDOWN Command pt. 1 (06:51)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
SHUTDOWN Command pt. 2 (05:27)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Combining STARTUP and ALTER DATABASE (01:34)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Oracle Enterprise Manager Console (01:43)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Configuration Parameters
What is the Parameter File? (04:41)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Looking at Parameters (02:17)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Parameters and What They Do pt. 1 (05:26)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Parameters and What They Do pt. 2 (06:53)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The Parameters and What They Do pt. 3 (04:30)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
DDL and the Physical Database
DDL and the Physical Database? (03:54)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The ALTER DATABASE Command (02:31)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Looking at the Database (05:23)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Changing Datafiles (05:19)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Sizing of Datafiles (04:15)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Datafiles and Tempfiles (04:22)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Control Files (07:21)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Logfiles and Archives pt. 1 (04:03)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Logfiles and Archives pt. 2 (06:44)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The ALTER SYSTEM Command pt. 1 (06:14)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
The ALTER SYSTEM Command pt. 2 (04:53)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Automated Undo/Manual Rollback pt. 1 (05:45)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Automated Undo/Manual Rollback pt. 2 (02:27)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Metadata Views (03:49)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
DDL and the Logical Database
What is the Logical Database? (03:08)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Tablespace Management pt. 1 (06:03)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Tablespace Management pt. 2 (07:32)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Tablespace Management pt. 3 (05:51)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Metadata Views (01:27)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Expanding Database Objects
Tables pt. 1 (03:57)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Tables pt. 2 (03:10)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Tables pt. 3 (04:48)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Indexes pt. 1 (05:38)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Indexes pt. 2 (06:21)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Clusters (02:33)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Index Organized Tables (01:53)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Sequences (02:39)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
UNDROP, PURGE and the Recycle Bin (01:29)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Partitioning (07:06)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Metadata Views pt. 1 (05:58)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Metadata Views pt. 2 (06:18)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Expanding Security for Database Administration
Types of Users (01:52)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Grants and Revokes (01:15)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Create and Alter User Syntax (03:28)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Administration Users (07:48)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Database Auditing (00:54)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Scheduling
The DBMS_JOB Package (01:51)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Job Scheduling in Oracle (02:06)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Scheduling/Executing Jobs in Windows and Unix (05:10)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Utilities
Export (02:42)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Import (01:48)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
SQL*Loader (03:54)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
ORAPWD and ORADIM (01:30)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Built-In Packages
Supplied Packages (03:37)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Scripting for Automation
Some Example Scripts (07:47)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips
Credits
About the Author (02:00)

BOOKMARKS

Subscribed users can bookmark any lesson for later viewing
Hide these tips

Lesson Notes

Subscribed users can add notes to any lesson for future reference
Hide these tips