{"id":1401,"date":"2025-12-09T09:38:21","date_gmt":"2025-12-09T14:38:21","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1401"},"modified":"2025-12-09T09:39:14","modified_gmt":"2025-12-09T14:39:14","slug":"introduction-to-structured-query-language-for-data-analytics-sf25sql6172025-day-7","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1401","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) \u2014 Day 7"},"content":{"rendered":"<p>We have started creating and dropping data objects.<\/p>\n<pre><span style=\"color: #0000ff\">  CREATE<\/span> data_object object_name [code]\r\n\r\n  <span style=\"color: #0000ff\">DROP<\/span>   data_object object_name\r\n\r\n  <span style=\"color: #0000ff\">ALTER<\/span>  data_object object_name\r\n    <span style=\"color: #0000ff\">ADD<\/span>|<span style=\"color: #0000ff\">ALTER<\/span>|<span style=\"color: #0000ff\">DROP<\/span> data_object object_name<\/pre>\n<p>Download the class notes for <a href=\"https:\/\/s3.amazonaws.com\/files.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2025\/12\/SF25SQL6172025_20251208.pdf\">day 7<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have started creating and dropping data objects. CREATE data_object object_name [code] DROP data_object object_name ALTER data_object object_name ADD|ALTER|DROP data_object object_name Download the class notes for 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":[35,3,1,2],"tags":[],"class_list":["post-1401","post","type-post","status-publish","format-standard","hentry","category-sf25sql6172025","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1401","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=1401"}],"version-history":[{"count":3,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions"}],"predecessor-version":[{"id":1413,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1401\/revisions\/1413"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}