Oracle PL/SQL Training | PL/SQL Online Training | PL SQL Tutorials | SRY IT - PowerPoint PPT Presentation

Loading...

PPT – Oracle PL/SQL Training | PL/SQL Online Training | PL SQL Tutorials | SRY IT PowerPoint presentation | free to view - id: 5f047b-Zjk3O



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
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:884

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

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
About PowerShow.com