Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 10g: Architecture For Developers
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

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved