Semos Education Semos Education
  • Monday - Friday 9:00AM - 10:00PM
  • Call us now +44 7487633466
  • Keep in touch info@semosedu.com
EN / МК / RS
Кошничка
reserve a seat
  • Description
  • Content
  • Target Audience
  • Benefits
  • Certificates

The Oracle Database: Programming with PL/SQL course begins with an introduction to PL/SQL and then introduces the benefits of this powerful programming language.

 

Through practical instructions from an experienced lecturer, you will learn to develop stored procedures, functions, triggers, packages and more.

MODULE 1

Introduction

 

MODULE 2

Introduction to PL/SQL

 

MODULE 3

Declaration of PL/SQL identifiers

 

MODULE 4

Write executable commands

 

MODULE 5

Interaction with the Oracle server

 

MODULE 6

Control structures

 

MODULE 7

Mixed data types

 

MODULE 8

Explicit cursors

 

MODULE 9

Working with exceptions

 

MODULE 10

Stored procedures

 

MODULE 11

Stored functions and tuned subroutines

 

MODULE 12

Packages

 

MODULE 13

Deploying packages

 

MODULE 14

Implementation of Oracle packages during application development

 

MODULE 15

Dynamic SQL

 

MODULE 16

What to consider when building PL/SQL code

 

MODULE 17

Triggers

 

MODULE 18

Creation of composite triggers, DDL triggers, database event triggers

 

MODULE 19

PL/SQL compiler

 

MODULE 20

Dependency management

  • Administrator
  • Architect
  • Database Administrator

What we will teach you:

 

  • Use conditional compilation to modify functionality in a PL/SQL application without removing the source code.
  • They will design PL/SQL packages to group related constructs
  • Create subroutines for overloaded packages to provide more flexibility
  • Design PL/SQL anonymous blocks that work efficiently
  • Use Oracle PL/SQL packages to generate screen output, file output, and email output
  • Write dynamic SQL for more coding flexibility
  • Describe PL/SQL properties and syntax
  • Create and debug stored procedures and functions
  • Use PL/SQL programming constructs and conditionally inspect code (loops, control structures, and explicit cursors)
  • Manage dependencies between PL/SQL subroutines
  • Deal with runtime errors
  • Create triggers to solve business challenges

Course attendance certificate issued by Semos Education

Description

The Oracle Database: Programming with PL/SQL course begins with an introduction to PL/SQL and then introduces the benefits of this powerful programming language.

 

Through practical instructions from an experienced lecturer, you will learn to develop stored procedures, functions, triggers, packages and more.

Content

MODULE 1

Introduction

 

MODULE 2

Introduction to PL/SQL

 

MODULE 3

Declaration of PL/SQL identifiers

 

MODULE 4

Write executable commands

 

MODULE 5

Interaction with the Oracle server

 

MODULE 6

Control structures

 

MODULE 7

Mixed data types

 

MODULE 8

Explicit cursors

 

MODULE 9

Working with exceptions

 

MODULE 10

Stored procedures

 

MODULE 11

Stored functions and tuned subroutines

 

MODULE 12

Packages

 

MODULE 13

Deploying packages

 

MODULE 14

Implementation of Oracle packages during application development

 

MODULE 15

Dynamic SQL

 

MODULE 16

What to consider when building PL/SQL code

 

MODULE 17

Triggers

 

MODULE 18

Creation of composite triggers, DDL triggers, database event triggers

 

MODULE 19

PL/SQL compiler

 

MODULE 20

Dependency management

Target Audience
  • Administrator
  • Architect
  • Database Administrator
Benefits

What we will teach you:

 

  • Use conditional compilation to modify functionality in a PL/SQL application without removing the source code.
  • They will design PL/SQL packages to group related constructs
  • Create subroutines for overloaded packages to provide more flexibility
  • Design PL/SQL anonymous blocks that work efficiently
  • Use Oracle PL/SQL packages to generate screen output, file output, and email output
  • Write dynamic SQL for more coding flexibility
  • Describe PL/SQL properties and syntax
  • Create and debug stored procedures and functions
  • Use PL/SQL programming constructs and conditionally inspect code (loops, control structures, and explicit cursors)
  • Manage dependencies between PL/SQL subroutines
  • Deal with runtime errors
  • Create triggers to solve business challenges
Certificates

Course attendance certificate issued by Semos Education

Past experiences

What people say about us

  • - Marko Krstevski Microsoft .NET Academy

    Seeking to expand my knowledge, I decided to enroll in Semos Education, where I am gaining the necessary knowledge and experience.

  • - Teodor Markovski Student

    The desire to become a Cloud architect led me to Semos Education. I am thrilled by the positive experiences of former students and the way in which the instructors and Career Center take care of the students.

  • - Viktorija Georgieva Summer Mentorship Program for Python Develope

    The reputation of Semos Education for quality training and the opportunity to learn from experienced instructors played an additional significant role in my decision.

  • - Borche Peltekovski Accredited Academy for Graphic Design

    After completing my studies at Semos Education, I envision myself working in a technology company, such as Samsung, Apple, or a company of similar caliber.

  • - Vasilija Uzunova Oracle Certified Instructor

    For me, there was no other choice but Semos Education. I want to be part of the best, I want to share my knowledge in a company that is global, and ours.

Meet the instructors

  • Biljana Barukchieva  

    Senior project manager

    @Quinshift

     

    20+ years of experience