infyni

Tableau and SQL Concepts

Tableau and SQL Concepts

Live Course

Duration: 3 Hours

Enrolled: 0

Offered by: infyni

Live Course

$150

Coming Soon Notify Me

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
  • Instructor (1)
1 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

...
Rajesh Nichenametla
About Instructor

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.

0

Rating

0

Review

9

Students

2

Courses