Oracle Database 12c: Introduction to SQL

This Oracle Database: PL/SQL Fundamentals training introduces you to PL/SQL and explains the benefits of this programming language.

This Oracle Database: PL/SQL Fundamentals training will enhance developer skills through the powerful PL/SQL programming language. You’ll learn to create and execute PL/SQL blocks of application code and integrate SQL with the programming constructs.

Što ćete naučiti

  • Conditionally control code flow (loops, control structures).
  • Use explicit cursors.
  • Handle runtime errors.
  • Describe stored procedures and functions.
  • Work with composite data types.
  • Declare PL/SQL variables.
  • Create anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.

Kome je namijenjeno

  • Technical Consultant
  • System Analysts
  • PL/SQL Developer
  • Forms Developer



Nastavni plan

  • Introduction
  • Introduction to PL/SQL
  • PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures, Composite Data Types
  • Explicit Cursors, Exception Handling
  • Stored Procedures and Functions