logo

Hot Jobs

Uktha Global Inc provides software training on latest technologies to follow current job market. As a trainee, you'd be trained by experienced software developers who work for top 50 companies in their domain. We, at Uktha Global Inc., aim to bridge the gap between training opportunities and the scope available in the industry. The intensive training imparted by us is followed by job related mock interviews which prepares students to face any job interview with ease. Our training program is very unique and enables students to be functional and Productive in their respective domains.

 
  • SQL and PL/SQL - Basic, Intermediate, and Advance
  • Crystal Reports and Crystal Enterprise
  • Business Objects
  • ASP and Web Development (Active Server Page)
  • Business Analysis and Business System Analysis
  • Java

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
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.

 

HOTJOBS

Business Development Manager
(4 - 8Yrs, Hyderabad)
Handling the team of Relationship Managers. Handling the escalations of the team....

Senior .Net developer
(Above 5Yrs, Noida)
The ideal candidate will have a high level of Back End database development with strong commercial experience developing applications and systems in ADO.NET....

View All >