Working with SQL Stored Procedures using MySQL Workbench

提供:
このガイド付きプロジェクトでは、次のことを行います。
2 hours
中級
ダウンロード不要
分割画面ビデオ
英語
デスクトップのみ

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!

あなたが開発するスキル

  • Data Manipulation

  • Mysql Workbench

  • Stored Procedure (SPROC)

  • database administration

  • MySQL

ステップバイステップで学習します

ワークエリアを使用した分割画面で再生するビデオでは、講師がこれらの手順を説明します。

ガイド付きプロジェクトの仕組み

ワークスペースは、ブラウザに完全にロードされたクラウドデスクトップですので、ダウンロードは不要です

分割画面のビデオで、講師が手順ごとにガイドします

よくある質問