Tableau and SQL Concepts

Live Class: 30 Oct 2020

Enrolled: 2

Duration: 3 Hours

About Course

Learn how to work with Tableau and SQL 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 SQL

•  Introduction to SQL Database and terminology
•  Installing MySQL and getting acquainted with basic structure
•  SQL 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

About Instructor

0 Rating

0 Reviews

9 Students

2 Courses

Rajesh Nichenametla

I am a technology educator, specializing in cloud and DevOps as well as an experienced professional. I have led technology strategy initiatives and teams in such diverse domains. I am a lifelong student who strongly believes that education is the most powerful way to change the world.

Enrollment Closed!
₹12000

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