Oracle DBA

Course Description

The course teaches the skills to manage a complex database, backup and recovery Oracle database server. Create a complete database. Customize the database by changing initialization parameters. Manage the database structure with tablespace, storage with tables, index, clusters, and hash clusters. Manage rollback segments and temporary segments. Ensure data integrity. Identify some of issues of disaster recovery for any computer system. Discuss the importance of getting management concurrence on backup methodology. Upon successful completion of this course, students should be prepared to sit for certification exam. The cost of certification exam of $450 is not included in the tuition.

You will learn

  • Knowledge of database queries
  • Knowledge of database theory
  • Knowledge of database design
  • Knowledge of structured query language (SQL), e.g. SQL/PSM or Transact-SQL
  • General understanding of distributed computing architectures, e.g. Client–server model
  • General understanding of operating system, e.g. Windows or Linux
  • General understanding of storage technologies and networking
  • General understanding of routine maintenance, recovery, and handling failover of a database

Course Outline

Oracle Introduction
  • Write efficient SQL statement
  • Restricting and sorting data
  • Single row, multiple row and group functions
  • Display data from multiple table using join function.
  • Subquery and output with SQLPLUS
  • Manipulating data
  • Create database objects such as table, index, constraint, and view.
  • Controlling user access
  • Oracle 10g date time and set operation.
  • Advance subquery and hierarchical retrieval
  • Oracle 9I extensions and DML and DDL statement
  • Introduction PL/SQL
Oracle database administration Workshop I
  • Oracle architectural components
  • Operation for database server startup and shutdown.
  • Managing oracle instance and create database
  • Data dictionary contents and usage
  • Maintaining the control file, redo log file, data file and tablespace
  • Storage structure and relationship in system management and local management.
  • Managing undo data and temp data
  • Managing table, indexes, constraints, password security and resources
  • Managing user, privilege and role.
  • Globalization Support.
Oracle database administration Workshop II
  • Basic oracle network architecture
  • Oracle net server-side configuration
  • Oracle net client-side configuration
  • Usage and configure of Oracle shared server
  • Instance and media recovery structure
  • Configuring DB archive mode
  • Oracle recovery management overview and configure.
  • User managed backup
  • RMAN backup
  • User managed/RMAN completed recovery
  • User managed/RMAN incomplete recovery
  • RMAN recovery catalog creation and maintenance.
  • Transporting data between databases.
  • Loading data into database
Performance tuning Oracle database
  • Performance tuning step and tools
  • Database configuration and I/O issues
  • Sizing share pool, buffer cache and other SGA structure
  • Tuning oracle shared server (MTS)
  • Tuning undo segments
  • Tuning SQL statement and application tuning
  • Managing statistics
  • Using materialized views
  • Monitoring and detecting lock contention
  • Using source manage and tuning OS


No schedule available now