SQL Tutorial for Beginners 5: UPDATE and DELETE - Modifying and Removing Records from Your Database

In this video we will learn how to modify and remove records from our database using the UPDATE and DELETE statements. We will learn how to update and delete all the values in our table as well as updating and deleted specific values. Let's get started.

✅ Support My Channel Through Patreon:

✅ Become a Channel Member:

✅ One-Time Contribution Through PayPal:

✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot

✅ Corey's Public Amazon Wishlist

✅ Equipment I Use and Books I Recommend:

▶️ You Can Find Me On:

#SQL #Postgres

[brainmind]

So proud of Jane for graduating and getting started in her programming career!

[gmagcaling]

Hey, Corey. Thanks for the videos, but can you continue these SQL tutorials ?

[marthalanaveen]

Please resume this series with videos on
1. cases
2. sub-queries
3. string formatting
4. data & time manipulation
5. window functions
6. event triggers
7. joins(outer, inner, left, right and mainly self join)
8. functions
9. trigger functions
10. procedures and stored procedures
11. views
12. temporary & foreign tables
13. schemas
14. index
15. rules

[lilminishlomit]

I have been looking for SQL tutorial video for beginner but I found yours to be the only one that is easy for me to understand. Thank you very much!

[porlando]

It would be awesome if you continued this series! I'm really interested in running psql from terminal too.

[dLantee]

Best tutorial series on the internet for SQL fundamentals.

[xiaoxiaolei]

Excellent tutorials! Hope you generate more like these!

[SamSam-whvj]

very good tutorials, you hit the target in a short time and excellent explanation. keep on and thank you.

[wonjaehwang]

Simple and straight forward demonstrations

[ahmadabzakh]

Hey Corey, , thanks for those great tutorials, , would it be possible to teach us how to link a postgreSQL database to an Excel sheet or a google sheet, where one can update them and then data is reflected live or scheduled on the database, and how to link between python and you database, , those would be really great and helpful I think, , great content man, please keep it going 🙏🙏

[Travel_with_Thar]

you have shared a valuable information. Thanks a ton buddy.

[BakalovDmitry]

Great tutorial Corey. Straight to the point. Thank you so much.
But who is that one person disliked the video? Must be Neil Tyson a 57 years old scientist)))

[simplyviki]

I need some advanced sql tutorials, any recommendations ? Corey is my best teacher so far

[syedbilal]

Really Your Tutorials It's Too Good !!! I Understand Easily Good WorkMany Many Thanks...

[andyn]

Loved this short SQL tutorial. Where should I head to learn more about SQL? Any recommendations people?

[Travel_with_Thar]

Its been great help for me as a beginner. Thanks a ton. I want ti learn further. I want to learn how to take backup, full backup, incremental backup. Could you please tell us how to continue it.

[bestest]

Hi Corey, great tutorials I have to say first. But giving id manually seemed to me a little bit awkward and unnecessary. Can't we set the query to give an​ id by incrementing the value every time we add a new record?

[ChiefGuest]

How to auto generate id numbers? How to keep those numbers sorted automatically?

[davidbrown]

I was hoping we would be accessing the database with Python code.

[azizybiz]

Thanks for the video but use CTRL/CMD and + to zoom up the tables view