{"id":577,"date":"2017-09-26T11:54:28","date_gmt":"2017-09-26T15:54:28","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=577"},"modified":"2021-09-16T14:58:01","modified_gmt":"2021-09-16T18:58:01","slug":"database-administration-fundamentals-sf17sql1001-day-8","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=577","title":{"rendered":"Database Administration Fundamentals (SF17SQL1001) &#8211; Day 8"},"content":{"rendered":"<p>We are almost done with the course. This means that we have one more day to learn new material and review all the material. Then we take care of our <em>final<\/em> (just another lab, but a tad longer).<\/p>\n<p>In the meantime, we have covered how to <tt>CREATE<\/tt> and <tt>ALTER<\/tt> database objects &#8212; <tt>DATABASE<\/tt>s, <tt>SCHEMA<\/tt>s, <tt>TABLE<\/tt>s, <tt>VIEW<\/tt>s and <tt>COLUMN<\/tt>s.<\/p>\n<pre>CREATE <em>object_type object_name<\/em>\r\n  <em>[code_to_create_object]<\/em>\r\n\r\nDROP <em>object_type object_name<\/em>\r\n  <em>[code_to_drop_object]<\/em>\r\n\r\nALTER <em>object_type object_name<\/em>\r\n  ADD\/DROP\/ALTER <em>object_type<\/em>\r\n  <em>[code_to_alter_object]\r\n<\/em><\/pre>\n<p>Download the\u00a0<a title=\"Class Notes for SF17SQL1001 - Day 8 (2017\/09\/25)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2017\/09\/SF17SQL1001.20170925.pdf\">class notes<\/a>\u00a0for day 8.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are almost done with the course. This means that we have one more day to learn new material and review all the material. Then we take care of our final (just another lab, but a tad longer). In the meantime, we have covered how to CREATE and ALTER database objects &#8212; DATABASEs, SCHEMAs, TABLEs, [&hellip;]<\/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":[20,3,1,17,2],"tags":[],"class_list":["post-577","post","type-post","status-publish","format-standard","hentry","category-sf17sql1001","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\/577","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=577"}],"version-history":[{"count":2,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/577\/revisions"}],"predecessor-version":[{"id":582,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/577\/revisions\/582"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}