Udemy

Platform

English

Language

Data & Analytics

Category

The Complete SQL Bootcamp 2021: Go from Zero to Hero

Become an expert at SQL!

4.68 (89536 reviews)

335172

Students

9 hours

Content

Oct 2020

Last Update
$179.99
Regular Price

What you will learn

Use SQL to query a database

Use SQL to perform data analysis

Be comfortable putting SQL and PostgreSQL on their resume

Learn to perform GROUP BY statements

Replicate real-world situations and query reports


Topics

SQL


Description

Learn how to use SQL quickly and effectively with this course!

You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!

In this course you will learn everything you need to become a SQL Pro! Including:

  • Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools

  • Learn he basics of SQL syntax

  • Analyzing data using aggregate functions with GROUP BY commands

  • Running advanced queries with string operations and comparison operations

  • Learn to use logical operators to add logic flow to your SQL queries

  • Learn common SQL JOIN commands

  • Learn to create tables and databases with constraints on data entries

  • Learn to use Python to further advanced your SQL skills

  • and much, much more!

This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.

I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.

SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!

I'll see you inside the course!

Check out the free preview videos for more information!


Screenshots

The Complete SQL Bootcamp 2021: Go from Zero to Hero
The Complete SQL Bootcamp 2021: Go from Zero to Hero
The Complete SQL Bootcamp 2021: Go from Zero to Hero
The Complete SQL Bootcamp 2021: Go from Zero to Hero

Content

Course Introduction

Introduction

Course Curriculum Overview

Overview of Databases

Course FAQs

Time to get your Computer Set-Up!

Windows Installation - PostGreSQL and PgAdmin with Database Setup

MacOS Installation - PostgreSQL and PgAdmin with First Query

SQL Statement Fundamentals

Overview of Challenges!

SQL Cheat Sheet

SQL Statement Fundamentals

SELECT Statement

Challenge: SELECT

SELECT DISTINCT

Challenge: SELECT DISTINCT

COUNT

SELECT WHERE - Part One

SELECT WHERE - Part Two

Challenge: SELECT WHERE

ORDER BY

LIMIT

Challenge: ORDER BY

BETWEEN

IN

LIKE and ILIKE

General Challenge 1

GROUP BY Statements

Introduction to GROUP BY

Aggregation Functions

GROUP BY - Part One

GROUP BY - Part Two

GROUP BY - Challenge

HAVING

HAVING - Challenge Tasks

Assessment Test 1

Overview of Assessment Test 1

Assessment Test 1

Solutions to Assessment Test 1

JOINS

Overview of JOINS

AS Statement

Overview of Inner Join

Examples of Inner Joins

Overview of Join types

Example of Outer Joins

Union

Join Challenges

Advanced SQL Commands

Overview of Advanced SQL Commands

Timestamps and Extract

Mathematical Functions

String Function and Operators

SubQuery

Self-Join

Assessment Test 2

Assessment Test 2 Overview

Assessment Test 2

Solutions to Assessment Test 2

Creating Databases and Tables

Overview of Section

Data Types

Primary Keys and Foreign Keys

Resource for Create Table Code

Note on Constraints

Create Table

Challenge: Create Table

Challenge: Create Table - SOLUTION

Insert

Update

Delete

Alter Table

Drop Table

CHECK Constraint

NOT NULL Constraint

UNIQUE Constraint

Assessment Test 3

Assessment Test 3

Solutions to Assessment Test 3

Extra: Views

Views

Extra: PostGreSQL with Python

Overview of Python and PostgreSQL

Psycopg2 Example Usage

Psycopg2 Resources

Databases and Tables

Databases and Tables Overview

Creating and Restoring a Database

Challenge: Restore a Database!

Restoring a Table Schema

Challenge: Restore a Table Schema!

Review of Section

Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)

Mac OS X - Quick Note

Mac OS Installation

Mac Sample Database Download

Mac Database Set-up

Review of Set-up

Windows - Quick Note

Windows Installation

Sample Database Download

Windows Command Line Installation Lecture

BONUS SECTION: THANK YOU!

Bonus Lecture



Reviews

R
Raviteja9 October 2020

I did not go through a smooth installation process. I had to refer to multiple other resources to get around the errors

K
Karl9 October 2020

The course is well-structured and easy to follow. Thanks for putting it together, I feel like I'm learning a lot!

J
Jordi9 October 2020

The course is well formulated but it is a begginers course; far from becoming a hero! Lack of exercises on complex queries.

M
Marcos9 October 2020

Very good course with detailed instructions on basic operations that allows you to understand how to use SQL. For a BA job for example, this is more than enough for you to learn and move forward with your role like an expert. However, if you plan on becoming a database admin, this is just a beginning. Still worth tho

C
Clyde9 October 2020

downloading dvdrental was an absolute nightmare. eventually after searching Q&A for hours i came across a comment about using the database straight from the site. this kind of troubleshooting should be readily available as it looks like this downloadable content was moved. i shouldn't have to go look through other users comments. i am also a student in my own right and deserve to get my own questions answered. unsuccessful in posting my own question as this feature is either hidden, not displayed properly or disabled.

J
Julie26 February 2020

As a complete newbie to SQL, I learned about in this class. The instructors keeps the examples simple enough so we can get a solid foundation in the concepts that he teachers. If you are looking for a good first class in SQL, I recommend this one.

R
Rafeeq26 February 2020

this course for really awesome, and people like me who are not aware of sql, was able to understand very much good.

O
Orsolya26 February 2020

One of the best courses I have ever taken. Very clear, very detailed, lecturer is really good. I am more than satisfied.

A
Amy25 February 2020

Overall really like the training. Because I am on a MAC, there are a few extra steps that were left out. Such as remind the user to set the mouse with a right and left setting. Use more descriptive language, such as run. Instead of click here, say click the black arrow pointing right.

R
Richard25 February 2020

I was nice, I refreshed my memory of SQL. But the part about creating tables and altering could be more detailed and longer.

M
Madhu25 February 2020

It was Great ! By during this session I could easily downloaded the PostgreSQL and pgAdmin and set up all requirements. Thank you :)

T
Travis24 February 2020

Outstanding, excellent tutorial for installing PostgreSQL and PgAdmin. Perfect depth in SQL queries and joins. Great course.

R
Robert23 February 2020

I've taken 2 other courses so far in SQL. At the time, I thought those were good courses, but this course is hands down the best way I've seen so far to learn SQL....The explanations, and practice problems are GREAT. I highly recommend this to anyone that wants to learn SQL quick!!

D
Derek22 February 2020

This is an excellent SQL class. Lots of hands on exercises to reinforce the learning. The note for the teacher is to avoid repeating "with that being said" at the end of each video. Otherwise, the instructions were clear and easy to follow.

B
Benjamin22 February 2020

I'm really enjoying it, but I haven't found the class to be very challenging. When it said it went from beginner to expert, I was hoping the "Expert" portion of data calls would be a bit more fleshed out. That being said, I wish I had this when I was just starting out.


Coupons

StatusDateDiscount
Expired7/1/201997% OFF
Expired4/22/202095% OFF


762616

Udemy ID

2/14/2016

Course created date

7/1/2019

Course Indexed date
dayananda
Course Submitted by

Twitter
Telegram
Android PlayStore
Apple Appstore