+91 937 791 6611 inquiry@iantindia.com

IANT The First & only Platinum partner In India.Is the No.1 Hardware & Networking institute Award Winner in India.

CompTIA | Miscrosoft | Red Hat | EC-Council | Oracle | Cloud Computing | Android


REQUEST A CALL BACK

Please fill all the texts in the fields.


Our Courses

Oracle 11g DBA - OCP


Oracle Database 12c: Introduction to SQL Ed 1.1

Audience


  • Data Warehouse Administrator
  • Developer
  • Application Developers
  • PL/SQL Developer
  • Forms Developer
  • System Analysts
  • Business Analysts

Required Prerequisites


  • Familiarity with data processing concepts and techniques, Data processing

Course Topics:


  • 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

Oracle Database 11g: Administration Workshop I Release 2

Course Topics:


  • 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

Audience


  • Database Administrators
  • Technical Administrator
  • Support Engineer
  • Technical Consultant
  • Java Developers

Oracle Database 11g: Administration Workshop II Release 2

Course Topics:


  • 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

Audience


  • Database Administrators
  • Technical Administrator
  • Support Engineer
  • Technical Consultant