The Complete SQL Bootcamp 2023 - Data Querying Essentials

Learn to query databases using MySQL. A must-have skill for users of data in any industry! Go from beginner to expert

4.60 (208 reviews)
Udemy
platform
English
language
Databases
category
instructor
869
students
11.5 hours
content
Jun 2022
last update
$79.99
regular price

What you will learn

Learn how to query data from databases using SQL on your own machine and within your own database

Learn fundamental SQL syntax that enables you to query database tables in any way imaginable

Learn about Data Aggregations and perform them using SQL (SUM / COUNT / MIN / MAX / AVERAGE / GROUP BY / HAVING)

Learn how to join multiple tables in a variety of ways - (LEFT / RIGHT / INNER / FULL / UNION / UNION ALL / INSERSECT / MINUS)

Learn database management techniques - (CREATE / REPLACE / UPDATE / DELETE)

Learn how to work with Date information (extracting, filtering, formatting)

Learn how to generate your own columns of data within a result set

Learn about Arithmetic & Comparison operators

Learn how to create Temporary Tables, Common Table Expressions, Subqueries, Derived Tables & Views

Learn about in-built functions (String / Numeric / Date / Comparison / Window)

Learn how to create Conditional Statements (CASE / WHEN / THEN)

Learn how SQL can be used in other software and languages such as Tableau, Python and Alteryx

Learn how to use MySQL Workbench to manage your data

Learn how to use SQL to perform data analysis

All the skills required to add SQL to your CV / Resume

Learn how to implement Triggers & Loops using SQL

Learn about SQL cursors with examples

Learn how to create Stored Procedures and Stored Functions

Learn about the differences between MySQL, PostgreSQL, SQL Server, SQLite and Oracle

Description

Welcome to The Complete SQL Bootcamp 2023 - Data Querying Essentials!

Having a solid understanding of SQL is a must-have skill in today's world for anybody who works with data. Gone are the days when the SQL programming language resided solely inside the 4 walls of an IT department. If you do not know SQL and the fundamental aspects of the querying language, then you are falling behind the curve.

Whether you are looking to upskill and learn about database management or want to learn SQL in order to gain insights into your data that is currently difficult to do using Excel, then you are certainly in the right place.

In this course we will be using one of the most popular databases in the world called MySQL and it is no doubt one of the most highly in-demand skills in the business sector today. With huge companies such as Twitter, Udemy, Airbnb, Uber and Dropbox using MySQL, you are learning SQL with a very powerful database option that you will install on your own machine. Furthermore, the skills you learn are highly transferable to other database platforms with a whole section dedicated to showcase the high level differences. You will no doubt become an SQL pro.

There are lots of courses to choose from, and finding the right one can sometimes be difficult. So why choose this course? Here are few reasons that come to mind:

  • Data analytics is my full-time job. With over 13 years of experience, I have learnt what works and what does not work in an organisation. I have consolidated this experience and focussed on creating video content that explains fundamental features that will add huge value to you personally as well as your firm

  • The course is constantly updated with new material to ensure you are supplemented with the most recent developments

  • This course is delivered with precision in mind. Videos are targeted at showcasing specific elements that can be tackled in isolation or as part of a well thought through journey

  • You are presented with high quality video material, tested with quizzes in every section, provided with tips and tricks to improve your SQL experience and introduced to articles that will help grow your knowledge to the next level

The skills you will learn in this course will allow you to:

  • Significantly reduce operational costs through automated processes using databases

  • Generate insights into your data that lead to improved decision making at all levels of management

  • Impress your colleagues and peers with data querying capabilities that are second to none

  • Become more efficient with your time by conducting data analysis in Tableau, Alteryx or Python by using SQL to query underlying databases

It's now 2023. SQL is a language that you must have on your CV to stand out as a data analyst or you'll be left behind as the industry moves forward. Being able to query stored data is a vital part in any quest for improved decision making and I am here to help you understand it all.

This is a course designed for those who have not touched SQL before to those who want a refresher on advanced topics such as triggers, loops, procedures and functions! The course is designed and presented in an easy to understand fashion and I hope you find the learning style engaging and easy to follow.

