We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

By becoming an Oracle Database PL/SQL Certified Professional, you will be ready to fully exploit the most advanced features of PL/SQL. You will gain thorough knowledge of PL/SQL language, its architecture, features, interactions with the SQL engine, programming constructs and datatypes. Enhance the appearance and functionality of the basic form by using PL/SQL trigger, JavaBeans, and Pluggable Java Components.

Outline

Diploma courses :
Oracle 12c Introduction to SQL ( 40 Hours )
Oracle 12c Program with PL/SQL ( 40 Hours )
Oracle Fusion Middleware Build Applications with Oracle Forms ( 40 Hours )

Oracle 12c Introduction to SQL:
  • Introduction
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Definition Language
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
  • Managing Data in Different Time Zones


Oracle 12c Program with PL/SQL:
  • Introduction
  • Introduction to PL/SQL
  • Declare PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures
  • Manage Dependencies


Oracle Fusion Middleware 11g Build Applications with Oracle Forms
  • Running a Forms Application
  • Working in the Forms Builder Environment
  • Creating a Basic Form Module
  • Creating a Master-Detail Form
  • Working Data Blocks and Frames
  • Working with Text Items
  • Creating LOVs and Editors
  • Creating Additional Input Items
  • Creating Noninput Items
  • Creating Windows and Content Canvases
  • Working with Other Canvas Types
Reviews
Be the first to write a review about this course.
Write a Review

Since 1995, CLS Learning solutions is leading the technology learning market in Egypt, the Middle East, and Africa. With our wide network of international partners, trainers, instructors, and technology leaders; we are able to deliver top notch training programs to our students and technology professionals.

25 Years in the market.

We delivered over 4,200 courses to 63,500 professionals in our centers.

We delivered 1,200 courses to 18,240 corporate employees on Site.

 
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.