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 create and use triggers, including how to create triggers with one statement, triggers with multiple statements, and multiple triggers on one table. Finally, you learned how to create and use temporary tables, either explicitly or implicitly, as well as how to drop temporary tables. 

In the next chapter, you will learn how to explore and process data. By the end of the next chapter, you will be able to understand how to get to know the data by creating a statistical identity, learn how to detect and fix anomalous and missing values, learn how to formalize strings via functions, and use regular expressions to match data value patterns.