MySQL and Tableau

Learn how to combine the two most important tools in data science: SQL, and Tableau

Duration: 10 Hours

Offered by: infyni

$412 20% off

$329

Coming Soon Notify Me

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.

Skills You Will Gain

Binary Classification Data Analysis Tableau Software SQL Business Analysis Business Analytics Business Process Microsoft Excel Linear Regression Data Visualization

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of Completion
  • Employability Opportunity
  • Topics
  • Instructor
  • 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
  • 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