SQL Server 2019 Data Analytics & Tableau Data Visualisation

Learn SQL for Business & Statistical Analysis, Marketing, Data Management and BI

4.37 (414 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
SQL Server 2019 Data Analytics & Tableau Data Visualisation
3,220
students
21.5 hours
content
Jun 2020
last update
$84.99
regular price

What you will 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

Develop Tableau worksheets to incorporate into dashboards

Create your own dashboard based on your own learning from the course

Showcase a project dashboard based on your ideas and show this to anyone including prospective employers

Approaching interviews and their inherent catch and scenario questions

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

Description

Knowledge is power , right ?

Not quite ! , it's potential power, like a battery , electrical charge waiting to be used in a device.

The same applies to your knowledge!

Do you think database design, SQL Knowledge and data visualisation is important in our age of big data and analytics ?

Well it is ! in fact SQL accounts for 90% of the requirements to perform data analysis and then how do we present the data ?

100% of the time us analysts present data graphically using software for example Tableau, QlikSense, Python, R, SAS and more

Are there enough people to fill the current job market in the data analysis world ?

No, the demand is growing ! And until relational databases die off then we will always need SQL Skills !

For the most part Data Analysts can command 6 figure salaries and more if you are top of the game. My pay for 2019 was the top end of 6 figures!

Are you concerned that you have no experience in this area , yet !?

Don't be !  everyone heading into Data Analysis and Visualisation has to start somewhere !

So why buy this course as there is a lot to choose from !?

Because this course is comprehensive , in other words it is detailed enough to get started and gradually work up to the advanced concepts

Yes all courses say theirs is the best ! But I will leave it to you to look at the sections and see just how much learning material is here for you to absorb and build your knowledge.

In summary this course ...

  1. Is very comprehensive at every level

  2. Starts with easy topics and builds up to complex topics

  3. Tons of practice assignments after each lecture to reinforce your knowledge and skills

  4. Includes large sample data sets for download used during the course (and after for you to research more)

  5. Learn to develop data visualisations with Tableau and assignments for you to participate in

  6. Section quizzes to further test how you think you would go at interviews and job reviews

  7. Achievement awards based on your Quiz results

In my humble opinion

This course is the most comprehensive and practical that you can buy.

It is a culmination of my real world work experience in the data analysis and visualisation world.

It will get you going with your career expectations

I have helped 85,000+ students achieve their skills requirements through my courses here on Udemy.

Here is a quote from one of my QlikView students back in March 2020 ...

I just wanted to let you know that thanks to your training, I've got a new job in Zurich as a Business Intelligence and Qlikview Developer.

I was working as BI Specialist and Data Scientist before but I was learning QlikView thanks to your course.

Are you keen to enrol ?

Well, check out the other courses first to compare to and you will see the difference , you be the judge

If you buy this course and it turns out is not for you there is the 30 day money back guarantee, a win win for you.

Looking forward to seeing you in the course.

Paul

Data Analyst and Visualisation Engineer


Content

Introduction

Introduction to the course
What are Resource links ?
Tune your browser to get 1080p HD all of the time
Installing SQL Server 2019 Express on your PC

Introduction to Microsoft SQL Server

Section 2 Overview
Why learn SQL using SQL Server ?
SQL Server architecture
Working with SQL Server Management Studio - Pt 1
Create and Organise your T-SQL scripts
What are system databases ?
Quiz time

Introduction to relational databases

Section 3 Overview
The anatomy of a database
SQL is a Set Based Declarative language
The primary method to retrieve data
Quiz Time

The SQL Toolbox

Section 4 Overview
SQL reserved key words
DDL - Data Definition Language
DML - Data Manipulation Language
TCL - Transaction Control Language
DCL - Data Control Language
Quiz time

SQL Terminology and Concepts

Section 5 Overview
Database Types
Primary and Foreign Keys - A primer
Quiz time

SQL - The First Steps

Section 6 Overview
Create a database using DDL
6.1 Exercise - Create a database using DDL
6.1 Exercise - Solution
Create a table using DDL
6.2 Exercise - Create a table using DDL
6.2 Exercise - Solution
What is a data type ?
Insert table data using DML
6.3 Exercise - Add data to a different table
6.3 Exercise - Solution
Update table data using DML
6.4 Exercise - Update data
6.4 Exercise - Solution
Rename the database using DDL
6.5 Exercise - Change the Database Name
6.5 Exercise - Solution
Alter a table using DDL
6.6 Exercise - Add a new column to a table
6.6 Exercise - Solution
Alter a column using DDL
6.7 Exercise - Alter a column attribute using DDL
6.7 Exercise - Solution
Set Theory - Lesson 1
Set Theory - Lesson 2
Quiz time

SQL Server Basic House Keeping to protect your data

Section 7 Overview
How to backup a database
How to duplicate a database
Use DDL to drop a database
How to restore a database
Quiz time

Loading the HR & Payroll transaction database

Exercise 8.1 - Restore the HR database backup
8.1 Exercise - Solution
An overview of the HR & Payroll database content

SQL SELECT Statement

Section 9 Overview
SELECT FROM
Exercise 9.1 - SELECT FROM
Exercise 9.1 - Solution
SELECT WHERE
Exercise 9.2 - SELECT WHERE
Exercise 9.2 - Solution
SELECT AND
Exercise 9.3 - SELECT AND
Exercise 9.3 - Solution
SELECT OR
Exercise 9.4 - SELECT OR
Exercise 9.4 - Solution
SELECT IN / NOT IN
Exercise 9.5 - SELECT IN / NOT IN
Exercise 9.5 - Solution
SELECT BETWEEN
Exercise 9.6 - SELECT BETWEEN
Exercise 9.6 - Solution
SELECT IS NULL
Exercise 9.7 - SELECT IS NULL
Exercise 9.7 - Solution
SELECT LIKE
Exercise 9.8 - SELECT LIKE
Exercise 9.8 - Solution
SELECT WHERE ... Boolean
Exercise 9.9 - SELECT WHERE ... Boolean
Exercise 9.9 - Solution
SELECT Distinct
Exercise 9.10 - SELECT Distinct
Exercise 9.10 - Solution
SELECT AS
Exercise 9.11 - SELECT AS
Exercise 9.11 - Solution
SELECT TOP
Exercise 9.12 - SELECT TOP
Exercise 9.12 - Solution
Quiz time

SQL SELECT Using common functions

Section 10 Overview
SELECT CASE
Exercise 10.1 - SELECT CASE
Exercise 10.1 - Solution
SELECT YEAR()
Exercise 10.2 - SELECT YEAR()
Exercise 10.2 - Solution
SELECT DATEPART()
Exercise 10.3 - SELECT DATEPART()
Exercise 10.3 - Solution
SELECT DATEDIFF()
Exercise 10.4 - SELECT DATEDIFF()
Exercise 10.4 - Solution
SELECT DATEADD()
Exercise 10.5 - SELECT DATEADD()
Exercise 10.5 - Solution
SELECT FORMAT()
Exercise 10.6 - FORMAT()
Exercise 10.6 - Solution
SELECT CONCAT()
Exercise 10.7 - SELECT CONCAT()
Exercise 10.7 - Solution
Quiz time

SQL JOINS - Foundation

Section 11 Overview
INNER JOIN
Exercise 11.1 - INNER JOIN
Exercise 11.1 - Solution
LEFT JOIN
Exercise 11.2 - LEFT JOIN
Exercise 11.2 - Solution
RIGHT JOIN
Exercise 11.3 - RIGHT JOIN
Exercise 11.3 - Solution
FULL JOIN
Exercise 11.4 - FULL JOIN
Exercise 11.4 - Solution
SQL Best Practice
Quiz time

SQL JOINS - Advanced

Section 12 Overview
INNER JOIN - Advanced
Exercise 12.1 - INNER JOIN - Advanced
Exercise 12.1 - Solution
INNER JOIN & LEFT JOIN Combo
Exercise 12.2 - INNER JOIN & LEFT JOIN Combo
Exercise 12.2 - Solution
SELF JOIN (Part 1)
SELF JOIN (Part 2)
Exercise 12.3 - SELF JOIN
Exercise 12.3 - Solution
Quiz time

SQL Views

Section 13 Overview
Create a view
Exercise 13.1 - Create a view
Exercise 13.1 - Solution
Create a view using DDL
Exercise 13.2 - Create a view using DDL
Exercise 13.2 - Solution
Quiz time

SQL Insert - Advanced Technique

Section 14 Overview
INSERT to create a table
Exercise 14.1 - INSERT to create a table
Exercise 14.1 - Solution
INSERT new data to an existing table (Pt-1)
INSERT new data to an existing table (Pt-2)
INSERT new data to an existing table (Pt-3)
INSERT new data to an existing table (Final)
Exercise 14.2 - INSERT new data to an existing table
Exercise 14.2 - Solution
Quiz time

SQL Update - Advanced Technique and TCL

Section 15 Overview
UPDATE data via a Join
Exercise 15.1 - UPDATE data via a Join
Exercise 15.1 - Solution
UPDATE with data conversion
Exercise 15.2 - UPDATE with data conversion
Exercise 15.2 - Solution
UPDATE Commit/Rollback (TCL)
Exercise 15.3 - UPDATE Commit/Rollback (TCL)
Exercise 15.3 - Solution
Quiz time

SQL DELETE and TCL

Section 16 Overview
DELETE table data
TRUNCATE Table
Quiz time

SQL Constraints

Section 17 Overview
The Primary Key
Exercise 17.1 - The Primary Key
Exercise 17.1 - Solution
The Foreign Key
Exercise 17.2 - The Foreign Key
Exercise 17.2 - Solution
DEFAULT
Exercise 17.3 - DEFAULT
Exercise 17.3 - Solution
CHECK
Exercise 17.4 - CHECK
Exercise 17.4 - Solution
NOT NULL
Quiz time

SQL Aggregations

Section 18 Overview
COUNT
Exercise 18.1 - COUNT
Exercise 18.1 - Solution
COUNT DISTINCT
Exercise 18.2 - COUNT DISTINCT
Exercise 18.2 - Solution
SUM
Exercise 18.3 - SUM
Exercise 18.3 - Solution
AVG
Exercise 18.4 - AVG
Exercise 18.4 - Solution
MIN/MAX
Exercise 18.5 - MIN/MAX
Exercise 18.5 - Solution
HAVING
Exercise 18.6 - HAVING
Exercise 18.6 - Solution
Quiz time

SQL Programmability

Section 19 Overview
SQL Variables
Exercise 19.1 - SQL Variables
Exercise 19.1 Solution
STORED PROCEDURE
Exercise 19.2 - STORED PROCEDURE
Exercise 19.2 - Solution
The SCHEMA and DCL for Security
TRIGGERS - Part 1
TRIGGERS - Final
Exercise 19.3 - TRIGGERS
Exercise 19.3 - Solution
STRING Functions - Len()
STRING Functions - Left()
STRING Functions - Charindex()
STRING Functions - Replace()
SCALAR (udf) Function
Exercise 19.4 - SCALAR (udf) Function
Exercise 19.4 - Solution
TABLE (udf) Function
Exercise 19.5 - TABLE (udf) Function
Exercise 19.5 - Solution
Quiz time

SQL Xtras

Section 20 Overview
WHILE Loops
Exercise 20.1 - WHILE Loops (Part 1)
Exercise 20.1 - Solution (Part 1)
Exercise 20.2 - WHILE Loops (Part 2)
Exercise 20.2 - Solution (Part 2)
EXISTS
Exercise 20.2 - EXISTS
Exercise 20.2 - Solution
Quiz time

SQL Query Performance

The Basics
INDEX
Exercise 21.1 - INDEX
Exercise 21.1 - Solution
Quiz time

Download the eCommerce Database ,Download & Install Tableau

Restore the database
Overview of the eCommerce data
Register and download Tableau (Free)

Getting SQL Server Data into Tableau

Section 23 Overview
How to load SQL Server data to Tableau
The Tableau Workspace
The Tableau Data Model
Exercise 23.1 - Loading your model
Exercise 23.1 - Solution
Quiz time

Hands on with Tableau dashboards (using a real project)

Section 24 Overview
Design analysis life cycle
Identify your data to use in the dashboard
SQL Query - Single metric
Tableau View - Single metric
Exercise 24.1 - Single Metric
Exercise 24.1 - Single metric solution
SQL Query - Dimension analysis & metric
Tableau View - Dimension & metric
Exercise 24.2 - Dimension analysis & metric
Exercise 24.2 - Dimension analysis & metric solution
SQL Query - Multipart calculation
Tableau View - Visualise the result
Exercise 24.3 - Multipart calculation
Exercise 24.3 - Multipart calculation solution
SQL Query - Final multipart calculation
Tableau View - Visualise the final result
Exercise 24.4 - Multipart calculation with a twist
Exercise 24.4 - Multipart calculation with a twist solution
Adding Tableau filters
Exercise 24.5 - Add a final filter
Exercise 24.5 - Add a final filter solution
Tableau Dashboard #1 Formatting
Tableau Dashboard #1 Assembly
Exercise 24.6 - Tableau Dashboard #2 Assembly
Exercise 24.6 - Dashboard #2 Solution
Quiz time

Complex SQL Queries and Tableau Visualisations

Section 25 Overview
Dashboard requirements specification
Identify your data to use in the dashboard
Initial Data Prep & Extract
Exercise 25.1 - Adjust the query for more columns
Exercise 25.1 - Query solution
Commence Dashboard #1 development
Exercise 25.2 - Add a measure and table calculation
Exercise 25.2 - Label & Calculation solution
SQL - OVER clause
Tableau View - Dual Axis charting
Exercise 25.3 - OVER clause & chart
Exercise 25.3 - OVER clause & chart solution
SQL - LAG () OVER Clause (Pt 1)
SQL - LAG() OVER Clause (Pt 2)
Tableau View - Chart the output
Exercise 25.4 - LAG() OVER
Exercise 25.4 - LAG() OVER Solution
SQL - OVER (Preceding) clause
Tableau View - Visualise the MVA output
Exercise 25.5 - OVER (Preceding)
Exercise 25.5 - OVER (Preceding) solution
SQL - CROSS JOIN (Pt 1)
SQL - CROSS JOIN (Pt 2)
Tableau View - Visualise the cross join results
Exercise 25.6 - CROSS JOIN
Exercise 25.6 - CROSS JOIN solution
SQL - CTE (Common Table Expression) (Pt 1)
SQL - CTE (Common Table Expression) (Pt 2)
Tableau - Visualise the CTE measures
Exercise 25.7- CTE
Exercise 25.7 - CTE solution
Tableau - Geo analytics
Exercise 25.8 - Geo analytics
Exercise 25.8 - Geo analytics solution
Tableau - Performance Dashboard #1 Assembly
Exercise 25.9 Tableau - Performance Dashboard #2
Exercise 25.9 Tableau - Performance Dashboard #2 my take
Quiz time
How to retrieve your quiz score based achievement certificate

The Showcase Project

Showcase public project specification

Reviews

Prasad
April 30, 2023
It's not just a course it's a one type of hands on real time project. Mentor explained every topic with a pupose why we are doing these ? In every requirement of client we follows a same process which is expleined in data analyst life cycle.
Aaditya
January 20, 2023
Personally, It was a great experience to learn as well as code side by side, and hoping to see more such courses from Paul. Thanks
Atulya
November 13, 2022
Good course. For people using Macbook and Azure Data Studio there is research that you will have to do on your own to get through some lectures. Functions and features might differ from SSMS
James
October 31, 2022
A bit slow to begin with as my SQL Skills are strong, but once into the Tableau portion, the course was extremely well presented and very enjoyable.
Daniel
October 28, 2022
Fue una excelente elección, aunque tengo conocimientos y experiencia en los tópicos de este curso, me ayuda a formalilzar conocimiento, refrescarlo y estar preparado para temas que no he visto como lo que vendrá a continuación (tableau por ejemplo). Es útil en mi día a día.
Juttiga
October 14, 2022
Paul is an excellent teacher and, in this course, provides a great balance between theory and coding. He talks us through the background fundamentals of databases and key terms and concepts then walks us through the terms and keywords we need to use to pull data from a real-world database environment. Excellent value and learning all the essentials!
Fabian
July 12, 2022
Like all courses from Paul, this course is amazing!!! Very well thougt out, great detail and everything is just working. you should buy it =)
John
June 30, 2022
Pretty good match learning about the interplay between SQL and Tableau, better understanding how the coding works "under the hood" of Tableau -
Martin
June 29, 2022
I have been using SQL for many years and decided to take a look over this course as a refresher, and it is probably one of the most comprehensive SQL course I think I have ever used. with good explanations and clear example, thouroughly recommend.
Arvind
June 7, 2022
Instructor is well versed with the subject and has tried to cover everything from the perspective of data analytics.
Julio
May 20, 2022
Paul Scotchford is by far the best instructor I have encountered. I bought this course purely because it is the most extensive SQL course he offers, and I am able to digest his lessons more so than any other I have come across. Thank you for making data analytics easy, Paul.
Ankita
March 21, 2022
One of the best course for SQL. I have finished the half course and it is going very good. will complete it soon. Thank you Paul.
Mohammed
March 5, 2022
I have taken some courses in SQL in the past so the concept of SQL RDBMS is not new to me. Having said that, I must admit, among all the other courses that I have taken in the past, this course by Paul Scotchford stands out as the best course I have ever taken in SQL. Paul is true lecturer and I think it runs in his chemistry. His lecture and the quality of his lecture slides are some of the best one that are out there and mimic some of the top schools (Yes MIT included) computer science departments. I will recommended this course to students and professionals who wants to learn not only SQL but also all the surrounding fields like data analyst, tableau developer and so on. Lots of Kudos to Paul! M. Ashraf
Mahe
February 6, 2022
This is really a good course for SQL, Tableau and Analytics. This course contains enterprise level projects. The only thing missing is data cleaning or ETL part. If that is available in this course then I would surely give 5 star rating for this course. I would request Paul to add/update this course with data cleaning or ETL part.
Sello
December 16, 2021
Is very user friendly for mobile device ,I don’t have to seat next to my computer or tv to watch the lectures .

Charts

Price

SQL Server 2019 Data Analytics & Tableau Data Visualisation - Price chart

Rating

SQL Server 2019 Data Analytics & Tableau Data Visualisation - Ratings chart

Enrollment distribution

SQL Server 2019 Data Analytics & Tableau Data Visualisation - Distribution chart
2695096
udemy ID
12/8/2019
course created date
6/28/2020
course indexed date
Bot
course submited by