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

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
   • Formatting Features
       - 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
   • Exporting Report Results Within Your Organization
       - Understanding Export Formats and Destinations
   • Setting Default and Report Options
       - 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

   We cover following topics in Business Objects training.

   We cover following topics in ASP and Web Development training.

   We cover following topics in Business Analysis training.

   We cover following topics in Java training.