Hot Jobs

Topics covered in PL/SQL training are given below.
SQL

• Introduction
• Data Types
• Comparison Operators
• Logical Operators
• Select Statements
• Where Clause
• Pseudo Table
• Case Construct
• Decode Construct
• Integrity Constraints
• Order by Clause
• Group by Clause
• Having Clause
• Functions
• String Functions
• Numeric Functions
• Date Functions
• Conversion Functions
• Group Functions
• Miscellaneous Functions

• Joins
• Equi Join
• Non-Equi Join
• Self Join
• Outer joins
• Set Operators
• Sub-queries
• Views
• Simple View
• Complex View
• Commit
• Roll Back
• Save Point
• Insert
• Update
• Delete
• Create Tables
• Create Constraints
• Drop Tables
• Alter Tables
• Rename Tables
• Synonyms
• Sequence
• Indexes
• Partitions

PL/SQL

• Introduction
• Defining Variables
• P/L SQL Block
• Control Structures
• If statements
• While loop
• Do while
• For Loop
• Nested Loops
• Exceptions
• Cursors
• Implicit
• Explicit
• Reference Cursors
• Stored Procedures
• User Defined Functions
• Packages
• Triggers

Crystal Reports and Crystal Enterprise We cover following topics in Crystal Reports training.
Before You Begin to create a Report

• Defining the Purpose of the Report
• Determining the Layout of the Report
• Finding the Data
• Organizing the Data for the Report

• Quick Formatting with the Template Expert
• Formatting Objects
• Format Painter
• Drawing and Inserting Lines and Boxes
• Inserting Graphics
• Working with the Page Commands
• Changing Page Orientation and Margins
• Formatting Part or All of an Object
• Working with Text Objects
• Inserting Special Fields

Selecting Specific Records from the Database

• Filtering Data with the Select Expert
• Selecting Records with Multiple Criteria
• Viewing and Editing the Select Formula
• Case Sensitive vs. Case Insensitive
• Record Selection Formula Templates

Grouping and Sorting Data for Summary Purposes

• When and Why to Group Records
• Creating new Groups
• Group and Sort Direction
• Customize Group Name Field
• Modifying Groups
• Creating Multiple Groups in a Report
• Using the Group Tree to Navigate the Report
• Reordering Groups
• Sorting Records Within a Group
• Summarizing Groups
• Adding a Grand Total to Reports
• Grouping Data in Date/Time Intervals
• Calculating Percentages
• Ordering Groups Based on Their Subtotals Using the Top N Expert

Combining Multiple Tables

• Understanding Tables, Records, and Fields
• Learning About Linking
• Adding Multiple Tables to a Report
• Using Various Objects in the report
• Deriving Data from multiple Databases/RDBMS/DBMS/Flat files

Creating and Using Formulas

• Understanding Crystal Formula Syntax
• Working with the Formula Workshop
• Working with the Formula Editor
• Performing Simple Number Calculations
• Manipulating Dates with Formulas
• Creating Boolean Formulas and String Formulas
• Using Bookmarks to Navigate Through Formulas

Conditional Formatting

• Using the Highlighting Expert
• Setting Highlighting Priorities
• Formatting Sections
• Formatting Sections Conditionally
• Conditionally Formatting Fields

Creating Summary Reports and Charts

• Creating a Summary Report
• Applying the Drill Down Feature
• Applying the Drill Down Group Level
• Producing, Editing and Formatting Charts
• Applying Chart Templates
• Using the General Chart Options
• Modifying Individual Object in the Chart
• Using Auto-Arrange Chart
• Applying Chart Templates

• Understanding Export Formats and Destinations

• Setting the Default Layout for Design and Preview Views

Using the Report Wizards

• What are the Report Wizards?
• Create a Report Using the Standard Report Creation Wizard
• The Data Dialog Box
• The Fields Dialog Box
• The Grouping Dialog Box
• The Summaries Dialog Box
• The Group Sorting Dialog Box
• The Chart Dialog Box
• The Record Selection Dialog Box
• The Template Dialog Box

Creating an ODBC Data Source to Attach to a Database

• Creating an ODBC Connection to Any Database
• Introduction to Crystal Enterprise