SQL Query Basics: Insert, Select, Update, and Delete

Without question the most used statements in SQL are the Insert, Select, Update, and Delete statements. They make up the core foundation for any database work.

Hope you enjoyed the video!

Create Tables Video:

Check out this code here:

Join my Discord server to chat with me:

Check out some code on my GitHub:

Come visit us on Reddit:

Other Social:

[pierogii_]

This taught me more than a $2, 000 university database basics class. Thanks man!

[ZacKoch]

Great video! Everyone should know SQL basics, you're going to run into a database no matter what technical career path you choose.

[MrGFYne]

Dude you explain things so well and it is so much easier for me to understand, , ty. sincerely ty.

[HadToChangeMyName_YoutubeSucks]

A shortcut for the insert of multiple rows, insert into people (name, age) values ('john', 21), ('fred, 22), ('albert', 23);

[MatiEP]

im having tommorow an exam on this, nice explanation!

[thomasterp-madsen]

Great video, as always - I'll check out your other SQL videos right away; you're great at explaining everything in just the right amount of detail AND in a perfect tempo. Thank you so much!

[mayne]

Thanks broo!! I wish that I'll get the teachers like you...Keep it up buddie!!!

[justnbody.]

just found your channel and i’m learning so much from it MASSIVE THANK YOU BRO ❤️❤️

[nidhi]

I knew the basics. But never used limit and transaction..thanks EM

[morningtarr]

Thanks,
If you could explain about how internals work, would be great.

[kevinc.]

Apologies if you already made one, but an ATOM tips and tricks vid would be much appreciated. Love the content, Thanks!!

[ayeshairshad]

I am outreaching you on behalf of NCache by Alachisoft. Ncache is a 100% .NET / .NET Core distributed cache.
We have been following your YouTube Channel since quite a while and we really can’t help appreciating the amazing work you are doing. We saw some Tutorials, How-To guides and Tips on your channel, so we would really want to have an alliance with you for some similar videos.
I hope you don’t mind if we talk further about this.

[hbdfnny]

you are great man but please add the possibility to activate the subtitles, you speak fast and we are not all english native speakers, so they help. have a nice day and thank you ;)

[s]

Looking forward to more DB videos. Subscribed.

[misterinc]

I just started to learn python and a bunch of things related to data science 1 month ago. I really appreciate your video. I was wondering if you could tell me what IDE are you using for SQL and asking for doing a video for noSQL. Cheers

[blanketfish]

Love your videos. Could you do a video on "ON DELETE" clause when using foreign keys or foreign keys in general?

[arielapp]

that happened to me, I wrote a database update php page, obviously one of the functions was: delete from table_name, it took me a while to understand that, I forgot to write down the where part, and I kept deleting my table, goos thing I was in the development stage, and not in the production stage :)

[adparikhyt]

That's help me in computer application thanks bro

[mohamedelhagib]

Hi can you help me how can i delet using this select

SELECT PRO.CDPRO, TRA.NHORAS, TRA.CDEMP
FROM PROYECTO PRO, TRABAJA TRA
WHERE TRA.CDPRO = PRO.CDPRO
group by PRO.CDPRO, TRA.NHORAS, TRA.CDEMP
HAVING SUM(NHORAS)=0;

this is the incial select and i need to transforme it into delete how can a i do it? thanks

[stephenwatson]

Hello Engineer man if you could help I would appreciate it.

How do you syntax sql to display output in a decimal field when using number like 2, 244.90 and not having the database erroring the comma thinking it is an extra field.