MySQL and Tableau

Duration: 10 Hours

About Course

Learn how to connect Tableau with MySQL database and then analyze the data to get insights.

All the data is recorded and most of the times stored in files called databases and an essential task of a Data Analyst is to be able to access data from databases and then analyze them. Most of the ETL tools that tend to help in the cleaning part are actually running SQL commands under the hood. So having knowledge of MySQL can be quite a valuable resource for a Tableau user.

Topics - covered in the course

Introduction to Database and MySQL

•  Introduction to SQL Database and terminology
•  Installing MySQL and getting acquainted with basic structure
•  MySQL Constraints

•  Introduction to DML in MySQL
•  How to Insert,Update,Delete records in Tables

•  Introduction to Functions 
•  COUNT,Group BY, MIN, MAX, ,SUM, Average functions used in My SQL

•  SELECT,SELECT DISTINCT,ORDER BY,WHERE
•  Operators AND,OR,IN,BETWEEN
•  LIKE,LIMIT,IS NULL
•  Table & Column Aliases
•  Joins INNER JOIN, LEFT JOIN,RIGHT JOIN,Self Join,CROSS JOIN
•  GROUP BY,HAVING
•  Subquery, Derived Tables
•  EXISTS,UNION,MINUS,INTERSECT
•  INSERT,INSERT INTO SELECT, Insert On Duplicate Key Update,INSERT IGNORE
•  UPDATE,UPDATE JOIN
•  DELETE,DELETE JOIN,ON DELETE CASCADE,REPLACE

•  IF statements
•  CASE statements
•  Basic LOOP statement
•  SQL Exception
•  SELECT INTO – fetch a single row from a table into variables.

•  Introduction to Tableau and Combining SQL & Tableau
•  Installation Tableau Software
•  Connecting MySQl with Tableau

•  Analysis in Tableau of data from MySQL
Course is coming soon!
₹4500
₹11250 60% off

Course Offerings

  • Instructor Led Live sessions
  • Clarify doubts during session
  • Access Session Recordings
  • Attend on mobile and Tablet
  • Project reviews by Instructor
  • Direct Messages
  • Feedback from Instructor
  • Full lifetime Resources
  • Certificate of Completion
  • Employability opportunity