{"id":1130,"date":"2022-10-25T10:41:11","date_gmt":"2022-10-25T14:41:11","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1130"},"modified":"2022-10-25T10:55:20","modified_gmt":"2022-10-25T14:55:20","slug":"introduction-to-structured-query-language-for-data-analytics-sf22sql1001-day-7","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1130","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (SF22SQL1001) \u2014 Day 7"},"content":{"rendered":"<p>We are three (3) more sessions to go.<\/p>\n<p>We have started using variables (<tt>DECLARE <em>@parameter<\/em><\/tt>) in order to avoid re-writing code every time the values in the <tt>WHERE<\/tt> clause change. Parameters will also help us create our own functions.<\/p>\n<p>Download the\u00a0<a href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2022\/10\/SF22SQL1001_20221024.pdf\">class notes<\/a> for day 7 &#8212; 29 pages&#8217; worth of material.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are three (3) more sessions to go. We have started using variables (DECLARE @parameter) in order to avoid re-writing code every time the values in the WHERE clause change. Parameters will also help us create our own functions. Download the\u00a0class notes for day 7 &#8212; 29 pages&#8217; worth of material.<\/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":[31,3,1,2],"tags":[],"class_list":["post-1130","post","type-post","status-publish","format-standard","hentry","category-sf22sql1001","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1130","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=1130"}],"version-history":[{"count":4,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1130\/revisions"}],"predecessor-version":[{"id":1135,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1130\/revisions\/1135"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}