PostgreSQL For Beginners

Learn PostgreSQL quickly with Practical Hands-On Easy to Follow Videos

3.95 (92 reviews)
Udemy
platform
English
language
Databases
category
PostgreSQL For Beginners
1,076
students
7.5 hours
content
Aug 2021
last update
$34.99
regular price

What you will learn

Use

Filter Data with WHERE clause

Retrieve Data from multiples using Table Joins

Implement Constraint on table columns

Use wildcards to search data patterns

Perform CRUD operation on PostgreSQL Database

Build complex PostgreSQL statement using Subqueries

DROP Tables

Truncate Tables

Sort Data returned by SELECT statement

GROUP Data

Query all Data from a Table

Query specific data from a Table

Description

PostgreSQL is commonly known as Postgres and it is also  open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.


 The course also covers the basics of creating tables, storing data with data types, and working with expressions,  operators, and strings.

Topics include:
Installing PostgreSQL
Verify postgresql installation
postgresql INSERT Statement
Postgres UNIQUE Constraints
Postgres Truncate statement
Postgres  UPDATE
Postgresql INNER JOIN
Removing Duplicate Records
Postgres LIKE Operator
Postgresql OR Operator
Sorting Data
Server service
Sequences
Schema
Retrieving all Data from Table
Query Data fro specific column
Loading sample database
Postgresql DELETE Statement
Postgresql DATA Types
Postgresql CREATE Table Statement
Postgresql SubQuery
Postgresql UNION Operator
PostgreSQL ORDER BY clause
PostgreSQL UNION ALL Operator
PostgreSQL GROUP BY clause
PostgreSQL FULL OUTER JOIN
PostgreSQL CROSS JOIN
PostgreSQL combining AND | OR  Operator
PostgreSQL AND Operator
PostgreSQL BETWEEN Operator
PostgreSQL NATURAL JOIN Operator
PostgreSQL SELECT statement
CRUD Operations
PostgreSQL EXCEPT Operator
Create a Database with PG4ADMIN
Create a Table with PG4ADMIN
PostgreSQL NOT Operator
PostgreSQL NOT BETWEEN Operator
PostgreSQL LIMIT Operator
PostgreSQL INTERSECT Operator
PostgreSQL Left Join
PostgreSQL IN Operator
PostgreSQL HAVING clause
Comparison operators
Cast and Operators
Filtering Data with WHERE clause


This is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL .




Content

Installing PostgreSQL Server and Database

Introduction
PostgreSQL Server Minimum Requirements
Installing PostgreSQL on Windows
Installing Python on Macs
Installing PostgreSQL on Linux
Installing PgAdmin Tool on MacOS
Installing PostgreSQL on Linux
Connecting to PostgreSQL Database Server
Download Sample Database
What is PostgreSQL
Who is Using PostgreSQL

PostgreSQL Server and Database Objects

Introduction
Server service
Database
Table
Schema
Tablespace
views
Functions
Cast and Operators
Sequences
Extensions
Section Summary

PostgreSQL Fundamentals

PostgreSQL Data Types
PostgreSQL UNIQUE Constraint
Filtering Data with WHERE clause
Retrieving all Data from Table
Query Data from specific column
Removing Duplicate Records
Sorting Data
PostgreSQL ORDER BY clause
PostgreSQL Group By
PostgreSQL Having
PostgreSQL Truncate and DROP Table

PostgreSQL CRUD Operations

Introduction to PostgreSQL CRUD Operations
Create a Database with PG4ADMIN
Create a Table with PG4ADMIN
PostgreSQL CREATE Table Statement
PostgreSQL SELECT statement - Reading data
PostgreSQL Subquery
PostgreSQL UPDATE
PostgreSQL DELETE Statement
PostgreSQL INSERT Statement

PostgreSQL Operators

