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.
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
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
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 😎
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.
Hey Atziri, the parameters can help you with fetching details with respect to a particular input. They help us use procedures like functions in computer programming languages. Way useful if u ask me
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'
Delimiter $$ Create procedure Large_finalworth5 (rank int) Begin Select * from billionaires where rank= rank; End $$ Delimiter; call Large_finalworth5 (2); it shows me error on line 2 and 8 , create procedure and delimeter....pls anyone suggest where i went wrong.
1. Change the delimiter before and after the procedure to $$. 2. Rename the parameter from rank to rank_input to avoid conflicts. 3. Use rank_input in the WHERE clause. DELIMITER $$ CREATE PROCEDURE Large_finalworth5 (IN rank_input INT) BEGIN SELECT * FROM billionaires WHERE `rank` = rank_input; END $$ DELIMITER ; CALL Large_finalworth5(2);
@@azmary986 pls do also tell me while store procedure when i call any specific value lets say life_expectancy=77, it shows all data. where i went wrong here is my query :- Delimiter $$ Create procedure life_expectancy_country (life_expectancy_country int) Begin Select * from billionaires where life_expectancy_country = life_expectancy_country; End $$ Delimiter $$ ; call life_expectancy_country(77);
@@azmary986 when i run below commond it relects all the data, but it has to only reflect the data where life_expectancy_country=77, pls help. where i went wrong. Delimiter $$ Create procedure life_expectancy_country (life_expectancy_country int) Begin Select * from billionaires where life_expectancy_country = life_expectancy_country;
End $$ Delimiter $$ ; call life_expectancy_country(77);
@alex I didn't get any output and was able to create the stored procedure when I ran the below code...why so? CREATE procedure new_store_procedure3() Select * from order_details where order_id >= 9; Select * from order_details where order_id >= 5;
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
Dear Alex My name is Molwedi Ramoeletsi Augustinus from South Africa. You had an online bootcamp here on RUclips, 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😟😟😟
Exactly the same problem I am facing , all 12 rows from the employee_salary were returned whereas it just returned only one for Alex . I thought I was the only one in this ship of confusion
@@abdulgafarjimoh9323 I think I changed the name for one of them and that seemed to make it work. But can’t exactly recall as I am not in a PC and have not touched SQL in a while.
The best STORED PROCEDURE video I have seen on RUclips. Kudos to you ALEX.
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.
Every got into the industry?
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
That's smart. 😆
Simple and to the point!! Thanks Alex
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
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 😎
This is extremely helpful. You explain things very nicely, Alex. Keep it up! :)
Owh I got it Alex, it similar to Function in another language. Really helpful for doing some job and call it when we want, GBU Alex!
This whole series is AWESOME!!
This was awesome and so clear. It felt so understandable. Thanks for this tutorial.
Thank you very much for putting out such great content, Alex. I'm grateful!
Awesome video Huggymuffin! (No judgement here!) LOL! Thanks for your easy to understand instructions! I will be watching more!
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.
You are not the only one.
Hey Atziri, the parameters can help you with fetching details with respect to a particular input. They help us use procedures like functions in computer programming languages. Way useful if u ask me
Thanks a lot. Wish u good luck and a lot of followers ☺️
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...
That's really amazing Alex however can you please make a video on out and inout parameter as well that would help us alot as well..... Thanks
Thanks for teaching us ❤
6:25 This is not giving two outputs for me as only the second query in the stored procedure is running.
AMAZING
why should one use procedures instead of views?
I wasn't able to find a way how to use the DELIMITER in MS SQL Server Management Studio. Would you be able to assist?
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'
Delimiter $$
Create procedure Large_finalworth5 (rank int)
Begin
Select *
from billionaires
where rank= rank;
End $$
Delimiter;
call Large_finalworth5 (2);
it shows me error on line 2 and 8 , create procedure and delimeter....pls anyone suggest where i went wrong.
1. Change the delimiter before and after the procedure to $$.
2. Rename the parameter from rank to rank_input to avoid conflicts.
3. Use rank_input in the WHERE clause.
DELIMITER $$
CREATE PROCEDURE Large_finalworth5 (IN rank_input INT)
BEGIN
SELECT *
FROM billionaires
WHERE `rank` = rank_input;
END $$
DELIMITER ;
CALL Large_finalworth5(2);
@@azmary986 thankyou very much.😀
@@azmary986 pls do also tell me while store procedure when i call any specific value lets say life_expectancy=77, it shows all data. where i went wrong here is my
query :-
Delimiter $$
Create procedure life_expectancy_country (life_expectancy_country int)
Begin
Select *
from billionaires
where life_expectancy_country = life_expectancy_country;
End $$
Delimiter $$ ;
call life_expectancy_country(77);
THANK U SO MUCH.@@azmary986
@@azmary986 when i run below commond it relects all the data, but it has to only reflect the data where life_expectancy_country=77, pls help. where i went wrong.
Delimiter $$
Create procedure life_expectancy_country (life_expectancy_country int)
Begin
Select *
from billionaires
where life_expectancy_country = life_expectancy_country;
End $$
Delimiter $$ ;
call life_expectancy_country(77);
How is this different from create view?
Does that require write permissions?
did exec turn to call? i'm revising and before i wrote it that way.
Hi i am confuse here
What is difference between views,store procedure both are doing the same thing...
Thanks!
excellent
Pls do video on creation of views
thanks♥
MySQL is showing error when I input delimiter
Who can help please
@alex I didn't get any output and was able to create the stored procedure when I ran the below code...why so?
CREATE procedure new_store_procedure3()
Select * from
order_details
where order_id >= 9;
Select * from
order_details
where order_id >= 5;
Hey. You need to use the first execution option, not the cursor one.
✅
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
huggymuffin :D
Dear Alex
My name is Molwedi Ramoeletsi Augustinus from South Africa. You had an online bootcamp here on RUclips, 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😟😟😟
Work out the problems that God has assigned you
Anyone know when I follow Alex's example of "WHERE employee_id = employee_id" it outputs all salaries when I compute "CALL large_salariesX(1)"?
Exactly the same problem I am facing , all 12 rows from the employee_salary were returned whereas it just returned only one for Alex . I thought I was the only one in this ship of confusion
@@abdulgafarjimoh9323 I think I changed the name for one of them and that seemed to make it work. But can’t exactly recall as I am not in a PC and have not touched SQL in a while.
use employee_id=emp_id , giving it same varibale name leads to the issue you are having
Hi
I'm having same issue still @ignisync
Hi,
Did you figure it out?? 😢