Udemy

Platform

English

Language

IT Certification

Category

Oracle Database Administration for JuniorDBA/Oracle cloud.

To get skill how to do Oracle Database Administration ,Learn Oracle Cloud and prepare Oracle Certification exam

3.50 (125 reviews)

Students

9.5 hours

Content

Mar 2020

Last Update
Regular Price

SKILLSHARE
SkillShare
Unlimited access to 30 000 Premium SkillShare courses
30-DAY FREE TRIAL

What you will learn

After completing this course you will have fundamentals required for installation, configuration, and administration of an Oracle 12c database

To learn Database instance and storage,Instance memory pools,Instance background processes,Client connections,Database storage file types,Control files and backup files,Multitenant databases,Starting and stopping the database,Installing Oracle 12c software,Using the developer tools and Database management


Description

Oracle Database 12c is the world's leading relational database management system.After completing this course you will have fundamentals required for installation, configuration, and administration ,Architecture of an Oracle 12c database including hand on all exercise files are  attached with respective chapter.

Topics Covered

  1. Database instance and storage

  2. Instance memory pools

  3. Instance background processes

  4. Client connections

  5. Database storage file types

  6. Control files and backup files

  7. Multi-tenant databases

  8. Starting and stopping the database

  9. Installing Oracle 12c software

  10. Using the developer tools

  11. Database management

    Oracle Backup (RMAN) Hands-On Demo and Concepts

  12. Starting and connecting to database

  13. How to backup database in Archivelog and NoArchivelog mode with RMAN

  14. Oracle database incremental backup using RMAN

    Oracle Backup (User-Managed Backup) Hands-On Demo and Concepts

  15. How to take cold backup and Restore

  16. How to take Hot backup

  17. How to restore Hot backup


  18. Oracle DBA interview questions

  19. Oracle DBA terminology

  20. Oracle Basic Concepts


  21. QUICK REVIEW VERY Useful for DBA

    Install oracle 18c Demo 

    Install Oracle enterprise manager(OEM) in steps Demo

    Oracle Migration from Non-RAC to RAC database  Demo

    Oracle Database clone in RAC enviroment  Demo

    Convert oracle database from windows to Linux Demo

    Duplicate Oracle Database using RMAN Demo

    =========================================

  22. Oracle Database 19c installation in Oracle Linux 7

    Action Plan:

    1.  Preparing the Oracle Linux 7.6 Operating System for Database 19c installation.

    2.  Virtual Box Settings for Oracle Linux 7 VM.

    3.  Setting the static ip address

    4.  kernel parameters configuration

    5.  Resource limit configuration and stopping the Firewall

    6.  dependencies installation

    7.  oracle database installation

    8.  Host name configuration for Oracle Linux VM.

    9.  Oracle listener configuration after installation.

    10.  Starting the Database in SQL Plus

    11. Create one Common user called "scott"

    12. SQL Developer 19.1 Connectivity with Oracle database 19c

    13. Mounting the pluggable database orclpdb and check connectivity on SQL Developer.

    14. Access the Oracle Enterprise Manager on host machine browser.


Screenshots

Oracle Database Administration for JuniorDBA/Oracle cloud.
Oracle Database Administration for JuniorDBA/Oracle cloud.
Oracle Database Administration for JuniorDBA/Oracle cloud.
Oracle Database Administration for JuniorDBA/Oracle cloud.

Content

Introduction

Welcome

Target Audience

Oracle 12c Database Architecture

Oracle Database Instance

Oracle Database Storage

Oracle Server Processes

Oracle Memory Architecture

System global area

Shared pool

Redo log Buffer

Buffer cache

Other SGA pools and PGA

SGA and PGA Sizing

Oracle instance Background Processes

Oracle Database writer

LREG Process

Oracle Checkpoint Process

PMON Process

Log Writer

REC Process

Archive Process

Oracle Client Connections

Oracle listener

Tnsname.ora Configuration File

