Oracle Database Administration 12c

About This course

In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

In this students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.

Learn To:

Manage an Oracle Database instance.
Configure the Oracle Network environment.
Create and manage storage structures.
Manage and move data.
Create and manage users.
Monitor the database and manage performance.
Create and manage Database as a Cloud Service database deployments

Develop appropriate backup and recovery procedures to address your business needs.
Implement backup and recovery settings and perform backup operations to disk and tape.
Employ oracle database recovery procedures to recover from media and other failures.
Diagnose and repair data failures.
Use flashback technologies and data duplication to complement backup and recovery procedures.
Secure the availability of your database by appropriate backup and recovery strategies.

Suggested Prerequisite

A working knowledge of SQL and PL/SQL packages is very helpful in the course.
Basic knowledge of Linux operating system

Audience

Database Administrators, Database Designers, Support Engineer, Technical Administrator
Data Warehouse Administrator

Course Objectives

Manage database instances
Manage UNDO data
Move data between databases
Implement basic backup and recovery procedures
Monitor and tune database performance
Tune SQL to improve performance
Manage resources with Oracle Database Resource Manager
Create pluggable databases (PDBs)
Configure the Oracle network environment
Administer user security and implement auditing
Create and manage tablespaces
Manage storage space
Use Oracle Flashback Technologies to recover from human error
Use Recovery Manager (RMAN) to create backups and perform recovery operations
Use the Data Recovery Advisor to diagnose and repair failures
Plan effective backup and recovery procedures
Describe the Oracle Database architecture components related to backup and recovery operations
Perform an encrypted database backup and restore
Perform tablespace point-in-time recovery
Configure the database for recoverability
Describe Cloud Tooling for Backup and Recovery
Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure

Gallery (32)

Intro Video

+25 more

About the Trainer

4.6 Avg Rating

29 Reviews

90 Students

19 Courses

Skill Sigma

MSc Statistics, Oracle Certified Professional

She is a technocrat with over 14 years of rich experience as a trainer and currently is the competency head at The Skill Enhancers in the Oracle, DBA and BI. She has imparted high quality training in technologies like Oracle, Teradata, MySQL, Informatica, ABinitio and COGNOS.

Areas of Expertise:
Databases (DBA) :
Oracle 8i / 9i / 10g / 11g/ 12c: SQL, PLSQL, Administration, Performance Tuning, SQL Statement Tuning, New Features, Streams, ASM, Dataguard, Real Application Clusters
Teradata Versions 11/12/13: Basics, SQL, Architecture, BTEQ & Utilities, SQL Statement Tuning
My SQL: Development and Administration
ETL: Oracle 11g : Warehouse Builder (OWB), Informatica 9 / 8.x , COGNOS, Ab Initio
Business Intelligence : Cognos 8 , Oracle OBIEE

Professional Experience:
Head Technology at The Skill Enhancers (TSE). In the past, she has worked for Wilshire Software Technologies, Software Technology International Ltd, Software Solution Integrated Ltd. and Compusoft in different technical positions involving Systems analysis, design, development and implementation of application software and training.
More than 500 programs executed for various corporates on the database, data-warehousing, Business Intelligence and Analytics.

Education:
MSc in Mathematics from Osmania University
Diploma in Citation in Application Programming.
Corporate Training conducted
Associated with more than 150 corporates, some note-worthy clients are Accenture India, Capgemini, CA, CISCO Systems, Deloitte Consulting, JDA, Oracle India, Oracle University, Wipro Technologies, Infosys Technologies, Societe Generale, Verizon, SUMTOTAL, GENPACT