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

4.8 /5

(4 Ratings)

Offered byUDEMY

Oracle DBA 11g/12c - Database Administration for Junior DBA
at
UDEMY
Overview

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

Duration	11 hours
Total fee	₹455
Mode of learning	Online
Credential	Certificate

Oracle DBA 11g/12c - Database Administration for Junior DBA
at
UDEMY
Highlights

Earn certificate of completion from Udemy
Get an easy access on mobile and TV
Learn from 7 articles 7 downloadable resources
Students will get a 30 days money back guarantee

Oracle DBA 11g/12c - Database Administration for Junior DBA
at
UDEMY
Course details

Skills you will learn

Database Administration OLAP Linux Java C Oracle 11g

Who should do this course?

For students who want to start their career in Database Administration

What are the course deliverables?

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

More about this course

'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
Almost in every organization, people will find Database Administrator's (DBA's) to maintain the organization's database
Becoming a good DBA depends on the knowledge one has in the overall architecture of Oracle Database.
In this course, students will 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

Oracle DBA 11g/12c - Database Administration for Junior DBA
at
UDEMY
Curriculum

Introduction

Role of a DBA

OLTP vs OLAP Databases

Database abc's

Undo vs Redo Data

Oracle Instance vs Database

Process Architecture

Database Writer Process

Log writer Process

Checkpoint Process

SMON Process

PMON Process

RECO Process

Archiver Process

Memory Architecture

Database Buffer Cache

Shared Pool

REDO log buffer

Large Pool

Java Pool and Streams Pool

Keep Buffer Pool

Recycle Buffer Pool

Virtual Machine Installation

Linux Installation

Oracle Software Installation

Oracle Parameter Files

Database creation - Manual Method Demo

Verify Database creation

Database creation using DBCA (Preferred option)

How data is stored in a Database?

Tablespace Concepts

Online and Offline Tablespaces

Let's create a Tablespace...

Let's add more space to the Database...

Tablespace Demo 1

Tablespace Demo 2

Tablespaces with different block sizes

UNDO Concepts

Read Consistency

ORA-01555 snapshot too old error

Automatic Undo Management

UNDO Management

Configuring Undo Retention Period

Oracle DBA 11g/12c - Database Administration for Junior DBA
at
UDEMY
Faculty details

Amarnath Reddy

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.