We have covered parameters, functions and procedures. Do not forget that, if you are taking the certification exam, you must know about procedures.

Download the class notes for day 6.

Note that functions and procedures change from vendor to vendor. In this course, we are looking at Microsoft’s T-SQL for SQL Server.

If anyone if interested in functions and procedures in Oracle, refer to the following URLs.

1. https://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25108/xedev_programs.htm
2. http://www.techonthenet.com/oracle/procedures.php
3. http://www.techonthenet.com/oracle/functions.php

For MySQL and MariaDB, refer to the following URLs.

1. http://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
2. http://dev.mysql.com/doc/refman/5.7/en/create-function.html
3. http://dev.mysql.com/doc/refman/5.7/en/create-function-udf.html