Home

All courses

SQL Data Analytics with Tableau Data Visualisation

Business

Business Intelligence

Business Analytics & Intelligence

SQL Data Analytics with Tableau Data Visualisation

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

4.7

(487)

3796 enrolled on this course

Last updated 11/2021

None

₹ 3699.0

₹ 5199.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

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

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

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Introduction to the course

1.2-What are Resource links ?

1.3-Tune your browser to get 1080p HD all of the time

1.4-Installing SQL Server 2019 Express on your PC

2-Introduction to Microsoft SQL Server

2.1-Section 2 Overview

2.2-Why learn SQL using SQL Server ?

2.3-SQL Server architecture

2.4-Working with SQL Server Management Studio - Pt 1

2.5-Create and Organise your T-SQL scripts

2.6-What are system databases ?

2.7-Quiz time

3-Introduction to relational databases

3.1-Section 3 Overview

3.2-The anatomy of a database

3.3-SQL is a Set Based Declarative language

3.4-The primary method to retrieve data

3.5-Quiz Time

4-The SQL Toolbox

4.1-Section 4 Overview

4.2-SQL reserved key words

4.3-DDL - Data Definition Language

4.4-DML - Data Manipulation Language

4.5-TCL - Transaction Control Language

4.6-DCL - Data Control Language

4.7-Quiz time

5-SQL Terminology and Concepts

5.1-Section 5 Overview

5.2-Database Types

5.3-Primary and Foreign Keys - A primer

5.4-Quiz time

6-SQL - The First Steps

6.1-Section 6 Overview

6.2-Create a database using DDL

6.3-6.1 Exercise - Create a database using DDL

6.4-6.1 Exercise - Solution

6.5-Create a table using DDL

6.6-6.2 Exercise - Create a table using DDL

6.7-6.2 Exercise - Solution

6.8-What is a data type ?

6.9-Insert table data using DML

6.10-6.3 Exercise - Add data to a different table

6.11-6.3 Exercise - Solution

6.12-Update table data using DML

6.13-6.4 Exercise - Update data

6.14-6.4 Exercise - Solution

6.15-Rename the database using DDL

6.16-6.5 Exercise - Change the Database Name

6.17-6.5 Exercise - Solution

6.18-Alter a table using DDL

6.19-6.6 Exercise - Add a new column to a table

6.20-6.6 Exercise - Solution

6.21-Alter a column using DDL

6.22-6.7 Exercise - Alter a column attribute using DDL

6.23-6.7 Exercise - Solution

6.24-Set Theory - Lesson 1

6.25-Set Theory - Lesson 2

6.26-Quiz time

7-SQL Server Basic House Keeping to protect your data

7.1-Section 7 Overview

7.2-How to backup a database

7.3-How to duplicate a database

7.4-Use DDL to drop a database

7.5-How to restore a database

7.6-Quiz time

8-Loading the HR & Payroll transaction database

8.1-Exercise 8.1 - Restore the HR database backup

8.2-8.1 Exercise - Solution

8.3-An overview of the HR & Payroll database content

9-SQL SELECT Statement

9.1-Section 9 Overview

9.2-SELECT FROM

9.3-Exercise 9.1 - SELECT FROM

9.4-Exercise 9.1 - Solution

9.5-SELECT WHERE

9.6-Exercise 9.2 - SELECT WHERE

9.7-Exercise 9.2 - Solution

9.8-SELECT AND

9.9-Exercise 9.3 - SELECT AND

9.10-Exercise 9.3 - Solution

9.11-SELECT OR

9.12-Exercise 9.4 - SELECT OR

9.13-Exercise 9.4 - Solution

9.14-SELECT IN / NOT IN

9.15-Exercise 9.5 - SELECT IN / NOT IN

9.16-Exercise 9.5 - Solution

9.17-SELECT BETWEEN

9.18-Exercise 9.6 - SELECT BETWEEN

9.19-Exercise 9.6 - Solution

9.20-SELECT IS NULL

9.21-Exercise 9.7 - SELECT IS NULL

9.22-Exercise 9.7 - Solution

9.23-SELECT LIKE

