4.42 out of 5
4.42
652 reviews on Udemy

SQL & PostgreSQL for Beginners

SQL & PostgreSQL Tutorial: Become an Expert in SQL and PostgreSQL by Writing SQL Queries using PostgreSQL and PgAdmin 4.
Instructor:
Jon Avis - SQL Instructor
4,566 students enrolled
English [Auto-generated]
How to create a database from scratch.
How to retrieve data from tables using select queries.
Filter data using where clauses in SQL.
Build complex SQL queries to extract important data from databases using table joins.
Use SQL aggregate functions and group data using group by clauses.
How to create, alter and delete tables from a database in PostgreSQL.
How to insert, update and delete data from tables in PostgreSQL.
How to install and setup PostgreSQL and PgAdmin 4.
Take your SQL and PostgreSQL skills to the next level.

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 is high 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. 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

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!

Course Introduction

1
Course Introduction

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

2
A Few Notes on this Course

Introduction to Databases, SQL and PostgreSQL

1
What is a Database?

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

2
Relational Databases and SQL

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.

3
Databases and SQL

A quiz to test your knowledge of databases, relational databases and SQL.

4
Installing PostgreSQL

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

SQL & PostgreSQL : Data Definition Language - Creating Our Movie Database

1
Section Introduction
2
Database Tables
3
Data Types Explained
4
Primary Keys and Foreign Keys
5
Unique, Not Null and Check Constraints
6
Creating Our First Table
7
Creating the Actors Table
8
Creating a Table with a Foreign Key
9
Creating the Movie Revenues Table
10
Creating a Junction Table
11
Modifying Tables Part 1: Adding Columns
12
Modifying Tables Part 2: Changing a Columns Data Type
13
Deleting Tables from a Database
14
Challenge: Data Definition Language
15
Solution: Data Definition Language
16
Section Summary

SQL & PostgreSQL: Data Manipulation Language

1
Section Introduction
2
Inserting Data into a Table
3
Updating Data in a Table
4
Deleting Data from a Table
5
Inserting Data into Our Movie Data Database
6
Challenge: Data Manipulation Language
7
Solution: Data Manipulation Language
8
Section Summary

SQL & PostgreSQL : Retrieving Data from a Table - Select Queries

1
Section Introduction
2
Select Queries

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

3
Where Clauses

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

4
Logical Operators
5
Challenge 1: Select Queries
6
Solution 1: Select Queries
7
In, Not In

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.

8
Like

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

9
Between

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.

10
Challenge 2: Select Queries
11
Solution 2: Select Queries
12
Order By

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

13
Limiting the Number of Results

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.

14
Fetch
15
Distinct Values

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

16
Challenge 3: Select Queries
17
Solution 3: Select Queries
18
Null Values
19
Setting a Column Name Alias

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.

20
Concatenation
21
Challenge 4: Select Queries
22
Solution 4: Select Queries
23
Section Summary

SQL & PostgreSQL : Aggregate Functions and Grouping Data

1
Section Introduction
2
Aggregate Functions Explained

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.

3
Count Aggregate Functions

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

4
Sum Aggregate Function

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

5
Min and Max Aggregate Functions
6
Average Aggregate Functions
7
Challenge 1: Aggregate Functions

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

8
Solution 1: Aggregate Functions

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

9
Grouping Data

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

10
Having Clauses
11
Challenge 2: Aggregate Functions

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

12
Solution 2: Aggregate Functions

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.

13
Section Summary

Database Relationships

1
Section Introduction
2
What Are Database Relationships?
3
One to One Relationships
4
One to Many Relationships
5
Many to Many Relationships
6
(Optional) Challenge: Database Relationships
7
Solution: Database Relationships
8
Section Summary

SQL & PostgreSQL: Joining Tables

1
Section Introduction
2
SQL Joins Explained
3
Inner Joins Part 1
4
Inner Joins Part 2
5
Inner Joins Part 3
6
Challenge 1: Joins
7
Solution 1: Joins
8
Left Joins
9
Right Joins
10
Full Joins
11
Challenge 2: Joins
12
Solutions 2: Joins
13
Joining More Than Two Tables
14
Challenge 3: Joins
15
Solution 3: Joins
16
Union
17
Union All
18
Challenge 4: Joins
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
652 Ratings

Detailed Rating

Stars 5
294
Stars 4
254
Stars 3
84
Stars 2
19
Stars 1
1
5236f33d4caa7ee801e174352b9db27c
30-Day Money-Back Guarantee

Includes

7 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion