Oracle Database Administration Fundamentals I Tutorials

Course Title: Oracle Database Administration Fundamentals I

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.

Course Author/Expert: Gavin Powell

Language: english

Full Online Training Available: Yes

Number of Course Movies: 99

Course Duration: 8 hours

Never has it been so easy to learn Oracle Database Administration Fundamentals I.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.

Course Outline:

The FIRST THREE chapters of this online training course can be viewed right now!

Click Here Now To View the First Three Chapters of Oracle Database Administration Fundamentals I Online Training For Free

If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.

The Architecture of Oracle

Oracle Database Architecture

Memory Structures

Processes

Datafiles/Tablespaces/Objects

Control Files/Logging/Archiving/Recovery

COMMIT vs ROLLBACK

Rollback and Undo

Temporary Sort Space

How it all Fits Together

Oracle Managed Files

Partitioning

Installing Oracle and Creating a Database

The Oracle Installer pt. 1

The Oracle Installer pt. 2

The Oracle Installer pt. 3

Configuration Parameter Files pt. 1

Configuration Parameter Files pt. 2

SQL*Net Configuration Files

Oracle Optimal Flexible Architecture

Windows Specifics pt. 1

Windows Specifics pt. 2

Creating a Database with a Script pt. 1

Creating a Database with a Script pt. 2

Starting Up and Shutting Down a Database

Connecting to a Database

STARTUP Command pt. 1

STARTUP Command pt. 2

SHUTDOWN Command pt. 1

SHUTDOWN Command pt. 2

Combining STARTUP and ALTER DATABASE

The Oracle Enterprise Manager Console

Configuration Parameters

What is the Parameter File?

Looking at Parameters

The Parameters and What They Do pt. 1

The Parameters and What They Do pt. 2

The Parameters and What They Do pt. 3

DDL and the Physical Database

DDL and the Physical Database?

The ALTER DATABASE Command

Looking at the Database

Changing Datafiles

Sizing of Datafiles

Datafiles and Tempfiles

Control Files

Logfiles and Archives pt. 1

Logfiles and Archives pt. 2

The ALTER SYSTEM Command pt. 1

The ALTER SYSTEM Command pt. 2

Automated Undo/Manual Rollback pt. 1

Automated Undo/Manual Rollback pt. 2

Metadata Views

DDL and the Logical Database

What is the Logical Database?

Tablespace Management pt. 1

Tablespace Management pt. 2

Tablespace Management pt. 3

Metadata Views

Expanding Database Objects

Tables pt. 1

Tables pt. 2

Tables pt. 3

Indexes pt. 1

Indexes pt. 2

Clusters

Index Organized Tables

Sequences

UNDROP, PURGE and the Recycle Bin

Partitioning

Metadata Views pt. 1

Metadata Views pt. 2