Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL Data Analytics with Tableau Data Visualisation

Name: SQL Data Analytics with Tableau Data Visualisation
Rating: 4.7 (518 reviews)

Deep dive SQL Server and data analytics queries. Followed by using Tableau to visualise the outputs from the queries

Created byPaul Scotchford

Last updated 6/2026

English

EnglishThai [Auto],

What you'll learn

Become highly competent in writing all types of SQL (simple to complex) preparing you for your BI Projects
With SQL skills learned here you can extract data from any Relational Database including Oracle,PostgreSQL,MySQL and many more
How to visualise the data using Tableau the most popular data visualisation & business intelligence tool out there
Write DDL, DCL, TCL code so you can create and manage your own database(s) from scratch
Be proficient in using SQL Server Management Studio to develop your data analysis solutions
Work with scenarios that prepare you for the questions that users will ask of their data, including gnarly & complex questions
Code table Joins from simple to complex so you will never be stuck in this again, a common stumbling block for SQL coders
Learn to create Primary and Foreign key constraints for data integrity
Learn the aggregation functions in SQL preparing data for visualisation
Write powerful Window functions such as LAG()
Every lecture is followed with an exercise for you to practice what you have learned in the previous lecture
Quizzes at the end of each section to test your knowledge
Data Visualisation via Tableau (Public) worksheets to incorporate into dashboards
Showcase a project dashboard based on your ideas and show this to anyone including prospective employers
Did I mention Triggers and Stored procedures ? Yes learn these too!
Understand the difference between old style dated SQL and ANSI SQL best practice
Learn how to make queries work better with Indexes for query performance enhancement
What are Common Table Expressions (CTE) find out how to code these and exploit them.
User defined functions and Table functions are very useful, you will learn to create and use these as well
Learn to code Cross Joins and how to leverage these in analysis
Learn about the SQL Server Architecture and SET Theory
How to Insert , Update and Delete data
Learning SQL also means you are becoming proficient in T-SQL
Data wrangling like you would do in the corporate environment
And many more topics

Course content

26 sections • 314 lectures • 21h 34m total length

Introduction to the course3:21
How to get the most from this course and apply what you learned , it is recommended you watch this lecture
What are Resource links ?1:15
A quick overview of how the resource links work
Tune your browser to get 1080p HD all of the time6:56
Sometimes the video player will get blurry due to adaptive streaming even though the course is recorded in 1080p HD, this lecture shows how to fix it permanently.
Installing SQL Server 2019 Express on your PC5:30
To code along in the course then you will need to download the free software from Microsoft. You can also download a Docker container for MAC.
Note: If you cannot install SQL 2019 then you can still use SQL 2014 and up.
Use the 2014 backup files offered in Section 8 and 22

Section 2 Overview1:59
What you will learn in this section and why it is important to understand these topics.
Why learn SQL using SQL Server ?9:21
See why SQL Server is #1 with large (and medium) enterprises and what are the 6 key skills for Data Analysts and Business Intelligence Developers
Whether you are working in Business Intelligence (BI), Data Science, Database Administration, or Back-End development, you will have to extract information from a server storing large amounts of data and to do this you’ll need SQL !
SQL Server architecture15:17
Understand the components that make up the SQL Server technology rather than thinking of it a just a black box. Showcase your knowledge and impress at your interview.
Working with SQL Server Management Studio - Pt 114:29
How to navigate and use the SSMS features
Create and Organise your T-SQL scripts5:41
How to organise your SQL files (Scripts) for easy reference and recall
What are system databases ?5:19
When you installed SQL Server it created system databases, lets explore what each one is for.
Quiz time

Section 3 Overview0:48
What you will learn in this section and why it is important to understand these topics.
The anatomy of a database12:00
Discuss the structure of a relational database
SQL is a Set Based Declarative language5:40
Why is this so ? Why is it not a procedural language ? These questions are answered in this lecture.
The primary method to retrieve data11:34
The journey to retrieve data starts with the SELECT statement, let's explore what this is.
Quiz Time

