The Complete SQL Bootcamp: Go from Zero to Hero

8h 45m 49s
English
Paid
October 14, 2024

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!

More

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 The Complete SQL Bootcamp: Go from Zero to Hero

Join premium to watch
Go to premium
# Title Duration
1 Introduction 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

Similar courses to The Complete SQL Bootcamp: Go from Zero to Hero

Learn Database Design with MySQL

Learn Database Design with MySQL

Duration 6 hours 14 minutes 51 seconds
Learn MySQL and Solve 42 Practical Problems

Learn MySQL and Solve 42 Practical Problems

Duration 4 hours 24 minutes 35 seconds
SQL - The Complete Guide (MySQL, PostgreSQL & more)

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

Duration 19 hours 35 minutes 38 seconds
Database Design & Implementation

Database Design & Implementation

Duration 2 hours 7 minutes 49 seconds
100 Days Of Code: The Complete Web Development Bootcamp 2024

100 Days Of Code: The Complete Web Development Bootcamp 2024

Duration 78 hours 51 minutes 55 seconds
MySQL High Performance Tuning Guide

MySQL High Performance Tuning Guide

Duration 2 hours 49 minutes 22 seconds
Mastery with SQL

Mastery with SQL

Duration 9 hours 15 minutes 2 seconds
Complete SQL Mastery

Complete SQL Mastery

Duration 10 hours 47 minutes 7 seconds
Zero To Shipped

Zero To Shipped

Duration 24 hours 38 minutes 44 seconds