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