PostgreSQL Comparison operators
PostgreSQL BETWEEN Operator
PostgreSQL NOT BETWEEN Operator
PostgreSQL NOT Operator
Postgres LIKE Operator
PostgreSQL OR Operator
PostgreSQL AND Operator
PostgreSQL combining AND | OR Operator
PostgreSQL LIMIT Operator
PostgreSQL IN Operator
Postgress UNION Operator
PostgreSQL UNION ALL Operator
PostgreSQL INTERSECT Operator
PostgreSQL EXCEPT Operator

Getting Data from Multiple Tables with Table JOINS

Introduction to Postgres JOINS
PostgreSQL Inner Join
PostgreSQL Left Join
PostgreSQL Full Outer Join
PostgreSQL Cross Join
PostgreSQL Natural Join

Implementing Database Security with Roles

Introduction
Database Role
Role Attributes
Role Membership
Group and user role inheritance
Removing Roles
Default Roles
Defining Roles

Database Backup and Restore

Introduction
Backing up a single database with pg_dump
Backing up a single database using pgadmin
Restoring a database
Restoring a database using pgrestore
Restoring a database using pgadmin
Thank You

Reviews

Patricio
April 26, 2022
Very basic and very useful if you know nothing about PostgreSQL. Lacks some examples and some are redundant. Muy básico ymuy util si no sabes nada de PostgreSQL. Faltan ejemplos y algunos son redundantes
Will
August 22, 2021
- Examples are not illustrative or interesting - Voice is extremely slow even on 2x speed - Wastes time in each video explaining the same concepts (how to access the db) - Several videos are out of order - Explains how to connect to the server in Windows only
Jeff
June 1, 2020
Based on the title and summary, I was hoping to learn more about PostgreSQL and not re-learn basic SQL syntax (which I already know from other databases). This course is only half about PostgreSQL.
Paul
November 5, 2018
The delivery is very dry. Fortunately, I'm drinking coffee or I'd be falling asleep by now (even the coffee wasn't enough at times). A lot of time wasted showing us over and over how to find pgAdmin and enter the password. Some of his explanations miss the point. For example, the "CROSS JOIN" lecture never explains what a cartesian product is and the repeated emphasis on combining all of the columns, rather than rows, gives an incorrect impression at best. The examples are trivial and meaningless for the most part. These constructs are useful to answer real business problems and make more sense when illustrated in that manner. The amount of information you actually get from this course could be covered in a an hour or two. The delivery is slow, boring, and uninformative. Except for one or two concepts that are unique to Postgres, this is a poor intro to SQL course. There are much better courses (see Khan Academy) which may or may not use Postgres for their examples. At this level, the database is largely immaterial. Don't waste your time and money on this course.
William
September 28, 2017
This course is absolute beginner level, which is fine. It will not be useful to someone who already has some SQL experience who e.g. needs to know what is particular to PostgreSQL, and many important details are glossed over or not mentioned. (e.g. subtleties of different data types, why you would choose some over others for certain purposes; how do different versions of SQL vary on certain clauses, functions; how to deal with temporal data; no mention of WITH clauses; etc.) The videos really needed to be edited, some parts better organized. All of the videos appear to have been made in one take with no edits. Some typos. Unnecessary repetition between videos. Presentation is very slow; I had to watch it at 1.5x and 2.0x speed. Even so I did learn some things about pgAdmin and aspects of SQL that I rarely use.
James
August 31, 2017
The explanation is very shallow and uninsightful. Many times the teacher just rephrases the names of the things on the screen without useful explanation. For example, even at chapter 2, he hasn't explained what are scripts, dependencies, and "schemas" is sorely lacking: what's a "logical container"? What does he mean by "other database objects"? I will most likely request for a refund if the remaining videos do not reflect a higher quality of content. I am learning PostgreSQL completely from scratch, but I've learned basic SQL functions before.
Brian
April 25, 2017
Enjoyed the course and found it very informative, I have never used PostgreSQL before so found the information very helpful.

Charts

Price

PostgreSQL For Beginners - Price chart

Rating

PostgreSQL For Beginners - Ratings chart

Enrollment distribution

PostgreSQL For Beginners - Distribution chart

Related Topics

1184226
udemy ID
4/18/2017
course created date
11/11/2021
course indexed date
Bot
course submited by