Oracle DBA 19C -Learn Real Time Scenarios

Oracle DBA 19C -Learn Real Time Scenarios, available at $54.99, has an average rating of 4.52, with 79 lectures, based on 257 reviews, and has 1631 subscribers.

You will learn about Learners can be able to get hands on experience on Oracle database administration Learners get confidence to face real time scenarios Learners can apply the techniques in their workplace Learners can get a broader understanding of Oracle Administration This course is ideal for individuals who are Oracle DBA It is particularly useful for Oracle DBA.

Enroll now: Oracle DBA 19C -Learn Real Time Scenarios

Summary

Title: Oracle DBA 19C -Learn Real Time Scenarios

Price: $54.99

Average Rating: 4.52

Number of Lectures: 79

Number of Published Lectures: 79

Number of Curriculum Items: 79

Number of Published Curriculum Objects: 79

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration

Who Should Attend

Oracle DBA

Target Audiences

Oracle DBA

Objective:

Title – Administration in standalone database

********Course will be updated dynamically ********!

Practice makes perfect !

Are you new to Oracle database?

Do you want to become a DBA?

Are you obsessed to get a real world knowledge on the DBA tasks?

Are you ready to learn by simulating the issues faced by a day to day DBA in his job

Majority of lab scenarios are presented in this course

Do you want to pretend you as a DBA in a project or account?

If you are looking for a structured course explaining “what is what” all the time, then this course is not for you.

This course is for those who are really interested in technical content and learning with illustrations

This course is for oracle learners who want to pretend doing a DBA job by simulations and scenarios
In this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasks
All the parameters will be used in the practical box for different oracle versions
Oracle machine is built in virtual box for simulation of the tasks
Learners can be able to confidently face a request from application team after completing the course
Database administration job is the core of this course. So you will learn common situations faced in your jobs.
Hope the learner who applies for this course has a prior understanding of what oracle database is.
You will be practicing in oracle 19c which is the widely used version all over the world.
You will learn the administration concepts from a DBA point of view rather than full presentations.

Prerequisites:

Oracle Database Administration fundamentals

Linux operating system basics

PC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit

CPU core(minimum) – 2

Student category:

Oracle DBA

For any questions, reach out to me at oracle community

Profile name- Kishan-Oracle

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: VM Configuration

Lecture 1: Software to be installed

Chapter 3: OEL 8.2 Installation and Configuration

Lecture 1: Oracle Linux 8.2 Installation and Network Configuration

Lecture 2: Initial Configuration

Chapter 4: Oracle Database Software Installation

Lecture 1: Oracle Database Software

Chapter 5: Database installation using DBCA

Lecture 1: Database installation

Lecture 2: Listener creation

Lecture 3: Connect to database

Chapter 6: Oracle Architecture

Lecture 1: High Level Architecture

Chapter 7: Database Startup and Shutdown Modes

Lecture 1: Startup Stages, Pfile and SPfile concepts

Chapter 8: DB_FILE_MULTI_BLOCK_READ_COUNT

Lecture 1: Scattered reads

Chapter 9: Database Basic healthchecks

Lecture 1: Database health checks

Chapter 10: Diagnostics practice

Lecture 1: Identify the alertlog and tracefiles

Chapter 11: Create a sample table with million rows for practice

Lecture 1: Create sample table

Chapter 12: Monitoring database generally as a DBA

Lecture 1: Monitor a session

Lecture 2: Identify Long sessions

Lecture 3: Why and When to use session longops?

Lecture 4: Identify session that i am connected to

Lecture 5: Project scenario – Kill sessions

Lecture 6: Kill a single application specific session

Lecture 7: Kill resource hogging processes

Lecture 8: Map OS process to database

Lecture 9: Who has blocked my session?

Lecture 10: Identify the software edition in an Oracle Home

Lecture 11: Identify SQL Command Type

Lecture 12: Identify Session Accessing An Object

Chapter 13: FRA housekeeping

Lecture 1: FRA space issues

Chapter 14: Managing processes, sessions and transactions effectively

Lecture 1: Calculate optimal processes, sessions and transactions

Lecture 2: Simulate processes exceed error

Lecture 3: Handling Inactive Sessions

Chapter 15: OPEN CURSOR

Lecture 1: Why cursors exceed in database?

Chapter 16: Undo management

Lecture 1: Undo management demonstration

Lecture 2: Undo errors and face them

Lecture 3: Undo solution

Chapter 17: Project scenario – Basic database down and start during OS patching

Lecture 1: DBA coordination for OS patching

Chapter 18: Project scenario – Ensure backup during application activity

Lecture 1: Ensure backups

Chapter 19: Mount point full

Lecture 1: Database mount point full scenario

Chapter 20: Statistics collection basics

Lecture 1: Statistics theory

Lecture 2: Optimizer statistics for table

Lecture 3: Statistics issues scenario

Lecture 4: Statistics Staleness Mystery

Chapter 21: User access scenarios

Lecture 1: Grant access for existing user

Chapter 22: Temporary tablespace scenario

Lecture 1: Temp tablespace growth

Lecture 2: Sorting with multiple queries in Temp tablespace

Lecture 3: Temp usage history

Chapter 23: Tablespace issues when disk is full

Lecture 1: Tablespace issues when disk is full

Chapter 24: Database decommission request

Lecture 1: Decommission a database

Chapter 25: PDB scenarios

Lecture 1: PDB connection scenario

Lecture 2: Connect to PDB and identify current connected container

Lecture 3: Application connectivity issues to PDB after activity

Lecture 4: Save PDB states

Chapter 26: Diagnose ORA-00600/7445 internal errors

Lecture 1: Oracle internal error scenario

Lecture 2: Error lookup

Chapter 27: BONUS: Oracle Enterprise Manager

Lecture 1: Real time monitoring tool for mission critical database system(OEM 13.5)

Lecture 2: Post Installation Steps

Lecture 3: Download Agent Software

Lecture 4: Configure Registration Password

Lecture 5: Deploy agent in target host

Lecture 6: Target addition in OEM

Chapter 28: Patching

Lecture 1: Database Patching

Lecture 2: Check for availability of RU's for 19c

Lecture 3: RU Patching Scenario

Lecture 4: RU Patching for 19c- Practical 1

Lecture 5: RU Patching for 19c – Practical 2

Lecture 6: RU Patching Post Patch steps

Chapter 29: Simulate corruption

Lecture 1: Simulate logical corruption

Chapter 30: Data refresh activities

Lecture 1: Instant Data Copy Using DBLINK

Lecture 2: Table refresh 1

Lecture 3: Table refresh 2

Chapter 31: High CPU diagnosis scenario

Instructors

eX hydra
Generic Technology Enthusiast

Rating Distribution

1 stars: 6 votes
2 stars: 5 votes
3 stars: 19 votes
4 stars: 94 votes
5 stars: 133 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu