Stored Procedures in MySQL | Advanced MySQL Series

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Stored Procedures in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
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:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
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!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱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_19]

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

[@ericrullepa5683]

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.

[@Neriamonde]

This whole series is AWESOME!!

[@radhameena4959]

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

[@ozgunc4735]

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

[@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

[@user-kq3tc5tu1c]

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 😎

[@user-pi7yx7dr8u]

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

[@anonymous-65732]

AMAZING

[@AmanTiwari-ow6rc]

excellent

[@joanvou5867]

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

[@user-ok2hb1ks7e]

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'

[@tahiraleem]

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

[@marcink6879]

Does that require write permissions?

[@atzirimendozagtz9787]

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.

[@saivinith321]

Pls do video on creation of views

[@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

[@musicbox415]

Dear Alex My name is Molwedi Ramoeletsi Augustinus from South Africa. You had an online bootcamp here on KZbin, 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😟😟😟

[@aidanthompson5053]

Work out the problems that God has assigned you