infyni

MySQL and Tableau

Our comprehensive training programme combines live and online lectures to give you a solid foundation in MySQL database administration and Tableau data visualization. Learn how to construct and query databases efficiently with MySQL and how to create interactive visualizations with Tableau

Live Course

Live Class: Saturday, 09 Mar

Duration: 10 Hours

Enrolled: 100

Offered by: infyni

Live Course
$375 20% off

$300

Enroll Now Join Free Demo

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
1 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
  • 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