9.24-Exercise 9.8 - SELECT LIKE

9.25-Exercise 9.8 - Solution

9.26-SELECT WHERE ... Boolean

9.27-Exercise 9.9 - SELECT WHERE ... Boolean

9.28-Exercise 9.9 - Solution

9.29-SELECT Distinct

9.30-Exercise 9.10 - SELECT Distinct

9.31-Exercise 9.10 - Solution

9.32-SELECT AS

9.33-Exercise 9.11 - SELECT AS

9.34-Exercise 9.11 - Solution

9.35-SELECT TOP

9.36-Exercise 9.12 - SELECT TOP

9.37-Exercise 9.12 - Solution

9.38-Quiz time

10-SQL SELECT Using common functions

10.1-Section 10 Overview

10.2-SELECT CASE

10.3-Exercise 10.1 - SELECT CASE

10.4-Exercise 10.1 - Solution

10.5-SELECT YEAR()

10.6-Exercise 10.2 - SELECT YEAR()

10.7-Exercise 10.2 - Solution

10.8-SELECT DATEPART()

10.9-Exercise 10.3 - SELECT DATEPART()

10.10-Exercise 10.3 - Solution

10.11-SELECT DATEDIFF()

10.12-Exercise 10.4 - SELECT DATEDIFF()

10.13-Exercise 10.4 - Solution

10.14-SELECT DATEADD()

10.15-Exercise 10.5 - SELECT DATEADD()

10.16-Exercise 10.5 - Solution

10.17-SELECT FORMAT()

10.18-Exercise 10.6 - FORMAT()

10.19-Exercise 10.6 - Solution

10.20-SELECT CONCAT()

10.21-Exercise 10.7 - SELECT CONCAT()

10.22-Exercise 10.7 - Solution

10.23-Quiz time

11-SQL JOINS - Foundation

11.1-Section 11 Overview

11.2-INNER JOIN

11.3-Exercise 11.1 - INNER JOIN

11.4-Exercise 11.1 - Solution

11.5-LEFT JOIN

11.6-Exercise 11.2 - LEFT JOIN

11.7-Exercise 11.2 - Solution

11.8-RIGHT JOIN

11.9-Exercise 11.3 - RIGHT JOIN

11.10-Exercise 11.3 - Solution

11.11-FULL JOIN

11.12-Exercise 11.4 - FULL JOIN

11.13-Exercise 11.4 - Solution

11.14-SQL Best Practice

11.15-Quiz time

12-SQL JOINS - Advanced

12.1-Section 12 Overview

12.2-INNER JOIN - Advanced

12.3-Exercise 12.1 - INNER JOIN - Advanced

12.4-Exercise 12.1 - Solution

12.5-INNER JOIN & LEFT JOIN Combo

12.6-Exercise 12.2 - INNER JOIN & LEFT JOIN Combo

12.7-Exercise 12.2 - Solution

12.8-SELF JOIN (Part 1)

12.9-SELF JOIN (Part 2)

12.10-Exercise 12.3 - SELF JOIN

12.11-Exercise 12.3 - Solution

12.12-Quiz time

13-SQL Views

13.1-Section 13 Overview

13.2-Create a view

13.3-Exercise 13.1 - Create a view

13.4-Exercise 13.1 - Solution

13.5-Create a view using DDL

13.6-Exercise 13.2 - Create a view using DDL

13.7-Exercise 13.2 - Solution

13.8-Quiz time

14-SQL Insert - Advanced Technique

14.1-Section 14 Overview

14.2-INSERT to create a table

14.3-Exercise 14.1 - INSERT to create a table

14.4-Exercise 14.1 - Solution

14.5-INSERT new data to an existing table (Pt-1)

14.6-INSERT new data to an existing table (Pt-2)

14.7-INSERT new data to an existing table (Pt-3)

14.8-INSERT new data to an existing table (Final)

14.9-Exercise 14.2 - INSERT new data to an existing table

14.10-Exercise 14.2 - Solution

14.11-Quiz time

15-SQL Update - Advanced Technique and TCL

15.1-Section 15 Overview

