{"id":172,"date":"2016-06-14T09:40:26","date_gmt":"2016-06-14T13:40:26","guid":{"rendered":"http:\/\/folvera.commons.gc.cuny.edu\/?p=172"},"modified":"2021-09-16T14:58:25","modified_gmt":"2021-09-16T18:58:25","slug":"database-administration-fundamentals-day-6-2","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=172","title":{"rendered":"Database Administration Fundamentals (WS16SQL1006) \u2013 Day 6"},"content":{"rendered":"

We have covered parameters, functions and procedures. Do not forget that, if you are taking the certification exam, you must know about procedures.<\/p>\n

Download the class notes<\/a> for day 6.<\/p>\n

Note that functions and procedures change from vendor to vendor. In this course, we are looking at Microsoft’s T-SQL<\/a> for SQL Server.<\/p>\n

If anyone if interested in functions and procedures in Oracle, refer to the following URLs.<\/p>\n

    \n
  1. https:\/\/docs.oracle.com\/cd\/B25329_01\/doc\/appdev.102\/b25108\/xedev_programs.htm<\/a><\/li>\n
  2. http:\/\/www.techonthenet.com\/oracle\/procedures.php<\/a><\/li>\n
  3. http:\/\/www.techonthenet.com\/oracle\/functions.php<\/a><\/li>\n<\/ol>\n

    For MySQL and MariaDB, refer to the following URLs.<\/p>\n

      \n
    1. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/create-procedure.html<\/a><\/li>\n
    2. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/create-function.html<\/a><\/li>\n
    3. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/create-function-udf.html<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      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 […]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[6,3,1,17,2],"tags":[],"class_list":["post-172","post","type-post","status-publish","format-standard","hentry","category-ws16sql1006","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=172"}],"version-history":[{"count":5,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/172\/revisions"}],"predecessor-version":[{"id":957,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/172\/revisions\/957"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}