Oracle

Master Program1034 Ratings
  • Live interaction with Industry leadershipIncludes live Master Classes and Ask me anything sessions
  • 100+ hours of live interactive learningLive Online classes by industry experts
  • With real time projectsBuilt on datasets of various scenarios & real time problems
  • ITlearn360 JobAssistGet noticed by the top hiring companies

Learning Path

  • Course 1

    Oracle Database Admin Training

    Course curriculum

    Module 1: Oracle Database 12c Architecture

    • 1.1  Overview of Oracle 12c and Architecture
    • 1.2   Instance Configurations
    • 1.3   Connecting to the Oracle Database Instance
    • 1.4   Memory Structures and Process Architecture
    • 1.5   Storage Architecture
    • 1.6   Pluggable Databases and Container Databases
    • 1.7   Oracle Database 11g vs 12c

    Module 2: Software Installation & Database Creation

    • 2.1  Planning for Installation
    • 2.2   Hardware and OS Prerequisites
    • 2.3   Database Creation
    • 2.4   Oracle Services Overview

    Module 3: Multitenant Database Administration

    • 3.1  About and Purpose of Multitenant
    • 3.2   Creating a Pluggable Database(PDB) from the seed PDB
    • 3.3   Connect to a Container Database(CDB) and to a PDB
    • 3.4   Managing CDBs and PDBs
    • 3.5   Startup/shutdown a CDB and Open/Close PDBs
    • 3.6   Pluggable Database Storage Management
    • 3.7   Pluggable Database Memory Management
    • 3.8   Work on 12c Dictionary Views
    • 3.9   Securities on Pluggable Databases
    • 3.10   Guidelines for Managing Tablespaces

    Module 4: Creating Tablespaces

    • 4.1  Creating Tablespaces
    • 4.2   Specifying Nonstandard Block Sizes for Tablespaces
    • 4.3   Controlling the Writing of Redo Records
    • 4.4   Altering Tablespace Availability
    • 4.5   Using Read-Only Tablespaces
    • 4.6   Renaming Tablespaces
    • 4.7   Dropping Tablespaces
    • 4.8   Managing the SYSAUX Tablespace
    • 4.9   Diagnosing and Repairing Locally Managed Tablespace Problems
    • 4.10   Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
    • 4.11   Transporting Tablespaces Between Databases
    • 4.12   Viewing Tablespace Information

    Module 5: Converting and Cloning Multitenant Database

    • 5.1  Convert a Non-CDB to a PDB
    • 5.2   Unplugging and Plugging Multitenant Databases
    • 5.3   Remote cloning of Non-CDB
    • 5.4   Cloning Pluggable Databases
    • 5.5   PDB Snapshot Clone
    • 5.6   Cloning Alternatives

    Module 6: Backup & Recovery in Multitenant Databases

    • 6.1  Backup and Recovery Concept
    • 6.2   Recovery Manager (REMAN) for Backuping
    • 6.3   Handling Redo Log Failures
    • 6.4   Recovery Use Cases
    • 6.5   Point In Time Recovery

    Module 7: Database Upgrade

    • 7.1  Upgrade Methodology
    • 7.2   Routine Patching: OPatch
    • 7.3   Ensuring Plan Stability Post Upgrade
    • 7.4   Testing the Upgrade
    • 7.5   Introduction to EM Express to Manage 12c Databases

    Module 8: Tuning Performance

    • 8.1  Indexing Concept to Boost Select Performance
    • 8.2   Understanding SQL Server Database Statistics and Profiler
    • 8.3   Using Views to Improve Performance
  • Course 2

    Oracle PL/SQL Fundamentals

    Course curriculum

    Module 1: Introduction to Oracle Database and PL/SQL

    • 1.1  Understanding PL/SQL and its Blocks
    • 1.2   Working with SQL Plus
    • 1.3   DECLARE Clause Objects

    Module 2: PL/SQL Data Types

    • 2.1  Declaring simple data types and assignments
    • 2.2   Declaring complex data types and assignments
    • 2.3   Declaring complex row types and assignments
    • 2.4   Declaring complex tables
    • 2.5   Declaring complex records
    • 2.6   Creating and declaring user-defined types
    • 2.7   What can be included in the BEGIN clause
    • 2.8   Working with CHAR and VARCHAR2 variables
    • 2.9   Handling string literals
    • 2.10   Working with numeric variables
    • 2.11   Working with date variables
    • 2.12   Assigning and using boolean variables

    Module 3: Using Operators and Functions

    • 3.1  Using comparison operators
    • 3.2   Using SQL functions
    • 3.3   SQL DML within PL/SQL
    • 3.4   Using SELECT

    Module 4: Using Sequences

    Module 5: Using Logic Control, Branching and Sub Programs

    • 5.1  Using GOTO
    • 5.2   Working with LOOPS
    • 5.3   Creating and using the indefinite loop
    • 5.4   Creating and using the conditional loop
    • 5.5   Using nested loops
    • 5.6   Using the If-Then-Else
    • 5.7   Using the CASE statement
    • 5.8   Using the continue statement
    • 5.9   Understanding nested blocks
    • 5.10   Subprograms: how they differ from nested blocks

    Module 6: Error Handling Through Exceptions and Embedded SQL

    • 6.1  Trapping exceptions Identify exception details
    • 6.2   SQLCODE & SQLERRM Example
    • 6.3   Creating user-defined exceptions
    • 6.4  Handling compilation errors

    Module 7: Understand and Use Pl/SQL Cursor

    • 7.1  Understand the implicit cursor
    • 7.2   Understanding explicit cursors
    • 7.3   FOR…LOOP cursors
    • 7.4   Working with updateable cursors
    • 7.5   Learn about cursor attributes
    • 7.6   Creating and using cursor parameters
    • 7.7   Weak cursor definitions
    • 7.8   REFCURSOR cursor definition
    • 7.9   Using cursor expression

    Module 8: Using Read and Write Packages

    • 8.1  Using the DBMS OUTPUT() package
    • 8.2   Using the UTL FILE() package

    Module 9: Understand and Apply Database Trigger

    • 9.1  Statement-Level Triggers
    • 9.2   Row-Level Triggers
    • 9.3   Using INSTEAD OF Trigger
    • 9.4   Using the CALL Statement
    • 9.5   Maintaining Trigger
    • 9.6   Setting Multiple Triggers for a Single Table
    • 9.7   Handling Mutating Table Issues
    • 9.8   Using the Compound Trigger
    • 9.9   Using System Event Trigger