From the course: Database Foundations: Database Management

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Challenge: Write a stored procedure

Challenge: Write a stored procedure

From the course: Database Foundations: Database Management

Start my 1-month free trial Buy for my team

Challenge: Write a stored procedure

“

(lively music) - [Instructor] Before we wrap up this course, I'd like to finish with one last challenge. In order to help end users add new customers into the Two Trees database, I'd like you to create a stored procedure that'll take input parameters and save them into a new row. I didn't demonstrate this in the course, but stored procedures can take multiple input parameters. Just list them out separated by commas when you create the stored procedure. And when it comes time to test the stored procedure out, just pass in the new customer values in the same order as they're listed in the stored procedure. You can use whatever database platform you prefer. I'll demonstrate the solution on both platforms in the next movie. I estimate that this challenge should take about 10 to 15 minutes to complete. Good luck.

Contents