Trening predstavlja temelj za PL/SQL programiranje omogućujući napredovanje od uvodnih tema do naprednog dizajna i programiranja aplikacija te konačno do pisanja složenih aplikacija visokih performansi. Polaznici će naučiti kako koristiti programske jedinice pohranjene u bazi podataka kao što su procedure, funkcije, paketi i okidači baze podataka.

Osnovne informacije

Move Icon

  1. Using PL/SQL programming language for database applications and development.
  2. Incorporating PL/SQL modules within the application architecture from the initial design and planning phase.
  3. The essentials of building executable PL/SQL program units.
  4. Each of the major segments of a working program and how these interact with each other during program execution.
  5. Important error or exception handling capabilities of the language.
  6. How database-resident program units can be used as part of the overall database application architecture.
  7. Applying these new skills to the development of PL/SQL packages.
  8. Advanced database programming capabilities and benefits.
  9. How database triggers can be used as part of an advanced database application design.
Application developerima, administratorima baza podataka, poslovnim analitičarima i krajnjim korisnicima koji se susreću s Oracle bazom podataka ili za one kojima je potrebno opće razumijevanje funkcionalnosti Oracle baze podataka.
Osnovno poznavanje baze podataka.

Moduli koji će se izvoditi

  • PL/SQL Concepts
  • PL/SQL Language Fundamentals
  • SQL in PL/SQL
  • Conditional Control: IF Statements

  • Conditional Control: CASE Statements
  • Iterative Control: Part I
  • Iterative Control: Part II
  • Introduction to Cursors

  • Error Handling and Built-in Exceptions
  • Procedures and Functions – Introduction

Brzi upit

Prijavite se

Lokacija 


Trajanje: 24 sati

Brzi upit