Tableau Training Institute in Delhi

HomeTableau Training Institute in Delhi

Tableau

INTRODUCTION

  • Introduction
  • Prepare files

CONNECTING TO YOUR DATA

  • Deep Dive into Tableau
  • Getting Data from different Sources
  • Tableau Joins
  • MetaData
  • Data Blening
  • Hierarchy and Groups
  • Quiz

VISUALIZATION

  • Dual Axis Graphs
  • Histogram
  • Pareto Chart
  • Motion Chart
  • Box Plot
  • Funnel Chart
  • Waterfall Charts
  • Quiz

MAPS AND IMAGES

  • Maps in Tableau
  • Advance Maps
  • Polygon Maps
  • Geocoding
  • Quiz

ANALYZING THE DATA

  • Parameters
  • Sorting
  • Filteration
  • Data blending
  • Dashboard Filter
  • Sets
  • Grouping
  • Analytics Dashboard
  • Quiz

CALCULATION

  • Numeric Calculations
  • String Calculations
  • Date Calculations
  • User Defined Calculations
  • Logical Calculations

STATISTICS

  • Control Charts
  • Statistical Measures
  • Box Plots

SQL

Module 1

  1. What is SQL?
  2. Why SQL?
  3. History
  4. SQL Process
  5. SQL Commands
  6. DDL – Data Definition Language
  7. DML – Data Manipulation Language
  8. DCL – Data Control Language
  9. DQL – Data Query Language

Module 2

  1. Create Table
  1. Alter Table
    1. Add Column
    2. Modify Column
    3. Rename Column
    4. Drop Column
    5. Add Constraint
    6. Drop Constraint
  2. SQL Data Types
  3. SQL SELECT
  4. SQL DISTINCT
  5. SQL WHERE
  6. SQL AND, OR
  7. SQL IN
  8. SQL bETWEEN
  9. SQL WILDCARD
  2. SQL LIKE
  3. SQL ORDER BY
  4. SQL GROUP BY
  5. SQL HAVING
  6. SQL ALIAS
  7. SQL INSERT INTO
  8. SQL INSERT INTO SELECT
  9. SQL UPDATE
  10. SQL DELETE

Module 3

  1. SQL Data Types
  2. Exact Numeric Data Types
  3. Approximate Numeric Data Types
  4. Date and Time Data Types
  5. Character Strings Data Types
  6. Unicode Character Strings Data Types
  7. Binary Data Types
  8. Misc Data Types
  1. SQL Operators
  2. What is an Operator in SQL?
  3. SQL Arithmetic Operators
  4. SQL Comparison Operators
  5. SQL Logical Operators
  1. SQL Expressions
  2. Syntax
  3. SQL – Boolean Expressions
  4. SQL – Numeric Expression
  5. SQL – Date Expressions

Module 4

  • SQL Joins
  • SQL Joins Types
    • INNER JOIN
      • Syntax
      • Example
    • LEFT JOIN
      • Syntax
      • Example
    • RIGHT JOIN
      • Syntax
      • Example
  • FULL JOIN
    • Syntax
    • Example
  • SELF JOIN
    • Syntax
    • Example
  • CARTESIAN JOIN
    • Syntax
    • Example

Module 5

  • SQL Unions Clause
    • Syntax
    • Example
  • The UNION ALL Clause:
    • Syntax
    • Example
  • SQL Date Functions
  • SQL Temporary Tables
  • SQL String Functions
  • Date Convert Functions
Tableau +  SQL Course Detail
Fees:
Rs 15,000

 

Class Mode:
Online

 

Duration:
2 Months

 

Course Contents:
Tableau +SQL (Basic +Advance)

 

Course Benefit:
Student will able to learn Advance Tableau with SQL

 

KEY FEATURES

2 Months of Classroom Training.

 

Session have assignments and daily task.

 

Recorded Videos and presentation for reference.

Books and related data sets in form of excel and csv.

 

Interview Questions for related topic.

 

Used Case Study and Projects to understand real scenarios.

CHOOSE YOUR COURSE

APPLY TO OUR CERTIFICATION COURSES NOW

Data
Science

Machine
Learning

Artificial
Intelligence

Python
Programming

R
Programming

Data
Visualization

Code Calibre