Oracle (Application Development Track)

by Aptech Computer Training

This course covers 3 modules : 1) Introduction to SQL and PL/SQL 2) Forms 3) Reports. It covers all the essential elements of these applications.

AED 4500

Contact the Institutes

Fill this form
Aptech Computer Training Logo

img Duration

3 Months

Course Details

This workshop covers the following 3 modules in detail: 


1) Introduction to SQL and PL/SQL

2) Forms

3) Reports


1. Introduction to SQL and PL/SQL


- Introduction

- Retrieving Data Using the SQL SELECT Statement

- Restricting and Sorting Data

- Using Single Row Functions to Customize Reports

- Reporting Aggregated Data Using the Group Functions

- Displaying Data From Multiple Tables

- Using Sub queries to Solve Queries

- Using the SET Operators

- Manipulating Data

- Using DDL Statements to Create and Manage Tables

- Creating Other Schema Objects

- Managing Objects with Data Dictionary Views

- Controlling User Access

- Generating Reports by Grouping Related Data

- Managing Data in Different Time Zones

- Searching Data Using Advanced Sub queries

- Hierarchical Data Retrieval

- Introduction to PL/SQL Objects

- Procedural Language

- PL/SQL Blocks, Anonymous Blocks and Named Blocks

- Creating PL/SQL Procedures and Functions

- Understanding Triggers

- Packages


2. Oracle Developer Forms 


- Introducing Oracle Forms Developer and Forms Services

- Creating Forms Modules

- Working with Data Blocks and Frames

- Working with Input Items

- Working with Non input Items

- Creating Windows and Canvases

- Producing Triggers

- Debugging Triggers

- Adding Functionality to Items

- Run-Time Messages and Alerts

- Query Triggers

- Validation

- Navigation

- Transaction Processing

- Writing Flexible Code

- Sharing Objects and Code

- Introducing Multiple Form Applications


3. Oracle Developer Reports


- Introduction to Oracle Reports Developer

- Designing and Running Reports

- Working in Oracle Reports Developer

- Creating a Paper Report

- Enhancing a Basic Paper Report

- Managing Report Templates

- Controlling the Paper Layout: Common Properties

- Creating and Using Report Parameters

- Embedding a Graph in a Report

- Enhancing Matrix Reports

- Coding PL/SQL Triggers

Aptech Computer Training is among the leaders in career education in the Dubai & Sharjah. The company focuses on career development for students and working professionals. In addition, Aptech Computer Training also offers various training services to large companies to help develop the skills of their employees.

Newly emerging trends and technologies like Artificial Intelligence (AI) cloud computing, mobile applications, Multimedia courses, Social media and Data analytics are bringing about increasing job opportunities in the IT & ICT industry.

Aptech Computer Training, through its courses and curriculum, ensures that you are at par with global standards. We provide KHDA Attested Certificates.

  • Bur Dubai Branch

    Aptech Computer Education Institute, Mankhool Road, Al Tawhidi Bldg II, 7th Floor, Bur Dubai, Dubai
  • Al Majaz Branch

    Aptech Computer Training Institute, King Faisal Street, Al Majaz, Sharjah

Check out more Oracle courses in UAE

Learners Point Academy Logo

Oracle Apps Financials-R12 (Functional)

This training will teach you about the different financial concepts of Oracle Financial such as General Ledger, Payables, Purchasing, Fixed Assets,  Accounts Receivables, Order-Management, Cash Management, and other different Projects.

by Learners Point Academy
  • Price
  • Start Date
  • Duration
Oscar Institute Logo

MySQL

After the successful completion of this course, an attested certificate is issued by the Ministry of Education, U.A.E. Learn how to operate and manage MySQL features and functions. The qualified instructors at Oscar Institute will take into

by Oscar Institute
  • Price
  • Start Date
  • Duration
Learners Point Academy Logo

Oracle Apps HRMS

Learn about Oracle-Apps HRMS and understand how the HR Department and Payroll have been using this software to manage various HR information in pockets making them duplicate systems.

by Learners Point Academy
  • Price
  • Start Date
  • Duration
Oscar Institute Logo

SQL Server

After the successful completion of each course, an attested certificate is issued by the Ministry of Education, U.A.E. This is an instructor-led SQL Server learning course aimed at teaching you different features and functions of SQL Server

by Oscar Institute
  • Price
  • Start Date
  • Duration
Elite Stars Easy Learn Institute Logo

MySQL Training

This training will teach you to develop a database for enterprise after acquiring a comprehensive understanding of structured query language (SQL).

by Elite Stars Easy Learn Institute
  • Price
  • Start Date
  • Duration

© 2024 www.coursetakers.ae All Rights Reserved. Terms and Conditions of use | Privacy Policy