15.2-UPDATE data via a Join

15.3-Exercise 15.1 - UPDATE data via a Join

15.4-Exercise 15.1 - Solution

15.5-UPDATE with data conversion

15.6-Exercise 15.2 - UPDATE with data conversion

15.7-Exercise 15.2 - Solution

15.8-UPDATE Commit/Rollback (TCL)

15.9-Exercise 15.3 - UPDATE Commit/Rollback (TCL)

15.10-Exercise 15.3 - Solution

15.11-Quiz time

16-SQL DELETE and TCL

16.1-Section 16 Overview

16.2-DELETE table data

16.3-TRUNCATE Table

16.4-Quiz time

17-SQL Constraints

17.1-Section 17 Overview

17.2-The Primary Key

17.3-Exercise 17.1 - The Primary Key

17.4-Exercise 17.1 - Solution

17.5-The Foreign Key

17.6-Exercise 17.2 - The Foreign Key

17.7-Exercise 17.2 - Solution

17.8-DEFAULT

17.9-Exercise 17.3 - DEFAULT

17.10-Exercise 17.3 - Solution

17.11-CHECK

17.12-Exercise 17.4 - CHECK

17.13-Exercise 17.4 - Solution

17.14-NOT NULL

17.15-Quiz time

18-SQL Aggregations

18.1-Section 18 Overview

18.2-COUNT

18.3-Exercise 18.1 - COUNT

18.4-Exercise 18.1 - Solution

18.5-COUNT DISTINCT

18.6-Exercise 18.2 - COUNT DISTINCT

18.7-Exercise 18.2 - Solution

18.8-SUM

18.9-Exercise 18.3 - SUM

18.10-Exercise 18.3 - Solution

18.11-AVG

18.12-Exercise 18.4 - AVG

18.13-Exercise 18.4 - Solution

18.14-MIN/MAX

18.15-Exercise 18.5 - MIN/MAX

18.16-Exercise 18.5 - Solution

18.17-HAVING

18.18-Exercise 18.6 - HAVING

18.19-Exercise 18.6 - Solution

18.20-Quiz time

19-SQL Programmability

19.1-Section 19 Overview

19.2-SQL Variables

19.3-Exercise 19.1 - SQL Variables

19.4-Exercise 19.1 Solution

19.5-STORED PROCEDURE

19.6-Exercise 19.2 - STORED PROCEDURE

19.7-Exercise 19.2 - Solution

19.8-The SCHEMA and DCL for Security

19.9-TRIGGERS - Part 1

19.10-TRIGGERS - Final

19.11-Exercise 19.3 - TRIGGERS

19.12-Exercise 19.3 - Solution

19.13-STRING Functions - Len()

19.14-STRING Functions - Left()

19.15-STRING Functions - Charindex()

19.16-STRING Functions - Replace()

19.17-SCALAR (udf) Function

19.18-Exercise 19.4 - SCALAR (udf) Function

19.19-Exercise 19.4 - Solution

19.20-TABLE (udf) Function

19.21-Exercise 19.5 - TABLE (udf) Function

19.22-Exercise 19.5 - Solution

19.23-Quiz time

20-SQL Xtras

20.1-Section 20 Overview

20.2-WHILE Loops

20.3-Exercise 20.1 - WHILE Loops (Part 1)

20.4-Exercise 20.1 - Solution (Part 1)

20.5-Exercise 20.2 - WHILE Loops (Part 2)

20.6-Exercise 20.2 - Solution (Part 2)

20.7-EXISTS

20.8-Exercise 20.2 - EXISTS

20.9-Exercise 20.2 - Solution

20.10-Quiz time

21-SQL Query Performance

21.1-The Basics

21.2-INDEX

21.3-Exercise 21.1 - INDEX

21.4-Exercise 21.1 - Solution

21.5-Quiz time

22-Download the eCommerce Database ,Download & Install Tableau

22.1-Restore the database

22.2-Overview of the eCommerce data

22.3-Register and download Tableau (Free)

23-Getting SQL Server Data into Tableau

23.1-Section 23 Overview

23.2-How to load SQL Server data to Tableau

