Monday - Friday 9:00AM - 10:00PM
Call us now +389 2 3130 900
Keep in touch info@semosedu.com

EN / МК / RS

EN / МК / RS

Reserve a seat

reserve a seat

Description
Content
Intendent To
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

Intendent To

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

Course info

Classes

40

Performance method

Online

Language

English

Price

ден1.210 EUR

Payment method Request a callback

Course Application

Oracle Database: Program with PL/SQL

Your Details

First Name Last Name E-mail Phone Country City

Who is the payment made for? Personal For a company For another person

Name and surname of the person being paid

Company Informations

Company Name Address

Number of employees Number of attendees

After submitting the application, you will be contacted by our sales persons.

Request a callback

Oracle Database: Program with PL/SQL

Еден чекор поблиску до посакуваната цел

Име на курс

Payment Method

Payment with credit cards

Payment via invoice