SQL UPDATE Statement |¦| SQL Tutorial |¦| SQL for Beginners

The UPDATE SQL statement is used to make changes to data in a database. You can make changes to one more columns for multiple rows in a single query. Today we will work an elite database of internationally known spies to practice making UPDATEs and checking our work.

Our SQL playlist starts here:

Be sure to SUBSCRIBE for more SQL!

You may also enjoy our Python playlist:

♦♦♦♦♦♦♦♦♦♦

Ways to support our channel:

►  We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank you!

♦♦♦♦♦♦♦♦♦♦

Connect with us!

♦♦♦♦♦♦♦♦♦♦

♦♦♦♦♦♦♦♦♦♦

[Socratica]

It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉

[ayencoscolfield]

Am simply amazed at how effortlessly she passes across her information while teaching us in an hilarious manner, i cant start stop laughing sometimes, i have been thoroughly entertained while learning. thanks

[JianqiuChen]

Wow, this is the best prepared videos for tech I have ever seen, keep it up!

[MyLinuxToyBox]

Such good tutorials short easy to understand. I told the Commision, "Socratica, as usual, has done an exemplary job on the SQL UPDATE project. Please do your best to extend her audience."

[CaioCSG]

create table secret_user (
user_id serial primary key,
first_name varchar(20),
last_name varchar(20),
code_name varchar(20),
country varchar(10),
organization varchar(10),
salary int,
knows_kung_fu bool
)

[davidcoley]

I love the humor first of all, but I'm especially a fan of the scenarios. This tutorial is great.

[sweetsakshigoel]

Is this what love feels like? Goodness these series are amaaazzzinnggg!<3

[justin]

I was trying to learn sql in work and stumbled upon your video. thanks to the numerous cut scenes from movies and you joking around on screen instead of teaching, my boss thinks i was watching a movie., *thumbs up*

[TheTrace]

My god. I'm watching this just for entertainment value. I know everything about updates, but I just can't stop!!

[vyvianspipes]

Thank you! This has changed my ability from being completely oblivious in IT studies, to knowing the thoughts of cyberdeities! 😁

[itsyourboyquetinbrown]

I'm hooked on your Beginner videos. Appreciate the simplicity it presents in learning to write a SQL Query !

[gopigwen]

Wonderful narration with well known stories, and Nick Fury knows Kung fu now😀😀😋😋

[pochta]

This is simply the best I have ever seen on YouTube tutorials 🎉

[AdrianJuliusRandall]

wayyyy easier and more exciting to learn than alot of these other channels thank you. Not to down talk on the other channels

[cmpuipf]

This series deserves so many more views there's nothing like them really

[chetanthaper]

Wow you're the person, the only person who made an effort to make this chapter interesting and it's a grt vid keep it up!

[orrange]

I love this series more than I hate having to learn sql. And that really is saying something

[quahntasy]

Another one of the best videos for learning SQL. Thanks!

[davidfreeman]

Especially for production databases:
1) please wrap updates in a transaction
2) please write the where clause first and then add the set statement above it.
Why - we all make mistakes!

[szreiberarkadiusz]

INSERT INTO secret_user
(first_name, last_name, code_name, country, organization, salary, knows)
VALUES
('Jimmy', 'Bond', '007', 'United Kingdom', 'MI6', 97200, false),
('George', 'Smiley', 'Beggarman', 'United Kingdom', 'MI6', 97200, false),
('Jason', 'Bourne', 'Delta One', 'United States', 'CIA', 115000, false),
('Jack', 'Ryan', null, 'United States', 'CIA', 85000, false),
('Ethan', 'Hunt', 'Bravo Echo 1-1', 'United States', 'IMF', 250000, false),
('Emma', 'Peel', 'Mrs. Peel', 'United Kingdom', 'MI6', 97200, true),
('Susan', 'Hilton', 'Agent 99', 'United States', 'Control', 250000, false),

('Nick', 'Fury', 'Foxtrol', 'United States', 'SHIELD', 250000, false);


Let me know if there is something to correct