{"id":1415,"date":"2025-12-16T09:25:50","date_gmt":"2025-12-16T14:25:50","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1415"},"modified":"2025-12-16T09:25:50","modified_gmt":"2025-12-16T14:25:50","slug":"introduction-to-structured-query-language-for-data-analytics-sf25sql6172025-day-8","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1415","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (SF25SQL6172025) \u2014 Day 8"},"content":{"rendered":"<p>After running into errors with the original database server for this class last Wednesday and building a new server on a virtual machine running a 90-day Windows 11 Enterprise 25H2 image provided by Microsoft with SQL Server Express 2025 and SSMS 22. It was a slow installation (~3 hours), but we were back last night.<\/p>\n<p>We covered how to <tt>CREATE<\/tt>, <tt>DROP<\/tt> and <tt>ALTER<\/tt> data objects.<\/p>\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_20251215.pdf\">day 8<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After running into errors with the original database server for this class last Wednesday and building a new server on a virtual machine running a 90-day Windows 11 Enterprise 25H2 image provided by Microsoft with SQL Server Express 2025 and SSMS 22. It was a slow installation (~3 hours), but we were back last night. [&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":[35,3,1,2],"tags":[],"class_list":["post-1415","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\/1415","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=1415"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions"}],"predecessor-version":[{"id":1419,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1415\/revisions\/1419"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}