IT / Programming / Oracle / Oracle 19c / PL/SQL 1

Oracle 19c - PL/SQL 1

Details

ID 2757615
Classroom 4 days
Webinar 5 days
Method Lecture with examples and exercises.
Prequisite Oracle SQL, PL / SQL
Audience DBAs, database developers

Services:

  • Lunch / Catering
  • Assistance for hotel / travel bookings
  • Comelio certificate
  • Flexible: Free cancellation up until 10 days before the training

Summary

PL/SQL is an SQL-based procedual programming language that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the robustness, security, and portability of Oracle Database. PL/SQL is tightly integrated with SQL. With PL/SQL, you can use all SQL data manipulation, cursor control, and transaction control statements, and all SQL functions, operators, and pseudocolumns. Oracle provides product-specific packages that define APIs you can invoke from PL/SQL to perform many useful tasks. You can create standalone subprograms (procedures and functions) at schema level. They are compiled and stored in the database, where they can be used by any number of applications connected to the database. This training introduces you to the basic syntax of PL/SQL and shows you then how to develop scripts, procedures, functions or triggers.

Training Dates

  • 2020-Nov-13 - Nov-12
  • 2021-Jan-22 - Jan-21
  • 2021-Apr-02 - Apr-01
  • 2021-Jun-11 - Jun-10

1550 EUR +VAT

Location | Enrollment


Agenda

PL/SQL Syntax

Basics of PL/SQL: programming concept of Oracle applications, PL/SQL blocks, variables, data types - control structures: conditional statements, loops - transaction management - data record types and records - working with files

Cursor for SQL Queries in PL/SQL

Declaration of Cursors in PL/SQL - cursor handling - data processing with cursors - attributes and parameters - cursor variables - cursor expressions in SQL

Exceptions and Error Handling

Key topics of error handling - exception block - triggering and handling exceptions - exception types and complex exception handling in nested PL/SQL routines

Collections

PL/SQL collections and collection types - bulk load and bulk inserts - combination of collections and SQL - collection methods – collections and records

Native Dynamic SQL

Dynamic SQL and its execution at run-time in PL/SQL - parameters - bulk inserts and bulk binding / mass data processing - using native dynamic SQL with cursors, collections and record types

PL/SQL Modules in Oracle

PL/SQL procedures - functions - parameters - local modules - overloading - use PL/SQL packages - triggers (DML, Instead-of-trigger, system triggers)

Overview of PL/SQL Extensions

Object-relational data structures and their usage in PL/SQL - XML integration with Oracle and XML processing in PL/SQL

Trainer

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Publications
  • Oracle PL/SQL ISBN 978-3-939701-40-8
  • Oracle SQL ISBN 978-3-939701-41-5
  • Oracle PL/SQL - Objektrelationale Techniken ISBN 978-3-939701-42-2
  • Oracle, PL/SQL und XML ISBN 978-3-939701-49-1
Projects

He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Research

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.