Oracle PL SQL |100% real time online training , job support from usa | - New York, NY

Saturday, 5 October 2019

Item details

City: New York
Salary: $250

Contacts

Contact name sri raja
Phone 8500122107

Item description

FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: httpsbest-online-it-training-institute.blogspot.com



Oracle PL SQL Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


ORACLE PL SQL COURSE CURRICULUM
the course content can be modified as per your requirements):



Introduction to PL/SQL



Advantages of PL/SQL

PL/SQL architecture

Datatypes in PL/SQL

PL/SQL program structure

Simple PL/SQL programs

Embedding SQL statements in PL/SQL

Conditional statements

Loops

Cursors :



About cursors in PL/SQL

Explicit cursors

For loop cursor

Cursor paramenters

For update clause

Where current of clause

Ref cursors

Implicit cursors

Exception Handling :

System defined exceptions

User defined exceptions

Sqlcode & sqlerrm

Pragma exception_init

Subprograms :



Introduction to subprograms

Difference between anonymous & named blocks

Stored procedures :-

Creatng procedures

Working with IN , OUT , INOUT parameters

Procedures with cursors

Procedures returning records

Pragma autotnomous transaction

Functions :

Difference b/w procedures and functions

Inline functions

Packages :



Introduction to packages

Package specification and package body

Overloading package members

Triggers :



Introduction to triggers

DML triggers

DDL triggers

Db auditing using triggers

DB level triggers

Collections in PL/SQL

Built-in packages in PL/SQL

Oracle 10g features

Oracle 11g features

DBA concepts

Copyright © 2018 Apex Online IT Trainings Inc. All Rights Reserved



Call us on : USA - +1 214 628 3894 | IND - +91 8500122107

for your course please follow the link : httpswww.apex-online-it-trainings.com/it-trainings-at-apex/oracle-plsql-online-training