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

단계별 학습

작업 영역이 있는 분할 화면으로 재생되는 동영상에서 강사는 다음을 단계별로 안내합니다.

안내형 프로젝트 진행 방식

작업 영역은 브라우저에 바로 로드되는 클라우드 데스크톱으로, 다운로드할 필요가 없습니다.

분할 화면 동영상에서 강사가 프로젝트를 단계별로 안내해 줍니다.

자주 묻는 질문