Programming with PL-SQL

Programming PL-SQL for Management of Oracle Databases

  • The expertise gained from this course will enable a rapid and competitive career growth path and advancement in software programming.

  • This course is designed to gain hands-on expertise in core fundamentals of Programming in PL-SQL and prepares for building real world applications from day one. We also prepare you for Oracle 11g SQL Certification exam as part of the course.

Batch Duration Start Date Timings
Batch 1 4 weeks
60 hrs
Febraury 23rd, 2015 Mon to Fri
2:00pm-5:00pm

What participants will learn

With a heavy focus on hands-on excercises, the following topics are covered:
  • Creating Programs for Database Management
  • Exception Handling
  • Create Triggers
  • Managing Dependencies
  • Oracle 11g: SQL certification exam preparation

Intended Audience

  • Professionals who want to build a quick grasp of database concepts on Oracle.
  • Students and recent Graduates who want to get a head-start in pursuing a career in software programming

Course Pre-requisites

  • The participants should have basic computer fundamental knowledge.
  • The participants should have completed the Oracle-SQL course

Course Details

  • PL-SQL Architecture
  • Variables in PL-SQL
  • Variable Types
  • PL-SQL using Control Structures
  • Using SQL within PL-SQL
  • Composite Type Variables
  • PL-SQL Tables
  • Nested Tables
  • V-Array
  • Data Manipulation Using Cursors in PL-SQL
  • Exception Handling in PL-SQL
  • Modular Programming through Sub-programmed blocks
  • Working with Procedures
  • Working with User Defined Functions
  • Working with Packages
  • Types Used in Packages
Advanced Topics
  • Dynamic SQL
  • Ref Cursors and SYS Ref Cursors
  • Bulk Binds
  • Working with Triggers
  • Oracle supplied packages such as UTL file, htp, utl_mail Packages
  • SQL Loader
  • Performance and Tuning
  • Object Oriented Concepts in Oracle

Venue Details

Location 1
Corporate Software Park,
Ashoka Plaza Tower B,
Next to Hotel Hyatt Regency,
Viman Nagar,
Pune-411014. Click here for Map
Location 2
La-Gloriosa Bldg,
Near Arnold's High School,
Kalyani Nagar,
Pune-411014. Click here for Map

Fees

Call for Pricing Info.
Subject to availability of seats. Registration is first come first serve basis.


Register Today»