reserve a seat

Description
Content
Intendent To
Benefits
Certificates

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language.

Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.

MODULE 1

Introduction

MODULE 2

Working with Oracle Cloud Exadata Express Cloud Service

MODULE 3

Introduction to PL/SQL

MODULE 4

Declare PL/SQL Variables

MODULE 5

Write Anonymous PL/SQL Blocks

MODULE 6

SQL Statements in a PL/SQL block

MODULE 6

Control Structures

MODULE 7

Composite Data Types

MODULE 8

Explicit Cursors

MODULE 9

Exception Handling

MODULE 10

Stored Procedures

MODULE 11

Stored Functions

MODULE 12

Debugging Subprograms

MODULE 13

Packages

MODULE 14

Deploying Packages

MODULE 15

Implement Oracle-Supplied Packages in Application Development

MODULE 16

Dynamic SQL

MODULE 17

Design Considerations for PL/SQL Code

MODULE 18

Triggers

MODULE 19

Creating Compound, DDL, and Event Database Triggers

MODULE 20

PL/SQL Compiler

MODULE 21

Manage Dependencies

Administrator
Architect
Database Administrator

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver
a higher quality of service by enabling consolidation onto database clouds.

Use Oracle SQL Developer

You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional
tools.

Course Bundle Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database:
Develop PL/SQL Program Units courses.

Learn To:

Conditionally control code flow (loops, control structures).
Create stored procedures and functions.
Use PL/SQL packages to group and contain related constructs.
Create triggers to solve business challenges. Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
Create custom packages for applications.
Write Dynamic SQL code for applications.

Course attendance certificate issued by Semos Education

Description

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language.

Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.

Content

MODULE 1

Introduction

MODULE 2

Working with Oracle Cloud Exadata Express Cloud Service

MODULE 3

Introduction to PL/SQL

MODULE 4

Declare PL/SQL Variables

MODULE 5

Write Anonymous PL/SQL Blocks

MODULE 6

SQL Statements in a PL/SQL block

MODULE 6

Control Structures

MODULE 7

Composite Data Types

MODULE 8

Explicit Cursors

MODULE 9

Exception Handling

MODULE 10

Stored Procedures

MODULE 11

Stored Functions

MODULE 12

Debugging Subprograms

MODULE 13

Packages

MODULE 14

Deploying Packages

MODULE 15

Implement Oracle-Supplied Packages in Application Development

MODULE 16

Dynamic SQL

MODULE 17

Design Considerations for PL/SQL Code

MODULE 18

Triggers

MODULE 19

Creating Compound, DDL, and Event Database Triggers

MODULE 20

PL/SQL Compiler

MODULE 21

Manage Dependencies

Intendent To

Administrator
Architect
Database Administrator

Benefits

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver
a higher quality of service by enabling consolidation onto database clouds.

Use Oracle SQL Developer

You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional
tools.

Course Bundle Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database:
Develop PL/SQL Program Units courses.

Learn To:

Conditionally control code flow (loops, control structures).
Create stored procedures and functions.
Use PL/SQL packages to group and contain related constructs.
Create triggers to solve business challenges. Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
Create custom packages for applications.
Write Dynamic SQL code for applications.

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.