About Course

The Complete SQL Bootcamp: Go from Zero to Hero – Free!

Learn how to use SQL quickly and effectively with this free course! You’ll learn how to read and write complex queries to a database using PostgreSQL, one of the most in-demand skills. These skills are also applicable to other major SQL databases, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and more.

Learning SQL is one of the fastest ways to improve your career prospects as it’s a highly sought-after tech skill. This course provides challenges and tests to enhance your understanding. You’ll learn everything you need to become a SQL Pro, including:

Getting started with PostgreSQL and PgAdmin, two of the world’s most popular SQL tools
Learning the basics of SQL syntax
Analyzing data using aggregate functions with GROUP BY commands
Running advanced queries with string operations and comparison operations
Using logical operators to add logic flow to your SQL queries
Learning common SQL JOIN commands
Creating tables and databases with constraints on data entries
Using Python to further advance your SQL skills
And much more!

This course puts you in control. You’ll set up and restore databases right from the start, instead of just watching someone else code. Every section includes fresh challenge questions and tasks, modeled after real-world scenarios.

This course is built to combine the best of online and in-person instruction, allowing you to learn at your own pace through an interactive environment. You’ll 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 a highly sought-after skill for business analysts, data scientists, and anyone working with data. Upgrade your skill set quickly and add SQL to your resume by joining today!

This course is completely free and available on Udemy. Check out the free preview videos for more information!

Course Content

01 – Course Introduction

– Introduction

02:15
– Course Curriculum Overview

01:41
– Overview of Databases

07:37
– Windows Installation PostGreSQL and PgAdmin with Database Setup

21:09
– MacOS Installation PostgreSQL and PgAdmin with First Query

23:06
– pgAdmin Overview

09:44
Section Quiz

02 – SQL Statement Fundamentals

A Message from the Professor
009 – Overview of Challenges.mp4

00:00
010 – SQL Cheat Sheet.html

00:00
011 – SQL Statement Fundamentals.mp4

00:00
012 – SELECT Statement.mp4

00:00
013 – Challenge SELECT.mp4

00:00
014 – SELECT DISTINCT.mp4

00:00
015 – Challenge SELECT DISTINCT.mp4

00:00
016 – COUNT.mp4

00:00
017 – SELECT WHERE Part One.mp4

00:00
018 – SELECT WHERE Part Two.mp4

00:00
019 – Challenge SELECT WHERE.mp4

00:00
020 – ORDER BY.mp4

00:00
021 – LIMIT.mp4

00:00
022 – Challenge ORDER BY.mp4

00:00
023 – BETWEEN.mp4

00:00
024 – IN.mp4

00:00
025 – LIKE and ILIKE.mp4

00:00
026 – General Challenge 1.mp4

00:00
Section Quiz

03 – GROUP BY Statements

04 – Assessment Test 1

05 – JOINS

037 – Overview of JOINS.html

00:00
038 – Introduction to JOINs.mp4

00:00
039 – AS Statement.mp4

00:00
040 – Inner Joins.mp4

00:00
041 – Full Outer Joins.mp4

00:00
042 – Left Outer Join.mp4

00:00
043 – Right Joins.mp4

00:00
044 – UNION.mp4

00:00
045 – JOIN Challenge Tasks.mp4

00:00
Section Quiz

06 – Advanced SQL Commands

046 – Overview of Advanced SQL Commands.mp4

00:00
047 – Timestamps and Extract Part One.mp4

00:00
048 – Timestamps and Extract Part Two.mp4

00:00
049 – Quick Note on TOCHAR.html

00:00
050 – Timestamps and Extract Challenge Tasks.mp4

00:00
051 – Mathematical Functions and Operators.mp4

00:00
052 – String Functions and Operators.mp4

00:00
053 – SubQuery.mp4

00:00
054 – SelfJoin.mp4

00:00
Section Quiz

07 – Assessment Test 2

08 – Creating Databases and Tables

059 – Introduction to Section.mp4

