Concepts of Oracle Database Architecture
Free tutorial
20,665 students
3hr 43min of on-demand video
Created by TISYA Software Solutions Private Limited, Ramkumar Swaminathan
English
English [Auto]
Current priceFree
What you’ll learn
- 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
Introduction34 lectures • 3hr 43min
- Introduction to Computing Architecture03:48
- Oracle Database Architecture Overview03:23
- Oracle Database and Instance Components10:08
- Oracle Instance Components08:22
- Oracle Database Files09:06
- What is the Listener?07:32
- SELECT STatement processing06:20
- DML Statement Processing09:06
- DDL Statement Processing02:08
- Instance Recovery05:59
- Redo Logs08:53
- Concurrent Transactions03:50
- Oracle Instance Startup03:37
- Oracle Instance Shutdown06:35
- Introduction to Real Application Clusters05:01
- Crash Recovery in Oracle RAC06:36
- How do applications Connect to the Database05:10
- Shared Server Configuration08:05
- Connection Pool08:05
- Connection Pool Optimization05:37
- Global Temporary Tables16:01
- Physical and Logical Structures06:13
- Different Types of Tablespaces08:21
- Read Consistency – Introduction03:28
- Read Consistency – Statement Level06:01
- System Change Number (SCN)02:44
- Read Consistency – Transaction Level04:53
- What are Data Blocks?03:28
- Structure of Data Blocks05:34
- Structure of a Row03:52
- Space Management12:59
- ROWID05:19
- User and Schema04:30
- User Profiles11:47
