Oracle Database - PL/SQL Fundamentals

The PL/SQL Fundamentals course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

In the class students will learn to create anonymous PL/SQL blocks, to create procedures, functions and triggers. Students will learn to use explicit cursors in their program blocks. Demonstrations and hands-on practice reinforce the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

  • Design PL/SQL anonymous block that execute efficiently
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Handle exceptions in the program units
  • Create and execute simple stored procedures and functions
  • Write PL/SQL code to interface with the database
  • Describe the features and syntax of PL/SQL

Förkunskaper

  • Familiarity with data processing concepts and techniques
  • Familiarity with programming languages

Ämnesområden

  • Introduction
  • Introduction to PL/SQL
  • eclaring PL/SQL Variables
  • Writing Anonymous PL/SQL blocks
  • Using SQL Statements within a PL/SQL Block
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating Stored Procedures and Functions

Boka kursen

Boka din plats redan idag.

Om kursen

Pris: 12 950,00 kr

exklusive moms

Längd 2 dagar
Kurskod A633
Boka kursen

Välj ort och kursstart

11 februari

8 april

Kunduppgifter