{"id":629,"date":"2018-03-06T12:59:20","date_gmt":"2018-03-06T17:59:20","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=629"},"modified":"2021-09-16T14:57:56","modified_gmt":"2021-09-16T18:57:56","slug":"database-administration-fundamentals-ws18sql1001-day-7","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=629","title":{"rendered":"Database Administration Fundamentals (WS18SQL1001) \u2013 Day 7"},"content":{"rendered":"<p>We have only three (3) more days. We have covered how to <tt>CREATE<\/tt>, <tt>DROP<\/tt> and <tt>ALTER<\/tt> data objects (databases, schemas, tables and views) with the correct data types.<\/p>\n<p>Download the\u00a0<a title=\"Class Notes for SF17SQL1001 - Day 7 (2018\/03\/05)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2018\/03\/WS18SQL1001_20180305.pdf\">notes<\/a>\u00a0for day 7.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have only three (3) more days. We have covered how to CREATE, DROP and ALTER data objects (databases, schemas, tables and views) with the correct data types. Download the\u00a0notes\u00a0for day 7.<\/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":[21,3,1,17,2],"tags":[],"class_list":["post-629","post","type-post","status-publish","format-standard","hentry","category-ws18sql1001","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\/629","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=629"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/629\/revisions"}],"predecessor-version":[{"id":631,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/629\/revisions\/631"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}