Up and Running With PostgreSQL 11

The Modern and Most Used Relational Database

4.55 (203 reviews)
Udemy
platform
English
language
Databases
category
instructor
4,584
students
4 hours
content
May 2019
last update
$44.99
regular price

What you will learn

What PostgreSQL is

SQL

SQL Joins and Relationships

Aggregate Data

Work with SQL Dates

Database Constraints

How Sequence data type works internally

CRUD Operations

SQL Error Handling

Create and Connect To Database

The Right Way To Create Tables

Export Query Results to CSV File

SQL Arithmetic Operators

Data Types

Description

Overview

PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system widely used to build back end systems.

Startups including big companies such as Apple, Cisco, Redhat and more use Postgres to drive their business.

The Goal of this course is to help anyone to become familiar with Relational Databases and learn most common used SQL statements, allowing you execute queries agains any relational database.


Course Road Map

  • Introduction to PostgreSQL

  • Setup your environment and get ready to start coding for both MacOS and Windows

  • Create, Read, Update & Delete (CRUD) commands

  • Learn about different ways of filtering data using where clause

  • Work with Date and Timestamps

  • Lean how to to Join and Left Join to combine data from one more tables

  • Postgres extensions and how sequences are managed

  • Learn how to create tables with the right constraints

  • Learn how to export data to CSV files

  • Congratulations. You will be ready to right SQL and have a great understanding of Postgres database

Let's get started now

Content

Introduction

Welcome
What is a database
SQL and Relational Databases
What is PostreSQL AKA Postrgres
Postgres Installation (MAC OS)
Postgres Installation (Windows)
Setting up PSQL (MAC OS)
Setting up PSQL (Windows)

Creating databases and tables

Creating a database
Connecting to databases
A very dangerous command
Create table syntax + Datatypes
Create Table Without Constraints
Create Table With Constraints

Insert and Querying records

How to Insert Data (Keynote)
Insert Into
Select From
Inserting One Thousand Records
Sorting
Removing Duplicates with Distinct Keyword

Filtering Data

Where and And
Comparison Operators
Limit, Offset and Fetch
In keyword
Between Keyword
Like and ILike

Grouping Data

Group By
Having
Adding a second table
Min, Max and Avg
Sum

Operators

Arithmetic Operators
Arithmetic Operators On Tables
Aliases

Handing Nulls

Coalesce
Handle Division by 0 with NULL IF

Working with Dates

Timestamp and Date
Adding and Subtracting Dates With INTERVAL
Extracting Fields From TIMESTAMP
Age Function

PostgreSQL Constraints

Primary Keys
Understanding primary keys and Dropping PK Constraint
Adding Primary Constraint
Unique Constraints
Check Constraints

Modifying Data

Deleting Records
Updating Records
On Conflict Do Nothing
Upsert (On Conflict Do Update)

Relationships and Joins

Relationships and Joins (Diagram)
Adding Relationships (Foreign Key)
Updating Foreign Key Columns
Inner Join
Left Join
Deleting Records With Foreign Keys

Sequences and Extensions

Exporting Query Results To CSV
Sequences
PosgtreSQL Extensions
Generating UUIDs
Using UUID's as Primary Keys

Screenshots

Up and Running With PostgreSQL 11 - Screenshot_01Up and Running With PostgreSQL 11 - Screenshot_02Up and Running With PostgreSQL 11 - Screenshot_03Up and Running With PostgreSQL 11 - Screenshot_04

Reviews

Peter
September 26, 2022
The instructor doesn't seem to care if the video is correct or not? He has been asked several times about missing instructions & has not really corrected the problem. He is also working on a Mac without really considering the Windows users. So I'm going to find a course where the instructor covers all options. Disappointing!
Rayden
December 22, 2020
Hope to have another module of how to use other development tools to integrate postgres into applications.
Michael
December 2, 2020
This is a concise introduction to SQL using Postgres. The lecturer is clearly spoken and articulate explaining all of the key concepts without fuss.
Víctor
July 17, 2020
Muy buen curso, bien explicado hasta para los que no somos hablantes de ingles de manera nativa, muy recomendado, very good course.
Carlos
July 7, 2020
I finished this course on Linux and it worked just fine, only the initial configuration is a little bit different in comparison with Windows and Mac. Resources available in the course are also helpful to practice.
Sudhakar
April 20, 2020
This course will definitely help me in my day to day activities, thanks for the helping us keeping our self updated. Regards, Sudhakar
Narasimha
April 10, 2020
The course was good and clear training. the course viedo streaming was not so great but i was able to complete
Jeremy
February 25, 2020
Awful software for teaching SQL Lesson pace too slow and watered down SQL statements way too simple to be useful Can't believe this cost 70 dollars
William
October 21, 2019
Learning to use the SQL Shell command line, instead of the GUI. Also learned about useful web tools such as "Mockaroo" to generate sample data.
Ray
September 29, 2019
This is a good course, well explained with examples. Definitely the right course to start using PostgreSQL
Nicolas
September 28, 2019
This course allows to learn what is specific to postgresql with respect to the other DBMS without spending too much time on it.
Thiago
July 9, 2019
O curso é para um nível muito iniciante, no overview não explicitava isso. As legendas foram auto-geradas, havia alguns erros nelas.
Yankı
July 4, 2019
It ends with a "join in next video." Is this course complete or not? In either case, I think this course is a bit shallow. It does a perfect job regarding the practice but theoretically lacking. There could've been more insight.

Charts

Price

Up and Running With PostgreSQL 11 - Price chart

Rating

Up and Running With PostgreSQL 11 - Ratings chart

Enrollment distribution

Up and Running With PostgreSQL 11 - Distribution chart

Related Topics

2351640
udemy ID
5/3/2019
course created date
5/23/2019
course indexed date
Bot
course submited by