Oracle DBA 11g/12c - Database Administration for Junior DBA
4.4 (177 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,071 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle DBA 11g/12c - Database Administration for Junior DBA to your Wishlist.

Add to Wishlist

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.
Bestselling
4.4 (177 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,071 students enrolled
Created by Amarnath Reddy
Last updated 7/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 11 hours on-demand video
  • 7 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Students who want to start their careen in Database Administration
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
+
Architecture Recap
1 Lecture 04:27

Architecture Quiz!!!
2 questions
+
Software Installation
11 Lectures 01:44:36
Software Download...
00:13

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:53
User Management Concepts
09:23

User Management Demo 1
09:43

User Management Demo 2
03:52

User Creation Exercise
00:08

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
7 More Sections
About the Instructor
Amarnath Reddy
4.4 Average rating
2,708 Reviews
18,748 Students
9 Courses
Oracle Architect

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.

Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.

Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.