If you have any questions, please feel free to contact me. I am here to make learning SQL a fun and enjoyable process and you'll soon ask yourself why you didn't do it sooner. I love my job and I love seeing others excel when they get to put their newly found SQL knowledge into practice. Sign up today and see how rewarding using SQL can be!

Enrol today and kickstart your SQL journey!

Content

Introduction to SQL

Course Introduction
What is SQL used for?
What opportunities open up if I learn SQL?
Database Installation
Datasets used in this course
Database Overview
Getting to know our first schema
Section 1 Quiz

Fundamental SQL Syntax

Single / Multi-line comments
SELECT / FROM Statements
Select Unique Values (DISTINCT)
Single quotes, Double quotes and Back-ticks
ALIAS Tables and Columns
Filtering Rows of Data (WHERE)
Multiple Conditions (AND)
Multiple Conditions (OR)
Using both AND & OR in a single query
Filter by multiple values at once (IN)
Filtering data BETWEEN two values
NULL data (IS NULL / IS NOT NULL)
Wildcard Matches (LIKE / % / - / REGEXP)
NOT Keyword
Sorting Data (ORDER BY / ASC / DESC)
LIMIT your query results
Section 2 Quiz

Data Aggregations

What are data aggregations?
The GROUP BY Keyword
Counting Records (COUNT)
Summation (SUM)
Finding the Minimum and Maximum Value (MIN / MAX)
Calculating Averages (AVG)
Filtering aggregated data (HAVING)
Order of Operations
Totals & Subtotals on Aggregated Data (WITH ROLLUP)
Section 3 Quiz

Generating your own columns of data

Generating new columns in the result set
Arithmetic Operators
Aggregating new columns
Conditional Statements Part 1
Conditional Statements Part 2
Multi-conditional Statements
Section 4 Quiz

SQL Functions & Operators

Comparison Operators
String Functions
Numeric Functions
Comparison Functions
Window Functions
Section 5 Quiz

Working with Dates

Extracting Date Information
Current Date & Time functions
Extracting Time Information
Performing Calculations on Dates & Times
Formatting Dates (DATE_FORMAT)
Filtering by dates
Section 6 Quiz

Joining Data

Join Types
Primary & Foreign Keys
Inner Joins (INNER JOIN)
Left Joins (LEFT JOIN)
Right Joins (RIGHT JOIN)
Joining multiple tables with filters & aggregations
Appending tables together (UNION / UNION ALL)
Section 7 Quiz

MySQL Join Emulation

Full Outer Join Emulation
Intersect Emulation
Minus Emulation
Section 8 Quiz

Creating a Database

Data Types Overview - Numeric Datatypes
Datatypes - Boolean, String and Dates
Creating a schema / database
Creating a database table (CREATE TABLE)
Inserting data into a table (INSERT / INTO)
Updating data in a table (UPDATE / SET)
Deleting data from a table (DELETE)
Deleting data from a table (TRUNCATE)
Altering Table structures (ALTER)
Deleting tables from a database (DROP)
Transactions (COMMIT / ROLLBACK)
Delete from multiple tables using JOINS
Load data from a csv file (LOAD DATA)
Section 9 Quiz

Temporary Tables, CTE's & Subqueries

Introduction to Temporary Tables
Creating a temporary table
Common Table Expressions (CTE)
Derived Tables / Subqueries
Section 10 Quiz

Database Views

Introduction to Views
Creating a View
Renaming and Dropping Views
Create updatable views
Understanding how views are processed
Section 11 Quiz

Stored Procedures

What is a stored procedure?
Understanding the DELIMITER
How to create a new stored procedure
Deleting stored procedures
Introducing Variables
Introducing Parameters and arguments
How to change a stored procedure
IF - ELSEIF - ELSE Conditional Statements
CASE WHEN Conditional Statements Part 1
CASE WHEN Conditional Statements Part 2
Section 12 Quiz

Loops

Understand Loops with FizzBuzz!
Loops
Loops - ITERATE keyword
WHILE Loop
REPEAT Loop
Section 13 Quiz

Functions

What is a function?
How to create a stored function
Using functions in stored procedures
Deleting and Altering stored functions
Section 14 Quiz

Introduction to Cursors

Cursors
Quiz 15

Introduction to Triggers

What is a Trigger?
Our first trigger (BEFORE UPDATE)
Trigger Use Case 2
Trigger Use Case 3
Multiple Triggers on same table
Deleting triggers
Section 16 Quiz

