The Complete SQL Bootcamp

Become an expert at SQL!

All Levels 4.5(48,305 Ratings) 200,953 Students enrolled
Created by Jose Portilla Last updated 09/2019 English English
What will i learn?
  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and PostgreSQL on their resume

Curriculum for this course
88 Lectures 08:22:26
Course Introduction
4 Lectures 00:34:47
  • Introduction 00:02:15
  • Course Curriculum Overview 00:01:41
  • Overview of Databases 00:07:37
  • Installing PostGreSQL and PgAdmin with Database Setup 00:23:14
  • Course FAQs 00:01:22 Time to get your Computer Set-Up! 00:00:44 Installation Notes 00:00:11
  • Overview of Challenges! 00:01:36
  • SQL Statement Fundamentals 00:00:42
  • SELECT Statement 00:10:48
  • Challenge: SELECT task. 00:02:45
  • SELECT DISTINCT 00:05:46
  • Challenge: SELECT DISTINCT 00:02:05
  • SELECT WHERE 00:14:03
  • Challenge: SELECT WHERE 00:03:45
  • COUNT 00:05:00
  • LIMIT 00:02:59
  • ORDER BY 00:10:05
  • Challenge: ORDER BY 00:03:38
  • BETWEEN 00:08:44
  • IN 00:08:27
  • LIKE 00:10:24
  • General Challenge 1 00:09:54
  • SQL Cheat Sheet 00:00:18
  • MIN MAX SUM and AVG 00:08:06
  • GROUP BY 00:18:10
  • Challenge:GROUP BY 00:12:15
  • HAVING 00:10:17
  • Challenge:HAVING 00:03:43
  • Quick Note 00:00:12
  • Overview of Assessment Test 1 00:01:08
  • Assessment Test 1 00:00:21 Solutions to Assessment Test 1 00:00:14
  • AS Statement 00:03:37
  • Overview of Inner Join 00:18:52
  • Examples of Inner Joins 00:16:21
  • Overview of Join types 00:12:55
  • Example of Outer Joins 00:11:47
  • Union 00:06:21
  • Overview of JOINS 00:00:21 Join Challenges 00:00:22
  • Timestamps and Extract 00:09:26
  • Mathematical Functions 00:06:37
  • String Function and Operators 00:07:11
  • SubQuery 00:15:01
  • Self-Join 00:14:17
  • Overview of Advanced SQL Commands 00:00:33
  • Assessment Test 2 Overview 00:06:36
  • Assessment Test 2 00:01:45 Solutions to Assessment Test 2 00:00:52
  • Overview of Section 00:03:28
  • Data Types 00:07:21
  • Primary Keys and Foreign Keys 00:09:43
  • Create Table 00:19:47
  • Challenge: Create Table - SOLUTION 00:05:50
  • Insert 00:15:31
  • Update 00:10:30
  • Delete 00:04:23
  • Alter Table 00:06:38
  • Drop Table 00:05:24
  • CHECK Constraint 00:09:48
  • NOT NULL Constraint 00:06:09
  • UNIQUE Constraint 00:04:53
  • Resource for Create Table Code 00:00:44 Note on Constraints 00:00:19 Challenge: Create Table 00:00:24
    Assessment Test 3 00:00:58 Solutions to Assessment Test 3 00:00:28
  • Views 00:08:48
  • Psycopg2 Example Usage 00:10:24
  • Overview of Python and PostgreSQL 00:00:32 Psycopg2 Resources 00:00:13
  • Databases and Tables Overview 00:01:12
  • Creating and Restoring a Database 00:06:21
  • Challenge: Restore a Database! 00:00:42
  • Restoring a Table Schema 00:06:13
  • Challenge: Restore a Table Schema! 00:00:43
  • Review of Section 00:00:26
  • Mac OS Installation 00:05:56
  • Mac Database Set-up 00:10:42
  • Windows Installation 00:04:07
  • Windows Command Line Installation Lecture 00:19:45
  • Mac OS X - Quick Note 00:00:26 Mac Sample Database Download 00:00:52 Review of Set-up 00:00:35 Windows - Quick Note 00:00:36 Sample Database Download 00:00:32
    Bonus Lecture 00:00:11
Requirements
  • No prior technical experience is required! All you need a computer!
+ View more
Description

Learn how to use SQL quickly and effectively with this course!

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!

Check out the free preview videos for more information!

+ View more
Other related courses
02:54:58
Updated Tue, 06-Nov-2018
4 10 $49.99 Free
13:08:26
Updated Tue, 24-Dec-2019
3.6 12 Free
00:40:13
4 0 Free
03:55:20
4.4 3 $99.99 Free
01:06:13
Updated Thu, 28-Nov-2019
4.3 5 $19.99 Free
00:43:00
4 5 $199.99 Free
00:48:22
3.5 7 Free
08:35:07
4.3 19 $79.99 Free
07:33:37
4.5 26 $199.99 Free
00:56:31
3 0 Free
01:05:47
Updated Sun, 19-Jan-2020
0 0 Free
00:41:36
Updated Fri, 17-Jan-2020
2.2 1 Free
14:31:41
4.4 2 $189.99 Free
01:13:31
Updated Tue, 12-Dec-2017
4.6 0 Free
00:30:22
4.3 1 Free
05:47:36
4 4 $29.99 Free
02:38:46
4 3 $29.99 Free
01:10:37
0 2 Free
00:48:17
4 2 $199.99 Free
00:34:24
4.1 0 $199.99 Free
06:09:45
Updated Thu, 04-Oct-2018
4 2 $99.99 Free
02:12:14
3.5 2 $99.99 Free
14:40:42
4.4 16 $199.99 Free
About the instructor
  • 209 Students
  • 6 Courses
+ View more
Head of Data Science, Pierian Data Inc.
Student feedback
4.5
Average rating
  • 1%
  • 1%
  • 13%
  • 68%
  • 115%
Comments
Free $194.99
Includes:
  • 08:22:26 On demand videos
  • 88 Lessons
  • Full lifetime access
  • Access on mobile and tv