{"id":47,"date":"2016-02-26T11:21:56","date_gmt":"2016-02-26T16:21:56","guid":{"rendered":"http:\/\/folvera.commons.gc.cuny.edu\/?p=47"},"modified":"2021-09-16T14:58:37","modified_gmt":"2021-09-16T18:58:37","slug":"intro-to-sql-days-5-6-pop-quiz","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=47","title":{"rendered":"Intro to SQL (WS16SQL1001) \u2013 Days 5 &amp; 6 (Pop Quiz)"},"content":{"rendered":"<p>This is a review of the first pop quiz #1 or <em>&#8220;practice&#8221;<\/em> as you would prefer calling it. So far we have covered how to make queries, <tt>TABLE<\/tt>s, <tt>UNION<\/tt>s, <tt>VIEW<\/tt>s, <tt>UPDATE<\/tt>s and how to\u00a0<tt>ALTER<\/tt>\u00a0data objects as well as its types.<\/p>\n<p>Download <a title=\"answers for pop quiz #1, part 1\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/02\/IntroToSQL_20160223.pdf\" rel=\"\">part one<\/a> and <a title=\"answers for pop quiz #1, part 2\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2016\/02\/IntroToSQL_20160225.pdf\" rel=\"\">two<\/a>\u00a0of the answers.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a review of the first pop quiz #1 or &#8220;practice&#8221; as you would prefer calling it. So far we have covered how to make queries, TABLEs, UNIONs, VIEWs, UPDATEs and how to\u00a0ALTER\u00a0data objects as well as its types. Download part one and two\u00a0of the answers.<\/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":[4,3,1,17,2],"tags":[],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-ws16sql1001","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\/47","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=47"}],"version-history":[{"count":4,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":270,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions\/270"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}