Have you thought about creating a query that can be called several times to perform a routine task? Stored procedures offer this with a great advantage of efficiency. This project-based course, "Working with SQL Stored Procedures using MySQL Workbench," is intended for intermediate SQL users with some related experiences with SQL and who are willing to advance their knowledge and skills.
In this 2-hour project-based course, you will learn how to create stored procedures for different tasks including stored procedures with one input parameter, multiple input parameters, and output parameter(s). The course is structured in a systematic way and very practical, offering you an option to practice as you progress. It's essential to understand using SQL, particularly writing SQL JOIN statements and working with aggregate functions to get the most out of this project. If you are comfortable with these SQL concepts, join this wonderful ride!
Certificate Available ✔
Get Started / More Info
Google Advanced Data Analytics offers professional training in advanced data analytics skills, including statistical analysis, Python, regression models, and machine...
Big Data Integration and Processing is a comprehensive course that equips learners with the skills to retrieve and process big data from various sources using tools...
Learn the basics of exploratory data analysis in R, automate EDA reports, and explore advanced EDA techniques in this 1-hour project-based course.
Learn how to optimize query performance in Looker with this self-paced lab, focusing on persistent derived tables, aggregate awareness, and performantly joining...