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 DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY
- ORACLE DATABASE 10G: INTRODUCTION TO PL/SQL – COMPLETE LIBRARY
Oracle Training Suggested Next Courses
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 DATABASE 10G: SQL TUNING
- ORACLE DATABASE 10G: ADVANCED PL/SQL PROGRAMMING & TUNING
Oracle Training Certification Examination
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 PL/SQL Developer Certified Associate (OCA)
- Oracle Forms Developer Certified Professional (OCP)
Oracle Training Audience
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:
- 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 duration
2 Days
Oracle Training Course outline
ABOUT THE ORACLE10G GRID-BASED TECHNOLOGY
- SMP
- ABOUT THE ORACLE10G DATABASE
- THE ENTERPRISE MANAGER DATABASE INTERFACE
THE ORACLE DATABASE ARCHITECTURE
- GENERAL DATABASE ARCHITECTURE
- ORACLE_BASE
- ORACLE_HOME
- DATABASE INSTANCE MEMORY ARCHITECTURE
DATABASE INSTANCE PROCESS ARCHITECTURE
- INSTANCE BACKGROUND PROCESSES
- SQL EXECUTION PROCESSES
DATABASE STORAGE ARCHITECTURE
- 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)
DATABASE SECURITY & INTEGRITY
- 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 NET SERVICES ARCHITECTURE
- ABOUT ORACLE NET SERVICES
- ORACLE NET SERVICES & EM
ORACLE DATABASE SHARED SERVERS ARCHITECTURE
- ABOUT SHARED SERVERS
- MONITOR SHARED SERVERS
- V$SHARED_SERVER
- V$SHARED_SERVER_MONITOR
- V$SESSION
- V$CIRCUIT
- V$DISPATCHER & V$DISPATCHER_CONFIG
- V$QUEUE
BACKUP & RECOVERY ARCHITECTURE
- ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
- REDO DATA
- FLASH RECOVERY AREA
DATABASE MANAGEABILITY
THE DATABASE MANAGEMENT FRAMEWORK
AUTOMATIC DATABASE DIAGNOSTIC MONITOR
METRICS & ALERT THRESHOLDS
ASM & THE BROADER DATABASE ARCHITECTURE
|
