United States Oracle Database Administration Fundamentals I Tutorials
Online Contents For This Course
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!
Course 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) | ||
Email this Page
Send us FeedbackCourse Information
| Course: | Oracle Database Administration Fundamentals I |
| Author: | Gavin Powell |
| SKU: | 33456 |
| ISBN: | 1932072535 |
| Release Date: | 2003-09-30 |
| Duration: | 8 hrs / 100 tutorials |
| Captions: | No |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 782 courses, 81,350 video tutorials (20,800+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More