Advanced SQL Tutorial | Stored Procedures + Use Cases

In today's Advanced SQL lesson we walk through how to use Stored Procedures.

____________________________________________

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

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

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*

[LukeBarousse]

I like how you run the code (before it is fully complete) to show the error messages you expect and then show how to fix said error messages. This really helps with understanding SQL and helps with understanding troubleshooting code in the future. Keep up the content, Alex!

[ContentRoomB]

So far partition and stored procedures are the 2 videos that I found difficult. But I've learned a lot from this series. Thanks, Alex!

[ezehconfidenceadaeze]

Thank you Alex. Your videos are literally the best. You came down to the beginners level and walked us from ground to top.

[colourNika]

I was slightly struggling with it to follow along so here is the steps to actually get the same result:
1) You write a stored procedure: drop table if exists, create table, inset into and select - finish with GO (you can also wrap the whole thing in: BEGIN (all queries) END
2) Run what you wrote (all of it)
3) Exec [store procedure name]
4) Modify - add parameter
5) Run the whole thing again ( I mean the modify query)
6) Exec [store procedure name] [your parameter]

[romanvasiura]

Cool. This lesson was much more harder than previous one.
I'll check for myself what means "@" and other stuff.. Definitely I'll rewatch this video again.

Thank you for this interesting lesson.

[maheshmagadi]

Thank you very much Alex. Your videos are adding much values in my learnings.

[danielalcivar]

Thank you Alex, your content is so useful. I was waiting for your next advanced series. Do you think you could show how to make advanced triggers?

[mathewsjoy]

Please keep these style of videos coming, very insightful!

[Tuuuuusssjjjjjjnrnfnnfnfn]

Best YouTube channel for Data Analysts!!❤️🔥

[Mahshadn]

Great content Alex! Keep up the good work 👍

[LearnITskills]

Great video! I've worked with SQL a few times but I still got a lot to learn. This was very helpful!

[BigAguy]

you explain this so easily. appreciate this!

[sia_ibk]

This was more intense than the previous sessions.

[edricnes]

Superb explanation and content, keep it up Alex!

[janetl]

Hi Alex, I am a huge fan of your channels. Recently I am looking for a job of data analyst.
Could you please show us some behavior questions which might be asked frequently during the interview session.
Again, thank you so much for your videos, it is really helpful to me.

[ProgressiveDeveloper]

this tutorial changed my mind am now on the real track for the progress thanks alex>>>

[saltech]

I subscribe straight along the way....
Your tutorial is awesome

[naveonleo]

Hey Alex, Can you show us (a) how to compare two databases and their tables for gap analysis using Python -
(b) and also how to compare text file data with table data using python assuming both have similar table structure...
would appreciate your work and contribution for students and learners.

[maximillianquaife-larsen]

Thank you I’ve been confused on this one for ages

[pablosalazar]

Super video ! Breve y muy práctico. Muy bien explicado. Muchas gracias !