{"id":893,"date":"2019-10-28T09:45:40","date_gmt":"2019-10-28T13:45:40","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=893"},"modified":"2021-09-16T14:57:22","modified_gmt":"2021-09-16T18:57:22","slug":"database-administration-fundamentals-sf19sql1002-day-5","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=893","title":{"rendered":"Database Administration Fundamentals (SF19SQL1002) \u2013 Day 5"},"content":{"rendered":"

We have finished the course and had a final covering all material we have covered.<\/p>\n

For fun run the following.<\/p>\n

    DECLARE<\/span> @yourName VARCHAR<\/span>(50) = 'your_name_here'<\/span>,\r\n            @CourseCd VARCHAR<\/span>(15) = 'SF19SQL1002'<\/span>;\r\n    PRINT<\/span> CONCAT<\/span>(CHAR<\/span>(084), CHAR<\/span>(104), CHAR<\/span>(097),\r\n      CHAR<\/span>(110), CHAR<\/span>(107), CHAR<\/span>(032), CHAR<\/span>(121),\r\n      CHAR<\/span>(111), CHAR<\/span>(117), CHAR<\/span>(044), CHAR<\/span>(032),\r\n      @yourName, CHAR<\/span>(044), CHAR<\/span>(032), CHAR<\/span>(102),\r\n      CHAR<\/span>(111), CHAR<\/span>(114), CHAR<\/span>(032), CHAR<\/span>(116),\r\n      CHAR<\/span>(097), CHAR<\/span>(107), CHAR<\/span>(105), CHAR<\/span>(110),\r\n      CHAR<\/span>(103), CHAR<\/span>(032), CHAR<\/span>(099), CHAR<\/span>(108),\r\n      CHAR<\/span>(097), CHAR<\/span>(115), CHAR<\/span>(115), CHAR<\/span>(032),\r\n      @CourseCd, CHAR<\/span>(046), CHAR<\/span>(013), CHAR<\/span>(083),\r\n      CHAR<\/span>(101), CHAR<\/span>(101), CHAR<\/span>(032), CHAR<\/span>(121),\r\n      CHAR<\/span>(111), CHAR<\/span>(117), CHAR<\/span>(032), CHAR<\/span>(105),\r\n      CHAR<\/span>(110), CHAR<\/span>(032), CHAR<\/span>(116), CHAR<\/span>(104),\r\n      CHAR<\/span>(101), CHAR<\/span>(032), CHAR<\/span>(105), CHAR<\/span>(110),\r\n      CHAR<\/span>(116), CHAR<\/span>(101), CHAR<\/span>(114), CHAR<\/span>(109),\r\n      CHAR<\/span>(101), CHAR<\/span>(100), CHAR<\/span>(105), CHAR<\/span>(097),\r\n      CHAR<\/span>(116), CHAR<\/span>(101), CHAR<\/span>(032), CHAR<\/span>(099),\r\n      CHAR<\/span>(108), CHAR<\/span>(097), CHAR<\/span>(115), CHAR<\/span>(115),\r\n      CHAR<\/span>(046), CHAR<\/span>(013), CHAR<\/span>(013), CHAR<\/span>(070),\r\n      CHAR<\/span>(046), CHAR<\/span>(079), CHAR<\/span>(108), CHAR<\/span>(118),\r\n      CHAR<\/span>(101), CHAR<\/span>(114), CHAR<\/span>(097), CHAR<\/span>(032),\r\n      CHAR<\/span>(040), CHAR<\/span>(102), CHAR<\/span>(111), CHAR<\/span>(108),\r\n      CHAR<\/span>(118), CHAR<\/span>(101), CHAR<\/span>(114), CHAR<\/span>(097),\r\n      CHAR<\/span>(064), CHAR<\/span>(098), CHAR<\/span>(109), CHAR<\/span>(099),\r\n      CHAR<\/span>(099), CHAR<\/span>(046), CHAR<\/span>(099), CHAR<\/span>(117),\r\n      CHAR<\/span>(110), CHAR<\/span>(121), CHAR<\/span>(046), CHAR<\/span>(101),\r\n      CHAR<\/span>(100), CHAR<\/span>(117), CHAR<\/span>(041), CHAR<\/span>(013),\r\n      CHAR<\/span>(104), CHAR<\/span>(116), CHAR<\/span>(116), CHAR<\/span>(112),\r\n      CHAR<\/span>(058), CHAR<\/span>(047), CHAR<\/span>(047), CHAR<\/span>(102),\r\n      CHAR<\/span>(111), CHAR<\/span>(108), CHAR<\/span>(118), CHAR<\/span>(101),\r\n      CHAR<\/span>(114), CHAR<\/span>(097), CHAR<\/span>(046), CHAR<\/span>(099),\r\n      CHAR<\/span>(111), CHAR<\/span>(109), CHAR<\/span>(109), CHAR<\/span>(111),\r\n      CHAR<\/span>(110), CHAR<\/span>(115), CHAR<\/span>(046), CHAR<\/span>(103),\r\n      CHAR<\/span>(099), CHAR<\/span>(046), CHAR<\/span>(099), CHAR<\/span>(117),\r\n      CHAR<\/span>(110), CHAR<\/span>(121), CHAR<\/span>(046), CHAR<\/span>(101),\r\n      CHAR<\/span>(100), CHAR<\/span>(117), CHAR<\/span>(047));\r\n<\/pre>\n
Download the\u00a0class notes for\u00a0day 5<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
We have finished the course and had a final covering all material we have covered. For fun run the following. DECLARE @yourName VARCHAR(50) = ‘your_name_here’, @CourseCd VARCHAR(15) = ‘SF19SQL1002’; PRINT CONCAT(CHAR(084), CHAR(104), CHAR(097), CHAR(110), CHAR(107), CHAR(032), CHAR(121), CHAR(111), CHAR(117), CHAR(044), CHAR(032), @yourName, CHAR(044), CHAR(032), CHAR(102), CHAR(111), CHAR(114), CHAR(032), CHAR(116), CHAR(097), CHAR(107), CHAR(105), CHAR(110), CHAR(103), CHAR(032), […]<\/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":[27,3,1,17,2],"tags":[],"class_list":["post-893","post","type-post","status-publish","format-standard","hentry","category-sf19sql1002","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\/893","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=893"}],"version-history":[{"count":5,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/893\/revisions"}],"predecessor-version":[{"id":899,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/893\/revisions\/899"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}