CF

The Complete SQL Bootcamp: Go from Zero to Hero

8h 45m 49s
English
Paid

Master the art of SQL and elevate your career prospects with our comprehensive bootcamp, designed to take you from a beginner to a SQL hero using PostgreSQL. Enhance your skills in a high-demand tech field with this immersive and interactive learning experience.

Course Overview

This course is packed with content that will guide you through reading and writing complex queries using SQL, a vital skill for many data-related professions. While we focus on PostgreSQL, you'll find the skills you build are applicable to other major SQL databases, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and more.

What You Will Learn

Our curriculum is designed to equip you with essential SQL skills, including:

  • Getting started with PostgreSQL and PgAdmin, two of the most popular SQL tools globally.
  • Understanding the basics of SQL syntax.
  • Analyzing data using aggregate functions with GROUP BY commands.
  • Executing advanced queries with string operations and comparison operators.
  • Employing logical operators for enhanced query logic flow.
  • Mastering common SQL JOIN commands.
  • Creating tables and databases with enforced data entry constraints.
  • Using Python to further hone your SQL abilities.
  • And many more advanced topics!

Why This Course?

Unlike traditional courses, this bootcamp puts you in the driver’s seat. From the very start, you'll set up and restore databases, working hands-on rather than watching demos. Each section includes practical challenge questions and tasks that simulate real-world scenarios.

Learn from Expert Instructors

Our instructors bring years of teaching experience both online and at top-tier Fortune 500 companies. This course blends these experiences, offering you the freedom to learn at your pace while benefiting from interactive and rich content. Start with foundational knowledge and advance to handling complex commands like a seasoned SQL professional.

Get Ahead in Your Career

SQL ranks among the top skills for business analysts, data scientists, and data-driven roles. Enhance your abilities and boost your resume by mastering SQL with us. Don't miss out on the opportunity to transform your career — enroll today and I'll see you inside the course!

About the Author: Udemy

Udemy thumbnail

Udemy is the largest open marketplace for online courses on the internet. Founded in 2010 by Eren Bali, Oktay Caglar, and Gagan Biyani and headquartered in San Francisco, the company went public on the Nasdaq in 2021 under the ticker UDMY. The platform hosts well over two hundred thousand courses across software development, IT and cloud, data science, design, business, marketing, and creative skills, taught by tens of thousands of independent instructors. Roughly seventy million learners use it worldwide, and the corporate arm — Udemy Business — supplies a curated subset of that catalog to enterprise customers.

Because Udemy is a marketplace rather than a single editorial publisher, the catalog is uneven by design. The strongest material lives in the long-form, project-based courses authored by working engineers — full-stack JavaScript, React, Node.js, Python data science, AWS, Docker and Kubernetes, mobile development with Flutter and React Native, and cloud certification preparation. The CourseFlix listing under this source is the slice of that catalog that has been mirrored here for offline-friendly viewing, organized by topic and updated as new releases land. Pricing on Udemy itself swings dramatically with the site's near-permanent sales, which is why the platform is best treated as a deep reference catalog: pick instructors with strong reviews and a track record of updating their material rather than buying on the headline price alone.

Watch Online 69 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 69 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction
All Course Lessons (69)
#Lesson TitleDurationAccess
1
Introduction Demo
02:16
2
Course Curriculum Overview
01:42
3
Overview of Databases
07:38
4
Windows Installation - PostGreSQL and PgAdmin with Database Setup
21:10
5
MacOS Installation - PostgreSQL and PgAdmin with First Query
23:07
6
pgAdmin Overview
09:45
7
Overview of Challenges!
01:37
8
SQL Statement Fundamentals
00:43
9
SELECT Statement
08:41
10
Challenge: SELECT
04:30
11
SELECT DISTINCT
05:39
12
Challenge: SELECT DISTINCT
01:55
13
COUNT
07:24
14
SELECT WHERE - Part One
04:31
15
SELECT WHERE - Part Two
07:05
16
Challenge: SELECT WHERE
05:36
17
ORDER BY
08:12
18
LIMIT
05:07
19
Challenge: ORDER BY
05:02
20
BETWEEN
06:58
21
IN
04:56
22
LIKE and ILIKE
09:37
23
General Challenge 1
09:55
24
Introduction to GROUP BY
00:58
25
Aggregation Functions
08:00
26
GROUP BY - Part One
07:49
27
GROUP BY - Part Two
10:43
28
GROUP BY - Challenge
04:06
29
HAVING
06:26
30
HAVING - Challenge Tasks
02:49
31
Overview of Assessment Test 1
01:09
32
Introduction to JOINs
01:15
33
AS Statement
07:49
34
Inner Joins
14:50
35
Full Outer Joins
14:23
36
Left Outer Join
11:19
37
Right Joins
04:22
38
UNION
02:28
39
JOIN Challenge Tasks
12:16
40
Overview of Advanced SQL Commands
00:48
41
Timestamps and Extract - Part One
07:39
42
Timestamps and Extract - Part Two
10:07
43
Timestamps and Extract - Challenge Tasks
03:40
44
Mathematical Functions and Operators
05:01
45
String Functions and Operators
08:25
46
SubQuery
15:12
47
Self-Join
10:56
48
Setting up New Database for Assessment Exercises
07:27
49
Solutions to Assessment Test 2
23:46
50
Introduction to Section
01:13
51
Data Types
06:28
52
Primary Keys and Foreign Keys
09:05
53
Constraints
05:18
54
CREATE Table
18:29
55
INSERT
09:06
56
UPDATE
07:59
57
DELETE
03:13
58
ALTER Table
06:48
59
DROP Table
03:19
60
CHECK Constraint
07:05
61
Conditional Expressions and Procedures Introduction
00:44
62
CASE
22:40
63
CASE - Challenge Task
03:10
64
COALESCE
05:36
65
CAST
07:08
66
NULLIF
10:35
67
Views
07:08
68
Import and Export
13:31
69
Psycopg2 Example Usage
10:25
Unlock unlimited learning

Get instant access to all 68 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Related courses

Frequently asked questions

What is The Complete SQL Bootcamp: Go from Zero to Hero about?
Master the art of SQL and elevate your career prospects with our comprehensive bootcamp, designed to take you from a beginner to a SQL hero using PostgreSQL . Enhance your skills in a high-demand tech field with this immersive and…
Who teaches this course?
It is taught by Udemy. You can find more courses by this instructor on the corresponding source page.
How long is the course?
It contains 69 lessons with a total runtime of 8 hours 45 minutes. Every lesson is available to watch online at your own pace.
Is it free to watch?
It is part of CourseFlix's premium catalog. A subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch it online?
The course is available to watch online on CourseFlix at https://courseflix.net/course/the-complete-sql-bootcamp-go-from-zero-to-hero. The page hosts every lesson with the integrated video player; no download is required.