Oracle PL/SQL Expertise On-Line with Steven Feuerstein

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: PL/SQL and Oracle.

Description

Oracle University is proud to present our online Celebrity Seminar series. This is a unique opportunity to attend an online Seminar with one of Oracle's most experienced PL/SQL experts. The event will consist of three, consecutive, in-depth, 2.5-hour sessions. (total duration: 7.5 hours). Join us for this innovative and informative virtual series of Celebrity Seminars from the comfort of your office. Each training session will give you the opportunity to gain in-depth insight into PL/SQL.

These highly instructive sessions will cover the following topics:

  • Day 1: 2:00PM – 4:30PM CET - Programming with Collections:
  • Collections (array-like structures in PL/SQL) are critical data structures t…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: PL/SQL, Oracle, Microsoft SQL Server, SQL & MySQL, and Oracle 11G.

Oracle University is proud to present our online Celebrity Seminar series. This is a unique opportunity to attend an online Seminar with one of Oracle's most experienced PL/SQL experts. The event will consist of three, consecutive, in-depth, 2.5-hour sessions. (total duration: 7.5 hours). Join us for this innovative and informative virtual series of Celebrity Seminars from the comfort of your office. Each training session will give you the opportunity to gain in-depth insight into PL/SQL.

These highly instructive sessions will cover the following topics:

  • Day 1: 2:00PM – 4:30PM CET - Programming with Collections:
  • Collections (array-like structures in PL/SQL) are critical data structures that are used in some of the most important features of PL/SQL. Every PL/SQL developer will be familiar with collections and the wide range of features that come with them.

    This session introduces collections and quickly moves on to detailed explanations of collection methods, how to leverage string indexing in associative arrays, multi-level collections, set-level operations on nested tables and more.

    After attending this webinar, you will be in a well-positioned to apply collections in your every day development and, most important, take advantage of features like BULK COLLECT and FORALL to improve application performance.

  • Day 2: 2:00PM – 4:30PM CET - Say Goodbye to Hard-Coding in PL/SQL:
  • Everyone knows that hard-coding is a bad idea. Many developers, however, think in terms of literal values when they think of hard-coding but there are many ways that hard-coding can manifest in our programs.

    This webinar offers a comprehensive review of all the types of hard-coding that can appear in your programs, from literals to explicit declarations and exposed formulas, and examines specific techniques to eliminate it. The resulting code is much easier to read and to maintain. After attending this webinar, you will be able to easily and quickly identify hard-coding, and apply techniques to remove hard-coding.

  • Day 3: 2:00PM – 4:30PM CET - Dynamic SQL in Oracle PL/SQL:
  • Dynamic SQL (construction, parsing and execution of SQL statements and PL/SQL blocks at runtime) has become a common and critical element of most modern applications. PL/SQL offers two distinct methods for dynamic SQL: native dynamic SQL (NDS) and DBMS_SQL.

    This webinar focuses primarily on the capabilities of native dynamic SQL in using EXECUTE IMMEDIATE to execute dynamic query, DML, and DDL statements. We also go beyond the basics and explore when to use DBMS_SQL (method 4 dynamic SQL), and new Oracle Database 11g features for dynamic SQL (most importantly, interoperability between DBMS_SQL and NDS).

    After attending this webinar you will be able to quickly identify the type of dynamic SQL challenge you face and from there apply the correct PL/SQL functionality to get the job done.


Audience
Course Topics
Course Objectives
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.