• Retriving data using the SQL select statement.
• Restricting and sorting& filtering data.
• Using single row function to customize output.
• Displaying data from multiple tables –I.
• Displaying data from multiple tables-II.
• Using sub queries to solve problems.
• Using set operators.
• Character function.
• Manipulating function.
• Conversion, Number & date function.
• Conditional expressions.
• Joins
• Using DML statements.
• Using DCL statements.
• Using DDL statements to create and manage tables
• Constraints.
• Simple view, views & complex view.
• Retrieving data using sub queries.
• Creating other schema objects.
• Managing schema objects.
• Managing objects with data dictionary.
• Controlling user access.
• Manipulating large data sets.

• Introducation.
• Declaring Variables.
• Writing Executable Statements.
• Interacting with Oracle Server.
• Working with Composite Data Types.
• Writing Explicit Cursors.
• Writing Implicit Cursors.
• Handling Exceptions.
• Creating Procedures.
• Creating Functions.
• Creating Loops.

• Designing and executing a simple report.
• Managing the appearance of data in reports with layout objects.
• Customizing the display of data in reports.
• Integrating text and graphics in reports.
• Linking tabular, break, master/detail, matrix and form letter reports.
• Applying the packaged functions and procedures supplied with the reports builder component of Developer.
• Writing queries to retrieve data.
• Create and modify by wizard & manual basic tabular reports.
• Create and modify by wizard & manual group above reports.
• Create and modify by wizard & manual other report styles such as break reports and matrix reports.
• Create and modify by wizard & manual other report styles such as break reports and matrix with group reports.
• Determining how to best produce reports by analyzing report structures.
• Filtering report information from the database server.
• Building modules in Developer Reports for use with other Developer tools.

• Creating data blocks and relationships as source data for retrieval and display.
• Creating input items: text, list, checkbox, radio group and buttons.
• Creating non-input items: display, image and buttons.
• Defining item values in their respective property palette.
• Creating forms with multiple window and content canvases.
• Saving and running a form module using designer and runtime executables.
• Developing a tabular and group layout form.
• Identifying characteristics of each forms file storage type.
• Creating program units and learning to create and attach program unit libraries.
• Using Oracle built-in packages, calendars and timers.
• Writing application triggers for various form events.
• Creating trigger code to interact with windows.
• Passing data between forms using parameter lists.
• Passing values between forms using global variables.
• Enhancing the default menu.
• Adding basic menu items and context menus.
• Embedding charts into a form module using the Chart Wizard.
• Incorporating existing graphic displays in a form module.
• Creating and invoking reports in a form using the Report Wizard.
• Controlling a report programmatically in a form.

Fee for both Tracks
(Developer & Database - SQL , PL-SQL )
Rs.40000/- (forty Thousand only)
Breakup Fee on monthly basis
Rs.6500/-Duration: Six Months
Classes: Three alternate days a week
Timing: (8:30pm to 11:30pm).....