Oracle Training Overview|
This is a special adaptation of the database architecture module normally presented to database administrators but customized for the benefit of developers and technical managers. With a series of in-depth lectures students are progressively acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals, advanced manageability features and more.
Oracle Training Prerequisites
Oracle Training Suggested Next Courses
- ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY
- ORACLE DATABASE 10G: INTRODUCTION TO PL/SQL – COMPLETE LIBRARY
After this course developers are well-equipped to proceed onto the most advanced aspects of Oracle database application development and tuning. These are among the suggested next courses:
Oracle Training Certification Examination
- ORACLE DATABASE 10G: SQL TUNING
- ORACLE DATABASE 10G: ADVANCED PL/SQL PROGRAMMING & TUNING
Although this course does not map directly to any of the certification examinations, it does provide useful background information for the following certification tracks:
Oracle Training Audience
- Oracle PL/SQL Developer Certified Associate (OCA)
- Oracle Forms Developer Certified Professional (OCP)
The target audience for this course is senior Oracle database developers. Although these will rely upon database administrators for the day-to-day administration of the database, their understanding of the architecture is critical. This course will also be of interest to management and others who require an in-depth understanding of the database architecture without a corresponding knowledge of how to perform the actual administration tasks.
Oracle Training Objectives
The objective is to provide developers with the skills needed to properly build and tune applications for optimum performance compatible with the architecture of the Oracle database. Among the specific subjects included are:
Oracle Training Course duration
- The enterprise-wide Oracle grid-based architecture and how this relates to individual databases and their architecture.
- The Oracle database and other tightly integrated related technologies, such as Oracle Net Services, Oracle Enterprise Manager and others.
- The internal architecture of an Oracle database. This includes the memory structures, process structures and physical data structures.
- Drilling deep into the physical storage architecture of the data structures, including tablespaces, data files, segments, extents, partitions, blocks, and row internals.
- Database security and integrity components.
- Advanced architecture components, such as shared servers, the manageability framework, and automatic storage management.
- Backup and recovery structures, including redo data and flashback database technology.
Oracle Training Course outline
ABOUT THE ORACLE10G GRID-BASED TECHNOLOGY
THE ORACLE DATABASE ARCHITECTURE
- ABOUT THE ORACLE10G DATABASE
- THE ENTERPRISE MANAGER DATABASE INTERFACE
DATABASE INSTANCE PROCESS ARCHITECTURE
- GENERAL DATABASE ARCHITECTURE
- DATABASE INSTANCE MEMORY ARCHITECTURE
DATABASE STORAGE ARCHITECTURE
- INSTANCE BACKGROUND PROCESSES
- SQL EXECUTION PROCESSES
DATABASE SECURITY & INTEGRITY
- ABOUT TABLESPACES
- MORE ABOUT TEMPORARY TABLESPACES
- MORE ABOUT PERMANENT TABLESPACES
- MORE ABOUT THE SYSAUX TABLESPACE
- ABOUT UNDO SPACE MANAGEMENT
- MORE ABOUT DATA FILES
- ABOUT ORACLE-MANAGED FILES (OMF)
ORACLE NET SERVICES ARCHITECTURE
- DATABASE SYSTEM PRIVILEGES
- DATABASE OBJECT PRIVILEGES
- DATABASE ACCOUNTS
- ABOUT ROLE-BASED SECURITY
- WITH ADMIN OPTION & System Privileges
- WITH GRANT OPTION & Object Privileges
- ABOUT LATCHES & LOCKS
ORACLE DATABASE SHARED SERVERS ARCHITECTURE
- ABOUT ORACLE NET SERVICES
- ORACLE NET SERVICES & EM
BACKUP & RECOVERY ARCHITECTURE
- ABOUT SHARED SERVERS
- MONITOR SHARED SERVERS
- V$DISPATCHER & V$DISPATCHER_CONFIG
THE DATABASE MANAGEMENT FRAMEWORK
- ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
- REDO DATA
- FLASH RECOVERY AREA
AUTOMATIC DATABASE DIAGNOSTIC MONITOR
METRICS & ALERT THRESHOLDS
ASM & THE BROADER DATABASE ARCHITECTURE