Oracle PL/SQL Training | PL/SQL Online Training | SRY IT

Views:
 
Category: Education
     
 

Presentation Description

SRY IT Solutions provides Online ORACLE PL SQL Training. Our trainer for Oracle PL SQL carries a lot of experience and he has been into IT Online Coaching since 8 years.We will provide you the best resources which will enhance your knowledge in the particular technologies. SRY IT will provide you a customized training course material for Oracle Procedural Language/Structured Query Language. FEATURES: Course Duration: 60 Hours Access: With 2 months server access Trainer Details: 8+ Years Real Time Consultant Training: We train people ONLINE/OFFLINE on Oracle PL/SQL and Oracle Apps Technical, Functional Modules. Prerequisites: Any Bachelor Degree student can learn this course. Material: Soft Copy of Training Course Materials, Session Video Recordings will be provided. After Training: Resume preparation, Interview Questions Career Support will be provided. Support: we will give direct access to our server to each trainee with individual login 24×7 support. Offered Other Modules: SAP: SAP BPC, BASIS, ABAP, BO, ADMIN, FICO, MDM, CRM, HANA, FSCM, IS UTILITIES, BO DATA SERVICES, APO…. etc. Data Warehouse: AB INITIO, AJAX, INFORMATICA, DATA STAGE, HADOOP, WEBSPHERE Oracle & Hyperion: ESSBASE, PLANING, DQM, FM….and more For More details Contact us at: Phone: USA: +1-319-804-4998 India: +91-9948030675 (Available 24/7) Email id: info@sryitsolutions.com Website: http://www.sryitsolutions.com/oracle-pl-sql-online-training-in-hyderabad

Comments

Presentation Transcript

ORACLE PL SQL ONLINE TRAINING :

www.sryitsolutions.com ORACLE PL SQL ONLINE TRAINING www.sryitsolutions.com USA: +1-319-804-4998 INDIA: +91-9948030675 Email id: info@sryitsolutions.com

Basics of PL/SQL :

Basics of PL/SQL  PL/SQL architecture PL/SQL and SQL*Plus PL/SQL Basics, Variables, Constants, data types & error handling PL/SQL wrapper utility www.sryitsolutions.com

PL/SQL Structures :

PL/SQL Structures Simple blocks Control structures PL/SQL records Recognizing the Basic PL/SQL Block and Its Sections Describing the Significance of Variables in PL/SQL Distinguishing Between PL/SQL and Non-PL/SQL Variables Declaring Variables and Constants www.sryitsolutions.com

Error Checking / Exception Handling :

Error Checking / Exception Handling Defining exceptions Using the when others clause Ensuring complete error checking Passing error messages to calling routine www.sryitsolutions.com

Boolean Logic in PL/SQL :

Boolean Logic in PL/SQL Identifying the Uses and Types of Control Structures Constructing an IF Statement Constructing and Identifying Different Loop Statements Controlling Block Flow Using Nested Loops and Labels Using Logic Tables If-then-else structure Testing for numbers characters and Booleans www.sryitsolutions.com

Cursors in PL/SQL :

Cursors in PL/SQL Cursor basics Using a cursor for a multi-row SQL query www.sryitsolutions.com

PL/SQL Tables :

PL/SQL Tables Defining PL/SQL tables Reasons to use PL/SQL tables Populating a PL/SQL table Retrieving from a PL/SQL table www.sryitsolutions.com

Triggers in PL/SQL :

Triggers in PL/SQL Triggers and database events Defining a trigger Timing a trigger Enabling and disabling a trigger www.sryitsolutions.com

Stored Procedures, Functions and Packages :

Stored Procedures, Functions and Packages Basics of stored procedures Basics of functions Basics of packages Defining stored procedures & functions Function and stored procedures prototypes Passing arguments to functions and stored procedures Recompiling functions and stored procedures www.sryitsolutions.com

Bulking in PL/SQL :

Bulking in PL/SQL Bulk queries Bulk DML (for all statement) Using cursor attributes Analyzing impact of bulk operations www.sryitsolutions.com

Offered Other Modules :

Offered Other Modules SAP: SAP BPC, BASIS, ABAP, BO, ADMIN, FICO, MDM, CRM, HANA, FSCM, IS UTILITIESBO DATA SERVICES, APO…. etc DWH: AB INITIO TRAINING, AJAX , INFORMATICA, DATA STAGE , HANDOOP , WEBSPHERE. www.sryitsolutions.com

PowerPoint Presentation:

Contact us for more details and Session Schedules at USA: +1-319-804-4998 INDIA: +91-9948030675 Email : info@sryitsolutions.com Web : www.sryitsolutions.com www.sryitsolutions.com

authorStream Live Help