Learn most advanced & updated content from industry experts having 15+ years of experience.
96 Hrs. of Instructor led online classroom with 3 real time Industry based projects
Course aligned with the official Oracle Certification Guide
Prepares to clear 1Z0 -071 Exam for Developer track & OCP 1Z0-082 exam Admin Track
Hands on practice on Oracle platform and 100+ sample programs Practical Hands-on Workshops
Lifetime access to Oracle Community forum and e-learning content and pdf materials
Course completion certificate.  Resume Preparation and mock Interviews
++++++++ SQL +++++++++++
Introduction to Database
Relational Database Concepts
Data Model
Normalization
Introduction to Oracle Database
Basic Elements of Oracle SQL, Oracle Built-in Datatypes
Types of SQL
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Hierarchical Queries
Using the Set Operators
Advance Analytical Functions
Manipulating Data
Using DDL Statements to Create and Manage Tables
Managing Schema Objects
Table Partitions
Creating Other Schema Objects
Other Schema Objects
Control User Access
Management of Schema Objects with Data Dictionary Views
Regular Expression Support - REGEXP
Â
++++++++++++ PLSQL ++++++
Mastering ORACLE 12c PL SQL for Development
Overview of PL/SQL
PL/SQL Programming Language Fundamentals
PL/SQL Datatypes
PL/SQL Control Structures and Loops
Error Handling & Built-in Expressions
User Defined ExceptionsÂ
Design Considerations For PL/SQL Code
Introduction CursorÂ
Advance Cursor
Triggers Â
Working with Compound, DDL and Event Database Triggers
Collections
Records
Using Static SQL
Dynamic SQL
PL/SQL Bulk Operation and Exception handling
Procedures
Functions
Packages
Tuning PL/SQL Applications for Performance
Using Oracle Supplied Packages in Application Development
Wrapping PL/SQL Source Code
+++++++++++++ Performance tuning +++++++++++
What is causing modern day performance issues?
How to overcome modern day performance issues?
Performance Gains by SQL Tuning (Behind Indexes)
Types of Indexes.
Understanding Structures of B-TREE, BITMAP Indexes
Function based Indexes (FBI), Foreign Key Indexes (FKI)
VISIBLE and INVISIBLE Indexes.Â
Monitoring and Managing Unused Indexes.
Optimizer Fundamentals
Displaying PLAN_TABLE: AUTOTRACE, TRACEONLY, STATISTICS
Optimizer : Table and Index Access Paths
Understanding Explain Plan
Joins, Loops
Writing Optimized SQL
Effective indexing, Single Column Indexes , Composite Indexes
How to Measure Index SELECTIVITY
Gather Stats , Introduction to Histograms
Table Partition , Index Partition, LOCAL and GLOBAL Indexes
Partition Pruning
Introduction to IOT tables
Use of Optimizer HITS, PARALLEL, INDEX, ALL_ROWS, FIRST_ROWS
Issues with Delete, Resetting High Water Mark
Using Bind Variables
Issues with Skew data
Tracing SQL Executions
Oracle dictionary tables for Indexes Monitoring, DBA_INDEXES, DBA_IND_COLUMNS
Concept of RESULT_CACHE and Usage
Curriculum for ADMINâ??s
Performance Gains by Instance Tuning/Database configuration (Behand Indexes)
Introduction to Oracle Memory Management and caches
Understanding SGA/PGA/ Shared Pool, KEEP pool, Recycle pools.
Fixed allocation memory allocation v/s automatic Memory Management (AMM)
Tuning the Shared Pool
Tuning the Buffer Cache
Impact of REDO LOGS Switch, Archive, NO Archive databases
Understanding diagnostic reports such as AWR, ADDM and ASH reports
Working in RAC Database. Importance of sequence caching
Reverse Key Indexes, Use of HASH Partitioned Indexes.
About SQL Tuning Sets (STS)
Concept of cursor sharing attributes, Adaptive Cursor Sharing
View this Course
Certified
You have 
