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