@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).

@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.

@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! ⭐⭐⭐⭐⭐

@kokoyoke2775

Working as an oracle dba, even non IT employees could use this db.
This is really help me to learn postgres, respect sir!!!

@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.

@chriswilson8584

The best PostgresQL tutorial I've seen so far.

@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.

@zulfiqaralikhan3227

I am from Pakistan yesterday I downloaded this video and watched it offline. After watching then I open youtube and search your video just for saying thank you for such a clear , simple and educated tutorial. Now I subscribed to your channel and will explore this channel.  Keep it up sir

@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

@TonnySanjiao

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

@michaelvigato3228

Boi this is excellent, it's really hard to believe this is free

@HelepodGTech

The volume difference at 1:43:20 was a wake up call. 



Great tutorial for someone who has never used postgres or wants to brush up.

@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.

@kjane3390

I am only 8.42 minutes through and I already felt the urge to thank you for such an incredible video. I have a terrible attention span and I am genuinely excited for what the next 4 hours will bring. Thank you thank you thank you!!!!!

@mauroavellaneda9019

Minute 24:57: To be able to write in bash profile or like in this case, zshrc, after you open the text editor, you need to type "i" to start typing. 
Another way of saving it is, when you finish what you need to type, press scape and then Shift + z + z. (two times "z")

@shivangchaturvedi237

One update for 2:04:24 : SELECT 100!; gives an error. So alternatively, one can use SELECT FACTORIAL(4); to get the answer. Give a 👍 if this helped you.

@itsReshad

I cant believe the quality of content and explanation in this video. Brilliant course explaining PostgreSQL. Very easy to follow - Highly recommend it!

@larhchimismail3399

I want to thank you sir for this beautiful and complete course now I'm heading to advanced postgres and spring boot as you said thanks

@hokage97531

I'm at 35:00, using windows and bversion 12 of PostgresQL, and the commands seem completely different.
first off I get a prompt that says "(database name)=#", rather than the ~ he gets, second, the --h commans isnt working. I'm typing in "help" to get commands, and it says \h for sql help, and \? for psql help. I typed in \? assuming it would show me the same PSQL help it shows on the video, but it shows a completely different set of commands, al starting with \ instead of with --.
I haven't watched the rest of the video, but so far it seems like it's different for windows. I hope not.

EDIT: I did manage to do the rest of the tutorial without problems, it works on windows aswell, I just skipped this step in particular. Wonderful tutorial. However I'm having trouble trying to add a NOT NULL constraint to an already created row. Is this possible? I'm using " ALTER TABLE person MODIFY name VARCHAR(30) NOT NULL; " and it says there's a syntax error around modify. Any help?