ORACLE SQL,PL/SQL TRAINING @ INFOCAMPUS

Introduction

SQL :

1.Retrieving Data Using SQL SELECT Statement
2.Restricting and Sorting Data
3.Using Single Row Functions to Customize Output
4.Reporting Aggregated Data Using Group Functions
5.Displaying Data from Multiple Tables
6.Using Subqueries to solve Queries
7.Using SET Operators
8.Manipulating Data
9.Using DDL Statements to Create and Manage Tables.
10.Creating Other Schema Objects
11.Managing Objects with Data Dictionary Views.

PL/SQL and Advanced PL/SQL :

1.Introduction to PL/SQL
2.Declaring PL/SQL Variables
3.Writing Executable Statements
4.Interacting with Oracle Server
5.Writing Control Structures
6.Working with Composite Data Types
7.Using Explicit Cursors
8.Handling Exceptions
9.Creating Stored Procedures and Functions
10.Packages
11.Database Triggers
11.Ref Cursors
12.Dynamic SQL
13.Collections
14.BUlk Collect and forall
15.Ananytical functions