Oracle 11g DBA For Beginners

Administer the most stable Oracle database version

Count

Install, Create, Administer Oracle Database

Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA. This course will take you through database installation, basic administration, user administration, tablespace administration and more.

What you will learn

Install and configure Oracle 11gR2 database on Oracle Linux
Manage database space allocation so that users can work smoothly
Setup Oracle networking to allow external clients to connect the database
Export and import data from one database to another database

Introduction to Database

What is a Database?

53m

Oracle 11g Architecture

1h 44m

Install Oracle 11g Software

13m

Create 11g Database

33m

Navigating Oracle Database

Oracle Metadata

46m

DB Startup & Shutdown

13m

Multiplexing of Database Files

15m

Database Archivelog Mode

9m

Administration Essentials

Tablespace Administration

21m

User Administration

51m

Oracle Listener & TNS Setup

33m

SQL * Loader

15m

Oracle Export Import

39m

Oracle Data Pump

32m

Database Backup & Recovery

Why Backup & Recovery

8m

Backup & Recovery Solutions

9m

Oracle User Managed Backups

Cold Backup & Recovery

12m

Hot Database Backups

3m

Find DB Files Location

3m

Taking Hot DB Backup

9m

Hot Backup Queries

2m

RESTORE vs RECOVER

5m

Oracle User Managed Recovery

Parameter File Recovery

17m

Control File Recovery

19m

Entire Database Recovery

1m