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