Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training          Email Us   Phone :
Contact Us   -   About Us   -   Clients    
Loading
Courses
A+
ADA
Adobe
AJAX
Android
Apache
AutoCAD
Business Analysis
Business Objects
Business Skills and Technology
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CORBA
Corel
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Enterprise Architecture
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Legato
Lotus
Macintosh
Mainframe programming
Microsoft technologies
MS Access
MultiMedia and design
.NET
Network+
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Perl
PHP
PowerBuilder
Professional Development
Professional Soft Skills Workshops
Project Management
Quality Center/Quick Test
Rational
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software Engineering
Software quality and testing
SQL Server
Sybase
Telecommunications
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web 2.0
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
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
Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © Sideris