Learn PostgreSQL Tutorial - Full Course for Beginners

Learn PostgreSQL Tutorial - Full Course for Beginners
Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and object-relational database management system. It is the most advanced op...


⭐️ Contents ⭐️

⌨️ (0:03:16) What is a Database

⌨️ (0:05:17) What is SQL And Relational Database

⌨️ (0:09:10) What is PostreSQL AKA Postrgres

⌨️ (0:10:53) PostgreSQL Installation (Mac OS)

⌨️ (0:14:21) PostgreSQL Installation (Windows)

⌨️ (0:17:38) GUI Clients vs Terminal/CMD Clients

⌨️ (0:21:39) Setup PSQL (MAC OS)

⌨️ (0:25:22) Setup PSQL (Windows)

⌨️ (0:30:15) How to Create Database

⌨️ (0:33:35) How to Connect to Databases

⌨️ (0:38:12) A Very Dangerous Command

⌨️ (0:41:37) How To Create Tables

⌨️ (0:45:46) Creating Tables Without Constraints

⌨️ (0:49:12) Creating Tables with Constraints

⌨️ (0:55:55) Insert Into

⌨️ (0:59:14) Insert Into Example

⌨️ (1:02:36) Generate 1000 Rows with Mockaroo

⌨️ (1:12:28) Select From

⌨️ (1:15:18) Order By

⌨️ (1:19:53) Distinct

⌨️ (1:21:60) Where Clause and AND

⌨️ (1:25:29) Comparison Operators

⌨️ (1:29:35) Limit, Offset & Fetch

⌨️ (1:32:43) IN

⌨️ (1:35:43) Between

⌨️ (1:37:45) Like And iLike

⌨️ (1:43:10) Group By

⌨️ (1:46:41) Group By Having

⌨️ (1:52:08) Adding New Table And Data Using Mockaroo

⌨️ (1:55:40) Calculating Min, Max & Average

⌨️ (1:59:48) Sum

⌨️ (2:01:55) Basics of Arithmetic Operators

⌨️ (2:05:59) Arithmetic Operators (ROUND)

⌨️ (2:09:43) Alias

⌨️ (2:12:32) Coalesce

⌨️ (2:16:15) NULLIF

⌨️ (2:20:21) Timestamps And Dates Course

⌨️ (2:23:21) Adding And Subtracting With Dates

⌨️ (2:25:58) Extracting Fields From Timestamp

⌨️ (2:27:28) Age Function

⌨️ (2:29:24) What Are Primary Keys

⌨️ (2:31:23) Understanding Primary Keys

⌨️ (2:36:26) Adding Primary Key

⌨️ (2:40:55) Unique Constraints

⌨️ (2:49:15) Check Constraints

⌨️ (2:54:45) How to Delete Records

⌨️ (3:01:36) How to Update Records

⌨️ (3:05:55) On Conflict Do Nothing

⌨️ (3:11:09) Upsert

⌨️ (3:16:41) What Is A Relationship/Foreign Keys

⌨️ (3:19:48) Adding Relationship Between Tables

⌨️ (3:25:04) Updating Foreign Keys Columns

⌨️ (3:29:30) Inner Joins

⌨️ (3:35:17) Left Joins

⌨️ (3:40:53) Deleting Records With Foreign Keys

⌨️ (3:47:27) Exporting Query Results to CSV

⌨️ (3:50:42) Serial & Sequences

⌨️ (3:57:18) Extensions

⌨️ (3:59:39) Understanding UUID Data Type

⌨️ (4:05:54) UUID As Primary Keys

⌨️ (4:16:30) Conclusion

Thanks for reading ❤

Follow me on Facebook | Twitter


Learn More

The Complete Python & PostgreSQL Developer Course

SQL & PostgreSQL for Beginners

An Introduction to Queries in PostgreSQL

Spring Boot with PostgreSQL, Flyway, and JSONB

Node.js - Express Persistent Session Store with PostgreSQL + Sequelize

Secure Node.js, Express.js and PostgreSQL API using Passport.js

Build a Basic App with Spring Boot and JPA using PostgreSQL

Originally published at https://www.youtube.com/watch?v=qw--VYLpxG4