Oracle Database 10g: Complete (Self-Study Course)

 

Who should attend

  • Database administrators
  • Technical consultants
  • System analysts

Prerequisites

  • SQL and PL/SQL Fundamentals
  • Database Administration

Course Objectives

  • SQL and PL/SQL Fundamentals
  • Database Administration

Product Description

  • Database Management in Oracle 10g
    • Database Management: Introduction
    • Oracle 10g
  • Basic SQL Statements
    • Retrieving Data
    • Restricting Data
  • SQL Functions
    • Single-Row Functions
    • Group Functions
  • Advanced SQL Statements
    • Joins
    • Sub-queries
    • Set Operators
  • DML and Schema Objects
    • Manipulating Data
    • Creating and Maintaining Tables
    • Other Schema Objects
    • Data Dictionary
  • Objects and Data Management
    • Controlling User Access
    • Maintaining Schema Objects
    • Manipulating Large Data Sets
    • Multi-table Inserts
    • Grouping Data
    • Manipulating Data Across Time zones
    • Using Advanced Sub-queries
  • Data Retrieval
    • Hierarchical Data Retrieval
    • Regular Expression Support
  • Programming with PL/SQL
    • Introduction to PL/SQL
    • Declarative Section
    • Executable Section
    • Data Retrieval, DML, and Cursors
    • Control Structures
    • Explicit Cursors
    • Exceptions Section
    • Stored Glossary and Functions
  • PL/SQL Blocks, PL/SQL Packages & Triggers
    • PL/SQL Block Constructs
    • Stored Procedures
    • Stored Functions
    • PL/SQL Package: Basics
    • PL/SQL Package: Advanced Concepts
    • Oracle-Supplied Packages
    • Creating Triggers
    • Trigger Applications
  • Dynamic SQL Statements
    • Dynamic SQL and MetaData
    • Manipulating Large Objects
  • PL/SQL Design Considerations
    • Standardizing PL/SQL Code
    • Managing Dependencies
  • Compilation Tools and Options
    • Compilation
  • Oracle Database 10g Workshop
    • Oracle Database: Overview
    • Installing an Oracle Database
    • Oracle Database Structure
    • Accessing Oracle Database
    • Managing Oracle Database
    • Oracle Database Table spaces
    • Managing Users
  • Data - Managing
    • Managing Database Objects
    • Managing Data
    • PL/SQL
  • Working with Databases
    • Defining Database Security
    • Auditing
    • Database Listeners and Services
    • Shared and Dedicated Servers
    • Performance Tuning and Monitoring
    • Maintaining Databases
    • Undo and Lock Management
    • Backup, Recovery, Database Failures & Recovering Databases
  • Performance Management
    • Use Enterprise Manager pages to monitor performance
    • Use the SQL Tuning Advisor
    • Use the SQL Access Advisor
    • Use Automatic Shared Memory Management
    • Use the Memory Advisor to size memory buffers
    • Use performance related dynamic views
    • Troubleshoot invalid or unusable objects
  • Scheduler, Advanced Tools & Resource Manager
    • Scheduler Components: Creation
    • Scheduler Components: Managing
    • Advanced Tools
    • Resource Manager: Concepts
    • Resource Manager: Configuration
    • Resource Manager: Using
  • ASM and Materialized Views
    • ASM
    • Materialized Views
  • Flashback Technology & Database Corruption
    • Flashback Concepts
    • Recovering from User Errors
    • Flashback Queries
    • Flashback Table
    • Dealing With Database Corruption
  • Automatic Performance Management
    • Identifying Tunable Components
    • Troubleshooting and Tuning Views
    • Direct Attach to SGA for Statistic Collection
    • Workload Repository & Advisory Framework
    • ADDM Scenarios and Usage Tips
    • Using the SQL Tuning and SQL Access Advisor
    • Memory Advisors & Segment Advisors
  • Using Recovery Manager & Diagnostic Sources and Recovery
    • RMAN Commands & Features of Recovery Manager
    • Backup Concepts
    • RMAN - Executing Backups
    • RMAN - Reporting and Monitoring
    • Configuring Recovery Manager
    • Incomplete Recovery: Concepts & Performing Incomplete Recovery
    • Diagnostic Sources
    • Recovering Non-Critical Losses
  • Using Globalization Support
    • Globalization Basics
    • Date time with Time Zones
    • NLS Parameters
    • Linguistic Interoperability
    • Migrating Globalized Data

Price on request