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!! 💜🦉
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
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*
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."
@@ma8969 It doesn't always have to be user_id but it has to be unique. Usually that's what user_id is made for, an unique identification number used to be primary key
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!
Suggestion for more advanced topic. When should you use "select for update" and when are "dirty reads" ok. As a follow up advanced topic, difference between MVCC versus Spin lock design on multiple updates.
It's 8 mins 2 secs friend. Why people try to find "cosmic" patterns in coincidence is beyond me. Here it is being forced by changing the time to work. Weak sauce. I think your fever has gotten to you.
Equality (=) is not the same thing as "member of" (IN). An ID cannot be equal to more than one value but it can be a member of a collection of values. If ID=5, for example, then ID != 6. This is why IN is used. If ID=5, then ID is a member of (IN) the list 5,6,7.
In case you missed it, always include a WHERE clause in your UPDATE statements. Make sure you have backups for your database for when you choose to ignore that advice
@@JorgeEscobarMX Some database engines have settings that can require a COMMIT after a UPDATE. If you made a mistake, you can ROLLBACK. In other database engines, you must start a TRANSACTION first. See: en.wikipedia.org/wiki/Rollback_(data_management)
Thanks for material. Ist very straight forward, however im missing some details. In my php app i have separate forms for insert and update order data, that are basicly duplicate. Today i found out im able to create new rows with just update form. Is it fine to do that, or is this can cause data corruption or something? also is frequent updating can cause problems in long distance? will db require defragmentation. Thanks for help...ups its yt not stackoverflow.
@Socratica In update query where we add 10% raise for every employee... It should be 0.1*salary not 1.1*salary.. Right?? Nice Videos and thanks for clear explanation.. Also can make video on script writing please....
The 0.1*salary is only the raise part, the new salary is the 1.1*salary. Ex: for a salary = 450 the 0.1*salary is 45 but the new salary is 1.1*salary = 495 (450+45) OR salary + 0.1*salary = salary(1+0.1) = 1.1*salary
Please urgent help ..for a table in SQL with columns(1) ID(pri key), (2)Name,(3) Gender, (4)DepartmentID...? I want to be able to change the name of an employee. How do I wrap this statement in a stored procedure? Update tblEmployee(table name) Set Name = 'john', Gender= 'Male', DepartmentID= 4 where ID = 3 I did this and it said violating primary key rule or something.. Create Proc spUdating Employee @ID int, @Name nvarchar(30), @Gender nvarchar(30), @DepartmentID(30) int As Begin Update tbl Employee Set Name=@Name, Gender=@Gender, DepartmentID=@DepartmentID Where ID=@ID End.. The problem is how to execute it Exec spUpdateEmployee ... Isn't working
Gizli Kullanıcı she was interupted before she could tell the entire joke, but as the three characters are databases walking into a bar, I guess the punchline is something about tables.
@@banzooiebooie Actually I don't understand the jokes like "x is walking into a bar. Orders a y, orders a z..." etc. Maybe that's an idiom in english, idk
@@gizlikullanc4861 It's just a structure for many different kinds of jokes. Many times the bar really has nothing to do with it, like in one classic example: A horse walks into a bar, and the bartender asks, "Why the long face?" "Why the long face" is an idiom for asking "Why do you look sad" by the way.... man I didn't realize how hard explaining jokes especially those relating to idioms really are! :)
@@dankwarmouse6248 wow, thanks for your explanation. After you said the meaning of "long face" and I re-read the joke, I lol'ed like crazy :D That was really funny and educational for me :)
What if you WANT to update ALL the data in a Column? Importing data from a spreadsheet with a date column comes in as TEXT. I want to change it to date of dd/mm/yyyy just like I get from the bank statement. I then want to be able to do a query on the date. You videos are out of the park FANTASTIC.. As of this date 04/01/2021 there are 1.6K likes up there and 17 idiots that did a thumbs down. THANK YOU for your videos and may the Lord bless you greatly :) ✨✨✨👍
Wow.. comment was 2 years ago.. Thanks for getting back.. I 'm actually doing taxes for 2022 and needing to refresh sql. Do you guys do any C# videos? I pray a special blessing to you and your crew for protection, continued good health, & having a closer relationship with God :)
1.1*salary = (1+0.1)*salary = 1*salary + 0.1*salary = salary + 10% of salary so 1.1*salary = new salary, which is 10% more than previous salary. So 1.1*salary means 10% increase added to previous salary.
CREATE TABLE public.secret_user ( user_id serial NOT NULL, first_name character varying, last_name character varying, code_name character varying, country character varying, organazation character varying, salary integer, knows_kung_fu boolean, PRIMARY KEY(user_id) ) WITH( OIDS = FALSE ); ALTER TABLE public.secret_user OWNER to postgres;
Sean Connery is the ultimate James Bond Legend has is...........He is older than the pyramids All his X GFs are now mummified (thats the only sure fire way of keeping them quiet)
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!! 💜🦉
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
She is an actor, videos and scripts are done by the company
Wow, this is the best prepared videos for tech I have ever seen, keep it up!
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*
My god. I'm watching this just for entertainment value. I know everything about updates, but I just can't stop!!
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."
I love the humor first of all, but I'm especially a fan of the scenarios. This tutorial is great.
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
)
why always primary key assign to user-ID
@@ma8969 It doesn't always have to be user_id but it has to be unique. Usually that's what user_id is made for, an unique identification number used to be primary key
Is this what love feels like? Goodness these series are amaaazzzinnggg!
Thank you! This has changed my ability from being completely oblivious in IT studies, to knowing the thoughts of cyberdeities! 😁
I'm hooked on your Beginner videos. Appreciate the simplicity it presents in learning to write a SQL Query !
Do you love Socratica Programming videos? We have a Kickstarter to make 20 Advanced Python Lessons. Support what you love! bit.ly/PythonKickstarter
This is simply the best I have ever seen on TH-cam tutorials 🎉
This series deserves so many more views there's nothing like them really
wayyyy easier and more exciting to learn than alot of these other channels thank you. Not to down talk on the other channels
I love this series more than I hate having to learn sql. And that really is saying something
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!
This is great advice. Thanks!
Wonderful narration with well known stories, and Nick Fury knows Kung fu now😀😀😋😋
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!
you are really awesome..the way you are teaching is best ..it is easy to learn..you are the best teacher..Thank You so much ..
Another one of the best videos for learning SQL. Thanks!
Waooh! I like the way you realised your video and I love your teaching technique! Please continue to make videos for us, new SQL language learners!
i love your videos. you make SQL so much fun and comprehensible! Ty!
Brilliant! Not just Brilliant. Copacetic. Creativity at its Best.
Suggestion for more advanced topic. When should you use "select for update" and when are "dirty reads" ok. As a follow up advanced topic, difference between MVCC versus Spin lock design on multiple updates.
I love this woman!!
Best Tutorial ever. :)
OMG this lady is great. Thanks!
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
Thanks for that. I like to follow along with the videos and that saved me some typing. Additional free time I will use to say how great you are. :-)
Thank you very much! you wrote 'knows' instead of 'knows_kung_fu' though
Socratica...my new favourite everything.
Instant subscribe! Video was informative and fun!
Awesome tutorial, keep up the good work !!!
thank you all for the explanation. i'm from Argentina
very creative and easy to understand, good work...
haahahha u are so funny !!!!!!!! I rly love this concept, please make more series like this . GREETINGS !
Video is 8 minutes. Released on Pi Day. 3+1+4=8.
It's 8 mins 2 secs friend. Why people try to find "cosmic" patterns in coincidence is beyond me. Here it is being forced by changing the time to work. Weak sauce. I think your fever has gotten to you.
Ulka is SQL: Seductive Queen of Learning.
Love the Susan Hilton reference!
As always, thank you very much.
That was so fun (and instructing).
thank you for sharing your knowledge!
Never had that fun learning sql queries :)
You are so talented
You are AMAZING 😍😍😍
5:58 can i write "WHERE user_id = 5, 7, 8;" instead of using IN? Why do i need to write IN?
I guess the code does some sort of for loop on the list and needs it as a list.
That looks like an extension to the ISO standard....using OR or IN ( ..., ... ) works everywhere.
IN is used to specify to only 5 6 7
Equality (=) is not the same thing as "member of" (IN). An ID cannot be equal to more than one value but it can be a member of a collection of values. If ID=5, for example, then ID != 6. This is why IN is used. If ID=5, then ID is a member of (IN) the list 5,6,7.
Another wonderful, great, helpful and entertaining video. :)
This is amazing! hahah
Watching a scifi and picking up skills like kung fu!
Great videos, thanks
Those vids are fun, good job I guess.
You should be on Mr Robot tv show! 😄
so nice.. thank you Socratica.
In case you missed it, always include a WHERE clause in your UPDATE statements. Make sure you have backups for your database for when you choose to ignore that advice
Love this series thanks
I have 2 questions:
History and Undo.
There is no undo an UPDATE, the database engine assumes that you know what you are doing.
@@JorgeEscobarMX Some database engines have settings that can require a COMMIT after a UPDATE. If you made a mistake, you can ROLLBACK. In other database engines, you must start a TRANSACTION first. See: en.wikipedia.org/wiki/Rollback_(data_management)
That's one incomplete statement Sir!
Always excellent
If you hadn't leaked those salaries on youtube the MI6 officers wouldn't have asked for equal pay.
Very helpful
What about if you need to update multiple values in a single entry?
Jack Ryan did not received the desired code name did he? At 2:25 in the note it says "Neo 2.0?" so there's a "?" missing! 😁
Thanks for material. Ist very straight forward, however im missing some details. In my php app i have separate forms for insert and update order data, that are basicly duplicate. Today i found out im able to create new rows with just update form. Is it fine to do that, or is this can cause data corruption or something? also is frequent updating can cause problems in long distance? will db require defragmentation. Thanks for help...ups its yt not stackoverflow.
lol, love these videos
Is making notes on programming is a good idea? If Yes, Can you a video on it.
Please make more sql videos. Thanks
I love it
@Socratica
In update query where we add 10% raise for every employee... It should be 0.1*salary not 1.1*salary..
Right??
Nice Videos and thanks for clear explanation.. Also can make video on script writing please....
The 0.1*salary is only the raise part, the new salary is the 1.1*salary. Ex: for a salary = 450 the 0.1*salary is 45 but the new salary is 1.1*salary = 495 (450+45) OR salary + 0.1*salary = salary(1+0.1) = 1.1*salary
Is nobody gonna talk about how these secret agents salaries are super low LMAO
The barman says will you be using a table? Oracle says IS_SERVERERROR(1017).
It still rocks!
1:26 you should have added john wick as well
The examples in the video -
www.db-fiddle.com/f/p8sgPxVtKevtJvkjybVJXp/1
10% rise means 1.1 ??? Please explain
Please urgent help ..for a table in SQL with columns(1) ID(pri key), (2)Name,(3) Gender, (4)DepartmentID...? I want to be able to change the name of an employee. How do I wrap this statement in a stored procedure?
Update tblEmployee(table name)
Set Name = 'john', Gender= 'Male', DepartmentID= 4
where ID = 3
I did this and it said violating primary key rule or something..
Create Proc spUdating Employee
@ID int,
@Name nvarchar(30),
@Gender nvarchar(30),
@DepartmentID(30) int
As
Begin
Update tbl Employee
Set Name=@Name, Gender=@Gender, DepartmentID=@DepartmentID
Where ID=@ID
End..
The problem is how to execute it
Exec spUpdateEmployee ...
Isn't working
thank you
Can someone explain the joke about Oracle, Postgres and SQLite in a bar?
Please tell me you have discovered the answer to the joke about Oracle having to "Look here old man" at 4 minutes 10 seconds in?
could anyone explain to me the joke about oracle? (please)
maybe Oracle is just older then the others
5:32 is ethan hunt dead🚶🚶♂️🚶♂️ ?, update it
Why did not you include Maxwell Smart? His Code name was: SuperAgent86 !
the music's name?
Do Socratica guys know Kung Fu?
Hahahahha you are awsome !!!
My english is not good enough to understand the joke at 4:25. Can someone please explain to me?
Gizli Kullanıcı she was interupted before she could tell the entire joke, but as the three characters are databases walking into a bar, I guess the punchline is something about tables.
Or maybe the punchline was "look up here old man" i.e select
@@banzooiebooie Actually I don't understand the jokes like "x is walking into a bar. Orders a y, orders a z..." etc. Maybe that's an idiom in english, idk
@@gizlikullanc4861 It's just a structure for many different kinds of jokes. Many times the bar really has nothing to do with it, like in one classic example:
A horse walks into a bar, and the bartender asks, "Why the long face?"
"Why the long face" is an idiom for asking "Why do you look sad" by the way.... man I didn't realize how hard explaining jokes especially those relating to idioms really are! :)
@@dankwarmouse6248 wow, thanks for your explanation. After you said the meaning of "long face" and I re-read the joke, I lol'ed like crazy :D That was really funny and educational for me :)
What if you WANT to update ALL the data in a Column? Importing data from a spreadsheet with a date column comes in as TEXT. I want to change it to date of dd/mm/yyyy just like I get from the bank statement. I then want to be able to do a query on the date. You videos are out of the park FANTASTIC.. As of this date 04/01/2021 there are 1.6K likes up there and 17 idiots that did a thumbs down. THANK YOU for your videos and may the Lord bless you greatly :) ✨✨✨👍
Were you able to accomplish all you wanted to in this comment?
Wow.. comment was 2 years ago.. Thanks for getting back.. I 'm actually doing taxes for 2022 and needing to refresh sql. Do you guys do any C# videos? I pray a special blessing to you and your crew for protection, continued good health, & having a closer relationship with God :)
best machine girl :| , forever
What this name application?
you have to update your t.shirt too.
You should have never disclose that document: disclosing it made all the agents unhappy!
lol
Set salary = 1.1*salary
1.1 means 10% ??
1.1*salary = (1+0.1)*salary = 1*salary + 0.1*salary = salary + 10% of salary so 1.1*salary = new salary, which is 10% more than previous salary. So 1.1*salary means 10% increase added to previous salary.
@@physicsguybrian thank you soooo much ;)
10% means 0.1 na ??
Emma Peel ❤️
+1 for Nick Fury
plz can make plsql tutorial vdos
UPDATE joke SET punch_line = ?
THIS WILL UPDATE ALL OF YOUR JOKES
Bro.... that was NOT kung fu! That was karate ! >:( ... I'm not mad, just a bit disappointed ... But the rest of the video was great!
8 minutes for an UPDATE tutorial lmao. 😂
--------------------------------------CREATE TABLE-------------------------------------------
CREATE TABLE secret_user (
user_id serial primary key,
first_name character varying,
last_name character varying,
code_name character varying,
country character varying,
organization character varying,
salary integer,
knows_kung_fu boolean
);
--------------------------------------INSERT INTO TABLE-------------------------------------------
INSERT INTO secret_user (first_name, last_name, code_name, country, organization, salary, knows_kung_fu)
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', 'Foxtrot', 'United States', 'SHIELD', 250000, false);
CREATE TABLE public.secret_user
(
user_id serial NOT NULL,
first_name character varying,
last_name character varying,
code_name character varying,
country character varying,
organazation character varying,
salary integer,
knows_kung_fu boolean,
PRIMARY KEY(user_id)
)
WITH(
OIDS = FALSE
);
ALTER TABLE public.secret_user
OWNER to postgres;
😂
i could not get the joke :(
PunjabiQuarters
James Bond is too old for this...he's too busy entertaining the chicks.
Sean Connery is the ultimate James Bond
Legend has is...........He is older than the pyramids
All his X GFs are now mummified (thats the only sure fire way of keeping them quiet)