Oracle DBA Training Program
<< back to 7 Training Programs
What you will learn
Basic SQL Statements
Subqueries
Creating Tables and Views
Creating Password Files
Redo Log Groups and Files
Managing the audit table
Export/Import and Reorganizing Tablespaces
Configuring Archiving
Configuring Oracle Enterprise Manager
Sizing the Database Buffer Cache
Managing Rollback Segments
ROWID format and DBMS_ROWID
Managing a Temporary Tablespace
Creating and Assigning Profiles
Managing User Privileges
Bitmapped Indexes Setting up a recovery catalog
Recovery of a table in a read-only tablespace
Configuring standby databases
Complete recovery from a backup
Configuring Multiblock Read Count
Checkpoint Process Tuning
Tuning for Multiple Buffer Pools
Tuning Reserved Space in the Shared Pool
Basic Net8 Client and Listener Configuration
Configuring Net8 Profile
Course Outline
SQL and PL/SQL
Overview of Relational Databases, SQL, and PL/SQL
Writing Basic SQL Statements
Restricting and Sorting Data
Single-Row Functions Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Subqueries
Producing Readable Output from SQL*Plus
Including Constraints
Creating and Managing Tables and Views
Controlling User Access
Declaring Variables
Writing Control Structures
Writing Explicit Cursors
Handling Exceptions
Database Administration
Oracle Architectural Components
Managing an Oracle Instance
Creating a Database
Data Dictionary Views and Standard Packages
Maintaining the Control File and Redo Log Files
Managing Tablespaces and Datafiles
Storage Structures and Relationships
Managing Rollback Segments
Managing Tables & Indexes
Maintaining Data Integrity
Loading Data
Managing Password Security and Resources
Managing Users & Privileges & Roles ...
Using National Language Support
Backup & Recovery Considerations
Oracle Recovery Structures and Processes
Oracle Backup and Recovery Configuration
Physical Backups & Recovery Without Oracle Recovery Manager
Incomplete Oracle Recovery with Archiving
Oracle Export and Import Utilities
Oracle Utilities for Troubleshooting
Oracle Recovery Catalog Creation and Maintenance
Backups Using RMAN
Restoration and Recovery Using RMAN
Oracle Standby Database
Oracle Tuning
Oracle Alert and Trace Files
Utilities and Dynamic Performance Views
Tuning the Shared Pool; Buffer Cache; Redo Log Buffer
Database Configuration and 1/0 Issues
Using Oracle Blocks Efficiently
Optimize Sort Operations
Rollback Segment Tuning
Monitoring and Detecting Lock Contention
Managing a Mixed Workload
Tuning with Oracle Expert
Network Administration
Networking Overview
Basic Net8 Architecture
Basic Net8 Server-Side Configuration
Basic Net8 Client Side Configuration
Centralized Naming Concepts
Usage and Configuration of Oracle Names
Usage and Configuration of the Multithreaded Server
Usage and Configuration of Connection Manager
Troubleshoot the Network Environment
Security in the Network Environment