Section 4 Overview1:29
What you will learn in this section and why it is important to understand these topics.
SQL reserved key words5:16
Certain words (verbs) should not be used in certain places
DDL - Data Definition Language8:59
CREATE,ALTER,DROP,TRUNCATE are DDL statements
DML - Data Manipulation Language13:27
INSERT,UPDATE,DELETE & SELECT are DML statements
TCL - Transaction Control Language3:47
BEGIN TRANSACTION,COMMIT,ROLLBACK are TCL statements
DCL - Data Control Language1:33
GRANT,DENY,REVOKE are DCL statements
Quiz time

Section 6 Overview0:52
What you will learn in this section and why it is important to understand these topics.
Create a database using DDL3:32
Create a database using DDL
6.1 Exercise - Create a database using DDL0:25
A lab for you to practice with
6.1 Exercise - Solution0:48
Verify your work is correct
Create a table using DDL2:17
Add a table to your database using DDL
6.2 Exercise - Create a table using DDL0:30
Now add a table to the database using DDL
6.2 Exercise - Solution1:11
Verify your work is correct
What is a data type ?8:28
Lets get started with understanding the various data types and when to use them.
Insert table data using DML3:18
Explore the INSERT statement to add data to a table
6.3 Exercise - Add data to a different table0:37
You can add data to the table you previously created
6.3 Exercise - Solution2:47
Verify your work is correct
Update table data using DML3:30
In this lecture you will learn to Update data and the WHERE clause is introduced
6.4 Exercise - Update data0:35
Update a data table and introduce WHERE to the DML
6.4 Exercise - Solution1:52
Verify your work is correct
Rename the database using DDL4:47
Sometimes your database name needs to change as it evolves, how to do this with the DDL Alter Keyword. Impress with your knowledge at your next interview.
6.5 Exercise - Change the Database Name0:38
Try to rename the database yourself
6.5 Exercise - Solution2:09
Verify your work is correct
Alter a table using DDL4:38
Add a new column to a table and introducing Identity field types
6.6 Exercise - Add a new column to a table0:35
An exercise for you to add a new column
6.6 Exercise - Solution1:52
Verify your work is correct
Alter a column using DDL2:45
Change an attribute of a column using DDL
6.7 Exercise - Alter a column attribute using DDL0:31
Practice making a change to a table column
6.7 Exercise - Solution1:20
Verify your work is correct
Set Theory - Lesson 19:14
What does Set Theory have to do with SQL anyway ? A lot actually ; so lets explore this is more detail
Set Theory - Lesson 210:01
A deeper dive into the SET operators
Quiz time

Section 7 Overview0:42
What you will learn in this section and why it is important to understand these topics.
How to backup a database4:46
Backups are insurance protection for your hard work and data
How to duplicate a database4:52
Here we can duplicate a database easily (not using restore for this)
Use DDL to drop a database2:30
Here we see DDL and Object Explorer database deletion
How to restore a database3:13
Restore that database we deleted
Quiz time

Exercise 8.1 - Restore the HR database backup2:24
Starting this section with an exercise to test your restore database knowledge, we'll use this database for subsequent sections so it is recommended that you proceed with the restore.
8.1 Exercise - Solution1:19
A step by step walk-through for you to check against
An overview of the HR & Payroll database content2:45
A quick summary of this database content. It is a large database with an excellent sample data set to work with.