Bonus Section - Using SQL in other software / languages

SQL in Tableau - Automated Visualisations
SQL in Alteryx - Automated data sourcing
SQL in Python - Automated data sourcing
Exporting data in a variety of file formats

Database Comparisons

MySQL vs MariaDB
MySQL vs PostgreSQL
MySQL vs SQLite
MySQL vs SQL Server
MySQL vs Oracle SQL

Conclusion

Congratulations!
Bonus Video

Screenshots

The Complete SQL Bootcamp 2023 - Data Querying Essentials - Screenshot_01The Complete SQL Bootcamp 2023 - Data Querying Essentials - Screenshot_02The Complete SQL Bootcamp 2023 - Data Querying Essentials - Screenshot_03The Complete SQL Bootcamp 2023 - Data Querying Essentials - Screenshot_04

Reviews

Lúcia
March 20, 2023
Very well explained course, easy to follow. I wish we could have the written tasks already available when we use MySQL during each chapter. I also think that we should have practical exercises along the course, even with solutions being provided later on. But overall the course is a great source of knowledge with very well spoken information.
Adiv
February 3, 2023
The instructor is articulate and authoritative. He explains concepts and objectives with great clarity.
Michael
January 30, 2023
The training is really very good, very clear and concise explanation so far. The instructor is a great teacher. However, it would have been much better if the training resources is a PDF that contains brief notes on what is being taught instead of sending us to https://dev.mysql.com/doc. In fact, this is the only reason I did not rate this training 5 star.
Joel
December 30, 2022
Lots of good information. Would be helpful to have a video for installation and configuration in Linux as well.
Amelia
October 1, 2022
I think it would be better to include a Mac version of the installation. I am a Mac user and I followed the steps; it doesn't seem to work.
Angelica
September 19, 2022
I really love the way this SQL Bootcamp is designed. I am an accountant with zero experience in SQL and the videos, data base and exercises just make it very easy for you to follow and practice. In only three sessions I'm on lesson 21 and it is very addictive. I really recommend it. Great choice to start learning SQL!!
Mariia
August 12, 2022
The course is very well structured and paced. Certainly, will recommend to my colleagues and friends.
John
May 27, 2022
So far so good, Dean doesn't beat around the bush, he teaches the practical stuff directly and smoothly. A major advantage of this course is that it's taught by a professional who has full grasp of SQL in the industry and not just by any instructor. There are more popular instructors in the platform offering SQL course but if you read carefully their backgrounds, plenty of them are geared towards sales quantity over quality and have no solid SQL work experience, they may know stuff but lack the production experience which in my opinion is a really bad initiative and motivation for them to teach about SQL. As for this course, it's definitely a good buy and investment.
Md
April 27, 2022
This is an excellent training course to learn MySQL with great practical sessions, allowing in depth hands-on to the real MySQL workbench. This alone allows for a better understanding of what's SQL commands, write SQL queries, triggers, functions, procedures and so on………..! Great course indeed!!
Makhosandile
February 10, 2022
As a SNR data engineer, i can assure all newbies that this is course will set you on the right track.
Fraser
January 28, 2022
Great content and a real high quality learning experience. I enjoyed the process of learning with this course, which isn't always easy to do!
Baran
December 19, 2021
Amazing content, pace and instructions. I don't think anybody will regret joining the course. Thank you sir.
Anand
September 8, 2021
An extremely professional course. Clear explanations and plenty of examples to help practice along the way. Thanks for recommending this course Udemy!
Pat
July 3, 2021
By far the best SQL course I have come across. I have done so many courses which never explained things well. Thanks for the content and clear explanations
Becky
July 1, 2021
I started an absolute SQL beginner but I honestly now feel like an SQL pro and I’m only half way through!! Loving this course!

Charts

Price

The Complete SQL Bootcamp 2023 - Data Querying Essentials - Price chart

Rating

The Complete SQL Bootcamp 2023 - Data Querying Essentials - Ratings chart

Enrollment distribution

The Complete SQL Bootcamp 2023 - Data Querying Essentials - Distribution chart
3853170
udemy ID
2/16/2021
course created date
6/28/2021
course indexed date
Bot
course submited by