4.26 out of 5
4.26
2317 reviews on Udemy

Oracle DBA 11g/12c – Database Administration for Junior DBA

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.
Instructor:
Amarnath Reddy
9,836 students enrolled
English [Auto-generated] More
Final Goal: Get a job as an Oracle Database Administrator (Oracle DBA)
As a Oracle Database Administrator (Oracle DBA), you would be able understand the Database Architecture, which will help you to perform your DBA duties with better understanding.
As a Oracle Database Administrator (Oracle DBA), you would be able to Install the necessary Oracle Software/Database
As a Oracle Database Administrator (Oracle DBA), you would be able to Administer User accounts in the Database
As a Oracle Database Administrator (Oracle DBA), you would be able to Manage Tablespace's to provide required space for the data
As a Oracle Database Administrator (Oracle DBA), you would be able perform Backup and Recovery as needed.
As a Oracle Database Administrator (Oracle DBA), you would be able to diagnose the problems and if required will be able to work with Oracle Support
As a Oracle Database Administrator (Oracle DBA), you would be able to configure the Listeners for users to communicate

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.

‘Oracle 11g/12c DBA’ course follows a step by step methodology in introducing concepts and Demo’s to the students so that they can learn with ease.

If you want to become an Oracle Database Administrator(Oracle DBA), this course is right for you!!!!

Almost in every organization, you will find Database Administrator’s (DBA’s) to maintain the organization’s database. Becoming a good DBA depends on the knowledge you have in the overall architecture of Oracle Database.

In this course, I have covered both Oracle Database 11g and Oracle Database 12c so that you get to know the differences and can work in organizations, who are still in 11g.

Step by Step methodology followed is…

  • Learn the fundamentals of database to set the stage for Oracle Architecture
  • Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
  •  Install Oracle Database 11g & 12c (Manual method and using DBCA)
  • Tablespace management to manage space to store the data.
  • UNDO Tablespace management to manage undo space.
  • REDO Log file management to manage redo space.
  • Manage users and security
  • Networking (Configuring Listeners and TNS entries)
  • Understand various Data dictionary tables/views
  • Diagnose issues using Diagnose data and generate packages for Oracle Support.
  • Backup and Recovery (User Managed)
  • Backup and Recovery (RMAN)
  • Materialized Views
  • Table Partitioning
  • Project Work

Let’s start and I will take you step by step to lead your journey into the DBA world!!!

Introduction

1
What is a Database?
2
Role of a DBA!!!
3
OLTP vs OLAP Databases
4
What is Oracle 11g?
5
What is Oracle 12c?
6
Database abc's
7
Undo vs Redo Data
8
Oracle Instance vs Database
9
Quiz Time!!!

Quiz1

Oracle Process Architecture

1
Process Architecture
2
Database Writer Process
3
Log writer Process
4
Checkpoint Process
5
SMON Process
6
PMON Process
7
RECO Process
8
Archiver Process
9
Quiz Time!!!

Oracle Memory Architecture

1
Memory Architecture
2
Database Buffer Cache
3
Shared Pool
4
REDO log buffer
5
Large Pool
6
Java Pool and Streams Pool
7
Keep Buffer Pool
8
Recycle Buffer Pool
9
nK Buffer Cache
10
Program Global Area (PGA)
11
Dedicated vs Shared Databases
12
PGA in a Shared Envrionment
13
Quiz Time!!!

Architecture Recap

1
Architecture Full Picture!!!!
2
Architecture Quiz!!!

Software Installation

1
Software Download...
2
Virtual Machine Installation
3
Linux Installation
4
Oracle Software Installation
5
Oracle Parameter Files
6
Database creation - Manual Method Demo
7
Verify Database creation
8
Database creation using DBCA (Preferred option)
9
Oracle Startup Steps...
10
Oracle Shutdown methods
11
Oracle 12c Upgrade

Tablespace Management

1
How data is stored in a Database?
2
Tablespace Concepts
3
Online and Offline Tablespaces
4
Let's create a Tablespace...
5
Let's add more space to the Database...
6
Tablespace Demo 1
7
Tablespace Demo 2
8
Tablespaces with different block sizes
9
Temporary Tablespace Management
10
Temporary Tablespace Groups
11
Extent Management (Local vs Dictionary managed)

UNDO Management

1
UNDO Concepts
2
Read Consistency
3
ORA-01555 snapshot too old error
4
Automatic Undo Management
5
UNDO Management
6
Configuring Undo Retention Period
7
Retention Guarantee!!

REDO Management

1
REDO Concepts
2
REDO Logfile Management Demo1
3
REDO Logfile Management Demo2
4
Archival Concepts
5
Archival Log Mode Demo

User Management

1
User Management Concepts
2
User Management Demo 1
3
User Management Demo 2
4
User Creation Exercise
5
Privileges
6
System Privileges Demo
7
Object Privileges Demo
8
Revoking User Privileges
9
Revoking System Privileges
10
Revoking Object Privileges
11
Let's practice what we learnt so far...
12
Role Management Concepts
13
Role Management Demo
14
User Profiles
15
User Profile Demo
16
Managing Passwords using Profiles

Oracle Networking

1
Networking Concepts
2
Listener Configuration Demo
3
TNSNAMES Configuration Demo
4
Database Link Concepts
5
Public Database Link
6
Private Database Link

Data Dictionary

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3
4.3 out of 5
2317 Ratings

Detailed Rating

Stars 5
1061
Stars 4
831
Stars 3
328
Stars 2
58
Stars 1
39
536613af021f3e7969eda945cdd7a1f4
30-Day Money-Back Guarantee

Includes

11 hours on-demand video
7 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion