Duration : 40 days | 1hr theory /day 1hr Practical

 

Oracle sql /plsql course outline

Introduction to Oracle

I . Database management system
Single row functions

Date functions

Numeric functions

Character functions

 

Group functions

Sum ,average,max,min,count

Group by clause

Having clause

Order by clause

Rollup

Cube

Grouping sets

 

Other functions

To-char

Nvl,nvl2,nullif,coalesce

Decode

Case expression

 

Conditions and operators

 

Like condition,null condition,in condition,not condition

 

Between condition, exists, not exists

Addition,

subtraction,

multiplication,

division

 

Ii. Relational database management system

set operators

 

Union
Union all
Minus


Intersect

 

joins

 

Equi-join
Non-equi-join
Self-join
Left-outer-join
Right-outer-join
Full-outer-join
Natural join
Using clause
On clause


Where clause

Constraints

 

primary key
unique key
reference key or foreign key
check constraint
not null

Sub quaries

 

Single row subquaries
Multiple row subquaries
Co-related sub quaries
In-line view

Hierarchical retrival

 

top down
bottom up
prunning

 

Object relational database management system

 views

Synonyms

Sequences

Indexes

Oracle pl/sql

introduction

Architecture of pl/sql
Programming language
Linear
Sequential
Iteratives

 

data types and intaraction with database

Single and composite type
type
rowtype


Pl/sql  variables

Cursers

Explicit cursors

notfound
found
isopen


rowcount

Implicit cursors

Sql not found
Sql found
Sql is open
Sql row count

 

Cursors in for loop

Exceptions

Pre-defined exceptions

User -defined exceptions

Procedures

In-parameter
Out-parameter
Cursors in procedures
Procedure in procedure

 

Functions

private functions

public functions

Packages

package specification

Package body

Triggers

Statement level

Row level

Triggers in procedures

Instead of trigger

Large objects

Clob(character large object)

Blob(binary large object)

Long

 

 


Contact US


A : :PHILLOS,

#257, (BIIT Building),9th A Main, Near Upahaara Darshini,

 3rd Block, Jayanagar, Bangalore - 560011

 

E : : nishu.phillos@gmail.

 

Ph : : 984488 5059 / 96208 90035 / 903588 5059

 

Whatsapp : 984488 5059 / 96208 90035

 

Facebook | Linked in | Google + | Google Web


 



ANIMATION & MULTIMEDIA

 

Adobe photoshop Course


 

Adobe illustrator Course



Corel draw Course



Graphic designing Course



Infographics



DTP Course



Web designing Course



Video editing Course



Audio editing Course



2D Animation Course



3D Animation Course



 



BUSINESS ANALYTICS & REPORTING TOOLS



 

Microsoft Advanced Excel Course


 

VBA & Macros Course


 

Microsoft Access Course


 

SAS Base & Advanced Course



Clinical sas Course



Statistical SAS Course



MSBI SSIS SSRS SSAS Course



Tableau Course



Business Analytics


 

 



SAP ERP Course



 

 

SAP fico Course


 

SAP ABAP Course


 

SAP WM Course



SAP PP Course



SAP SD Course



SAP MM Course



SAP HANA Course



SAP BI BO Course


 

 



.net Course



java / J2EE Course



Android Course



Oracle Sql & Plsql Course



Sql Server Course



PHP and MYSQL Course



Sql Course



Vmware Course



Tally ERP Course



Basic Excel


 

 



Why Phillos.....?


 

In Depth technical Knowledge

 

Live Project guidence

 

Real Time Working Environment

 

100% Placement Support

 

One On One Sessions availablity

 

Fast track & Super fast track classes

 



 

 

 

 

Related course

 

Related Links