{"id":2526,"date":"2015-12-22T10:00:14","date_gmt":"2015-12-22T15:00:14","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis5202online2016\/?page_id=2526"},"modified":"2020-07-29T11:17:45","modified_gmt":"2020-07-29T15:17:45","slug":"week-8-database-administration","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/week-8-database-administration\/","title":{"rendered":"Week 9: Databases &#8211; Database Administration"},"content":{"rendered":"<p>Databases- Database Server Auditing<br \/>\n\u2022 Presentation: Module 8 \u2013 Intro to MySQL Server:<\/p>\n<p><a href=\"http:\/\/community.mis.temple.edu\/mis5122sec002fall17\/files\/2017\/08\/Murach-MySQL-Chapter-1-slides.pptx\">Murach MySQL Chapter 1 slides<\/a><\/p>\n<p><a href=\"http:\/\/community.mis.temple.edu\/mis5122sec002fall17\/files\/2017\/08\/Murach-MySQL-Chapter-2-slides.pptx\">Murach MySQL Chapter 2 slides<\/a><\/p>\n<p><a href=\"http:\/\/community.mis.temple.edu\/mis5122sec002fall17\/files\/2017\/08\/Murach-MySQL-Chapter-17-slides.pptx\">Murach MySQL Chapter 17 slides<\/a><\/p>\n<p><a href=\"http:\/\/community.mis.temple.edu\/mis5122sec002fall17\/files\/2017\/08\/Murach-MySQL-Chapter-18-slides.pptx\">Murach MySQL Chapter 18 slides<\/a><\/p>\n<p>\u2022 Activity:\u00a0<a href=\"http:\/\/community.mis.temple.edu\/mis5122sec002fall17\/files\/2015\/12\/Tech-Challenge-6-MySQL-Server-Installation.docx\">Tech Challenge 6 &#8211; MySQL Server Installation<\/a><\/p>\n<p>Starter Code:<\/p>\n<p>AP SQL Script(Run this code in MySQL to create database):\u00a0\u00a0<a href=\"http:\/\/community.mis.temple.edu\/mis5122sec002fall17\/files\/2015\/12\/create_db_ap.zip\">create_db_ap.zip<\/a><\/p>\n<p>Readings<\/p>\n<p>Murach\u2019s MySQL Chapters 1, 2, 17, 18<\/p>\n<p><a href=\"http:\/\/community.mis.temple.edu\/mis5122sec002fall17\/files\/2015\/12\/IT-Audit-Checklist_Databases.pdf\">IT-Audit-Checklist_Databases<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Databases- Database Server Auditing \u2022 Presentation: Module 8 \u2013 Intro to MySQL Server: Murach MySQL Chapter 1 slides Murach MySQL Chapter 2 slides Murach MySQL Chapter 17 slides Murach MySQL Chapter 18 slides \u2022 Activity:\u00a0Tech Challenge 6 &#8211; MySQL Server Installation Starter Code: AP SQL Script(Run this code in MySQL to create database):\u00a0\u00a0create_db_ap.zip Readings Murach\u2019s [&hellip;]<\/p>\n","protected":false},"author":12705,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"class_list":{"0":"post-2526","1":"page","2":"type-page","3":"status-publish","5":"entry"},"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/wp-json\/wp\/v2\/pages\/2526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/wp-json\/wp\/v2\/users\/12705"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/wp-json\/wp\/v2\/comments?post=2526"}],"version-history":[{"count":2,"href":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/wp-json\/wp\/v2\/pages\/2526\/revisions"}],"predecessor-version":[{"id":3712,"href":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/wp-json\/wp\/v2\/pages\/2526\/revisions\/3712"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis5122sec701fall2020\/wp-json\/wp\/v2\/media?parent=2526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}