Where IT meets Excellence

Delivering Quality Education Since 12 Years

Contact via email
sales@suninfosystem.net

Call us today!
(0261) 2464788

Toll-free
1800 532 9992

Course Details

Image

Oracle Database Administration

Oracle, one of the biggest technology giants in the world, offers IT products and services which are recognized and revered throughout the world. SIPL provides various prestigious and worthy Oracle Certification courses in India at different metro locations for professionals who wish to climb the corporate ladder. You can register for Oracle Training and opt from a wide range of Oracle Training Courses at Sun Infosystems in India.

SIPL offers one of the most popular Oracle certification courses - Oracle 11g DBA OCA & OCP. Oracle DBA training takes the database administrators beyond the basic tasks covered in the SQL New and Administration Workshop I. Students will gain a deep understanding of the most important responsibilities a DBA has: performing backup and recovery in this DBA course. After completing this Oracle certification course, students will be able to diagnose and repair data failures with Flashback technology and manage space to optimize database storage.

  

Apply for this Course Now

I. Oracle Database: Introduction to SQL

  • Introduction
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Definition Language
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
  • Managing Data in Different Time Zones

II. Oracle Database: Administration Workshop I

  • Exploring the Oracle Database Architecture
  • Installing your Oracle Software
  • Creating an Oracle Database
  • Managing the Oracle Database Instance
  • Manage the ASM Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auditing
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Working with Support

III. Oracle Database: Administration Workshop II

  • Core Concepts and Tools of the Oracle Database
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Settings
  • Creating Backups with RMAN
  • Restore and Recovery Task
  • Using RMAN to Perform Recovery
  • Monitoring and Tuning RMAN
  • Diagnosing the Database
  • Using Flashback Technology I
  • Using Flashback Technology II
  • Performing Flashback Database
  • Managing Memory
  • Managing Database Performance
  • Managing Performance by SQL Tuning
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Managing Space in Blocks
  • Managing Space in Segments
  • Managing Space for the Database
  • Duplicating a Database

Exam

  • 1Z0-053 Oracle Database: Administration II


Post your review