Tutors

Innomatics Research Labs

PROGRAM OVERVIEW

CURRICULUM

  MySql

  • MySql Installation Processor
  • MySql Installation Processor Doc File
  • Intro to DataBase and SQL
  • SQL Introduction File
  • SQL Lab - 1
  • SQL Lab - 1 File
  • SQL Lab - 2
  • SQL Lab - 2 Files
  • SQL Lab - 3
  • SQL Lab - 3 Files
  • SQL Lab - 4
  • SQL Lab - 4 Files
  • SQL Lab - 5 Joins Merges Concepts
  • SQL Lab - 5 Files
  • SQL Lab - 6
  • SQL Lab - 6 Files
  • SQL Lab - 7
  • SQL Lab - 7 Files

  Tableau

  • Introduction to Tableau and Data Types
  • Day 2 - Various Filters and Data Manipulations
  • Day 3 - Advance filters, parameters, mark tab, calculated field, dual axis
  • Day 1 , Day 2 and Day 3 Class Files
  • Day 4 - Analytics in Tableau
  • Day 5 - Tooltips, Dual Asix, Geo Plots, Actions on worksheet Pages
  • Day 6 - Dashboard ( Formatting, navigation ) Story Board and Publishing of Tableau Workbook
  • Day 7: Advance Charts, LIVE PROJECT and Assignment Explanation
  • Tableau All Classes Complete Lab File
  • Tableau Dashboard Assignment

  SQL Module (on-going)

  • MySQL Installation Step by Step Procedure
  • MySql Installation Processor File
  • SQL 1 - Intro to SQL, Roles and Importance & RDMS and its Models
  • RDBMS - Advantages & disadvantages types of normalization Basics of SQL structs(DDL DML ETC)
  • Intro to SQL , Structs in SQL Constraints in SQL, Data Types in SQL Hands-on session on DDL
  • DML DCL TCL Sql operators Sql functions
  • HR Schema Database File
  • SQL Basic and HR Employee Lab - Part 1 File
  • SQL Part-1- Database Management System and Normalization PDF File
  • SQL Part-2 Basic SQL_Subset_Operators_Functions_SetOperators_Joins PDF
  • Complete Lab on all the Basic and Group by Order by Using HR Employee - Part 1
  • Lab - join Rank Rank dense concept Sub query
  • Lab File - join Rank Rank dense concept Sub query

  Tableau Module

  • Introduction to Tableau and Desktop Tableau Data Types
  • tableau_intro and data types PDF
  • Sorting Files Types Grouping Data Relationship Filters
  • Day 1 & 2 Lab Files
  • Calculated Fields Tableau Calculation Logical Functions Shapes Font Shading functionalities
  • Number & String Functions Actions on Worksheets Dual axis Models and Forecasting
  • Reference Line & band Clustering Filters at Worksheet level Dash Board making and Story boards
  • Tableau July 11th - 15th Class Lab Files
  • Special chart and Creating COVID dashboard

  SQL

  • MySql Installation Processor
  • MySQL Installation Processor Doc File
  • Intro to Data Base and SQL
  • SQL Introduction File
  • SQL Lab - 1
  • SQL Lab - 1 File
  • SQL Lab - 2
  • SQL Lab - 2 Files
  • SQL Lab - 3
  • SQL Lab - 3 Files
  • SQL Lab - 4
  • SQL Lab - 4 Files
  • SQL Lab - 5 Joins Merges Concepts
  • SQL Lab - 5 Files
  • SQL Lab - 6
  • SQL Lab - 6 Files
  • SQL Lab - 7
  • SQL Lab - 7 Files