What is a Database

What is SQL And Relational Database

What is PostreSQL AKA Postrgres

PostgreSQL Installation (Mac OS)

PostgreSQL Installation (Windows)

GUI Clients vs Terminal/CMD Clients

Setup PSQL (MAC OS)

Setup PSQL (Windows)

How to Create Database

How to Connect to Databases

A Very Dangerous Command

How To Create Tables

Creating Tables Without Constraints

Creating Tables with Constraints

Insert Into

Insert Into Example

Generate 1000 Rows with Mockaroo

Select From

Order By

Distinct

Where Clause and AND

Comparison Operators

Limit, Offset & Fetch

Between

Like And iLike

Group By

Group By Having

Adding New Table And Data Using Mockaroo

Calculating Min, Max & Average

Basics of Arithmetic Operators

Arithmetic Operators (ROUND)

Alias

Coalesce

NULLIF

Timestamps And Dates Course

Adding And Subtracting With Dates

Extracting Fields From Timestamp

Age Function

What Are Primary Keys

Understanding Primary Keys

Adding Primary Key

Unique Constraints

Check Constraints

How to Delete Records

How to Update Records

On Conflict Do Nothing

Upsert

What Is A Relationship/Foreign Keys

Adding Relationship Between Tables

Updating Foreign Keys Columns

Inner Joins

Left Joins

Deleting Records With Foreign Keys

Exporting Query Results to CSV

Serial & Sequences

Extensions

Understanding UUID Data Type

UUID As Primary Keys

Conclusion

freeCodeCamp.org

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 open source database system widely used to build back-end systems.

⭐️ 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:59) 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

✏️ Course from Amigoscode.
🔗 Subscribe to Amigoscode YouTube channel | http://bit.ly/2HpF5V8
🔗 Visit Amigoscode.com for more courses | http://bit.ly/2JgGW0w
🔗 Full Playlist Available Here | http://bit.ly/2ClGPdY
🔗 Follow Amigoscode on Instagram | http://bit.ly/2TSkA9w
🔗 Join Amigoscode Closed Facebook Group | http://bit.ly/2FbuIkx

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org

And subscribe for new videos on technology: https://youtube.com/subscription_center?add_user=freecodecamp

Learn PostgreSQL Tutorial - Full Course for Beginners

Learn PostgreSQL Tutorial - Full Course for Beginners

Learn PostgreSQL Tutorial - Full Course for Beginners

Get Full Course Access

Highly Recommended Courses

Explore top skills

In-demand Careers

Popular Topics

Creative Skills

Business Skills

Choose your learning path