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
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams. Udemy is the leading global marketplace for teaching and learning, connecting millions of students to the skills they need to succeed. Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.

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