Section 9 Overview1:49
What you will learn in this section and why it is important to understand these foundation topics.
SELECT FROM2:04
Refresh with a basic Query first
Exercise 9.1 - SELECT FROM0:35
Practice a basic select to display the gender name values from the gender table in Management Studio.
Exercise 9.1 - Solution1:52
SELECT WHERE2:27
How to use the WHERE clause to declare what data you want
Exercise 9.2 - SELECT WHERE0:47
Extract engineer employee numbers from the employee position history by applying a select where filter to match the engineer position.
Exercise 9.2 - Solution3:40
Verify your work is correct - lets explore lateral thinking in this scenario , a requirement for analysts at large
SELECT AND6:23
Using the AND operator in the WHERE condition and introducing Order By and a logical operator.
Exercise 9.3 - SELECT AND0:32
Practice using a select query with an and condition on the current personnel table to retrieve employees earning over 50,000 who are located in Beverly Hills.
Exercise 9.3 - Solution1:51
SELECT OR7:46
Using the OR operator in the WHERE condition and introducing ORDER BY Ordinal and another logical operator.
Incorporating the AND make sure you get the precedence right or your results will look odd !
Exercise 9.4 - SELECT OR1:06
Check your skill with a slight variation to the question being asked! How will you respond to the exercise scenario , this tests lateral minded thinking?
Exercise 9.4 - Solution3:17
SELECT IN / NOT IN4:54
Did you know you can replace the OR with IN & NOT IN operator ?
Exercise 9.5 - SELECT IN / NOT IN1:17
Validate that current personnel records have corresponding entries in the employees table using the Emp number as the key, via select in and not in.
Exercise 9.5 - Solution2:33
SELECT BETWEEN5:01
Return rows that sit in a range that you specify
Exercise 9.6 - SELECT BETWEEN0:49
Query the HR data to return female employees hired between 2014-12-31 and 2016-12-31, including employee number, gender, first name, last name, and hire date, sorted by last name.
Exercise 9.6 - Solution4:04
Build a base query selecting employees, profile the data, filter for female by gender, apply between on hire date between 2014-12-31 and 2016-12-31, then order by hire date.
SELECT IS NULL3:40
How to handle NULL values in the query
Exercise 9.7 - SELECT IS NULL1:36
Exercise 9.7 - Solution1:30
Build a base SQL query to identify records with null sid_employee in the employee_location table, include sid_employee for validation, and verify the 114,612 row count to ensure data integrity.
SELECT LIKE7:33
Looking for patterns in the column value
Exercise 9.8 - SELECT LIKE0:25
Test you knowledge but there is a twist in this seemingly simple exercise , will you detect it ?
Exercise 9.8 - Solution2:17
Build and run a basic employee query to select emp number, first name, last name, and gender. Filter for males and for names beginning with lv using the like operator.
SELECT WHERE ... Boolean5:17
Using comparison operators the return a Boolean data type
Exercise 9.9 - SELECT WHERE ... Boolean0:33
Test your knowledge and lateral thinking.
Exercise 9.9 - Solution2:08
Did you deduce that we can use another method as well?
SELECT Distinct1:47
Removing duplicate rows from the rowset
Exercise 9.10 - SELECT Distinct0:25
Apply select distinct to retrieve unique first and last names from the employees table, and order results by first name and last name to fulfill the HR request.
Exercise 9.10 - Solution1:59
Create a distinct list of first and last names from the employees table, ordered by first name and last name, removing duplicate rows with the distinct clause.
SELECT AS2:48
Using a column alias to rename an output column as well as using a table alias which is common to use in Joining tables
Exercise 9.11 - SELECT AS0:33
Extract cities and state provinces from the geography table, alias the state province as state, alias the output as dimGeo, and sort the list by country.
Exercise 9.11 - Solution2:12
Build a query selecting city and state province name from geography, alias geography to dim geo, order by country region name, even if not in the select list, noting duplicates.
SELECT TOP4:29
Limit the number of records returned from a query so that we do not impact performance when testing big queries
Exercise 9.12 - SELECT TOP0:53
Test your query against the salary history table, measure execution time for a raw current salary select, then reduce the row set with top 50,000 and compare results.
Exercise 9.12 - Solution1:21
The lecture demonstrates evaluating a salary history query's performance, showing around three seconds for nine hundred thousand rows and under a second for top 50,000, with mitigation and Q&A sharing.
Quiz time

