"Aim to help our customers achieve the end result they need in whatever is the most effective way for them. "

- Anonymous

PL/SQL Programming

Quick Stats

Combination of Structured Query Language and procedural programming languages developed by Oracle Corporation.
Identify issues in a PL/SQL script , rectify and optimize the script.
Handle un-expected outcome/abnormalities in your script using the various exception handlers.

Benefits

developed by Oracle Corporation.
Be trained on programming aspect of Oracle Database using PL/SQL.
Retrieve information from a database.
Know how to use the programming interface and retrieve information from a database.
Rectify and optimize the script
Identify issues in a PL/SQL script , rectify and optimize the script

Who Should Attend

  • Aspiring DB Programmers
  • BSc - IT Graduates
  • BCA/MCA/MBA (IT) Graduates
  • PGDBA (IT) Diploma Graduates
  • Aspirants looking to kick-start PL/SQL or Database Programming

Course Outcome

  • Learn the different structures of a PL/SQL script.
  • Learn to write your first PL/SQL script and retrieve database information.
  • You can write PL/SQL script and manipulate with multiple records using the help of database CURSORS.
  • Handle un-expected outcome/abnormalities in your script using the various exception handlers.

Curriculum

  • PL/SQL Programming
    • PL/SQL Program Structure
    • Querying in PL/SQL Programs
    • Using CURSORs in PL/SQL
    • Exception Processing in PL/SQL
    • Subprograms in PL/SQL
    • PL/SQL Optimization

 

Website Designed by © 2012 SMIIT. All Rights Reserved