How to client connection work

Physical Database Structure

Database Storage File Types

Datafiles and Tablespaces

Special Oracle Tablespace

Redo Log Files

Control files

Backup files

Additional storage files

Multitentant Oracle Database

Benefits of the Oracle 12c Architecture

New and Old

Backward compatibility

Start and Stop Oracle Database

Shutdown

Startup

Install Oracle 12C

Prerequisites for Oracle Installation

O/S Configuration

Download Oracle 12c

Install the Oracle Software

Create Oracle Instance

Use NETCA to Create a Listener

Use DBCA to Create a Database

Useful Tools for Developers and DBAs

SQL PLUS Administration

SQL Developer for Development

Oracle Enterprise Manager

Oracle Database Management

Start and stop the oracle instance

start and stop Oracle listener

View and set parameter

Create users and assign permissions

Data dictionary

Troubleshoot using Alert Log

Oracle Tablespaces and Datafiles

Backup Concepts

Backup Concepts

RMAN Concepts

Oracle Backup (RMAN) Hands-On Demo and Concepts

Starting and connecting to database

How to backup database in Archivelog and NoArchivelog mode with RMAN

Oracle database incremental backup using RMAN

Oracle Backup (User-Managed Backup) Hands-On Demo and Concepts

How to take cold backup and Restore

How to take Hot backup

How to restore Hot backup

Oracle DBA interview questions and Oracle Database Internal mechanism


Reviews

N
Nalini23 February 2020

Instructor is not clear what he's presenting. His presentation and what he says is different and not good in communication

H
Hicham17 September 2019

The same exact contents as the one offered in Lynda by David Yahalom " Oracle Admin" . One is copying from the other

S
Susa13 April 2019

Great course, very well polished and organised. Presenter is clear and engaging. Excellent supplementary course links for each section

C
Charles12 April 2019

I learn to love how this instructor teaches. I followed one of his tutorial on youtube and I learn a lot more than what I expected

P
Pedro9 February 2019

I have learned a lot about Oracle database which is important for my work. Now, I know how to manage database and I am using this knowledge in my business. It is very good course to learn about Oracle and how to be DBA.

V
Vijay4 February 2019

Very good course for ones who wanted to start his career as Oracle DBA as instructor covered a lot with basic physical and logical architecture plus backup and recovery with different type of backup method

O
Olufunmilade30 January 2019

In my opinion this course is the best course for gaining basic knowledge oracle database 12c and first few lectures basic second part is more handy to learn related to back and recovery

D
Domenico27 January 2019

I learnt a lot from this course like how to setup oracle 12c environment and basic to advance including backup and recovery

G
Gizem27 January 2019

Not very clear since now. Very less and general slides are used, but lecturer talking about so many technical terms and if you dont have a general knowledge about this lecture you cannot understand anything. Also in example part(how to create an instance) it was very fast and not clear. He was just copying or writing scripts without explaining what it is.

C
Carol12 January 2019

The course did taught me lot of things and provided the start of the path towards my database admin journey

R
Rajesh9 January 2019

Great as i expected with lot of demo real time example would recommend who want to start his career as ORACLE DBA

K
Kyle7 January 2019

This course was paced correctly for my level of experience and hands on practice very informative Oracle backup Part.

F
Frederic20 December 2018

I have really enjoyed the course! Of course I still have so much to learn from practicing. We are never done. I'm sure I will take this course several times over and be great, no doubt!

A
Adam9 December 2018

The instructor is so clear and precise, i loved the way he teaches, he makes it so simple to understand through all the course i wish if can be added more related to RMAN

M
Moses3 December 2018

Great course for the beginners. The course is well structured and all the sessions will give very good knowledge on the daily tasks that will performed by an Oracle DBA thank you.


Coupons

DateDiscountStatus
6/10/202190% OFFExpired

1450540

Udemy ID

11/28/2017

Course created date

11/21/2019

Course Indexed date
Bot
Course Submitted by