Full Postgres Course available for 90% off: www.udemy.com/course/practical-postgres-master-the-most-important-parts-of-sql/?couponCode=RUclips-PG-BEGINNER My course is focused on the most practical parts of postgres and the goal is to teach you the most useful things as quickly as possible.
This is one of the only programming tutorials on the site that deserves its title. You didn't assume I knew anything but you didn't insult my intelligence either. Half of the video isn't being dedicated to setup and you jump in with practical examples. You don't have any annoying ticks and you're not just reading off of documentation. I don't like being meaninglessly positive, if your work isn't good you shouldn't be praised for it, but this video really deserves all the praise in the world. Maybe it would have been good to cover some initial setup but as you rightly point out near the start the docs are there there for a reason.
I have an extenisve background in DB development going back to DB2. It's been awhile and I need to get up to speed on POSTgres quickly so I can assist my main guy who is doing all the front and back end work. I totally agree with all the people who say, 'hey...this guy is smart, well spoken, a good trainier, and someone who I trust to learn a lot from." Thanks Troy. I appreciate you very much
[00:49] Speaker 1 explains the difference between relational and non-relational databases and introduces Postgres as a relational database. [02:14] Speaker 1 explains the structure of a table in a database, with rows representing entities and columns representing attributes. [03:36] Speaker 1 introduces Postaco as an interface for interacting with Postgres and explains the use of keywords in SQL. [04:55] Speaker 1 discusses creating a table in Postgres, explaining the syntax for defining columns and the importance of the ID column as a primary key. [06:33] Speaker 1 explains the use of uppercase keywords and lowercase self-named elements in SQL, using the example of column names. [09:03] Speaker 1 explains the use of the varchar data type for text columns and the maximum length constraint. [11:10] Speaker 1 explains the concept of an integer data type and the use of the serial type for automatically incrementing IDs. [12:39] Speaker 1 explains the concept of a primary key and demonstrates the successful creation of a table in Postaco. [13:54] Speaker 1 explains the syntax error that occurs when using a table name that is a keyword and demonstrates the use of double quotes to resolve the issue. [15:42] Speaker 1 discusses the convention of using singular table names and the importance of following naming conventions in software development. [17:07] Speaker 1 explains the process of inserting data into a table, specifying the columns and values to be inserted. [21:07] Speaker 1 demonstrates the insertion of additional data into the table and confirms the successful execution. [22:15] Speaker 1 introduces the "select" keyword in SQL and explains its use for retrieving information from tables. [24:27] Speaker 1 explains the use of the "where" keyword to filter entries in a select statement based on conditions. [25:26] Speaker 1 discusses the importance of using "where" statements in update and delete statements to specify which rows to affect. [26:23] Speaker 1 explains the process of updating data in a table using the "update" and "set" keywords, emphasizing the use of the "where" statement. [27:25] Speaker 1 demonstrates the successful update of data in the table and verifies the change. [29:38] Speaker 1 explains the use of delete statements in SQL and the importance of specifying conditions for deletion. [31:19] Speaker 1 introduces the concept of data relationships and explains how tables in SQL can be related to each other. [32:33] Speaker 1 explains the concept of a one-to-one relationship in a database and provides an example using user and avatar tables. [34:02] Speaker 1 explains the three relationship types in relational databases: one-to-one, one-to-many, and many-to-many. [36:12] Speaker 1 explains the concept of a one-to-many relationship using the example of RUclips videos and comments. [37:30] Speaker 1 explains the process of setting up a one-to-many relationship between users and posts using a foreign key. [39:02] Speaker 1 explains the concept of a many-to-many relationship using the example of a school setup and discusses the use of a join table. [40:44] Speaker 1 discusses the structure of a post table and the use of foreign keys to relate posts to users. [43:03] Speaker 1 demonstrates the insertion of data into the post table and confirms the successful execution. [45:33] Speaker 1 demonstrates how to select data from multiple tables using joins and introduces the concept of inner joins. [48:11] Speaker 1 discusses the issue of column name conflicts and demonstrates how to modify column names in query results using aliases.
Great video man. Your teaching style is enthusiastic (but not overly done), clear, and concise. Thanks cor creating this, a real time saver for me. I came here because I am learning how to use Prisma + Railway and had no idea how to create and manipulate tables in PostgreSQL, so I had no idea how to create a scheima. 👍
GOATED definitely one of the best videos with clear explanations, examples, and great commentary of not just what but WHY we do things without the bloat of other videos.
@TroyAmelotte this has been the best introduction to postgres I've seen so far. Other tutorials overcomplicate stuff in 3 hour long videos. Thank you very much, you're a great teacher.
S/O all those getting to the end - Dyslexic and following this through was super easy and high level enough to apply as SE - but it’s the Corgis, slur for dogs that had me in absolute stitches that I had to comment - only those who get to the end get it!!! Legend!!!
It was the best video I watched during the preparation process for the technical interview. It was very productive and informative that you explained everything without going into too much detail, but without skipping details. thank you so much.
Agreed, seems like a good SQL crash course but as someone who's already learned mariadb and mySQL, my main feedback is the video didn't give a good sense of how Postgres is any different.
Thanks a lot for this video. Currently undergoing a course that requires me to learn PostgreSQL and I don't have prior SQL knowledge. This was really concise and it helped me to get up to speed with the basics.
Great video. I agree with all the positive comments. Such a shame this bloke didn't make a whole series of videos on this subject, like he suggested in this video. So many people could benefit.
Great video. Having debilitating ADHD and always getting hung up on little things, you went at a pace and explained things step by step to the point I had no issues picking it up even while not medicated, that sir is a feat in itself. One tip to help with when you're like "oops sorry if this is too small" I don't know if you use OBS but if you did you can simply run that program in windowed, but full size in the recording window which effectively increases its size. Ive done this trick in zoom and google meetings too but getting the aspect ratio down is tricky.
If you say 2+2=4 they'll say you're being "imperative".. or if you say the sky is blue, they'll saying you're arguing. The polarity of slander is religious.
good one but there was nothing about PostgreSQL in particular, it was all about MySQL and Fireship channel has the same content in < 17mins man, this one with 50 mins was just too much and sadly it doesn't anything specific to PostgreSQL!
OMG, I gave up on PostgreSQL years ago because I didn't know about the difference with single and double quotes. LOL That's what drove me to use MySQL ever since....
Thanks for posting this! It really helps to make sense of Postgres, at least on this basic stuff you have shown here. REALY hope the aditional parts are coming, at least kind of soon! 😃
This is very good. I'm currently in training and my task for the week is to use a database for my Java project. I'll use your video for educational purpose for sure.
😎 Nice! Just getting back into PostgreSQL. Appreciate the clear & concise instructions in your video. Looking forward to checking out "postico", especially if I cannot get Sublime Text to work with PostgreSQL. (I'm fairly sure it will, I just need to figure out how to set it up.) The last course I took focused on using the command line for everything - I'm glad you didn't go there. Nothing at all wrong with using the command line, I just appreciate the simplicity of a text editor. Anyway, thanks again and I hope you have continued to make awesome RUclips videos. Cheers!
Genuinely thought he was about to cry around here 14:40 - 14:45 I was like daaang... this man really loves this shit.. word. Seriously though, if you can continue the Database (postgres) make it into a serie.. you are good at teaching this stuff.
Great video, you are entertaining and the material is good. I got a lot of value from my 50 min with you. Thank you Troy! I have been looking for the follow up course, but I guess you never got to making it.
This was a very good watch. I have a mainly MSSQL DB back ground having worked as both a DB Dev and DBA. For me the main value was seeing the similarities between MSSQL and PostegreSQL. Any tips on how to get into a job involving PostgreSQL without having done it at anytime during your professional career.
I stopped watching 5min in. It absolutely blows my mind that so many people who somehow consider themselves "teachers" actually do things like jump-cutting to an open window, and beginning to type code/commands, with literally *zero* context or explanation regarding *where* they are typing this or how they got there... "This is just an interface for interacting with Postgres." _immediately begins writing code_ Gee, thanks so much... How tf is anyone supposed to follow this? Download Postgres, then sit back and snap our fingers and this window magically opens itself up in front of us, configured properly, connected to a database server, and ready to receive commands?? Wtf? Information about how to prepare/configure and open the GUI or CLI where one begins writing code is *essential* to actually learning about subjects like this, yet literally 9 out of 10 "teachers" *always* skip the first, essential, basic steps like this. It grates me to no end.
I feel that too. Someone like corey schafer is prob one of the only one who really tell how things work, and I learn a lot from his pandas course. He made one about postgres, but I haven't watched it
everythings great but at 10:24 VARCHAR is the exact same bytes in storage low level as TEXT (its in the dont do this part of the postgresql wiki), it doesnt optimize storage or anything really, but its just a way to both fullfil the sql standard and to explicitly limit the size of a string
Great video bu I have a question 40:07 A class can have multiple students? Likewise lets say we have a task table and a task can be assign to multiple users. How do we do that?
How does everyone not use the PSQL SHELL at all, but tell you two download another program. How does that work, when all I wanted to learn is PSQL in the shell not some easy to use interface, where It won’t be available for use in any job situations. What company used pop whatever.
Full Postgres Course available for 90% off:
www.udemy.com/course/practical-postgres-master-the-most-important-parts-of-sql/?couponCode=RUclips-PG-BEGINNER
My course is focused on the most practical parts of postgres and the goal is to teach you the most useful things as quickly as possible.
This is one of the only programming tutorials on the site that deserves its title. You didn't assume I knew anything but you didn't insult my intelligence either. Half of the video isn't being dedicated to setup and you jump in with practical examples. You don't have any annoying ticks and you're not just reading off of documentation. I don't like being meaninglessly positive, if your work isn't good you shouldn't be praised for it, but this video really deserves all the praise in the world. Maybe it would have been good to cover some initial setup but as you rightly point out near the start the docs are there there for a reason.
I have an extenisve background in DB development going back to DB2. It's been awhile and I need to get up to speed on POSTgres quickly so I can assist my main guy who is doing all the front and back end work. I totally agree with all the people who say, 'hey...this guy is smart, well spoken, a good trainier, and someone who I trust to learn a lot from." Thanks Troy. I appreciate you very much
what is DB2?!
[00:49] Speaker 1 explains the difference between relational and non-relational databases and introduces Postgres as a relational database.
[02:14] Speaker 1 explains the structure of a table in a database, with rows representing entities and columns representing attributes.
[03:36] Speaker 1 introduces Postaco as an interface for interacting with Postgres and explains the use of keywords in SQL.
[04:55] Speaker 1 discusses creating a table in Postgres, explaining the syntax for defining columns and the importance of the ID column as a primary key.
[06:33] Speaker 1 explains the use of uppercase keywords and lowercase self-named elements in SQL, using the example of column names.
[09:03] Speaker 1 explains the use of the varchar data type for text columns and the maximum length constraint.
[11:10] Speaker 1 explains the concept of an integer data type and the use of the serial type for automatically incrementing IDs.
[12:39] Speaker 1 explains the concept of a primary key and demonstrates the successful creation of a table in Postaco.
[13:54] Speaker 1 explains the syntax error that occurs when using a table name that is a keyword and demonstrates the use of double quotes to resolve the issue.
[15:42] Speaker 1 discusses the convention of using singular table names and the importance of following naming conventions in software development.
[17:07] Speaker 1 explains the process of inserting data into a table, specifying the columns and values to be inserted.
[21:07] Speaker 1 demonstrates the insertion of additional data into the table and confirms the successful execution.
[22:15] Speaker 1 introduces the "select" keyword in SQL and explains its use for retrieving information from tables.
[24:27] Speaker 1 explains the use of the "where" keyword to filter entries in a select statement based on conditions.
[25:26] Speaker 1 discusses the importance of using "where" statements in update and delete statements to specify which rows to affect.
[26:23] Speaker 1 explains the process of updating data in a table using the "update" and "set" keywords, emphasizing the use of the "where" statement.
[27:25] Speaker 1 demonstrates the successful update of data in the table and verifies the change.
[29:38] Speaker 1 explains the use of delete statements in SQL and the importance of specifying conditions for deletion.
[31:19] Speaker 1 introduces the concept of data relationships and explains how tables in SQL can be related to each other.
[32:33] Speaker 1 explains the concept of a one-to-one relationship in a database and provides an example using user and avatar tables.
[34:02] Speaker 1 explains the three relationship types in relational databases: one-to-one, one-to-many, and many-to-many.
[36:12] Speaker 1 explains the concept of a one-to-many relationship using the example of RUclips videos and comments.
[37:30] Speaker 1 explains the process of setting up a one-to-many relationship between users and posts using a foreign key.
[39:02] Speaker 1 explains the concept of a many-to-many relationship using the example of a school setup and discusses the use of a join table.
[40:44] Speaker 1 discusses the structure of a post table and the use of foreign keys to relate posts to users.
[43:03] Speaker 1 demonstrates the insertion of data into the post table and confirms the successful execution.
[45:33] Speaker 1 demonstrates how to select data from multiple tables using joins and introduces the concept of inner joins.
[48:11] Speaker 1 discusses the issue of column name conflicts and demonstrates how to modify column names in query results using aliases.
I usually fall asleep watching SQL tutorials, but that 50 mins flew by, thank you!
I watched your video as the first video
and I am starting Postgre SQL
God, bless you, bro.
Great video man. Your teaching style is enthusiastic (but not overly done), clear, and concise. Thanks cor creating this, a real time saver for me. I came here because I am learning how to use Prisma + Railway and had no idea how to create and manipulate tables in PostgreSQL, so I had no idea how to create a scheima. 👍
These 50 minutes are better than my 80 hours college course about Database!
GOATED definitely one of the best videos with clear explanations, examples, and great commentary of not just what but WHY we do things without the bloat of other videos.
Thank you!
Best tutorial about postgres for beginners. I've watched 10 videos on RUclips and this is definitely the best. Subscribed.
I worked with a guy who was trash at literally everything but SQL. He's doing really well. GG at this.
@TroyAmelotte this has been the best introduction to postgres I've seen so far. Other tutorials overcomplicate stuff in 3 hour long videos. Thank you very much, you're a great teacher.
I am a Bootcamp student. super duper helpful. I wish I had an instructor like you.
Thanks a lot.
S/O all those getting to the end - Dyslexic and following this through was super easy and high level enough to apply as SE - but it’s the Corgis, slur for dogs that had me in absolute stitches that I had to comment - only those who get to the end get it!!! Legend!!!
It was the best video I watched during the preparation process for the technical interview. It was very productive and informative that you explained everything without going into too much detail, but without skipping details. thank you so much.
You're Welcome
This is by fat the best Postgres video i've seen on RUclips so far
This is better than most paid content. This channel is so incredibly underrated. I hope the algorithm blesses you soon
I'd rename it to "SQL crash course"
Agreed, seems like a good SQL crash course but as someone who's already learned mariadb and mySQL, my main feedback is the video didn't give a good sense of how Postgres is any different.
@@CBiscuit25 yup, that's what I was hoping to see
The same I thought, it's OK for the people trying to learn any SQL DBMS but it's not specific about postgresql.
OMG I love this. Thank you so much for putting this together. I've taken the first step in understanding databases. You are a lifesaver sir!
Good start for someone like myself that has learned Microsoft Tsql and is trying to get into postgre sql.
Dude you need to make the advanced tutorial. This was sick, also that slip up at the end killlled me
Thanks a lot for this video. Currently undergoing a course that requires me to learn PostgreSQL and I don't have prior SQL knowledge. This was really concise and it helped me to get up to speed with the basics.
Yoh, my guy from ALX-T 😅
@@Majey_KE You're part of the program too? 😂
Great video. I agree with all the positive comments. Such a shame this bloke didn't make a whole series of videos on this subject, like he suggested in this video. So many people could benefit.
Bro sounds like he's trying to hold in the puff puff
Great Work Sir. I just started SQL course with Postgres and this video is helping me stay ahead of the class. Thank You!
Great video. Having debilitating ADHD and always getting hung up on little things, you went at a pace and explained things step by step to the point I had no issues picking it up even while not medicated, that sir is a feat in itself. One tip to help with when you're like "oops sorry if this is too small" I don't know if you use OBS but if you did you can simply run that program in windowed, but full size in the recording window which effectively increases its size. Ive done this trick in zoom and google meetings too but getting the aspect ratio down is tricky.
He went to slow for me. I'll never find that sweet middle ground.
44:49 this is the most interesting part of the whole video. Solving things like this is what really makes you good beyond theory
You’re a great teacher man. Very helpful for getting started no cap 😂
If you say 2+2=4 they'll say you're being "imperative".. or if you say the sky is blue, they'll saying you're arguing. The polarity of slander is religious.
good one but there was nothing about PostgreSQL in particular, it was all about MySQL and Fireship channel has the same content in < 17mins man, this one with 50 mins was just too much and sadly it doesn't anything specific to PostgreSQL!
OMG, I gave up on PostgreSQL years ago because I didn't know about the difference with single and double quotes. LOL
That's what drove me to use MySQL ever since....
Thanks for posting this! It really helps to make sense of Postgres, at least on this basic stuff you have shown here. REALY hope the aditional parts are coming, at least kind of soon! 😃
Best explanation I've had on many-to-many relationships. Thanks Troy
This is very good. I'm currently in training and my task for the week is to use a database for my Java project. I'll use your video for educational purpose for sure.
Amazing crash course! Thanks a lot! You're a great teacher, man 😁
Wonderful presentation Troy. So clear and easy to understand on every word. 👍
Thank you so much! This save me a lot of time understanding what SQL is all about
Had to leave a comment after the "you can be the first one please?" moment. This vid helped me!
Thank you very much! I'm new to SQL, and this helped me grasp it better.
Really like your style. It's like a breath of fresh air tbh!
I loved your intro. I love straight shooters. Great video.
😎 Nice! Just getting back into PostgreSQL. Appreciate the clear & concise instructions in your video. Looking forward to checking out "postico", especially if I cannot get Sublime Text to work with PostgreSQL. (I'm fairly sure it will, I just need to figure out how to set it up.) The last course I took focused on using the command line for everything - I'm glad you didn't go there. Nothing at all wrong with using the command line, I just appreciate the simplicity of a text editor. Anyway, thanks again and I hope you have continued to make awesome RUclips videos. Cheers!
this is such a good crash course! keep it up bro, I learned a lot
Genuinely thought he was about to cry around here 14:40 - 14:45
I was like daaang... this man really loves this shit.. word. Seriously though, if you can continue the Database (postgres) make it into a serie.. you are good at teaching this stuff.
Great video, you are entertaining and the material is good. I got a lot of value from my 50 min with you. Thank you Troy! I have been looking for the follow up course, but I guess you never got to making it.
Good to see you building a channel, Troy! I hope you continue with this. You are such a natural teacher.
Thank you tom! Hope all is well with you.
You teach so well, Troy. I was wondering where the continuation of this tutorial is...
amazing introduction. i really like your enthusiasm which makes the video entertaining to watch!
44:32 casually admitting to murder... :D
such a sweet and easy to follow tutorial. Thank you :)
Great video Troy. you cleared all my confusion. Thanks
i look forward to a project on this and the advance class
When can we expect a 50-60 minute, extensive, comprehensive PostgreSQL joins Tutorial? This one was so awesome, I'm waiting for sql Joins Tutorial.
Great primer on PostgreSQL basics. Many thanks!
thank you so much, so easy to understand because i'm just a beginner to postgreSQL
Great video, was perfect for refreshing myself with the basics of SQL
This man deserves the like.
This was incredibly helpful, thank you so much! You teach so well and I gained a lot from this, thank you :))
It ´d have been REALLY worthy with some SQL Function template so it´d have killed
it! Very good, anyway.
i love you my guy. this is so chill and helpful
great video, troy. Had to get a quick intro to sql in one day, ur vid saved me
You are an amazing instructor and I'm wondering where are the advanced topic that you said you're going to talk about!!, can't wait to see it
Such a great explanation, thank you for the video!. I think I've found a very nice channel :D
Amazing video thank you. Very well spoken and perfect mix of theory and application.
Man you're a great teacher. Thanks!
Really solid crash course, exactly what I was looking for to see and write some SQL/postgres code for the first time without diving in too deep
Phenomenal. Gave me all I needed to get started.
Wish I learned it like this in school! Amazing video
Amazing crash course on Postgresql. Thank you Troy.
good video. im 15 mins in and enjoying it.
Thankyou so much for this interesting video, I am used to work with postgres SQL and i can say that your video is very useful for beginners.
Thank you so much... looking forward to the advanced tutorial.
Amazing tutorial, thank you so much for putting this together
I'm sure I ain't the first, but commenting because algorithm and great explanation, besides you said please :P
I like the way you teach, very informational. Thanks for the info!
This is a life saver. Thanks a lot mate!
Amazing tutorial, also 44:32 cracked me up
This was a very good watch. I have a mainly MSSQL DB back ground having worked as both a DB Dev and DBA. For me the main value was seeing the similarities between MSSQL and PostegreSQL. Any tips on how to get into a job involving PostgreSQL without having done it at anytime during your professional career.
Great video you should definitely make a more full tutorial like a beginner to master esk type.
I stopped watching 5min in. It absolutely blows my mind that so many people who somehow consider themselves "teachers" actually do things like jump-cutting to an open window, and beginning to type code/commands, with literally *zero* context or explanation regarding *where* they are typing this or how they got there... "This is just an interface for interacting with Postgres." _immediately begins writing code_ Gee, thanks so much... How tf is anyone supposed to follow this? Download Postgres, then sit back and snap our fingers and this window magically opens itself up in front of us, configured properly, connected to a database server, and ready to receive commands?? Wtf? Information about how to prepare/configure and open the GUI or CLI where one begins writing code is *essential* to actually learning about subjects like this, yet literally 9 out of 10 "teachers" *always* skip the first, essential, basic steps like this. It grates me to no end.
I feel that too. Someone like corey schafer is prob one of the only one who really tell how things work, and I learn a lot from his pandas course. He made one about postgres, but I haven't watched it
kudos! this video is very clear and detailed.
do some AWS s3 bucket and LAMBDA CRUD rest function video.
Thanks a lot! This video is very helpful for beginners!
This was so helpful. Thank you so much!
everythings great but at 10:24 VARCHAR is the exact same bytes in storage low level as TEXT (its in the dont do this part of the postgresql wiki), it doesnt optimize storage or anything really, but its just a way to both fullfil the sql standard and to explicitly limit the size of a string
Great introduction to PostgreSQL. Could you recommend a Windows based tool similar to POSTICO?
I'm using HeidiSQL and it does the job
Bro, make a playlist of in depth explanation of PostGreSQL
This tutorial was great, thanks for this excellent content
the best teaching skills
@44:33 😂😂 I undid a "bit€h" I died laughing because I used this to show it to co-workers, and it caught me by surprise. 😂😂 thanks NSFW video
Simplified and very Helpful
Thanks🎉
I love this video so much. You are a great teacher and made learning SQL much easier. Thanks for all that you do!
This video was great, thanks!
Great video! Super well done and easy to follow
You are goated Troy. Thank you.
hope you get back sometimes, you are good at this.
Great video bu I have a question 40:07 A class can have multiple students? Likewise lets say we have a task table and a task can be assign to multiple users. How do we do that?
Thanks so much! Great Crash course!
Thank You for making this video.
How does everyone not use the PSQL SHELL at all, but tell you two download another program. How does that work, when all I wanted to learn is PSQL in the shell not some easy to use interface, where It won’t be available for use in any job situations. What company used pop whatever.
Great tutorial! I loved it 😊