Oracle 11g/12c

Overview

DB Concepts - SQL Concepts - Table Creation Inserting Records Null Values - Fetch Data Ordering Data - DML Commands and DDL Commands - DCL Commands and TCL Commands - Operators - Data Integrity Constraints Key & Domain Constraints - User Friendly Names for Constraints - Referential Integrity Constraints - Set Operators - Cross Join and Equi join - Equi Join and Inner Join - Self Join - Outer Join - Sub Queries Single and Multi Row - Sub Queries Correlated Sub Queries - Oracle Views - Types of Views - Indexes - Sequences and Synonyms - PL SQL Introduction - PL SQL Anonymous Blocks - Stored Procedures - PLSQL Functions - Procedures and Functions - Type Compatibility Keywords % Type and % RowType - PL SQL Conditional Statements - PL SQL LOOPS - PL SQL Cursors - PL SQL Implicit Cursors - PL SQL Explicit Cursors - PL SQL Exceptions - PL SQL Triggers - PL SQL Packages