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

So far we have covered how to<\/p>\n

    \n
  1. query databases as well as present data using built-in functions,<\/li>\n
  2. create tables and views with the proper data types,<\/li>\n
  3. modify tables adding, dropping or altering columns and data types<\/li>\n
  4. and also destroy these database objects.<\/li>\n<\/ol>\n

    Download the class notes<\/a> for day 4.<\/p>\n","protected":false},"excerpt":{"rendered":"

    So far we have covered how to query databases as well as present data using built-in functions, create tables and views with the proper data types, modify tables adding, dropping or altering columns and data types and also destroy these database objects. Download the class notes for day 4.<\/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-162","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\/162","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=162"}],"version-history":[{"count":3,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/162\/revisions"}],"predecessor-version":[{"id":247,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/162\/revisions\/247"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}