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 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications.

 

Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

MODULE 1

Introduction

 

MODULE 2

PL/SQL Programming Concepts: An Overview

 

MODULE 3

PL/SQL code design

 

MODULE 4

Collection overview

 

MODULE 5

Using collections

 

MODULE 6

Handling large objects

 

MODULE 7

Using advanced interface methods

 

MODULE 8

Performance and tuning

 

MODULE 9

Increasing performance with caching

 

MODULE 10

Analysis of PL/SQL code

 

MODULE 11

PL/SQL code profiling and monitoring

 

MODULE 12

Implementation of VPD with fine-grained control approach

 

MODULE 13

Code protection against SQL injection

  • Administrator
  • Architect
  • Database Administrator

Benefits to you:

 

Discover how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance.

 

By investing in this course, you’ll be introduced to the Virtual Private Database(VPD) to implement security policies and explore techniques and tools to strengthen your applications against SQL injection attacks. Expand programming resources by creating PL/SQL programs that interface with C and Java code.

 

 

Learn To:

 

  • Write powerful PL/SQL programs.
  • Explore programming efficiency.
  • Use external C and Java routines.
  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Implement a virtual private database with fine-grained access control.
  • Write code to interface with external C and Java applications.
  • Write code to interface with large objects and use SecureFile LOBs.
  • Write and tune PL/SQL code effectively to maximize performance.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.

Course attendance certificate issued by Semos Education

Description

This Oracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications.

 

Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

Content

MODULE 1

Introduction

 

MODULE 2

PL/SQL Programming Concepts: An Overview

 

MODULE 3

PL/SQL code design

 

MODULE 4

Collection overview

 

MODULE 5

Using collections

 

MODULE 6

Handling large objects

 

MODULE 7

Using advanced interface methods

 

MODULE 8

Performance and tuning

 

MODULE 9

Increasing performance with caching

 

MODULE 10

Analysis of PL/SQL code

 

MODULE 11

PL/SQL code profiling and monitoring

 

MODULE 12

Implementation of VPD with fine-grained control approach

 

MODULE 13

Code protection against SQL injection

Target Audience
  • Administrator
  • Architect
  • Database Administrator
Benefits

Benefits to you:

 

Discover how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance.

 

By investing in this course, you’ll be introduced to the Virtual Private Database(VPD) to implement security policies and explore techniques and tools to strengthen your applications against SQL injection attacks. Expand programming resources by creating PL/SQL programs that interface with C and Java code.

 

 

Learn To:

 

  • Write powerful PL/SQL programs.
  • Explore programming efficiency.
  • Use external C and Java routines.
  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Implement a virtual private database with fine-grained access control.
  • Write code to interface with external C and Java applications.
  • Write code to interface with large objects and use SecureFile LOBs.
  • Write and tune PL/SQL code effectively to maximize performance.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.
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