SQL Data Analytics with Tableau Data Visualisation

SQL Data Analytics with Tableau Data Visualisation, available at $74.99, has an average rating of 4.55, with 313 lectures, 22 quizzes, based on 433 reviews, and has 3384 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone looking to learn SQL from scratch to becoming highly competent or Anyone looking to refresh or enhance existing skills It is particularly useful for Anyone looking to learn SQL from scratch to becoming highly competent or Anyone looking to refresh or enhance existing skills.

Enroll now: SQL Data Analytics with Tableau Data Visualisation

Summary

Title: SQL Data Analytics with Tableau Data Visualisation

Price: $74.99

Average Rating: 4.55

Number of Lectures: 313

Number of Quizzes: 22

Number of Published Lectures: 313

Number of Published Quizzes: 22

Number of Curriculum Items: 335

Number of Published Curriculum Objects: 335

Original Price: $19.99

Quality Status: approved

Status: Live

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
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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to the course

Lecture 2: What are Resource links ?

Lecture 3: Tune your browser to get 1080p HD all of the time

Lecture 4: Installing SQL Server 2019 Express on your PC

Chapter 2: Introduction to Microsoft SQL Server

Lecture 1: Section 2 Overview

Lecture 2: Why learn SQL using SQL Server ?

Lecture 3: SQL Server architecture

Lecture 4: Working with SQL Server Management Studio – Pt 1

Lecture 5: Create and Organise your T-SQL scripts

Lecture 6: What are system databases ?

Chapter 3: Introduction to relational databases

Lecture 1: Section 3 Overview

Lecture 2: The anatomy of a database

Lecture 3: SQL is a Set Based Declarative language

Lecture 4: The primary method to retrieve data

Chapter 4: The SQL Toolbox

Lecture 1: Section 4 Overview

Lecture 2: SQL reserved key words

Lecture 3: DDL – Data Definition Language

Lecture 4: DML – Data Manipulation Language

Lecture 5: TCL – Transaction Control Language

Lecture 6: DCL – Data Control Language

Chapter 5: SQL Terminology and Concepts

Lecture 1: Section 5 Overview

Lecture 2: Database Types

Lecture 3: Primary and Foreign Keys – A primer

Chapter 6: SQL – The First Steps

Lecture 1: Section 6 Overview

Lecture 2: Create a database using DDL

Lecture 3: 6.1 Exercise – Create a database using DDL

Lecture 4: 6.1 Exercise – Solution

Lecture 5: Create a table using DDL

Lecture 6: 6.2 Exercise – Create a table using DDL

Lecture 7: 6.2 Exercise – Solution

Lecture 8: What is a data type ?

Lecture 9: Insert table data using DML

Lecture 10: 6.3 Exercise – Add data to a different table

Lecture 11: 6.3 Exercise – Solution

Lecture 12: Update table data using DML

Lecture 13: 6.4 Exercise – Update data

Lecture 14: 6.4 Exercise – Solution

Lecture 15: Rename the database using DDL

Lecture 16: 6.5 Exercise – Change the Database Name

Lecture 17: 6.5 Exercise – Solution

Lecture 18: Alter a table using DDL

Lecture 19: 6.6 Exercise – Add a new column to a table

Lecture 20: 6.6 Exercise – Solution

Lecture 21: Alter a column using DDL

Lecture 22: 6.7 Exercise – Alter a column attribute using DDL

Lecture 23: 6.7 Exercise – Solution

Lecture 24: Set Theory – Lesson 1

Lecture 25: Set Theory – Lesson 2

Chapter 7: SQL Server Basic House Keeping to protect your data

Lecture 1: Section 7 Overview

Lecture 2: How to backup a database

Lecture 3: How to duplicate a database

Lecture 4: Use DDL to drop a database

Lecture 5: How to restore a database

Chapter 8: Loading the HR & Payroll transaction database

Lecture 1: Exercise 8.1 – Restore the HR database backup

Lecture 2: 8.1 Exercise – Solution

Lecture 3: An overview of the HR & Payroll database content

Chapter 9: SQL SELECT Statement

Lecture 1: Section 9 Overview

Lecture 2: SELECT FROM

Lecture 3: Exercise 9.1 – SELECT FROM

Lecture 4: Exercise 9.1 – Solution

Lecture 5: SELECT WHERE

Lecture 6: Exercise 9.2 – SELECT WHERE

Lecture 7: Exercise 9.2 – Solution

Lecture 8: SELECT AND

Lecture 9: Exercise 9.3 – SELECT AND

Lecture 10: Exercise 9.3 – Solution

Lecture 11: SELECT OR

Lecture 12: Exercise 9.4 – SELECT OR

Lecture 13: Exercise 9.4 – Solution

Lecture 14: SELECT IN / NOT IN

Lecture 15: Exercise 9.5 – SELECT IN / NOT IN

Lecture 16: Exercise 9.5 – Solution

Lecture 17: SELECT BETWEEN

Lecture 18: Exercise 9.6 – SELECT BETWEEN

Lecture 19: Exercise 9.6 – Solution

Lecture 20: SELECT IS NULL

Lecture 21: Exercise 9.7 – SELECT IS NULL

Lecture 22: Exercise 9.7 – Solution

Lecture 23: SELECT LIKE

Lecture 24: Exercise 9.8 – SELECT LIKE

Lecture 25: Exercise 9.8 – Solution

Lecture 26: SELECT WHERE … Boolean

Lecture 27: Exercise 9.9 – SELECT WHERE … Boolean

Lecture 28: Exercise 9.9 – Solution

Lecture 29: SELECT Distinct

Instructors

Paul Scotchford
Data Analyst and Qlik Development Specialist @ awari

Rating Distribution

1 stars: 2 votes
2 stars: 2 votes
3 stars: 31 votes
4 stars: 132 votes
5 stars: 266 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu