Oracle

Course details

This course offers students an introduction to Oracle Database 11g database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language.

This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions.They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.

In this course students build, test, debug, and deploy interactive Internet applications. Working in a graphical user interface (GUI) environment, they develop an order entry application from the ground up.

This application incorporates several advanced features that provide a rich user experience while implementing business rules. In this course, students learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer 11g.

Working in the declarative environment of Reports Builder, students learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any

After course completion

• This course offers students an introduction to Oracle Database 11g database technology.
• This course introduces students to PL/SQL
• build, test, debug, and deploy interactive Internet applications.
• design and build a variety of standard and custom Web and paper reports

Who should attend

• All who have basic IT Knowledge and Interested

Prerequisites

• Basic IT Knowledge