MIRACLE WISDOM - ORACLE DATABASE
Oracle Database Forum

 
TUTORIALS
ERP
SAP
SAP BW
SAP Query Reporting
Oracle Applications
Oracle Database
Oracle Application Server
Microsoft Dynamics CRM
Project Management
Windows Vista
Java
Microsoft Excel
Windows PowerShell
Microsoft Visio
JBoss Seam
Ajax
Microsoft Office Project
Eclipse Web Tools Platform
Adobe Dreamweaver
Microsoft Access
Microsoft SharePoint
JavaServe Faces (JSF)
Microsoft Expression
JavaScript
Microsoft SQL Server
Cascading Style Sheets (CSS)
Active Directory
SQL
Oracle PL/SQL
Subversion
Unified Modeling Language (UML)
XML
Unix
Red Hat Linux Administration
Apache Web Server

Google Custom Search
 
ORACLE DATABASE TRAINING
An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to guides and manuals. This tutorial claims a unique place among them. Rather than focusing on one area, the tutorial explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it. This tutorial distills a vast amount of knowledge into easy-to-read lessons covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more. Featuring focused text, abundant illustrations, and helpful hints, the tutorial offers a valuable overview of Oracle's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. The tutorial contains lessons on:

* Oracle products, options, and overall architecture for Oracle 10g and prior recent releases

* Installing and running Oracle: how to configure, start up, and shut down the database, and various networking issues

* Oracle data structures, datatypes, and ways of extending datatypes, with an introduction to Oracle objects (e.g., tables, views, indexes)

* Managing Oracle: security, the Oracle Enterprise Manager, fragmentation and reorganization, and backup and recovery Oracle performance: characteristics of disk, memory, and CPU tuning

* Multi-user concurrency, online transaction processing (OLTP), and high availability

* Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle Data warehousing and distributed databases Network deployment: using Oracle as an Internet computing platform and for grid computing

* What's new in Oracle 10g: a summary of the database changes described

This tutorial is the perfect all-in-one source for understanding the complexities and capabilities of Oracle.



LESSONS
Introducing Oracle  
 Introduction to Oracle
 Relational Database Evolution
 Relational Basics
 The Oracle Family
 Oracle Features
 Database Application Development Features
 Database Connection Features
 Distributed Database Features
 Data Movement Features
 Performance Features
 Database Management Features
 Oracle Developer Suite
 Oracle Lite
Oracle Architecture  
 Instances and Databases
 The Components of a Database
 The Components of an Instance
 The Data Dictionary
Installing and Running Oracle  
 Installing Oracle
 Creating a Database
 Configuring Oracle Net
 Starting Up the Database
 Shutting Down the Database
 Accessing a Database
 Oracle at Work
Data Structures  
 Datatypes
 Basic Data Structures
 Additional Data Structures
 Data Design
 Constraints
 Triggers
 Query Optimization
 Understanding the Execution Plan
 SQL Tuning Advisor
 Data Dictionary Tables
Managing Oracle  
 Management and Enterprise Manager
 Self-Tuning and Management
 Implementing Security
 Fragmentation and Reorganization
 Backup and Recovery
 Working with Oracle Support
Oracle Performance  
 Performance Tuning Basics
 Oracle and Disk I/O Resources
 Oracle and Parallelism
 Oracle and Memory Resources
 Oracle and CPU Resources
 Database Resource Manager
 Monitoring
 Real Application Clusters and Performance
Multiuser Concurrency  
 Basics of Concurrent Access
 Oracle and Concurrent User Access
 Oracle's Isolation Levels
 Oracle Concurrency Features
 How Oracle Handles Locking
 Concurrent Access and Performance
 Workspaces
Oracle and Transaction Processing  
 OLTP Basics
 Oracle's OLTP Heritage
 Architectures for OLTP
 Oracle Features for OLTP
 High Availability
 Oracle Advanced Queuing and Streams
 Object Technologies and Distributed Components
Oracle and Data Warehousing  
 Business Intelligence Basics
 Data Warehouse Design
 Data Warehouse Query Optimization
 Analytics, OLAP, and Data Mining in the Database
 Managing the Data Warehouse
 Other Data Warehouse Software
 The Metadata Challenge
 Data Warehousing Best Practices
Oracle and High Availability  
 What Is High Availability?
 System Crashes
 Protecting Against System Crashes
 Recovering from Disasters
 Complete Site Failure
 Data Redundancy Solutions
Oracle and Hardware Architecture  
 System Basics
 Uniprocessor Systems
 Symmetric Multiprocessing Systems
 Clusters
 Massively Parallel Processing Systems
 Non-Uniform Memory Access Systems
 Grid Computing
 Disk Technology
 Which Platform Deployment Solution?
Distributed Databases and Distributed Data  
 Accessing Multiple Databases as a Single Entity
 Two-Phase Commits
 Moving Data Between Distributed Systems
 Advanced Queuing
 Oracle Streams
Extending Oracle Datatypes  
 Object-Oriented Development
 Extensibility Features and Options
 Using the Extensibility Framework in Oracle
Network Deployment Models  
 The Impact of the Internet
 The Oracle Database and the Internet
 Oracle Application Server
 Grid Computing Model
 
 

Online Software Training
Resources
Oracle Database Training Courses