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

Udemy Business

Enseigner sur Udemy

Transformez vos connaissances en véritable opportunité et touchez des millions de personnes du monde entier.

Votre panier est vide.

Continuer vos achats

Se connecter

S’inscrire

Créé parPaul Scotchford

Dernière mise à jour : 03/2026

Anglais

Ce que vous apprendrez

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

Contenu du cours

26 sections • 314 sessions • 21 h 34 min de durée totale

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
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
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
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
Exercise 9.5 - Solution2:33
SELECT BETWEEN5:01
Return rows that sit in a range that you specify
Exercise 9.6 - SELECT BETWEEN0:49
Exercise 9.6 - Solution4:04
SELECT IS NULL3:40
How to handle NULL values in the query
Exercise 9.7 - SELECT IS NULL1:36
Exercise 9.7 - Solution1:30
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
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
Exercise 9.10 - Solution1:59
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
Exercise 9.11 - Solution2:12
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
Exercise 9.12 - Solution1:21
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
Exercise 10.1 - Solution1:40
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
Exercise 10.3 - Solution2:09
SELECT DATEDIFF()3:36
Finding the elapsed count between 2 dates
Exercise 10.4 - SELECT DATEDIFF()1:14
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
SELECT FORMAT()7:08
Formatting your output is pretty easy
Exercise 10.6 - FORMAT()0:51
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

Prérequis

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

À qui ce cours s'adresse-t-il ?

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

Ce que vous apprendrez

Découvrir les sujets associés

Contenu du cours

Introduction4 sessions • 17 min

Introduction to Microsoft SQL Server6 sessions • 52 min

Introduction to relational databases4 sessions • 30 min

The SQL Toolbox6 sessions • 35 min

SQL Terminology and Concepts3 sessions • 16 min

SQL - The First Steps25 sessions • 1 h 9 min

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

Loading the HR & Payroll transaction database3 sessions • 6 min

SQL SELECT Statement37 sessions • 1 h 34 min

SQL SELECT Using common functions22 sessions • 1 h 10 min

Prérequis

Description

À qui ce cours s'adresse-t-il ?