{"id":192,"date":"2017-04-25T17:54:32","date_gmt":"2017-04-25T17:54:32","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/?post_type=chapter&#038;p=192"},"modified":"2017-04-25T17:54:32","modified_gmt":"2017-04-25T17:54:32","slug":"introduction-to-section-4","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/introduction-to-section-4\/","title":{"raw":"Introduction to Section 4","rendered":"Introduction to Section 4"},"content":{"raw":"<h1>Section Contents<\/h1>\r\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-37-database-types\/\"><span class=\"Hyperlink\">Database Types<\/span><\/a><\/p>\r\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-38-data-relationships\/\"><span class=\"Hyperlink\">Data Relationships<\/span><\/a><\/p>\r\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-39-mysql-data-types\/\"><span class=\"Hyperlink\">MySQL Data Types<\/span><\/a><\/p>\r\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-40-normalization\/\"><span class=\"Hyperlink\">Normalization<\/span><\/a><\/p>\r\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-41-mysql-crud-action\/\"><span class=\"Hyperlink\">MySQL CRUD Actions<\/span><\/a><\/p>\r\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-42-advanced-queries\/\"><span class=\"Hyperlink\">Advanced Queries<\/span><\/a><\/p>\r\n\r\n<div class=\"textbox learning-objectives\">\r\n<h3>Learning Objectives<\/h3>\r\nBy the end of this section, you should be able to demonstrate:\r\n<ul>\r\n \t<li class=\"bullet\">An understanding of basic database types<\/li>\r\n \t<li class=\"bullet\">How pieces of information can relate to each other<\/li>\r\n \t<li class=\"bullet\">The ability to normalize data into a structured query format<\/li>\r\n \t<li class=\"bullet\">The ability to create, populate, and interact with a MySQL database<\/li>\r\n \t<li class=\"bullet\">A basic understanding of the advanced capabilities of MySQL queries<\/li>\r\n<\/ul>\r\n<\/div>","rendered":"<h1>Section Contents<\/h1>\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-37-database-types\/\"><span class=\"Hyperlink\">Database Types<\/span><\/a><\/p>\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-38-data-relationships\/\"><span class=\"Hyperlink\">Data Relationships<\/span><\/a><\/p>\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-39-mysql-data-types\/\"><span class=\"Hyperlink\">MySQL Data Types<\/span><\/a><\/p>\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-40-normalization\/\"><span class=\"Hyperlink\">Normalization<\/span><\/a><\/p>\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-41-mysql-crud-action\/\"><span class=\"Hyperlink\">MySQL CRUD Actions<\/span><\/a><\/p>\n<p class=\"TOC\"><a href=\"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/chapter\/chapter-42-advanced-queries\/\"><span class=\"Hyperlink\">Advanced Queries<\/span><\/a><\/p>\n<div class=\"textbox learning-objectives\">\n<h3>Learning Objectives<\/h3>\n<p>By the end of this section, you should be able to demonstrate:<\/p>\n<ul>\n<li class=\"bullet\">An understanding of basic database types<\/li>\n<li class=\"bullet\">How pieces of information can relate to each other<\/li>\n<li class=\"bullet\">The ability to normalize data into a structured query format<\/li>\n<li class=\"bullet\">The ability to create, populate, and interact with a MySQL database<\/li>\n<li class=\"bullet\">A basic understanding of the advanced capabilities of MySQL queries<\/li>\n<\/ul>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-192\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Shared previously<\/div><ul class=\"citation-list\"><li>The Missing Link. <strong>Authored by<\/strong>: Michael Mendez. <strong>Provided by<\/strong>: Open SUNY Textbooks. <strong>Located at<\/strong>: <a target=\"_blank\" href=\"https:\/\/textbooks.opensuny.org\/the-missing-link-an-introduction-to-web-development-and-programming\/\">https:\/\/textbooks.opensuny.org\/the-missing-link-an-introduction-to-web-development-and-programming\/<\/a>. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/4.0\/\">CC BY-NC-SA: Attribution-NonCommercial-ShareAlike<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":622,"menu_order":1,"template":"","meta":{"_candela_citation":"[{\"type\":\"cc\",\"description\":\"The Missing Link\",\"author\":\"Michael Mendez\",\"organization\":\"Open SUNY Textbooks\",\"url\":\"https:\/\/textbooks.opensuny.org\/the-missing-link-an-introduction-to-web-development-and-programming\/\",\"project\":\"\",\"license\":\"cc-by-nc-sa\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-192","chapter","type-chapter","status-publish","hentry"],"part":140,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/pressbooks\/v2\/chapters\/192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/wp\/v2\/users\/622"}],"version-history":[{"count":1,"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/pressbooks\/v2\/chapters\/192\/revisions"}],"predecessor-version":[{"id":193,"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/pressbooks\/v2\/chapters\/192\/revisions\/193"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/pressbooks\/v2\/parts\/140"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/pressbooks\/v2\/chapters\/192\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/wp\/v2\/media?parent=192"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/pressbooks\/v2\/chapter-type?post=192"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/wp\/v2\/contributor?post=192"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-the-missing-link-an-introduction-to-web-development-and-programming\/wp-json\/wp\/v2\/license?post=192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}