top of page

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

19:32

What is Data?

22:55

What is a Database?

11:01

How a Database Function

Oracle 11g Architecture

23:16

User Connectivity in Oracle

05:18

Phases of SQL Execution

15:04

Select Statement Processing

22:05

DML / DDL Statement Processing

12:14

Oracle Architecture Components

12:09

Oracle Background Processes

14:49

Oracle Files

Oracle 11g Software Installation

00:50

Download Oracle 11g

01:03

Installation Prerequisites

06:17

Pre Install Tasks

03:35

Install Oracle 11g

01:13

Post Install Tasks

Oracle 11g Database Creation

03:41

Set Environment Variables

04:04

DBCA Create Database

03:42

Connect Database

20:07

Manual DB Creation

01:28

DBCA Delete Database

Navigating Oracle Database

06:02

Database Metadata

04:33

Basic Views You Must Know

13:21

Key Database Files

06:38

Database Storage Structures

06:50

Datafiles Metadata

09:20

Tablespace Metadata

Basic Database Administration

11:45

Database Operating Modes

01:24

DB Startup & Shutdown

02:00

Multiplexing of Database Files

07:35

Multiplexing Control Files

05:39

Multiplexing Redolog Files

09:43

Database Archivelog Mode

Tablespace Administration

04:52

Tablespace Utilization

08:02

Create New Tablespace

08:50

Capacity Planning

User Administration

02:56

Users in Oracle

16:25

User Management

07:27

User Role Management

08:21

User Permission Management

06:32

Profile Management

09:39

Create User Profile

Oracle Networking

07:09

Install Oracle 11g Client

10:13

Configuring Listener

12:07

Configuring TNS Entries

03:37

Oracle DB Links

Oracle Utilities

03:38

SQL * Loader

11:53

Import csv into Table

08:07

Oracle Export Import

17:13

Performing Export

13:50

Performing Import

06:20

Oracle Data Pump

06:23

Data Pump Directory

08:29

Data Pump Export

10:49

Data Pump Import

Database Backup & Recovery

08:13

Why Backup & Recovery?

09:23

Backup & Recovery Solutions

Oracle User Managed Backups

12:35

Cold DB Backup and Recovery

03:25

Hot Database Backups

03:31

Find DB Files Location

09:24

Taking Hot DB Backup

02:10

Hot Backup Queries

05:04

RESTORE vs RECOVER

Oracle User Managed Recovery

17:17

Parameter File Recovery

19:15

Control File Recovery

01:31

Entire Database Recovery

Introduction to RMAN

09:15

What is RMAN?

01:37

How to Connect RMAN Utility

Course Curriculum

bottom of page