@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

@sewind6613

That someone would take their time to make such a complete set of tutorials, and to make them available for free, is amazing. Words are not enough to express my gratitude, and my respect for you.

@calvinbarajas5144

This lecture is amazing because (a) Nelson knows the exact technical terminology, (b) he is very patient and methodical, (c) covers the basics very well, (d) gives professional insight into how to use PostgreSQL.

@gunk4196

The fact that this is free is insane! A very good course on Postgres. I finished this in less than 24 hours and before starting I didn't even know what 'SQL' was but now I feel like I have a solid understanding of Postgres.

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

@andrerangel7654

Somebody give that man a medal!!

@АйдарХабиров-т3к

Thank You for using easy English. I understand a lot of.
Respect from Russia with 41 peoples.

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

@chamchamchaam

Your are an excellent teacher, I understand everything fully and I've actually sat through this 4 hour lecture for 9 hours. 9 hours included breaks and lunch/dinner.

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

@madhanmurali4877

Completed till WHERE Clause and you're getting straight to the point without wasting time. It is really helpful for a complete newbie like me. Thank you!

@TheAremoh

From being scared to run sql command from command line to liking it. Thanks for this awesome video

@Terzaghi12

For Windows users, the command 'psql' only will work if you edit the environment variables and add 'C:\Program Files\PostgreSQL\13\bin' to your path, the 13 it's the version of Postgres i've installed.

After that, the command you have to enter on the cmd or powershell is:

psql -U postgres

then it will ask for the password you set on the installation

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

@alexnavarro2628

Seriously a 10/10 course! I sat down and watched this whole thing in a single session. I seriously appreciate your teaching style, and how well you explained everything. Thank you!

@kieranbarker1902

This video is excellent. I'm only as far as creating tables (around the 41-minute mark) but it's already better than the courses I could find on Udemy! Thank you! 🙏

@fahansheikh

for user using ubuntu/linux(check if postgres is preinstalled in your system) following the installation steps may cause installation of two versions of postgres simultaneously  which can cause unnecessary trouble for beginners.

@gwagner3446

Dude, this course was VERY GOOD! Basically binged through the whole 4 hours and felt like no time! Very didactic and well explained. THANK YOU SO MUCH FOR THIS AMAZING CONTENT!!

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