23.3-The Tableau Workspace

23.4-The Tableau Data Model

23.5-Exercise 23.1 - Loading your model

23.6-Exercise 23.1 - Solution

23.7-Quiz time

24-Hands on with Tableau dashboards (using a real project)

24.1-Section 24 Overview

24.2-Design analysis life cycle

24.3-Identify your data to use in the dashboard

24.4-SQL Query - Single metric

24.5-Tableau View - Single metric

24.6-Exercise 24.1 - Single Metric

24.7-Exercise 24.1 - Single metric solution

24.8-SQL Query - Dimension analysis & metric

24.9-Tableau View - Dimension & metric

24.10-Exercise 24.2 - Dimension analysis & metric

24.11-Exercise 24.2 - Dimension analysis & metric solution

24.12-SQL Query - Multipart calculation

24.13-Tableau View - Visualise the result

24.14-Exercise 24.3 - Multipart calculation

24.15-Exercise 24.3 - Multipart calculation solution

24.16-SQL Query - Final multipart calculation

24.17-Tableau View - Visualise the final result

24.18-Exercise 24.4 - Multipart calculation with a twist

24.19-Exercise 24.4 - Multipart calculation with a twist solution

24.20-Adding Tableau filters

24.21-Exercise 24.5 - Add a final filter

24.22-Exercise 24.5 - Add a final filter solution

24.23-Tableau Dashboard #1 Formatting

24.24-Tableau Dashboard #1 Assembly

24.25-Exercise 24.6 - Tableau Dashboard #2 Assembly

24.26-Exercise 24.6 - Dashboard #2 Solution

24.27-Quiz time

25-Complex SQL Queries and Tableau Visualisations

25.1-Section 25 Overview

25.2-Dashboard requirements specification

25.3-Identify your data to use in the dashboard

25.4-Initial Data Prep & Extract

25.5-Exercise 25.1 - Adjust the query for more columns

25.6-Exercise 25.1 - Query solution

25.7-Commence Dashboard #1 development

25.8-Exercise 25.2 - Add a measure and table calculation

25.9-Exercise 25.2 - Label & Calculation solution

25.10-SQL - OVER clause

25.11-Tableau View - Dual Axis charting

25.12-Exercise 25.3 - OVER clause & chart

25.13-Exercise 25.3 - OVER clause & chart solution

25.14-SQL - LAG () OVER Clause (Pt 1)

25.15-SQL - LAG() OVER Clause (Pt 2)

25.16-Tableau View - Chart the output

25.17-Exercise 25.4 - LAG() OVER

25.18-Exercise 25.4 - LAG() OVER Solution

25.19-SQL - OVER (Preceding) clause

25.20-Tableau View - Visualise the MVA output

25.21-Exercise 25.5 - OVER (Preceding)

25.22-Exercise 25.5 - OVER (Preceding) solution

25.23-SQL - CROSS JOIN (Pt 1)

25.24-SQL - CROSS JOIN (Pt 2)

25.25-Tableau View - Visualise the cross join results

25.26-Exercise 25.6 - CROSS JOIN

25.27-Exercise 25.6 - CROSS JOIN solution

25.28-SQL - CTE (Common Table Expression) (Pt 1)

25.29-SQL - CTE (Common Table Expression) (Pt 2)

25.30-Tableau - Visualise the CTE measures

25.31-Exercise 25.7- CTE

25.32-Exercise 25.7 - CTE solution

25.33-Tableau - Geo analytics

25.34-Exercise 25.8 - Geo analytics

25.35-Exercise 25.8 - Geo analytics solution

25.36-Tableau - Performance Dashboard #1 Assembly

25.37-Exercise 25.9 Tableau - Performance Dashboard #2

25.38-Exercise 25.9 Tableau - Performance Dashboard #2 my take

25.39-Quiz time

25.40-How to retrieve your quiz score based achievement certificate

26-The Showcase Project

26.1-Showcase public project specification

Course Categories

Popular Courses

SQL Data Analytics with Tableau Data Visualisation

Description

What you'll learn

Requirements

Course Content

You May Like