@AmanSinghYT

⭐️ 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

@khateebanwer7466

For someone who is following this tutorial currently :

1) at around 01:06:00 when you go through the SQL file in VSCode , do change the value of varchar of gender greater than 20 because Mockaroo includes more than 2 genders in randomly generated database which will throw an error during its execution through cli when not changed.

2)When using terminal (for windows users ) , you might get errors during execution of sql file through cli due to path format which can easily be dealt with --> before even opening your postgres ,navigate through the command line where the actual file is located and then open postgres and use   \i filename.extension   to execute your file.

3)When installing postgres , always provide passwords without any alphanumeric characters like "$" otherwise it will throw an error during the installation phase ( I don't know what is that error as it was really vague but this worked for me).

@LordDevCode

day 1 =>  (1:12:28)
day 2 =>  (1:52:08)
day 3 =>  (2:25:58)
day 4 =>    SKIPED
day 5 =>  (2:49:15)
day 6 =>    SKIPED
day 7 =>  (3:16:41)
day 8 =>  (3:40:53)

@niyazi95

33:39 guys if you cant run "psql" command in the command line, you must add it to system environments, find the postgresql folder in C:\ and add its "bin" folder to "Path" variable in the env.

@O_o___o_0

First thank you so much for this amazing course, easy to follow and straight to the point

For those like me that will be learning on PostgreSQL 14, at 33:50 he uses the command 

psql --help  

for the option help and on Windows and PSQL 14 it's actually the 

\? options 

command that will give you the same result.

@chriswilson8584

The best PostgresQL tutorial I've seen so far.

@franciscojavierramirezhern8588

I had a lot of extra work trying to follow some parts of this awesome course, the difference between MacOS and Windows are tinny, but important, when you try to import file using \i you must have to use '/' not '\' and other differences that I had to search on google and stack, but finally.... Thanks for sharing this course, I appreciate this. I heard something that bad MySql settings are so dangerous and complicate to fix and protect from SQL injection, so, he said PostgreSQL is more secure and flexible, but I just looking for answers. Anyway, nice work! greetings!

@John-fd9fe

I love the fact that we have timestamps. 
I already knew a lot of SQL, I just needed to learn PostgreSQL and I could skip a lot of the lessons.
Thank you very much.

@adamrolczyk7217

It was my long long dream to learn Postgres. I watched the entire video almost in one sitting, making notes in vscode and using commands in terminal. Thank you so much for sharing this knowledge. Can't wait to use it to build something cool.

@richard1991ish

also just going to take a moment to appreciate how excellent this tutorial is. Clear, concise, straight to the point with real-world examples. Worked through the whole thing, and learned a TON. TYSM! ⭐⭐⭐⭐⭐

@leondaz

If you're having trouble in AVG, use this "SELECT AVG(price::money::numeric) from car;" and this basically casts the VARCHAR money to Money (adds commas every 3 numbers) and casts the result to a number (decimal) as numeric is an alias for decimal in postgreSQL.

@StarBattle08

1:53:33 Make sure the currency is set to none, otherwise it won't work if you use numeric for the type for the price

@banisan2035

Hey everyone. For windows users on the mockaroo section: I encountered some problems importing the .sql file. Apparently psql doesn't accept the common backslashes \ that are used for paths on windows. So you need to use forward slashes / like on linux or mac. So for example, here's what I typed in psql:

\i C:/Users/MyName/Desktop/person.sql

@akashprofile

I was struggling to learn SQL, before this tutorial. I am commenting at 1:50:16 without watching the complete tutorial. This course is very helpful to me. Thank you! so much. I can't explain how grateful I am to you.

@TonnySanjiao

Great work man. Thank you from Barcelona. I like your voice, it's very clear to understand to non English-speaking like me.

@banisan2035

Thank you so much for this tutorial! It always fills me with joy when so much effort is put into something that simply benefits everyone without expecting anything in return. So much wholesome altruism in the IT community. <3

@OladipupoPopoola

Wow! I just finished this course and  I must confess you took me from a noob to an intermediate pro. Thank you so much. but I can't fid your other courses.....please share link in reply. I really appreciate. God bless you bro.

@mythic414

Thank you for this video! You're a great teacher and the material was clear and straight to the point. Definitely one of the best online courses i've come across

@mojojojo-k6v

My progress tracker : 

Day 1 => 1:16:00
Setting up PostgresSQL on windows ,  making databases & tables , dropping tables , Adding , renaming , dropping columns , Using 'Mockaroo' for creating dummy data and importing it via the '\i' command.

@ianawilsonn

Halfway through, and it's a great course so far. Some of the material is a little dated, as Postgresql has made some changes as they are at version 15+. For example: Postgresql uses "SELECT factorial(5);" now instead of "SELECT 5!;" to get the factorial of 5. Might be time for an updated course.