logo

Oracle Database 12c: PL/SQL I – Introduction (DB6162)

This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This course will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. 

PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.

Pohađajte naše Oracle obuke u Beogradu, putem virtuelne učionice (online, uživo) ili u vašim prostorijama (on-site).

Specijalni popusti se odobravaju prilikom prijave više učesnika koji istovremeno pohađaju obuku iz vaše kompanije, državni i neprofitni sektor, itd. Kontaktirajte nas da biste saznali više.

Termini obuke

Trajanje obuke: 
3 dana / 21 sat

Privatni trening

On-site / Online
Minimalan broj polaznika: 3
3 dana / 21 sat
Cena na zahtev
srpski ili engleski
Plan obuke: 

Module 1: Selection & Setup Of The Database Interface

  • Considering Available Tools 
  • Selecting The Appropriate Tool 
  • Oracle NET Database Connections 
  • Oracle PAAS Database Connections 
  • Setup SQL Developer 
  • Setup SQL*PLUS 
  • Setup JDeveloper

Module 2: About BIND & SUBSTITUTION Variables

  • Using SQL Developer 
  • Using SQL*PLUS

Module 3: Choosing A Database Programming Language

  • What Is Database Programming? 
  • PL/SQL Performance Advantages 
  • Integration With Other Languages

Module 4: PL/SQL Language Fundamentals

  • PL/SQL Program Structure 
  • Language Syntax Rules 
  • Embedding SQL 
  • Writing Readable Code
  • Generating Database Output
  • SQL*PLUS Input Of A Program Block

Module 5: DECLARE Section

  • About The DECLARE Section 
  • DECLARE Primitive Types 
  • Declaration Options 
  • NOT NULL 
  • CONSTANT 
  • Data Dictionary Integration
  • %TYPE 
  • Declare Simple User-Defined Types
  • TYPE ... TABLE 
  • TYPE ... RECORD 
  • Extended User-Defined Types

Module 6: BEGIN Section

  • About The BEGIN Section 
  • Manipulating Program Data 
  • Logic Control & Branching 
  • GOTO 
  • LOOP 
  • IF-THEN-ELSE 
  • CASE

Module 7: Exception Section

  • About The EXCEPTION Section
  • Isolating The Specific EXCEPTION
  • PRAGMA EXCEPTION_INIT 
  • SQLCODE & SQLERRM Example
  • SQL%ROWCOUNT & SELECT...INTO

Module 8: Beyond The Basics: Explicit Cursors

  • About Explicit Cursors 
  • Extended Cursor Techniques 
  • FOR UPDATE OF Clause 
  • WHERE CURRENT OF Clause 
  • Using FOR…LOOP Cursors

Module 9: Beyond The Basics: Nested Blocks

Module 10: Beyond The Basics: DECLARED Subprograms

  • Using DECLARED Subprograms 
  • DECLARED Procedure 
  • DECLARED Function
Benefiti: 
  • Video snimak predavanja u periodu od 180 dana posle kraja obuke

  • Pristup laboratorijama u toku trajanja kursa
  • Materijal u elektronskom obliku

  • Sertifikat o pohađanju kursa

Poželjno predznanje: 

Either of the Oracle Database 12c: SQL - Fundamentals (Levels I & II) or Oracle Database 12c: SQL Complete Library (Levels I, II & III) courses are recommended prerequisites for this training.

Kontaktirajte nas za više informacija o ceni:

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 195
E-mail: Jelena.Mijanovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 197
E-mail: Boris.Gigovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs