The Beginners Guide to SQL and PostgreSQL
4.5 (27 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.
1,554 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Beginners Guide to SQL and PostgreSQL to your Wishlist.

Add to Wishlist

The Beginners Guide to SQL and PostgreSQL

Create Databases, Build Queries, Master SQL and PostgreSQL
4.5 (27 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.
1,554 students enrolled
Created by Jon Avis
Last updated 8/2017
English
Curiosity Sale
Current price: $10 Original price: $195 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 32 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to install and setup PostgreSQL
  • How to retrieve data from tables using SELECT statement.
  • Filter data using WHERE clauses.
  • Build complex queries to extract important data from databases using table JOINs.
  • Use AGGREGATE FUNCTIONS and group data using GROUP BY clauses.
  • How to CREATE, ALTER and DROP tables from a database.
  • How to INSERT, UPDATE and DELETE data from tables.
  • Upgrade your SQL skills from beginner to intermediate level.
View Curriculum
Requirements
  • No previous technical knowledge is needed for this course.
Description

Learn how to master SQL and PostgreSQL with this 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!

PostgreSQL is one of the most popular and widely used database systems in the world. Companies who use PostgreSQL include Apple, Cisco, Fujitsu, Skype and IMDB.

You will learn how to:

  • Retrieve data from database tables using the SELECT statement. 
  • Use JOINs to retrieve data from multiple tables.
  • Use aggregate functions and group data.
  • CREATE, ALTER and DROP databases and tables. 
  • INSERT, UPDATE and DELETE data from tables. 


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 quizzes and exercises along the way to help you improve your knowledge.

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 one of the most important and in-demand technology skills!

Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
83 Lectures
04:48:52
+
Overview
1 Lecture 02:58

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

Preview 02:58
+
Introduction to SQL
4 Lectures 21:19

In this video you will learn the basics of what a database and what SQL are. 

Databases and SQL
03:24

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

Preview 06:00

In this video you will setup the database in pgAdmin 4 which we will be using throughout the course.

Preview 10:34
+
Selecting from a Table
22 Lectures 01:12:27

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

Preview 05:32


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

Select Where
06:12

CODE: SQL for Where
00:08

In this video you will learn how to use more than one WHERE clause in a single SELECT statement.

Multiple Wheres
09:36

CODE: SQL for Multiple Wheres
00:11

Quiz 1: Selecting from a Table
3 questions

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

In, Not In
07:21

CODE: SQL for IN, NOT IN
00:11

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

Between
05:31

CODE: SQL for BETWEEN
00:09

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

Like
07:40

CODE: SQL for LIKE
00:18

Quiz 2: Selecting from a Table
3 questions

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

Order By
07:29

CODE: SQL for Order By
00:18

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

Limiting Number of Results
06:03

CODE: SQL for Limit
00:21

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

Distinct
05:25

CODE: SQL for Distinct
00:06

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

Setting a Column Name Alias
05:05

CODE: SQL for Setting a Column Name Alias
00:07

Summary of Selecting from a Table
02:21

Quiz 3: Selecting from a Table
3 questions
+
Selecting from Multiple Tables
17 Lectures 01:18:17
Section Introduction
01:49

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.

Joins
03:49

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

Inner Join Part 1
13:03

CODE: SQL for Inner Joins Part 1
00:13

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

Inner Join Part 2
07:48

CODE: SQL for Inner Joins Part 2
00:16

Quiz 1: Selecting from Multiple Tables
2 questions

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

Left Join
08:32

CODE: SQL for Left Joins
00:15

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

Right Join
06:32

CODE: SQL for Right Joins
00:15

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

Full Join
07:33

CODE: SQL for Full Joins
00:15

Quiz 2: Selecting from Multiple Tables
2 questions

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

Joining More Than Two Tables
13:47

CODE: SQL for Joining More Than Two Tables
00:21

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.

Union
11:34

CODE: SQL for Union
00:17

Summary of Selecting from Multiple Tables
01:57

Quiz 3: Selecting from Multiple Tables
2 questions
+
Aggregate Functions
12 Lectures 31:06
Count
04:04

CODE: SQL for Count
00:14

Min and Max
03:35

CODE: SQL for Min and Max
00:10

Sum
03:59

CODE: SQL for Sum
00:06

Average
03:03

CODE: SQL for Average
00:08

Group By
11:42

CODE: SQL for Group By
00:09

Having
03:44

CODE: SQL for Having
00:10
+
Data Definition Language
18 Lectures 59:08
Section Introduction
00:59

In this video you will learn the basics of what data definition language is and what it is used for.

What is Data Definition Language?
01:22

In this video you will learn about the different data types which can be entered into a database.

Data Types
07:54

In this video you will learn about the primary key concept.

Primary Keys
02:59

In this video you will learn about the foreign key concept. 

Foreign Keys
02:49

Creating Tables: Part 1
10:38

CODE: SQL for Creating Tables: Part 1
00:12

Creating Tables: Part 2
09:28

CODE: SQL for Creating Tables: Part 2
00:13

In this video you will learn how to add and remove columns from tables within a database. 

Modifying Tables: Adding and Removing Columns
05:29

CODE: SQL for Adding and Removing Columns
00:21

In this video you will learn how to modify table columns. You will learn how to add and remove constraints from a column as well as how to change the data type of a column.

Modifying Tables: Modifying Columns
10:12

CODE: SQL for Modifying Columns
00:42

In this video you will learn how to remove tables from a database. 

Removing Tables
01:41

CODE: SQL for Removing Tables
00:04

In this video you will learn how to remove all the rows of data within a table using the TRUNCATE statement.

Deleting All Rows from Tables
01:58

CODE: SQL for Deleting All Rows from Tables
00:04

Summary of Data Definition Language
02:00
+
Data Manipulation Language
9 Lectures 24:40
Section Introduction
00:36

In this video you will learn the basics of what data manipulation language is and what it is used for.

What is Data Manipulation Language?
00:56

In this video you will learn how to INSERT data into tables. You will also learn about some common errors faced when entering data into a table.

Inserting Data into Tables
09:16

CODE: SQL for Inserting Data into Tables
00:09

In this video you will learn how to update data that has already been entered into a table. You will learn how to update multiple values at once. 

Updating Data in Tables
07:43

CODE: SQL for Updating Data in Tables
00:20

In this video you will learn to DELETE single rows and multiple rows of data within a table. You will also learn how to DELETE all rows of data from a table.

Deleting Data from Tables
04:31

CODE: SQL for Deleting Data from Tables
00:13

Summary of Data Manipulation Language
00:55
About the Instructor
Jon Avis
4.5 Average rating
26 Reviews
1,554 Students
1 Course
Application Support Analyst

Hi, my name is Jon. I am from the UK and currently work in Hong Kong. I work in the financial industry as an IT Application Support Analyst. This has allowed me to become an expert on SQL, Databases, Unix, Shell Scripting and coding in multiple languages.

Part of my role as a Support Analyst is to teach complex, technical subjects to colleagues. Through Udemy I hope to do the same to many more students around the globe.