Section 10 Overview2:40
What you will learn in this section and why it is important to understand these foundation topics.
SELECT CASE6:51
How to build a CASE statement to bucket (Discretize) data, a common exercise in Data Analysis
Exercise 10.1 - SELECT CASE0:53
Expand the previous salary status using a select case to classify salaries between 30,000 and 50,000 as junior and 50,001 to 99,999 as senior.
Exercise 10.1 - Solution1:40
Apply the SQL case statement to assign paid jr. and paid senior statuses for salary ranges, verify results, and practice conditional logic in data analytics with Tableau.
SELECT YEAR()3:58
Return a Year, Month, Day value from the selected date(s)
Exercise 10.2 - SELECT YEAR()0:45
Exercise 10.2 - Solution1:58
SELECT DATEPART()8:41
Convert dates to their integer parts and you'll be shown how to return text value from the date , there is a twist in this that often catches analysts out!
Exercise 10.3 - SELECT DATEPART()1:05
Use date part to break position from date into year and week. Then sort by year and week to list employees with emp number, position, and position from date.
Exercise 10.3 - Solution2:09
Build a basic sql select from the employee position history, add emp number, position, and position from date, compute year and week, then order by year and week.
SELECT DATEDIFF()3:36
Finding the elapsed count between 2 dates
Exercise 10.4 - SELECT DATEDIFF()1:14
Explore how to use the datediff function to add a new field showing how long employees have been in their jobs, improving accuracy in HR data.
Exercise 10.4 - Solution1:59
SELECT DATEADD()4:14
Calculating dates to define past and future dates
Exercise 10.5 - SELECT DATEADD()1:01
Exercise 10.5 - Solution3:47
Filter the dataset for January through March using date part and between, then compute the previous pay date with date add by subtracting seven days.
SELECT FORMAT()7:08
Formatting your output is pretty easy
Exercise 10.6 - FORMAT()0:51
Use the format() function to format payroll amounts in UK pounds and dates in UK format, applying changes to next and previous pay dates, per the UK locale documentation.
Exercise 10.6 - Solution2:24
SELECT CONCAT()6:37
Join 2 or more columns to form a concatenated string value to tell a story
Exercise 10.7 - SELECT CONCAT()0:57
Write a story line and recall a function shown briefly in an earlier lecture, this is a challenge to think outside of the box!
Exercise 10.7 - Solution5:14
Quiz time

Requirements

No prior experience is required as we will start with the basics.
Some resources maybe located on Dropbox or GitHub due to file size constraints

Description

Please note, some of the resources in this course are located on Dropbox or GitHub, hence you will need to use the supplied URL to download files e.g. Software

Unlock Your Potential with Advanced SQL Data Analytics Skills!

In today's data-driven world, SQL is not just useful—it's essential.

Mastering SQL means you're capable of tapping into 90% of what's required for impactful data analysis.

But how do you present this data?

That's where our comprehensive SQL Data Analytics course comes in, covering everything from database design to data visualization with tools like Tableau.

Why Enrol?

Expert-led Curriculum: Learn from a top industry professional with real-world experience.
Hands-On Learning: Engage with extensive practice assignments and section quizzes that mirror real job scenarios.
Progressive Difficulty: Start with the basics and gradually advance to complex concepts.
Interactive Visualizations: Master creating compelling data visualizations to communicate insights effectively in Tableau.
Certification Ready: Equip yourself with the knowledge to ace interviews and secure that six-figure salary.
Whether you're starting from zero or looking to enhance your skills, this course offers a detailed path to becoming a proficient data analyst. My Udemy courses have already assisted over 130,000 students in achieving their learning goals.

Ready to Begin?

Explore the curriculum and see how this course stands out.

With a 30-day money-back guarantee, you have nothing to lose but all to gain in your professional journey.

Enroll now and start transforming data into decisions!

Looking forward to seeing you in the course.

Paul

Data Analyst and Visualisation Engineer

Who this course is for:

Anyone looking to learn SQL from scratch to becoming highly competent
Anyone looking to refresh or enhance existing skills

SQL Data Analytics with Tableau Data Visualisation

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 17min

Introduction to Microsoft SQL Server6 lectures • 52min

Introduction to relational databases4 lectures • 30min

The SQL Toolbox6 lectures • 35min

SQL Terminology and Concepts3 lectures • 16min

SQL - The First Steps25 lectures • 1hr 9min

SQL Server Basic House Keeping to protect your data5 lectures • 16min

Loading the HR & Payroll transaction database3 lectures • 6min

SQL SELECT Statement37 lectures • 1hr 34min

SQL SELECT Using common functions22 lectures • 1hr 10min

Requirements

Description

Who this course is for: