Database Architecture
oracle Database Architecture
The Oracle RDBMS (Relation Database Management System).
In this course we shall cover the fundamentals of an Oracle Relational Database Management System. Teaching you everything you need to know about the database to confidently build, backup and maintain on a daily basis.
Day-1
- An Overview of Databases and Instances
Databases
Instances
- Oracle Logical Storage Structures
Blocks
Extents
Segments
- Oracle Logical Database Structures
Tables
Constraints
Indexes
Views
Users and Schemas
Profiles
Sequences
Synonyms
PL/SQL
External File Access
Database Links and Remote Databases
Day-1
- An Overview of Databases and Instances
Databases
Instances
- Oracle Logical Storage Structures
Blocks
Extents
Segments
- Oracle Logical Database Structures
Tables
Constraints
Indexes
Views
Users and Schemas
Profiles
Sequences
Synonyms
PL/SQL
External File Access
Database Links and Remote Databases
Day-2
- Oracle Physical Storage Structures
Datafiles
Redo Log Files
Control Files
Archived Log Files
Initialization Parameter Files
Alert and Trace Log Files
Backup Files
Oracle Managed Files
Password Files
Day-3
- Multiplexing Database Files
Automatic Storage Management
Manual Multiplexing
- Oracle Memory Structures
System Global Area
Program Global Area
Software Code Area
Background Processes
- Real Application Clusters
Overview of Real Application Clusters
Hardware Configuration
Software Configuration
Network Configuration
Disk Storage
- RAC Characteristics
Server Parameter File Characteristics
RAC-Related Initialization Parameters
Dynamic Performance Views
- RAC Maintenance
Starting Up a RAC
Redo Logs in a RAC Environment
Undo Tablespaces in a RAC Environment
Failover Scenarios and TAF
Tuning a RAC Node
Have any questions?
testimonials
-
Oracle Database Academy is one of the best courses I have participated in. Satnam 's knowledge, delivery, and experience are second to none.
Tom Jenkins
-
The only course that I have come across which was tailored to my specific company needs, at a fraction of the price compared to previous learning courses I have used.
Gurmejer Singh
-
Well thought out courses, amazing organisation of courses and the ODA team are extremely helpful during the hands-on process. Definitely recommend.
Sarah Robinson
