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

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

Target Audience
  • 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.

Meet the instructors

  • Biljana Barukchieva  

    Senior project manager

    @Quinshift

     

    20+ years of experience