Oracle DBA 11g/12c - Database Administration for Junior DBA
4.3 (4,625 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
18,692 students enrolled

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.
Bestseller
4.3 (4,625 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
18,692 students enrolled
Created by Amarnath Reddy
Last updated 2/2018
English
English [Auto], French [Auto], 6 more
  • German [Auto]
  • Italian [Auto]
  • Polish [Auto]
  • Portuguese [Auto]
  • Romanian [Auto]
  • Spanish [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 11 hours on-demand video
  • 7 articles
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • Students should have basic SQL Knowledge
  • Students should know the basic UNIX/LINUX commands
  • An open mind to understand Architecture, before jumping into demo's
Description

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!!!

Who this course is for:
  • Students who want to start their careen in Database Administration
Course content
Expand all 129 lectures 10:59:46
+ Introduction
8 lectures 37:31
Role of a DBA!!!
05:17
OLTP vs OLAP Databases
04:14
Database abc's
04:42
Undo vs Redo Data
05:41
Oracle Instance vs Database
03:43

Quiz1

Quiz Time!!!
2 questions
+ Oracle Process Architecture
8 lectures 18:40
Process Architecture
02:25
Database Writer Process
04:05
Log writer Process
01:14
Checkpoint Process
03:44
SMON Process
01:17
PMON Process
02:24
RECO Process
01:58
Archiver Process
01:33
Quiz Time!!!
4 questions
+ Oracle Memory Architecture
12 lectures 31:25
Memory Architecture
02:34
Database Buffer Cache
03:17
Shared Pool
07:20
REDO log buffer
01:03
Large Pool
01:54
Java Pool and Streams Pool
00:58
Keep Buffer Pool
03:00
Recycle Buffer Pool
01:48
nK Buffer Cache
01:32
Program Global Area (PGA)
02:36
Dedicated vs Shared Databases
04:44
PGA in a Shared Envrionment
00:39
Quiz Time!!!
5 questions
+ Software Installation
11 lectures 01:44:34
Software Download...
00:11
Virtual Machine Installation
02:20
Linux Installation
16:50
Oracle Software Installation
15:00
Oracle Parameter Files
05:55
Database creation - Manual Method Demo
16:08
Verify Database creation
02:17
Database creation using DBCA (Preferred option)
10:46
Oracle Startup Steps...
07:46
Oracle Shutdown methods
08:08
Oracle 12c Upgrade
19:13
+ Tablespace Management
11 lectures 01:07:39
How data is stored in a Database?
06:21
Tablespace Concepts
04:19
Online and Offline Tablespaces
01:11
Let's create a Tablespace...
02:00
Let's add more space to the Database...
02:09
Tablespace Demo 1
19:35
Tablespace Demo 2
06:10
Tablespaces with different block sizes
04:39
Temporary Tablespace Management
06:19
Temporary Tablespace Groups
06:18
Extent Management (Local vs Dictionary managed)
08:38
+ UNDO Management
7 lectures 33:41
UNDO Concepts
05:32
Read Consistency
03:10
ORA-01555 snapshot too old error
02:34
Automatic Undo Management
02:41
UNDO Management
09:51
Configuring Undo Retention Period
04:26
Retention Guarantee!!
05:27
+ REDO Management
5 lectures 22:53
REDO Concepts
07:12
REDO Logfile Management Demo1
06:01
REDO Logfile Management Demo2
03:32
Archival Concepts
03:00
Archival Log Mode Demo
03:08
+ User Management
16 lectures 01:13:52
User Management Concepts
09:23
User Management Demo 1
09:43
User Management Demo 2
03:52
User Creation Exercise
00:07
Privileges
05:49
System Privileges Demo
07:50
Object Privileges Demo
05:38
Revoking User Privileges
03:06
Revoking System Privileges
02:14
Revoking Object Privileges
02:19
Let's practice what we learnt so far...
02:23
Role Management Concepts
04:09
Role Management Demo
04:11
User Profiles
05:34
User Profile Demo
05:21
Managing Passwords using Profiles
02:13
+ Oracle Networking
6 lectures 38:01
Networking Concepts
10:00
Listener Configuration Demo
09:00
TNSNAMES Configuration Demo
07:35
Database Link Concepts
03:32
Public Database Link
05:09
Private Database Link
02:45