The Complete SQL Bootcamp

Become an expert at SQL!
4.6 (2,047 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
14,266 students enrolled Bestselling in SQL
$19
$195
90% off
Take This Course
  • Lectures 87
  • Length 8.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English Closed captions available

Course 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!

What are the requirements?

  • No prior technical experience is required! All you need a computer!

What am I going to get from this course?

  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and PostgreSQL on their resume

What is the target audience?

  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
Introduction
Preview
02:15
Course Curriculum Overview
Preview
01:41
Overview of Databases
Preview
07:37
Course FAQs
Article
Article

Computer Set-up!

14:57

Updated Guide for installation with pgAdmin 4

Section 2: PostGreSQL Installation (Mac OS)
Article

Quick note regarding mac setup.

Mac OS Installation
05:56
Mac Sample Database Download
Article
Mac Database Set-up
10:42
Review of Set-up
Article
Section 3: PostGreSQL Installation (Windows)
Article

Quick Note for Windows

04:07

Overview of windows installation.

Article

Sample Database to Download

Windows Command Line Installation Lecture
19:45
Section 4: Databases and Tables
Databases and Tables Overview
01:12
Creating and Restoring a Database
06:21
Overview of Challenges!
Preview
01:36
00:42

Challenge to test your skills!

Restoring a Table Schema
06:13
Challenge: Restore a Table Schema!
00:43
Review of Section
Article
Section 5: SQL Statement Fundamentals
Article

A cheat sheet for you!

SQL Statement Fundamentals
00:42
SELECT Statement
10:48
Challenge: SELECT task.
02:45
SELECT DISTINCT
05:46
Challenge: SELECT DISTINCT
02:05
SELECT WHERE
14:03
Challenge: SELECT WHERE
03:45
COUNT
Preview
05:00
LIMIT
02:59
ORDER BY
10:05
Challenge: ORDER BY
03:38
BETWEEN
08:44
IN
08:27
LIKE
10:24
General Challenge 1
09:54
Section 6: GROUP BY Statements
MIN MAX SUM and AVG
Preview
08:06
GROUP BY
18:10
Challenge:GROUP BY
12:15
HAVING
10:17
Article

Quick correction for the next lecture.

Challenge:HAVING
03:43
Section 7: Assessment Test 1
Overview of Assessment Test 1
01:08
Assessment Test 1
Article
Solutions to Assessment Test 1
Article
Section 8: JOINS
Overview of JOINS
Article
AS Statement
03:37
Overview of Inner Join
18:52
Examples of Inner Joins
16:21
Overview of Join types
12:55
Example of Outer Joins
11:47
Union
06:21
Join Challenges
Article
Section 9: Advanced SQL Commands
Overview of Advanced SQL Commands
Article
Timestamps and Extract
Preview
09:26
Mathematical Functions
06:37
String Function and Operators
07:11
SubQuery
15:01
Self-Join
14:17
Section 10: Assessment Test 2
06:36

Get ready for Assessment Test #2!

Article

Test your SQL skills!

Article

Test your SQL skills!

Section 11: Creating Databases and Tables
Overview of Section
03:28
Data Types
07:21
Primary Keys and Foreign Keys
09:43
Resource for Create Table Code
Article
Note on Constraints
Article
Create Table
19:47
Challenge: Create Table
Article
Challenge: Create Table - SOLUTION
05:50
Insert
15:31
Update
10:30
Delete
04:23
Alter Table
06:38
Drop Table
05:24
CHECK Constraint
09:48
NOT NULL Constraint
06:09
UNIQUE Constraint
04:53
Section 12: Assessment Test 3
Assessment Test 3
Article
Solutions to Assessment Test 3
Article
Section 13: Extra: Views
Views
08:48
Section 14: Extra: PostGreSQL with Python
Overview of Python and PostgreSQL
Article
Psycopg2 Example Usage
10:24
Psycopg2 Resources
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jose Portilla, Data Scientist

Jose Marcial Portilla has a BS and MS in Mechanical Engineering from Santa Clara University and years of experience as a professional instructor and trainer for Data Science and programming. He has publications and patents in various fields such as microfluidics, materials science, and data science technologies. Over the course of his career he has developed a skill set in analyzing data and he hopes to use his experience in teaching and data science to help other people learn the power of programming the ability to analyze data, as well as present the data in clear and beautiful visualizations. Currently he works as the Head of Data Science for Pierian Data Inc. and provides in-person data science and python training courses to a variety of companies all over the world, including top banks such as Credit Suisse. Feel free to contact him on LinkedIn for more information on in-person training sessions.

Ready to start learning?
Take This Course