ODB001 Oracle Database Fundamentals

Cel szkolenia

This course introduces students to PL/SQL and explains the benefits of this programming language. Participants learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. The course also imparts how to create anonymous PL/SQL blocks, stored procedures, and functions. Participants learn about declaring identifiers and trapping exceptions. Demonstrations and hands-on practice reinforce the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are available as optional tools. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features.

Program szkolenia

  1. Introduction
  2. Introduction to PL/SQL
  3. PL/SQL Identifiers
  4. Write Executable Statements
  5. Interaction with the Oracle Server
  6. Control Structures
  7. Composite Data Types
  8. Explicit Cursors
  9. Exception Handling
  10. Stored Procedures and Functions

Czas trwania szkolenia

dni/godziny:      5/40

Koszt szkolenia

Cena szkolenia wynosi 3 800 zł netto za osobę + VAT