•Introduction to SQL •Managing Tables using DML statements using TC Commands •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 Sub queries to Solve Queries •Using the SET Operators •Creating Sequences, Synonyms, Indexes & Views •Controlling User Access •Generating Reports by Grouping Related Data •Hierarchical Retrieval •SQL 12c New Features •Introduction to PL/SQL •Declaring PL/SQL Variables •Writing Executable Statements •Using SQL Statements within a PL/SQL Block •Writing Control Structures •Using Explicit Cursors •Handling Exceptions •Creating Stored Procedures and Functions. •Creating Triggers and Packages