From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Write a stored procedure
From the course: Database Foundations: Database Management
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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.