{"id":1291,"date":"2024-04-04T10:44:23","date_gmt":"2024-04-04T14:44:23","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1291"},"modified":"2024-04-04T10:44:23","modified_gmt":"2024-04-04T14:44:23","slug":"introduction-to-structured-query-language-for-data-analytics-ws24sql10001-day-8","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1291","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (WS24SQL10001) \u2014 Day 8"},"content":{"rendered":"<p>We are getting for the final next week. We have covered how to retrieve (<tt>SELECT<\/tt>) data from tables or views as well as making (<tt>CREATE<\/tt>), modifying (<tt>ALTER<\/tt>) and destroying (<tt>DROP<\/tt>) data objects.<\/p>\n<p>Download the <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2024\/04\/WS24SQL10001_20240403.pdf\">class notes<\/a> for day 8.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are getting for the final next week. We have covered how to retrieve (SELECT) data from tables or views as well as making (CREATE), modifying (ALTER) and destroying (DROP) data objects. Download the class notes for day 8.<\/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":[34,3,1,2],"tags":[],"class_list":["post-1291","post","type-post","status-publish","format-standard","hentry","category-ws24sql10001","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1291","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=1291"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1291\/revisions"}],"predecessor-version":[{"id":1293,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1291\/revisions\/1293"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}