Oracle Developer

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Oracle Developer which gives you the opportunity to interact with a Oracle Developer instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


Introduction to SQL

  • Introduction
  • Writing a Basic SQL statement
  • Restricting and Sorting Data
  • Single Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data by using Group functions
  • Writing Sub queries
  • Producing Readable Output with iSQL *Plus
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constraints
  • Creating Views
  • Other Database Objects
  • Controlling User Access
  • SQL Workshop
  • Using Set Operators
  • Oracle 9i Date time Functions
  • Enhancements to GROUP By clause
  • Advanced Sub queries
  • Hierarchical Retrieval
  • Oracle 9i Extensions to DML and DDL Statements

PL/SQL

  • Introduction
  • Declaring Variables
  • Writing Executable Statements
  • Interacting with the Oracle Server
  • Writing Control structures
  • Working with composite Data Types
  • Writing Explicit cursors
  • Advanced Explicit Cursor Concepts
  • Handling Exceptions
  • Creating Procedures
  • Creating Functions
  • Managing Subprograms
  • Creating Packages
  • More Package Concepts
  • Using Oracle-Supplied Packages
  • Creating Database Triggers
  • More Trigger Concepts
  • Managing Dependencies

Oracle Forms Release - (Option 1)

  • Introduction to Forms
  • Overview of the Designer Interface
  • The Runtime Interface
  • Querying the Database
  • Normal and Enter Query Mode
  • Manipulating the Database
  • Enhancing the Form
  • The Forms Designer
  • The object navigator
  • The layout editor
  • The properties Window
  • The Menu Editor
  • Forms Objects
  • Blocks and Relations
  • Items
  • Control
  • Windows and Dialogue Boxes
  • Record Structures and other Objects
  • Menus and Toolbars

Oracle Reports Release-(Option 2)

  • Introduction to Reports
  • Overview of Designer Interface
  • The Object Navigator the Data Model
  • Defining the Data Model
  • The layout model
  • Specifying a Runtime Parameter form
  • Creating Reports
  • Formulas & Summaries
  • Changing Fonts and modifying field properties
  • Page layout adjusting page size
  • Report Headers and Footers
  • Anchors
  • Creating Forms
  • Creating Form letters
  • Creating Mailing labels
  • Creating matrix reports
  • Combination Reports
  • Creating Parameter Forms
  • Adding Buttons, Images and other Objects to your reports
  • Creating Templates
  • Adding Templates to the default design interface
  • The Runtime interface.

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234