In this chapter, you learned how to create programmable objects, including how to create and use views, which included selecting data from views and inserting, updating, and deleting data using views. Additionally, you learned how to alter and drop views. You learned how to create and use variables, which included how to declare and assign values to variables. This also included how to use variables in a query.
Then, you learned how to create and use stored procedures, including how to alter and drop stored procedures. This included learning how to use variables and parameters in stored procedures, as well as how to control flow in stored procedures using IF, CASE, LOOP, REPEAT, and WHILE. Finally, you learned how to handle errors in stored procedures.
After that, you learned how to create and use functions, including how to alter and drop functions. You learned how to...