ORACLE SQL&PL/SQL PROGRAMMING TRAINING INSTITUTE IN BLR

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

Call me at:-9738001024