Working with SQL Stored Procedures using MySQL Workbench

oferecido por
Neste projeto guiado, você irá:
2 hours
Intermediário
Sem necessidade de download
Vídeo em tela dividida
Inglês
Apenas em desktop

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 an output parameter(s). This course is structured in a systematic way and very practical, where you get an option to practice as you progress. This project-based course is an intermediate-level course in SQL. Therefore, to get the most out of this project, it is essential to understand using SQL. Specifically, you should be able to write SQL JOIN statements and work with aggregate functions. If you are not familiar with these concepts, it will be helpful to complete my previous project titled "Performing Data Aggregation using SQL Aggregate Functions" and “Mastering SQL Joins.” However, if you are comfortable with these SQL concepts, please join me on this wonderful ride! Let’s get our hands dirty!

Habilidades que você desenvolverá

  • Data Manipulation

  • Mysql Workbench

  • Stored Procedure (SPROC)

  • database administration

  • MySQL

Aprender passo a passo

Em um vídeo reproduzido em uma tela dividida com a área de trabalho, seu instrutor o orientará sobre esses passos:

Como funcionam os projetos guiados

Sua área de trabalho é um espaço em nuvem, acessado diretamente do navegador, sem necessidade de nenhum download

Em um vídeo de tela dividida, seu instrutor te orientará passo a passo

Perguntas Frequentes – FAQ