From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Join today to access over 24,400 courses taught by industry experts.
Introduction to stored procedures - SQL Tutorial
From the course: Complete Guide to SQL for Data Engineering: from Beginner to Advanced
Introduction to stored procedures
- [Instructor] Imagine you have a magic recipe that cooks a delicious dish. Stored procedures are like those recipes. Once created, anyone can use them by following the steps. It's like cooking the same testy meal without having to figure out the recipe each time. Another example, think of a chef who prepares a dish regularly. They get faster each time because they know the steps well. Similarly, when you use a stored procedure, the server figures out the best way to do the things first time. After that, it keeps a quick way to do it again. It's like having a chef who gets faster and more efficient with every cooking session. Stored procedures are prepared SQL code that you save so you can reuse it over and over again. So if you have any SQL query that you write over and over again, you can save it as a stored procedure and call it to run whenever needed. It's quite similar to the functions which you see in the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
