The Complete SQL Bootcamp
4.6 (6,460 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.
40,844 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Complete SQL Bootcamp to your Wishlist.

Add to Wishlist

The Complete SQL Bootcamp

Become an expert at SQL!
Bestselling
4.6 (6,460 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.
40,844 students enrolled
Created by Jose Portilla
Last updated 3/2017
English
English
Current price: $10 Original price: $195 Discount: 95% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 8 hours on-demand video
  • 26 Articles
  • 16 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
View Curriculum
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!

Check out the free preview videos for more information!

Who is the target audience?
  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
88 Lectures
08:30:58
+
Course Introduction
7 Lectures 31:25



Course FAQs
01:22

Computer Set-up!

Time to get your Computer Set-Up!
02:54

Updated Guide for installation with pgAdmin 4

Preview 14:57

Notes on Installation.

Installation Notes
00:38
+
PostGreSQL Installation (Mac OS)
5 Lectures 18:32

Quick note regarding mac setup.

Mac OS X - Quick Note
00:26

Mac OS Installation
05:56

Mac Sample Database Download
00:52

Mac Database Set-up
10:42

Review of Set-up
00:35
+
PostGreSQL Installation (Windows)
4 Lectures 25:00

Quick Note for Windows

Windows - Quick Note
00:36

Overview of windows installation.

Windows Installation
04:07

Sample Database to Download

Sample Database Download
00:32

Windows Command Line Installation Lecture
19:45
+
Databases and Tables
7 Lectures 17:13
Databases and Tables Overview
01:12

Creating and Restoring a Database
06:21


Challenge to test your skills!

Challenge: Restore a Database!
00:42

Restoring a Table Schema
06:13

Challenge: Restore a Table Schema!
00:43

Review of Section
00:26
+
SQL Statement Fundamentals
16 Lectures 01:39:23

A cheat sheet for you!

SQL Cheat Sheet
00:18

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


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
+
GROUP BY Statements
6 Lectures 52:43

GROUP BY
18:10

Challenge:GROUP BY
12:15

HAVING
10:17

Quick correction for the next lecture.

Quick Note
00:12

Challenge:HAVING
03:43
+
Assessment Test 1
3 Lectures 01:43
Overview of Assessment Test 1
01:08

Assessment Test 1
00:21

Solutions to Assessment Test 1
00:14
+
JOINS
8 Lectures 01:10:36
Overview of JOINS
00:21

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
00:22
+
Advanced SQL Commands
6 Lectures 53:05
Overview of Advanced SQL Commands
00:33


Mathematical Functions
06:37

String Function and Operators
07:11

SubQuery
15:01

Self-Join
14:17
+
Assessment Test 2
3 Lectures 09:13

Get ready for Assessment Test #2!

Assessment Test 2 Overview
06:36

Test your SQL skills!

Assessment Test 2
01:45

Test your SQL skills!

Solutions to Assessment Test 2
00:52
5 More Sections
About the Instructor
Jose Portilla
4.6 Average rating
42,038 Reviews
216,690 Students
12 Courses
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 programming training courses to employees working at top companies, including General Electric, Cigna, The New York Times, Credit Suisse, and many more. Feel free to contact him on LinkedIn for more information on in-person training sessions.