ORACLE PLSQL

ORACLE PLSQL Training in Kukatpally Hyderabad

Algorithm training institute for ORACLE SQL PLSQL training institutes in Hyderabad5

Oracle Training Course Objectives

  • Create Database tables.
  • Manage Database objects.
  • Access and manipulate data in the Database using SQL statements.
  • Control user access to data.
  • Data Managing
  • Working with Databases

Oracle Training Course Duration

  •  45hrs

Trainer Details:

Trainer Name          : Mrs Kalyani
Qualification            : B.Tech(CSE)
Experience              : Software professional with 5 yrs experience in Dot Net/C#/ASP/MVC//JAVA/SQL/PL SQL/SQL SERVER/MYSQL

Oracle SQL PLSQL Training Content

Download course content here ORACLE-19c-SQL-PLSQL-MY-SQL-Algorithm.pdf (413 downloads )

                                PLSQL

SNO TOPIC Sub topic Lab
1 introduction Variables

constants

Data types
2 Control Statements if-elseif-else

case

while

for
3 Procedures Procedures

Functions

 
4 Cursor implicit cursor

explicit cursor
5 Exception select all colums

select few columns

select with where clause

select with having clause

select unique

select distinct

select count

select rownum

 
6 Triggers where clause

AND clause

OR clause

 

 

 

 

1. Introduction & Advantages.
2. Data types.
3. Variables & Blocks.
4. Control structures.
5. Loops.
6. CURSOR.
7. Collections.
8. Records
9. Exception handling.
10. Functions.
11. Procedures/stored procedures.
12. Triggers.
13. Packages.
14. Performance improvement techniques with BULK COLLECT & FOR ALL
15. Dynamic SQL.