Create and deliver your own elearning using eduslide.net

Browse thousands of lessons. Create your own and share the knowledge.

Sign up for a free eduslide account !

Create your own courses.
Access thousands of lessons.

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.

Prerequisites for this Course

About this Course

Technet Database Administration Manuals

Database Administration

Oracle Database Administration? pt. 1

Oracle Database Administration? pt. 2

The Basic Architecture of Oracle

Oracle Database Administration Tools

What are the Tools?

SQL*Plus Worksheet

All the Other Oracle Tools

Database Configuration Assistant pt. 1

Database Configuration Assistant pt. 2

Oracle Enterprise Manager Console pt. 1

Oracle Enterprise Manager Console pt. 2

The Management Server and the Agent

Net Configuration Assistant and Net Manager

Oracle Enterprise Manager Console pt. 3

Oracle Enterprise Manager Console pt. 4

The Architecture of Oracle

Oracle Database Architecture

Memory Structures

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

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

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

DDL and the Logical Database

What is the Logical Database?

Tablespace Management pt. 1

Tablespace Management pt. 2

Tablespace Management pt. 3

Expanding Database Objects

Index Organized Tables

UNDROP, PURGE and the Recycle Bin

Metadata Views pt. 1

Metadata Views pt. 2

Expanding Security for Database Administration

Grants and Revokes

Create and Alter User Syntax

Administration Users

Database Auditing

The DBMS_JOB Package

Job Scheduling in Oracle

Scheduling/Executing Jobs in Windows and Unix

ORAPWD and ORADIM

Built-In Packages

Supplied Packages

Scripting for Automation

Some Example Scripts

Course options

Flag this course

Search

Channels

Tags

.net adobe apple certification cooking dance design dogs dreamweaver exercise fitness games mac macromedia martial-arts microsoft photoshop recipes video web

Activity

No Entry Found