EXPERT PL/SQL PRACTICES Online Training

Introduction

PL/SQL (Procedural Language extensions to SQL) is designed explicitly for the easy handling of SQL statements. PL/SQL program products run within the Oracle executable gathered and are located in the database and get the robustness, safety, and convenience of the Oracle Database. In a network environment, this can affect traffic circulation and, in a time, Oracle should approach SQL statements one without PL/SQL and decrease response time. PL/SQL blocks kept in executable form to boost response time and may be collected once.

COURSE SUMMARY

Course NameEXPERT PLSQL PRACTICES Online Training
ContentsIntroduction to PL/SQL, Dynamic SQL, Testing, Error Handling etc.
Duration30 Hours with Flexible timings
DeliveryInstructor Led-Live Online Training
EligibilityAny Graduate
Ideal ForFreshers, aspirants seeking to learn the EXPERT PLSQL PRACTICES
Next BatchPlease visit the schedule section

Course Objectives

  • Learn how and when to use PL/SQL better.
  • How to use bulk SQL operations to move data effectively
  • Write code that balances through parallelism, pipelining, and profiling
  • How to select the precise PL/SQL cursor form for an application
  • How to execute unit testing to lessen coding errors

Course Curriculum

MODULE 1: INTRODUCTION

  • Nested Row-by-Row Processing
  • Row-by-Row Processing
  • Excessive Access to DUAL
  • Lookup Queries
  • Access to Sequences
  • Arithmetics with Date
  • Excessive Function Calls
  • Populating Master-Detail Rows
  • Costly Function Calls
  • Unnecessary Function Execution
  • Database Link Calls
  • Excessive Commits
  • Excessive Use of Triggers
  • Excessive Parsing

MODULE 2: DYNAMIC SQL: HANDLING THE UNKNOWN

  • Native Dynamic SQL
  • DBMS_SQL
  • Dynamic Cursors
  • Sample of Dynamic Thinking
  • Anti-Patterns
  • Security Issues
  • Object Dependencies
  • Positive Effects
  • Negative Effects

MODULE 3: WARNINGS AND CONDITIONAL COMPILATION

  • PL/SQL Warnings
  • Compilation and Warnings
  • Ignoring Warnings
  • Conditional Compilation
  • Preprocessing Code Benefits
  • Invalidations
  • Inquiry Variables

MODULE 4: PL/SQL UNIT TESTING

  • Unit Testing?98
  • Debugging or Testing
  • Tools for Unit Test
  • utPLSQL
  • Oracle SQL Developer
  • Unit Test Repository
  • Importing Tests
  • Specifying Parameters
  • Saving Tests
  • Debugging and Running Tests
  • Broadening the Scope of the Tests
  • Dynamic Query
  • Running Reports
  • Building Suites

MODULE 5: ERROR HANDLING

  • Coding conventions
  • Case
  • Indentation
  • Packages
  • Stored Procedures
  • Naming
  • Parameters
  • Constants
  • Global Variables
  • Procedure Metadata
  • Error Handling
  • Error Reporting
Download Material

Write Review

Quite good

★★★☆☆
3 5 1
Quite good. Much more interactive than I expected. In my opinion attending the webinars is a must.

Good class content

★★★★★
5 5 1
This series covers all major areas of program management and provides a good high level overview as well as tactical awareness. Good transition as well from project to program management learning. The website interaction is good and slides are available for download. Interesting how much more there is to managing programs! The online interface helps track where you are in the total process and creates good awareness. The slides are done really well and enables good transitions if you need to refer back to earlier series

Regarding thisCOURSE

★★★★★
5 5 1
I took course from IQ ONLINE TRAININGS. As a training center I think IQ ONLINE TRAININGS is a great place to study. Sefa Khyer

Very happy with abinito training course

★★★★★
5 5 1
Excellent Abinitio training with lots of practical aspect covered. The instructor was excellent in explaining things in details in simplest form.

Good

★★☆☆☆
2 5 1
Very Helpful

More reviews...

Summary
Review Date
Reviewed Item
EXPERT PL/SQL PRACTICES Online Training - Excellent
Author Rating
5
Please follow and like us:

Testimonials

Write a Review

No review posted.