Oracle University Sertificētais mācību centrs Latvijā Baltijas Datoru Akadēmija priecājas paziņot par virtuālās klases semināru "Oracle PL/SQL Expertise On-Line: In-depth training", kuru pasniedz Steven Feuerstein

Katra mācību sesija dos Jums iespēju iegūt dziļāku ieskatu PL/SQL Šīs augsti tehnologiskās mācību sesijas nosegs sekojošas tēmas:

• 2010.gada 23. februārī 15:00 - 17:30 - 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 should have a deep familiarity with collections and the wide range of features that Oracle has implemented for them over the years.
  
  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 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.
  
  
• 2010.gada 24. februārī 15:00 - 17:30 - Say Goodbye to Hard-Coding in PL/SQL:
  
  Everyone knows that hard-coding is a bad idea. Too many developers, however, only think in terms of literal values when they think of hard-coding. There are, unfortunately, many ways that hard-coding manifests itself in our programs.
  
  This webinar offers a comprehensive look at all the types of hard-coding that can appear in your programs, from literals to explicit declarations to exposed formulas, and offers specific techniques to get rid of the hard-coding. The result is code that is much easier to read and to maintain.
  
  After attending this webinar, you will be able to more easily and quickly identify hard-codings, and apply well-understood and safe transformations to remove those hard-codings.
  
  
• 2010.gada 25. februārī 15:00 - 17:30 - 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: how to use EXECUTE IMMEDIATE to execute dynamic query, DML, and DDL statements. We will also go beyond the basics and delve into 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.
  
  

Cena 1 cilvēkam 256Ls + PVN

Lai reģistrētos, rakstiet uz mara@bda.lv vai zvaniet 67505493