The Complete SQL Bootcamp: Go from Zero to Hero

8h 45m 49s
English
Paid

Course description

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!

Read more about the course

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!

Watch Online

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

Watch Online The Complete SQL Bootcamp: Go from Zero to Hero

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

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Ultimate Expert Guide: Mastering PostgreSQL Administration

Ultimate Expert Guide: Mastering PostgreSQL Administration

Sources: udemy
With the increasing popularity of Open Source Databases, organisations are looking for best alternatives among the widely available choices in the market. Among
10 hours 19 minutes 42 seconds
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Sources: udemy
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but compreh...
36 hours 35 minutes 57 seconds
SQL and PostgreSQL: The Complete Developer's Guide

SQL and PostgreSQL: The Complete Developer's Guide

Sources: udemy, Stephen Grider
SQL and PostgreSQL: The Complete developer’s Guide is a comprehensive SQL language training course and PostgreSQL database management system . Nowadays, all app
22 hours 1 minute
SQL - The Complete Guide (MySQL, PostgreSQL & more)

SQL - The Complete Guide (MySQL, PostgreSQL & more)

Sources: Academind Pro
SQL is THE most important query language you can learn! It's used by many popular database management systems like MySQL or PostgreSQL. But it's also used by data analysis and b...
19 hours 35 minutes 38 seconds
Make a Google search engine clone: JavaScript PHP and MySQL

Make a Google search engine clone: JavaScript PHP and MySQL

Sources: udemy
Do you want to become an expert in JavaScript, PHP and MySQL?Do you want to build a real search engine just like Google? If so, you’re in the right place!
5 hours 47 minutes 11 seconds