The Complete SQL Bootcamp 2020: Go from Zero to Hero
4.7 (74,600 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
284,066 students enrolled

The Complete SQL Bootcamp 2020: Go from Zero to Hero

Become an expert at SQL!
Bestseller
4.7 (74,600 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
284,005 students enrolled
Created by Jose Portilla
Last updated 7/2020
English
English [Auto], French [Auto], 6 more
  • German [Auto]
  • Indonesian [Auto]
  • Italian [Auto]
  • Polish [Auto]
  • Portuguese [Auto]
  • Spanish [Auto]
Price: $194.99
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 15 articles
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and PostgreSQL on their resume
  • Learn to perform GROUP BY statements
  • Replicate real-world situations and query reports
Requirements
  • No prior technical experience is required! All you need a computer!
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!

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!

Check out the free preview videos for more information!

Who this course is for:
  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!
Course content
Expand all 84 lectures 08:52:11
+ Course Introduction
9 lectures 01:07:48
Welcome Message
00:34
Course Curriculum Overview
01:41
Overview of Databases
07:37
Course FAQs
01:12

Computer Set-up!

Time to get your Computer Set-Up!
00:30
MacOS Installation - PostgreSQL and PgAdmin with First Query
23:06
pgAdmin Overview
09:44
+ SQL Statement Fundamentals
18 lectures 01:37:29

A cheat sheet for you!

SQL Cheat Sheet
00:18
SQL Statement Fundamentals
00:42
SELECT Statement
08:40
Challenge: SELECT
04:29
SELECT DISTINCT
05:38
Challenge: SELECT DISTINCT
01:54
COUNT
07:23
SELECT WHERE - Part One
04:30
SELECT WHERE - Part Two
07:04
Challenge: SELECT WHERE
05:35
LIMIT
05:06
Challenge: ORDER BY
05:01
BETWEEN
06:57
IN
04:55
LIKE and ILIKE
09:36
General Challenge 1
09:54
+ GROUP BY Statements
7 lectures 40:44
Introduction to GROUP BY
00:57
Aggregation Functions
07:59
GROUP BY - Challenge
04:05
HAVING
06:25
HAVING - Challenge Tasks
02:48
+ Assessment Test 1
3 lectures 01:41
Overview of Assessment Test 1
01:08
Assessment Test 1
00:20
Solutions to Assessment Test 1
00:13
+ JOINS
9 lectures 01:08:49
Overview of JOINS
00:16
Introduction to JOINs
01:14
AS Statement
07:48
Full Outer Joins
14:22
Left Outer Join
11:18
Right Joins
04:21
UNION
02:26
JOIN Challenge Tasks
12:15
+ Advanced SQL Commands
9 lectures 01:01:54
Overview of Advanced SQL Commands
00:47
Timestamps and Extract - Part One
07:38
Timestamps and Extract - Part Two
10:06
Quick Note on TO_CHAR
00:15
Timestamps and Extract - Challenge Tasks
03:38
Mathematical Functions and Operators
05:00
String Functions and Operators
08:24
SubQuery
15:11
Self-Join
10:55
+ Assessment Test 2
4 lectures 32:46
READ ME FIRST PLEASE
01:20
Setting up New Database for Assessment Exercises
07:26

Test your SQL skills!

Assessment Test 2
00:15

Test your SQL skills!

Solutions to Assessment Test 2
23:45
+ Creating Databases and Tables
11 lectures 01:17:52
Introduction to Section
01:12
Data Types
06:27
Primary Keys and Foreign Keys
09:04
Constraints
05:17
CREATE Table
18:28
INSERT
09:05
UPDATE
07:58
DELETE
03:12
ALTER Table
06:47
DROP Table
03:18
CHECK Constraint
07:04
+ Assessment Test 3
2 lectures 01:23
Assessment Test 3
00:56
Solutions to Assessment Test 3
00:26
+ Conditional Expressions and Procedures
8 lectures 01:10:23
Conditional Expressions and Procedures Introduction
00:43
CASE
22:39
CASE - Challenge Task
03:08
COALESCE
05:35
CAST
07:07
NULLIF
10:34
Views
07:07
Import and Export
13:30