Stored Procedures in MySQL | Advanced MySQL Series

In this lesson we are going to take a look at Stored Procedures in MySQL!

____________________________________________

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!*
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

*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*

[vanshgrover_]

The best STORED PROCEDURE video I have seen on Youtube. Kudos to you ALEX.

[anapslima]

Thank you for sharing! I don't use stored procedures because I don't want them visible to others. Usually, I just save all my queries in a GitHub repository

[ericrullepa]

I am so thankful that I discover your chanell way back Feb 2023 Alex. Before that, I am so lost in my career not knowing my purpose in life. But bc of some random vid yt recommended to me, I become interested in D.A field and your yt channel is such a great help. You've become my role model like a father figure teaching his son to be successful . I am currently working as a customer service rep. and currently taking the Google D.A cert to increase my chance in entering in DA industry.

[radhameena]

This is extremely helpful. You explain things very nicely, Alex. Keep it up! :)

[ozgunc]

This was awesome and so clear. It felt so understandable. Thanks for this tutorial.

[erlanbek-kanybekov]

Wow ❤ amazing, those stored procedures is like creating functions in Kotlin or java, python, etc.

I’d happy if you could make a video about backup in postgresql

[okhbkse]

Could this be applicable with date params? I have complex queries that I run often enough that this could be useful but I do have to shift the 'Where date Between yyymmdd and yyyymmdd'

[kqtctuc]

I hate myself... I had a really TLDR comment going and managed to lose my work! Not the course's fault, I own the responsibility. Anyway, I learned some "USE" syntax from this lesson that explained a minor issue I encountered earlier tonight. Trial and Error, not the most efficient learning method, but - it's better than not learning at all! Great lesson for so many reason Alex, thanks again for your time and effort. Cheers! BB 😎

[joanvou]

did exec turn to call? i'm revising and before i wrote it that way.

[tahiraleem]

6:25 This is not giving two outputs for me as only the second query in the stored procedure is running.

[atzirimendozagtz]

I have a question regarding parameters. I don't think I quite understand them well but in what scenario would they be useful? I understand why stored procedures are useful but the whole parameter thing kind of lost me.

[altramonster]

Hi i am confuse here
What is difference between views, store procedure both are doing the same thing...

[premakolia]

why should one use procedures instead of views?

[GbemigaAtolagbe]

Hi. Do a video on uncorrelated subqueries
i.e
SELECT s1.article, dealer, s1.price
FROM shop s1
JOIN (
SELECT article, MAX(price) AS price
FROM shop
GROUP BY article) AS s2
ON s1.article = s2.article AND s1.price = s2.price
ORDER BY article;

T for thanks

[musicbox]

Dear Alex
My name is Molwedi Ramoeletsi Augustinus from South Africa. You had an online bootcamp here on Youtube, I followed it and printed the certificate. Currently a hospital in my location is willing to give me work experience exposure for a Data Analyst role, they asked me to get Work Experience Certifcate Request. I'm pleading with you to assist me with writing the work experience certificate request please help me😟😟😟

[Simulyasiya]

The company doesn't care about Tom and Jerry when the salaries are increased but it also doesn't hesitate to see them as highly paid employees...

[aidanthompson]

Work out the problems that God has assigned you