Data Analytics Masterclass - Using SQL & Tableau
Course Description
Learn how to analyze data using SQL and Tableau. This course teaches you how to query databases, clean and transform data, and create powerful visual dashboards for data-driven decision-making.
This course provides a comprehensive introduction to data analytics using SQL and Tableau, two of the most in-demand tools in the data industry. You will begin by learning SQL, where you’ll understand how to query databases, filter and manipulate data, perform joins, and aggregate results to extract meaningful insights. The course then transitions into data visualization using Tableau, where you’ll learn how to transform raw data into interactive dashboards and compelling visual stories. Through hands-on projects, you will work with real-world datasets to develop practical skills in data cleaning, analysis, and visualization. By the end of the course, you will be able to confidently analyze data, uncover trends, and present insights that support business decisions. This course is ideal for beginners, aspiring data analysts, business professionals, and anyone looking to build a strong foundation in data analytics.
Requirements
What You Will Learn
Course Modules
Video
Introduction to SQL
Video
How to Access a Database, Select Columns, Create Tables & Insert Data (Beginner Guide)
Video
Creating Tables, Inserting Data, WHERE Clause & Logical Operators Explained
Video
Creating Tables, Auto-Increment Primary Keys, Dates, DISTINCT, CONCAT & LIKE Operators Explained
Video
Master Aggregate Functions, GROUP BY, ORDER BY, USE OF BACKTICK, ALIAS, & LIMIT Using Online Sales Data
Video
Interactive School Database Tutorial with Solved Practice Questions
Video
Mastering NULL Values in SQL & How to Update Tables Like a Pro
Video
SQL Update Statement, Delete Transaction, Commit and Rollback
Video
SQL Subquery
Video
SQL Joins (Inner Joins)
Video
From Confusion to Clarity: Understanding SQL Joins Deeply
Video
SQL INNER, LEFT & RIGHT JOIN Explained Simply for Data Analysts
Video
SQL Cross Join, Case Statement or Case Expression
Video
SQL Data Cleaning Explained | Essential Skills for Data Analysts
Video
SQL for Data Analysis: Data Modeling & Ranking Explained Step-by-Step
Video
Tableau Introduction: Learn Tableau the Simple Way
Video
Master Tableau Workflow: Import Data, Perform Analysis & Create Dashboards
Material
Download the Dataset I Used for This Tableau Analysis (Free Link)
Video
Airbnb Data Analytics Project in Tableau | End-to-End Portfolio Project
Video
How to Analyze Call Center Data in Tableau Without Building a Dashboard
Mary Godwin
Expert Instructor
Student Reviews
No Reviews Yet
Be the first to review this course!
One-time payment