Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

The Complete SQL Bootcamp - Data Querying Essentials

Name: The Complete SQL Bootcamp - Data Querying Essentials
Rating: 4.7 (229 reviews)

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

Created byDean Taylor

Last updated 6/2024

English

English [Auto],

What you'll 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

Course content

19 sections • 118 lectures • 11h 21m total length

Course Introduction3:01
What is SQL used for?4:34
What opportunities open up if I learn SQL?5:05
Database Installation8:37
Datasets used in this course3:32
Datasets used in this course
There are two main datasets that we use in this course. The sakila schema and the world schema. If you open MySQL workbench and you do not see these schemas in the schemas window, you are able to load these schemas from external files.
You can download the example database files by pasting the below link into a web browser:
https://dev.mysql.com/doc/index-other.html
To load, please follow the below instructions:
Sakila Schema
If you do not have the sakila schema installed, following the below steps:
1) Open the sakila-schema.sql file in MySQL workbench and run the file
2) Open the sakila-data.sql file in MySQL workbench and run the file
World Schema
If you do not have the world schema installed, following the below steps:
1) Open the world.sql file in MySQL workbench and run the file

We also use an illustrative dataset which we create called the Shop Schema. To load, open the file below named shop-schema-example and and run the file.
Database Overview4:48
In this video, we will start exploring important features of a database and introduce the Entity-Relationship Diagram which helps to visualise how a database is organised
Getting to know our first schema6:49
Sakila
In this course we will use the sakila schema to learn and practice a lot of SQL syntax. This video will show you where you can go to observe the different objects and also where you can find an Entity-Relationship Diagram that makes navigating the schema easy!
Section 1 Quiz

Single / Multi-line comments3:11
Comments
A very useful feature that enables you to:
1. Describe what your code is doing - This will not only help you when you come back to your code at a later point in time but also helps other people who look at your code understand what steps have been taken
2. Ignore parts of your code upon execution - Rather than deleting code completely, simply comment out your code so that it doesn't get executed
SELECT / FROM Statements8:07
Selecting Data
1. Use SELECT keyword to pick columns
2. Use * to obtain all columns
3. Use FROM to choose your table name
4. Use dot notation and precede the table name with the schema name
Select Unique Values (DISTINCT)4:38
Selecting Unique Data
1. Use SELECT DISTINCT to obtain columns of unique data
2. By selecting an individual column you will see unique values that exist within a column
3. By selecting multiple columns you will see unique rows of data that exist within the columns you selected
Single quotes, Double quotes and Back-ticks4:54
ALIAS Tables and Columns6:04
Column & Table ALIAS
1. To improve the readability of code and improve output format, use the optional keyword AS to relabel columns and tables that may otherwise be difficult to read or understand
2. New names that contains spaces should be wrapped in single quotes
3. New names that do not consist of spaces can simply be typed out
Filtering Rows of Data (WHERE)4:41
Filtering Data (WHERE)
Filtering rows in your dataset is extremely useful when you have a specific set of data within a table that you would like to obtain.
1. Use the WHERE keyword to stipulate filter conditions
Multiple Conditions (AND)4:08
Multiple conditions (AND)
Sometimes things aren't as simple as one condition! In this lesson you will learn how to incorporate as many conditions as you want using the AND keyword.
1. Use the keyword AND to incorporate more than one condition in your query
2. Conditions linked by AND both need to evaluate to true for the entire condition to evaluate to true. If one of the condition evaluates to false, then the entire condition will evaluate to false
Multiple Conditions (OR)4:10
Using both AND & OR in a single query4:14
Filter by multiple values at once (IN)3:00
Filtering data BETWEEN two values3:00
NULL data (IS NULL / IS NOT NULL)6:15
Wildcard Matches (LIKE / % / - / REGEXP)5:16
Learn how to perform wildcard searches on your datasets using the LIKE keyword
NOT Keyword5:48
Sorting Data (ORDER BY / ASC / DESC)6:51
LIMIT your query results7:59
Section 2 Quiz

What are data aggregations?2:52
The GROUP BY Keyword4:06
Counting Records (COUNT)9:22
Summation (SUM)5:52
Finding the Minimum and Maximum Value (MIN / MAX)5:41
Calculating Averages (AVG)6:05
Filtering aggregated data (HAVING)5:09
Order of Operations11:54
Totals & Subtotals on Aggregated Data (WITH ROLLUP)9:42
Treat this video as a bonus!
In this video, we will explore ways in which we can add totals and subtotals to our query results.
There will be concepts covered in this video such as UNIONs and the use of FUNCTIONS that are explored in more detail further into the course. Therefore, if you find you are not following with the syntax in this video or some of the concepts, continue on to the subsequent sections and revisit this video at a later point in time... it may become a lot clearer and easier to follow.
Section 3 Quiz

Data Types Overview - Numeric Datatypes7:13
Datatypes - Boolean, String and Dates4:52
Creating a schema / database2:38
Creating a database table (CREATE TABLE)5:41
Inserting data into a table (INSERT / INTO)5:39
Updating data in a table (UPDATE / SET)8:25
Deleting data from a table (DELETE)4:50
Deleting data from a table (TRUNCATE)4:23
Altering Table structures (ALTER)7:15
Deleting tables from a database (DROP)4:59
Transactions (COMMIT / ROLLBACK)7:59
Delete from multiple tables using JOINS7:09
Load data from a csv file (LOAD DATA)5:52
Section 9 Quiz

Requirements

An appetite to learn SQL and work with databases
No other pre requisites or course requirements

Description

Welcome to The Complete SQL Bootcamp - 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 2025. 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!

Who this course is for:

This course is for anyone who wants to learn the Fundamental aspects of SQL
This course is designed for any data enthusiast who wants to get more out of their data
This course is for anybody who wants improved insights into their data
This course is for anyone who wants to improve their breadth of SQL syntax knowledge
This course is for anyone who wants to migrate Excel based reports to a database
This course is for any keen data scientist who wants to leverage SQL for data analytics
This course is for anyone who wants to open up job opportunities that involve data

The Complete SQL Bootcamp - Data Querying Essentials

What you'll learn

Explore related topics

Course content

Introduction to SQL7 lectures • 36min

Fundamental SQL Syntax16 lectures • 1hr 22min

Data Aggregations9 lectures • 1hr 1min

Generating your own columns of data6 lectures • 30min

SQL Functions & Operators5 lectures • 38min

Working with Dates6 lectures • 39min

Joining Data7 lectures • 51min

MySQL Join Emulation3 lectures • 15min

Creating a Database13 lectures • 1hr 17min

Temporary Tables, CTE's & Subqueries4 lectures • 32min

Requirements

Description

Who this course is for: