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
635

Key-Takeaways
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
  • COUNT
  • SUM
  • AVG
  • HAVING Clause

Module 4: Sequences

Topic 1: Overview
  • Create sequence
  • Drop Sequence
  • Alter Sequence
  • CURRVAL
  • 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

Summary

very good
4.7
User Rating 0 (0 votes)
Sending
Comments Rating 0 (0 reviews)
Start-End Dates: 25 Jun 16 - 24 Jul 16
Course Duration: 30 days
Instructional Level: Appropriate for All
Certification
Quizzes
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

mytectra

Bangalore
+91 90191 91856
[email protected]

Contact Us