00:00
060 – Data Types.mp4

00:00
061 – Primary Keys and Foreign Keys.mp4

00:00
062 – Constraints.mp4

00:00
063 – CREATE Table.mp4

00:00
064 – INSERT.mp4

00:00
065 – UPDATE.mp4

00:00
066 – DELETE.mp4

00:00
067 – ALTER Table.mp4

00:00
068 – DROP Table.mp4

00:00
069 – CHECK Constraint.mp4

00:00
Section Quiz

09 – Assessment Test 3

10 – Conditional Expressions and Procedures

11 – Extra PostGreSQL with Python

12 – BONUS SECTION THANK YOU

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

Muhammad Tayyab Sheikh

5 months ago

The course was well-structured, taking me from basic to advanced concepts. The clear explanations and practical exercises helped me solidify my understanding. I feel much more confident in my SQL skills now. I highly recommend it!

About Course

The Complete SQL Bootcamp: Go from Zero to Hero – Free!

What Will You Learn?

Course Content

01 – Course Introduction

– Introduction

– Course Curriculum Overview

– Overview of Databases

– Windows Installation PostGreSQL and PgAdmin with Database Setup

– MacOS Installation PostgreSQL and PgAdmin with First Query

– pgAdmin Overview

Section Quiz

02 – SQL Statement Fundamentals

A Message from the Professor

009 – Overview of Challenges.mp4

010 – SQL Cheat Sheet.html

011 – SQL Statement Fundamentals.mp4

012 – SELECT Statement.mp4

013 – Challenge SELECT.mp4

014 – SELECT DISTINCT.mp4

015 – Challenge SELECT DISTINCT.mp4

016 – COUNT.mp4

017 – SELECT WHERE Part One.mp4

018 – SELECT WHERE Part Two.mp4

019 – Challenge SELECT WHERE.mp4

020 – ORDER BY.mp4

021 – LIMIT.mp4

022 – Challenge ORDER BY.mp4

023 – BETWEEN.mp4

024 – IN.mp4

025 – LIKE and ILIKE.mp4

026 – General Challenge 1.mp4

Section Quiz

03 – GROUP BY Statements

027 – Introduction to GROUP BY.mp4

028 – Aggregation Functions.mp4

029 – GROUP BY Part One.mp4

030 – GROUP BY Part Two.mp4

031 – GROUP BY Challenge.mp4

032 – HAVING.mp4

033 – HAVING Challenge Tasks.mp4

Section Quiz

04 – Assessment Test 1

034 – Overview of Assessment Test 1.mp4

035 – Assessment Test 1.html

036 – Solutions to Assessment Test 1.html

05 – JOINS

037 – Overview of JOINS.html

038 – Introduction to JOINs.mp4

039 – AS Statement.mp4

040 – Inner Joins.mp4

041 – Full Outer Joins.mp4

042 – Left Outer Join.mp4

043 – Right Joins.mp4

044 – UNION.mp4

045 – JOIN Challenge Tasks.mp4

Section Quiz

06 – Advanced SQL Commands

046 – Overview of Advanced SQL Commands.mp4

047 – Timestamps and Extract Part One.mp4

048 – Timestamps and Extract Part Two.mp4

049 – Quick Note on TOCHAR.html

050 – Timestamps and Extract Challenge Tasks.mp4

051 – Mathematical Functions and Operators.mp4

052 – String Functions and Operators.mp4

053 – SubQuery.mp4

054 – SelfJoin.mp4

Section Quiz

07 – Assessment Test 2

055 – READ ME FIRST PLEASE.html

056 – Setting up New Database for Assessment Exercises.mp4

057 – Assessment Test 2.html

058 – Solutions to Assessment Test 2.mp4

Section Quiz

08 – Creating Databases and Tables

059 – Introduction to Section.mp4

060 – Data Types.mp4

061 – Primary Keys and Foreign Keys.mp4

062 – Constraints.mp4

063 – CREATE Table.mp4