The Complete SQL Bootcamp – Data Querying Essentials

The Complete SQL Bootcamp – Data Querying Essentials, available at $79.99, has an average rating of 4.8, with 118 lectures, 16 quizzes, based on 215 reviews, and has 897 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is for anyone who wants to learn the Fundamental aspects of SQL or This course is designed for any data enthusiast who wants to get more out of their data or This course is for anybody who wants improved insights into their data or This course is for anyone who wants to improve their breadth of SQL syntax knowledge or This course is for anyone who wants to migrate Excel based reports to a database or This course is for any keen data scientist who wants to leverage SQL for data analytics or This course is for anyone who wants to open up job opportunities that involve data It is particularly useful for This course is for anyone who wants to learn the Fundamental aspects of SQL or This course is designed for any data enthusiast who wants to get more out of their data or This course is for anybody who wants improved insights into their data or This course is for anyone who wants to improve their breadth of SQL syntax knowledge or This course is for anyone who wants to migrate Excel based reports to a database or This course is for any keen data scientist who wants to leverage SQL for data analytics or This course is for anyone who wants to open up job opportunities that involve data.

Enroll now: The Complete SQL Bootcamp – Data Querying Essentials

Summary

Title: The Complete SQL Bootcamp – Data Querying Essentials

Price: $79.99

Average Rating: 4.8

Number of Lectures: 118

Number of Quizzes: 16

Number of Published Lectures: 118

Number of Published Quizzes: 16

Number of Curriculum Items: 135

Number of Published Curriculum Objects: 135

Original Price: £54.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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 2024. 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!

Course Curriculum

Chapter 1: Introduction to SQL

Lecture 1: Course Introduction

Lecture 2: What is SQL used for?

Lecture 3: What opportunities open up if I learn SQL?

Lecture 4: Database Installation

Lecture 5: Datasets used in this course

Lecture 6: Database Overview

Lecture 7: Getting to know our first schema

Chapter 2: Fundamental SQL Syntax

Lecture 1: Single / Multi-line comments

Lecture 2: SELECT / FROM Statements

Lecture 3: Select Unique Values (DISTINCT)

Lecture 4: Single quotes, Double quotes and Back-ticks

Lecture 5: ALIAS Tables and Columns

Lecture 6: Filtering Rows of Data (WHERE)

Lecture 7: Multiple Conditions (AND)

Lecture 8: Multiple Conditions (OR)

Lecture 9: Using both AND & OR in a single query

Lecture 10: Filter by multiple values at once (IN)

Lecture 11: Filtering data BETWEEN two values

Lecture 12: NULL data (IS NULL / IS NOT NULL)

Lecture 13: Wildcard Matches (LIKE / % / – / REGEXP)

Lecture 14: NOT Keyword

Lecture 15: Sorting Data (ORDER BY / ASC / DESC)

Lecture 16: LIMIT your query results

Chapter 3: Data Aggregations

Lecture 1: What are data aggregations?

Lecture 2: The GROUP BY Keyword

Lecture 3: Counting Records (COUNT)

Lecture 4: Summation (SUM)

Lecture 5: Finding the Minimum and Maximum Value (MIN / MAX)

Lecture 6: Calculating Averages (AVG)

Lecture 7: Filtering aggregated data (HAVING)

Lecture 8: Order of Operations

Lecture 9: Totals & Subtotals on Aggregated Data (WITH ROLLUP)

Chapter 4: Generating your own columns of data

Lecture 1: Generating new columns in the result set

Lecture 2: Arithmetic Operators

Lecture 3: Aggregating new columns

Lecture 4: Conditional Statements Part 1

Lecture 5: Conditional Statements Part 2

Lecture 6: Multi-conditional Statements

Chapter 5: SQL Functions & Operators

Lecture 1: Comparison Operators

Lecture 2: String Functions

Lecture 3: Numeric Functions

Lecture 4: Comparison Functions

Lecture 5: Window Functions

Chapter 6: Working with Dates

Lecture 1: Extracting Date Information

Lecture 2: Current Date & Time functions

Lecture 3: Extracting Time Information

Lecture 4: Performing Calculations on Dates & Times

Lecture 5: Formatting Dates (DATE_FORMAT)

Lecture 6: Filtering by dates

Chapter 7: Joining Data

Lecture 1: Join Types

Lecture 2: Primary & Foreign Keys

Lecture 3: Inner Joins (INNER JOIN)

Lecture 4: Left Joins (LEFT JOIN)

Lecture 5: Right Joins (RIGHT JOIN)

Lecture 6: Joining multiple tables with filters & aggregations

Lecture 7: Appending tables together (UNION / UNION ALL)

Chapter 8: MySQL Join Emulation

Lecture 1: Full Outer Join Emulation

Lecture 2: Intersect Emulation

Lecture 3: Minus Emulation

Chapter 9: Creating a Database

Lecture 1: Data Types Overview – Numeric Datatypes

Lecture 2: Datatypes – Boolean, String and Dates

Lecture 3: Creating a schema / database

Lecture 4: Creating a database table (CREATE TABLE)

Lecture 5: Inserting data into a table (INSERT / INTO)

Lecture 6: Updating data in a table (UPDATE / SET)

Lecture 7: Deleting data from a table (DELETE)

Lecture 8: Deleting data from a table (TRUNCATE)

Lecture 9: Altering Table structures (ALTER)

Lecture 10: Deleting tables from a database (DROP)

Lecture 11: Transactions (COMMIT / ROLLBACK)

Lecture 12: Delete from multiple tables using JOINS

Lecture 13: Load data from a csv file (LOAD DATA)

Chapter 10: Temporary Tables, CTE's & Subqueries

Lecture 1: Introduction to Temporary Tables

Lecture 2: Creating a temporary table

Lecture 3: Common Table Expressions (CTE)

Lecture 4: Derived Tables / Subqueries

Chapter 11: Database Views

Lecture 1: Introduction to Views

Lecture 2: Creating a View

Instructors

Dean Taylor
Data Scientist | Instructor

Rating Distribution

1 stars: 0 votes
2 stars: 2 votes
3 stars: 7 votes
4 stars: 67 votes
5 stars: 139 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