IT & Software Other IT & Software Oracle Database

Oracle Database Architecture

Concepts of Oracle Database Architecture
Rating: 4.6 out of 5 (1,346 ratings)
17,062 students
Created by TISYA Software Solutions Private Limited, Ramkumar Swaminathan
English

Understand the concepts of Oracle Database Architecture and Administration

Requirements

  • Good understand in working with SQL

Description

In this course you will learn about the architectural components of Oracle Database. You will learn about the various Processes , Memory areas, Files that are involved in the Architecture of Oracle Database. This course will help you to get a deep understanding of the fundamentals of Oracle Database Architecture and will lay the foundation for skills on the job as a DBA and also help you in taking up the DBA certification.

Who this course is for:

  • Anyone who would like to learn about Oracle Database Architecture

Course content

1 section • 34 lectures • 3h 42m total length

  • Introduction to Computing Architecture
    03:48
  • Oracle Database Architecture Overview
    03:23
  • Oracle Database and Instance Components
    10:08
  • Oracle Instance Components
    08:22
  • Oracle Database Files
    09:06
  • What is the Listener?
    07:32
  • SELECT STatement processing
    06:20
  • DML Statement Processing
    09:06
  • DDL Statement Processing
    02:08
  • Instance Recovery
    05:59
  • Redo Logs
    08:53
  • Concurrent Transactions
    03:50
  • Oracle Instance Startup
    03:37
  • Oracle Instance Shutdown
    06:35
  • Introduction to Real Application Clusters
    05:01
  • Crash Recovery in Oracle RAC
    06:36
  • How do applications Connect to the Database
    05:10
  • Shared Server Configuration
    08:05
  • Connection Pool
    08:05
  • Connection Pool Optimization
    05:37
  • Global Temporary Tables
    16:01
  • Physical and Logical Structures
    06:13
  • Different Types of Tablespaces
    08:21
  • Read Consistency - Introduction
    03:28
  • Read Consistency - Statement Level
    06:01
  • System Change Number (SCN)
    02:44
  • Read Consistency - Transaction Level
    04:53
  • What are Data Blocks?
    03:28
  • Structure of Data Blocks
    05:34
  • Structure of a Row
    03:52
  • Space Management
    12:59
  • ROWID
    05:19
  • User and Schema
    04:30
  • User Profiles
    11:47

Featured review

Sasa Savic
Sasa Savic
136 courses
13 reviews
Rating: 5.0 out of 5a year ago
I am very satisfied with this course. Everything is very precisely but yet not too detailed explained. I think that everyone who wants to start with Oracle needs to beginn with this course. After this you get a big picture of oracle architecture which can really help for preparing for the DBA Exams and jobs.

Instructors

TISYA Software Solutions Private Limited
Technology Learning Services
TISYA Software Solutions Private Limited
  • 4.5 Instructor Rating
  • 4,678 Reviews
  • 40,019 Students
  • 8 Courses

We are a group of senior technical professionals with varied experience in the Software Industry. We started this venture out of a passion to educate people. Our vision is to enable people learn at their own pace & convenience and go to the next level.

By sharing our knowledge & experience in professional videos we want to up-skill individuals and help them meet their learning goals. 


We are experts in technologies given below:

- Oracle Database ( Development, Administration & Tuning)

- Java & JEE ( Development and Tuning)

- JEE Application Servers

- Oracle Engineered Systems

- Big Data ( Hadoop, NoSQL databases, Kafka, Spark ...)

- Oracle GoldenGate  & Oracle Data Integrator

- Oracle Spatial

- Data Mining

- Performance Engineering

- OOAD & UML

- R and Analytics

- Oracle Cloud


Our approach/strategy in delivering online training is to bring the class to wherever you are. We believe learning is more effective when the student sees the instructor explaining concepts. We have been teaching Instructor led and Live Virtual Classes across the Globe. We also wanted to make knowledge available online at an affordable cost.

We are sure you will enjoy and learn and look forward to your feedback.

Happy Learning!!!!

Ramkumar Swaminathan
Senior Technical Professional
Ramkumar Swaminathan
  • 4.5 Instructor Rating
  • 4,678 Reviews
  • 39,986 Students
  • 8 Courses

Have been working on various technologies including Oracle Database and related technologies ( High Availability, RAC and DG, Security, Performance Tuning, Spatial etc) , GoldenGate, Exadata, Enterprise Manager, Oracle Cloud and  R.


Teaching is a passion and I am doing my best to help people learn and be better at their profession... Please do review my courses and provide list of interests that you have so that I can publish those courses as well...