click to enable zoom
Loading Maps
We didn't find any results
View Roadmap Satellite Hybrid Terrain My Location Fullscreen Prev Next
Advanced Search

₹ 0 to ₹ 100,000

We found 0 results. Do you want to load the results now ?
Advanced Search

₹ 0 to ₹ 100,000

we found 0 results
Your search results

Groovy Training at Mytectra Institute

IWWA Building NO (10)P 2nd Floor, 7th Main Road BTM 2nd Stage, ,
add to favorites

30 Hours of training with Lab Exercises
Lab exercises for each module.
Well-Experienced and Real Time Trainers
Best in Class Infrastructure
Real time case studies and project integrated into the Curriculum
24*7 Support from our team of administrators
Course Material and Lab guides for students reference

At the end of the course the participants will able to:

  • DQL-The Select Statement
  • Limiting The Database Records Retrieved €“WHERE
  • Sorting Records -ORDER BY
  • GROUP BY Clause And Functions
  • Character Functions
  • Integrity Constraints

Module 1: DQL-The Select Statement

Topics covered on introduction to Qlikview
  • Identifying Table and Column Names
  • Components of a Simple SELECT
  • Creating Character Values in the SELECT clause
  • Computing Numeric Values in the SELECT clause

Module 2: Joins

Topics covered on exploring data
  • Retrieving Records from Multiple Tables
  • How to Combine or Join Tables
  • What to Do with Join Columns with the Same Name
  • Joining Tables When the Value Exists in Only One Table

Module 3: GROUP BY Clause And Functions

Topics covered on sheet objects
  • Group Functions
  • SUM
  • AVG
  • HAVING Clause

Module 4: Sequences

Topic 1: Overview
  • Create sequence
  • Drop Sequence
  • Alter Sequence
  • Using in select statement

Module 5: Integrity Constraints

Topics covered on Data Modelling
  • Primary Key -Table Level and Column Level
  • Foreign Key -Table Level and Column Level
  • Check constraint
  • 10+ Years experienced Working Professional.
  • Handled Corporate Trainings.
  • 5+ Years of experience in On-line and Class Room Training
  • Trained more than 500+ students
  • A cogent speaker and a lucid communicator
  • Good at providing real time examples and practical scenarios while explaining concepts.
  • Possess positive attitude and ability to meet customer requirements
Good Course
  • Content
  • Instructor
  • Institute


very good
User Rating 0 (0 votes)
Comments Rating 0 (0 reviews)
Start-End Dates: 25 Jun 16 - 24 Jul 16
Course Duration: 30 days
Instructional Level: Appropriate for All
Live Projects
Doubt Clearing Sessions
Reading Material
EMI Option
Online Support
Post completion course access
Practice Exams
Placement assistance
Refund Policy
Post completion support

Compare courses

Leave a Reply


+91 90191 91856
[email protected]

Contact Us