IT & Software
IT Certification
PostgreSQL
SQL & PostgreSQL for Beginners: Become an SQL Expert
4.6 (2,256 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.
11,125 students enrolled

SQL & PostgreSQL for Beginners: Become an SQL Expert

SQL & PostgreSQL Tutorial: Become an Expert in SQL and PostgreSQL by Writing SQL Queries using PostgreSQL and PgAdmin 4.
Bestseller
4.6 (2,256 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.
11,125 students enrolled
Created by Jon Avis - SQL Instructor
Last updated 7/2020
English
English [Auto]
Preview this course
SQL & PostgreSQL for Beginners: Become an SQL Expert
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 2 articles
  • 28 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
  • How to create a database from scratch.
  • Use SQL to perform data analysis.
  • Perform complex SQL queries using joins and subqueries.
  • Understand database concepts such as database relationships.
  • Confident putting SQL and PostgreSQL on your resume.
Requirements
  • No previous knowledge of SQL or PostgreSQL is needed for this course.
Description

Become an expert in SQL and PostgreSQL with this bestselling course!

SQL is one of the most in-demand tech skills across many industries so learning SQL is one of the best ways to boost your career! After taking this course you will be comfortable putting SQL and PostgreSQL on your resume/CV. 

In the age of Big Data and Data Analysis, demand for employees with SQL skills has never been higher and will only increase in the future. Stand out from the crowd and learn SQL today.

PostgreSQL is the World’s most advanced open source relational database. It has a strong reputation for its reliability, data integrity and robustness. Because of this, PostgreSQL is one of the most popular and widely used database systems in the world. Companies who use PostgreSQL include Apple, Cisco, Spotify, Fujitsu, Skype, Netflix and IMDb.

A 2018 survey of stackoverflow developers reported that one third of developers used PostgreSQL on a daily basis in their professional lives, up from 25% in 2017. In 2019 PostgreSQL was the fastest growing database for the second year in a row. PostgreSQL experience really is a desired skill in the tech industry.


Here's what students are saying about this SQL course: 

Christopher says - "A really great course. The structure was well setup and the pacing was perfect. Each section and lecture flowed well in to the next. The exercises and solutions were very helpful. I was new to sql and postgresql before taking this course but I can now say that I am comfortable with both."

Erin Todd says - "I love this course so far very easy to follow and interactive."

Raymond Beauchamp says - "Amount of information is good for a beginner course. Was beneficial in increasing my understanding of the subject. Instructor was knowledgeable, and was easy to follow."

John Hellmann says - "Very concise lectures! Was a great course overall"

Abhinav Sharma says - "The explanations are really clear and the course structure is very well thought out."


By the end of this course you will know how to:

  • Create a relational database from scratch

  • Create, alter and delete tables from a database

  • Insert, update and delete data from a table

  • Retrieve data from a database using select queries

  • Filter data using where clauses and logical operators

  • Order and limit data retrieved from a table

  • Use aggregate functions and group data to gain more meaningful insights from a database

  • Relate tables together using database relationships

  • Use SQL join queries to retrieve data from multiple tables in a single query

  • Master complex SQL subqueries

  • Apply SQL string functions to data in PostgreSQL


A step-by-step video of how to install and setup PostgreSQL is included and the setup is completely FREE.

The SQL code for each video is included as a resource so you can easily access it. 

There are SQL exercises, and video solutions, along the way to help you improve your knowledge and SQL skills. 

I will be actively answering any questions you may have about the course in the Q&A section. 

The course will be continually updated with more sections in the future.

Watch the free preview videos and start learning SQL - one of the most important and in-demand technology skills!

Who this course is for:
  • Anyone wanting to learn SQL or PostgreSQL.
  • Anyone with a basic knowledge of SQL but is new to PostgreSQL.
  • Anyone wanting to learn more about databases.
Featured review
Rodrigo Figueiredo
Rodrigo Figueiredo ( 7 courses, 1 review )
a year ago
Nice and clear lessons. It's really easy to understand when the lessons are well segmented. For total beginners in SQL, who want to start codding already, this is a great option! On the other hand, for those whose goal is to learn the peculiarities and advanced resources of PostgreSQL, keep in mind that this is a beginner course and thus needs to focus on the SQL fundamentals. I do recommend this course to everyone who wants to learn, is learning, or needs to refresh the knowledge of SQL!
Course content
Expand all 125 lectures 09:11:44
+ – Course Introduction
2 lectures 02:54

An overview of the topics that will be covered in the course.

Course Introduction
Preview 02:25
A Few Notes on this Course
00:29
+ – Introduction to Databases, SQL and PostgreSQL
4 lectures 20:26

In this video you will learn the definition of a database and look at an example database.

What is a Database?
03:08

We will learn what a relational database is, what a relational database management system is and also what SQL is and what it is used for.

Relational Databases and SQL
04:11

In this video you will learn how to install and setup PostgreSQL for Mac.

Installing PostgreSQL for Mac
05:16

In this video you will learn how to install and setup PostgreSQL for Windows.

Installing PostgreSQL for Windows
07:51
+ – SQL & PostgreSQL : Data Definition Language - Creating Our Movie Database
16 lectures 01:15:44
Section Introduction
01:16

This video explains the structure of tables within relational databases.

Database Tables
04:02

This video explains the different data types that can be stored in databases.

Data Types Explained
07:44

In this video you will learn about the Primary Key and Foreign Key concepts and how they are used in databases.

Primary Keys and Foreign Keys
04:15
Unique, Not Null and Check Constraints
04:28
Creating Our First Table
09:36
Creating the Actors Table
05:21
Creating a Table with a Foreign Key
Preview 05:29
Creating the Movie Revenues Table
06:05
Creating a Junction Table
04:23
Modifying Tables Part 1: Adding Columns
07:33
Modifying Tables Part 2: Changing a Columns Data Type
Preview 04:11
Deleting Tables from a Database
02:44
Challenge: Data Definition Language
01:11
Solution: Data Definition Language
06:25
Section Summary
01:01
+ – SQL & PostgreSQL: Data Manipulation Language
8 lectures 39:25
Section Introduction
00:40
Inserting Data into a Table
09:12
Updating Data in a Table
Preview 07:22
Deleting Data from a Table
03:47
Inserting Data into Our Movie Data Database
07:13
Challenge: Data Manipulation Language
01:17
Solution: Data Manipulation Language
09:15
Section Summary
00:39
+ – SQL & PostgreSQL : Retrieving Data from a Table - Select Queries
23 lectures 01:40:14
Section Introduction
01:37

In this video you will learn how to use the SELECT query to extract data from tables in PostgreSQL.

Select Queries
Preview 03:09

In this video you will learn how to use WHERE clauses in PostgreSQL to filter results based on row values. 

Where Clauses
Preview 06:05
Logical Operators
07:34
Challenge 1: Select Queries
01:01
Solution 1: Select Queries
04:19

In this video you will learn how to use the IN and NOT IN operators in PostgreSQL to filter your extractions by multiple row values.

In, Not In
05:47

In this video you will learn how to use the LIKE operator in PostgreSQL to search for rows containing a specified pattern.

Like
07:29

In this video you will learn how to use the BETWEEN operator in PostgreSQL to extract results for rows between two values. This is particularly useful for dates.

Between
07:32
Challenge 2: Select Queries
01:06
Solution 2: Select Queries
04:54

In this video you will learn how to ORDER your result sets alphabetically and numerically as well as by date in PostgreSQL.

Order By
08:38

In this video you will learn how to LIMIT the number of results in your extraction as well as how to use an OFFSET in PostgreSQL.

Limiting the Number of Results
04:39
Fetch
03:58

In this video you will learn how to remove duplicate values from your result sets in PostgreSQL.

Distinct Values
Preview 03:50
Challenge 3: Select Queries
00:44
Solution 3: Select Queries
04:01
Null Values
05:11

In this video you will learn how to set a column name alias in PostgreSQL. This will help to make your result set more readable.

Setting a Column Name Alias
05:10
Concatenation
06:44
Challenge 4: Select Queries
00:44
Solution 4: Select Queries
04:51
Section Summary
01:11
+ – SQL & PostgreSQL : Aggregate Functions and Grouping Data
14 lectures 55:18
Section Introduction
00:56

In this video you will learn what a JOIN is, what it is used for, and what the differences between the most common JOIN statements are.

Aggregate Functions Explained
01:56

In this video you will learn how to write INNER JOIN statements in SQL to return data from more than one table.

Count Aggregate Functions
04:07

In this video you will learn how to write more complex INNER JOINs that include WHERE clauses.

Sum Aggregate Function
Preview 04:00
Min and Max Aggregate Functions
05:29
Average Aggregate Functions
02:44

In this video you will learn how to write LEFT JOINs and how they differ from INNER JOINs. 

Challenge 1: Aggregate Functions
01:05

In this video you will learn how to write RIGHT JOINs and how they are different from LEFT JOINs. 

Solution 1: Aggregate Functions
04:23

In this video you will learn how to write FULL JOINs.

Grouping Data
11:26
Having Clauses
04:51

In this video you will learn how to SELECT data from more than two tables by JOINing multiple tables together. 

Challenge 2: Aggregate Functions
00:46

In this video you will learn how you can SELECT from multiple tables using the UNION and UNION ALL statements. You will also learn the difference between UNION and UNION ALL.

Solution 2: Aggregate Functions
04:42
Mathematical Operators
07:56
Section Summary
00:57
+ – Database Relationships
8 lectures 22:56
Section Introduction
00:54
What Are Database Relationships?
01:31
One to One Relationships
03:27
One to Many Relationships
04:00
Many to Many Relationships
04:35
(Optional) Challenge: Database Relationships
02:27
Solution: Database Relationships
05:21
Section Summary
00:41
+ – SQL & PostgreSQL: Joining Tables
24 lectures 01:50:35
Section Introduction
01:09
SQL Joins Explained
10:07
Inner Joins Part 1
Preview 11:28
Inner Joins Part 2
05:30
Inner Joins Part 3
04:34
Challenge 1: Joins
01:08
Solution 1: Joins
07:22
Left Joins
05:55
Right Joins
03:23
Full Joins
03:32
Challenge 2: Joins
00:38
Solutions 2: Joins
05:27
Joining More Than Two Tables
11:33
Challenge 3: Joins
01:06
Solution 3: Joins
08:46
Union
06:09
Union All
03:48
Challenge 4: Joins
00:42
Solution 4: Joins
04:45
Intersect
03:44
Except
04:07
Challenge 5: Joins
00:42
Solution 5: Joins
03:58
Section Summary
01:02
+ – SQL & PostgreSQL: Subqueries
10 lectures 47:39
Section Introduction
00:47
Subqueries Explained
05:03
Uncorrelated Subqueries Part 1
08:15
Uncorrelated Subqueries Part 2
06:01
Challenge 1: Subqueries
01:29
Solution 1: Subqueries
08:54
Correlated Subqueries
07:19
Challenge 2: Subqueries
01:12
Solution 2: Subqueries
07:41
Summary
00:58
+ – SQL & PostgreSQL: String Functions
15 lectures 01:16:25
Section Introduction
01:34
Cloning a Database
04:02
Upper and Lower String Functions
06:19
Initcap Function
04:08
Left and Right String Functions
08:43
Reverse Function
02:17
Challenge 1: String Functions
01:19
Solution 1: String Functions
11:54
Substring Function
05:16
Replace Function
09:04
Split Part Function
07:20
Using the Cast Operator to Apply String Functions to Non-String Data Types
05:40
Challenge 2: String Functions
00:53
Solution 2: String Functions
06:52
Summary
01:04