Intermediate SQL Tutorial | Updating/Deleting Data

In today's Intermediate SQL lesson we walk through Updating/Deleting Data.

All Topics Covered: Joins, Unions, Case Statements, Updating/Deleting Data, Partition By, Data Types, Aliasing, Views, Having Clause, GetDate(), Primary vs Foreign Key

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

Resources:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

Websites:

____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[abbasali]

This is how tutorials are meant to be - short and simple. Elsewhere on internet I have found lengthy and complicated tutorials. Thank you Alex

[harshvardhanpatil]

A nice trick for the DELETE statement, using the SELECT statement before the DELETE statement.

3:12 You dont fool me by giving Toby a ridiculous raise and then firing him "randomly"

[nafisehfaqihi]

The HAVING clause is used if we need to filter the result based on aggregate functions such as MIN () and MAX(), SUM() and AVG() and COUNT().

[saraho.]

Thank you so much Alex, no matter how lazy i am, the length of your videos gives me the courage to learn at least one new thing a day

[elhammirzaei]

Not only your contents are so useful, but also your calm and good-toned voice helps me concentrate and gets all the stress of the new-things-learning away! Perfect job. Thank you!

[LAB-xwco]

3:13 "Let's delete a completely random employee" Come on Alex! Everyone knew it was Toby haha!

[czechmaster]

"I'm going to just pick a random ID".... proceeds to delete Toby lol. Michael would be proud!

[MuhammadSohail-wr]

"I appreciate your proactive approach to problem-solving. Your initiative has saved us time and effort."

[cindystokes]

completely random employee number to delete... 🤣🤣🤣 So many good Office jokes. I love it!

[jh]

Super loving that Alex is keeping up the Toby hate in these videos. Thanks for the laughs with the amazing content, Alex!

[krasiivanov]

You are soooo good in explaining stuff....wish there were hundreds of videos from you on SQL !! The best and easiest tutorials I have found on youtube...well done..

[nicatshiraliyev]

Shade on Toby on those is incredible😂. I am amazed that it doesn't get enough appreciation

[pearlskye]

Who else saw it coming Toby would be the one to get deleted? 😂 thank you so much for these videos BTW! they're super easy to follow.

[Zehfidence]

Alex thank you so much. You’ve been of great help.

[yt-sh]

thanks for using office cast as data, makes this more interesting!

[poojatodakar]

Begin transaction and rollback statements helps you to undo your deleted row /truncated/dropped table .

[carissagamboa]

Sooo were going to just delete a employee at random… TOBY FLENDERSON. 😂

[troyhickom]

We love the SQL information, but we hate the subtle Toby slander 😂

[estheroyelere]

THANKS FOR THE EXPLANATORY VIDEOS. PLEASE HOW DO I DELETE ONE OUT OF TWO DUPLICATED ROWS IN A TABLE