Oracle PL/SQL Training | PL/SQL Online Training | PL SQL Tutorials | SRY IT - PowerPoint PPT Presentation
1 / 12
Title:
Oracle PL/SQL Training | PL/SQL Online Training | PL SQL Tutorials | SRY IT
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. For More details Contact us at: Phone: USA: +1-319-804-4998 India: +91-9948030675 (Available 24/7) Email id: info@sryitsolutions.com Website: – PowerPoint PPT presentation
Number of Views:1203
Title: Oracle PL/SQL Training | PL/SQL Online Training | PL SQL Tutorials | SRY IT
1
ORACLE PL SQLONLINE TRAINING
- www.sryitsolutions.com
- USA 1-319-804-4998 INDIA 91-9948030675
- Email id info_at_sryitsolutions.com
2
Basics of PL/SQL
- PL/SQL architecture
- PL/SQL and SQLPlus
- PL/SQL Basics, Variables, Constants, data types
error handling - PL/SQL wrapper utility
3
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
4
Error Checking / Exception Handling
- Defining exceptions
- Using the when others clause
- Ensuring complete error checking
- Passing error messages to calling routine
5
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
6
Cursors in PL/SQL
- Cursor basics
- Using a cursor for a multi-row SQL query
7
PL/SQL Tables
- Defining PL/SQL tables
- Reasons to use PL/SQL tables
- Populating a PL/SQL table
- Retrieving from a PL/SQL table
8
Triggers in PL/SQL
- Triggers and database events
- Defining a trigger
- Timing a trigger
- Enabling and disabling a trigger
9
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
10
Bulking in PL/SQL
- Bulk queries
- Bulk DML (for all statement)
- Using cursor attributes
- Analyzing impact of bulk operations
11
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.
12
Contact us for more details and Session Schedules
at USA 1-319-804-4998 INDIA
91-9948030675 Email info_at_sryitsolutions.com Web
www.sryitsolutions.com
