Course Content:

Course Description: This course is targeted at novice to the technology. This course is intended to provide Oracle training with real time project.

Fundamental -I 

DAY - 1 Essential Unix and Linux from DBA perspective 

DAY â?? 2-4 Oracle Architecture

DAY â?? 5-6 Installing Oracle Software/ DB creation /Startup Shutdown modes

Installing the Oracle Database Software Plan an Oracle installation Install software with the Oracle Universal Installer (OUI) Creating an Oracle Database Create a database with the Database Configuration Assistant (DBCA) Create a database manually Managing the Oracle Instance Start and stop the Oracle database and components Access a database with SQL*Plus and iSQL*Plus Modify database initialization parameters Understand the stages of database startup View the Alert log Use the Data Dictionary

DAY â?? 7 Connectivity and Networking and Using SQL * PLUS

Oracle Networking and Database Connectivity Networking Concepts : How Oracle Networking works Establishing Oracle Connectivity Listener Configuration TNS Configuration Troubleshooting Starting a SQL *Plus Session Exiting SQL *Plus SQL * PLUS and SQL Commands iSQL *Plus 

DAY - 8 Managing Database Storage Structures

Define the purpose of tablespaces and data files Understand and utilize Oracle Managed Files (OMF) Create and manage tablespaces Obtain tablespace information Describe the main concepts and functionality of Automatic Storage Management 

DAY â?? 9-10 Schema Management

Types of SQL Statement Oracle Schemas Oracle tables Oracle Indexes Constraints Using Views Using Materialized Views Using Synonyms Using Sequences Using Triggers Viewing Object Information DAY â?? 11-12 User Management and Database Security

Create and manage database user accounts Authenticate users Assign default storage areas (tablespaces) Grant and revoke privileges Create and manage roles Create and manage profiles Implement standard password security features Control resource usage by users Enable standard database auditing Specify audit options, Review audit information Maintain the audit trail.

Fundamental -II:

DAY â?? 13-14 Loading and Transforming Data-

Describe available ways for moving data Use SQL*Loader to load data from a non-Oracle database (or user files) Using External tables to load data. Transforming Data

DAY â?? 15-18 Using Data pump Export and import-

Introduction to the Data pump technology Performing Data pump export Performing Data pump import Monitoring Data pump job Transportable tablespace How to take export into ASM diskgroup How to do ftp dumpfile from ASM diskgroup. How to refresh environment from other enviornment. DAY â?? 19-22 Backing UP database Configuring Recovery Manager Recovery Manager Features and Components Using a Flash Recovery Area with RMAN Configuring RMAN,Control File Autobackups Retention Policies and Channel Allocation Using Recovery Manager to connect to a target database in default NOCATALOG Displaying the current RMAN configuration settings Altering the backup retention policy for a database 

DAY â?? 22-24 Using Recovery Manager RMAN Command Overview Parallelization of Backup Sets Compressed Backups Image Copy Whole Database and Incremental Backups LIST and REPORT commands Enable ARCHIVELOG mode for the database Use Recovery Manager User Managed Backups Database Corruption Detection.

DAY -24-25 Database Recovery-

Performing Recovery with RMAN Cloning a database Recover from loss of a control file Recover from loss of a redo log file Perform complete recovery following the loss of a data file Recover tablespace Repairing database corruption 

DAY â?? 25-26 Managing and Monitoring the Operational Database

Generate AWR reports Generate ADDM report Generate ASH reports Managing Database links Using the Oracle Schduler 

DAY â?? 27-28 Improving Database Performance - SQL Query Optimization

Writing Efficient SQL SQL Performance tuning tools Using Explain plan SQL tuning Advisor 

DAY â?? 28-30 Performance Tuning : Tuning the Instance

Tuning oracle Memory PGA Management Troubleshooting and Tuning Views High Lights

- Trainer is a Real Time Oracle Certified working professional.

- Focus on Hands-on sessions.

- 100% satisfactory job oriented real time training

- Real-time projects.