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
Course Title Oracle DBA
Course provider VSS Innovative Technologies
Mode Interactive mode
Batch start As per your comfort will arrange.
Instructor Name Amritesh
Experience 12+ years
Location Class room
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
Oracle DBA Schedule
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 tunning 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.