{"id":494,"date":"2014-12-28T02:07:59","date_gmt":"2014-12-28T07:07:59","guid":{"rendered":"https:\/\/my.dev.vanderbilt.edu\/cs265\/?page_id=494"},"modified":"2020-09-17T15:50:45","modified_gmt":"2020-09-17T20:50:45","slug":"database-topic-overview","status":"publish","type":"page","link":"https:\/\/my.dev.vanderbilt.edu\/cs265\/database-topic-overview\/","title":{"rendered":"Topics"},"content":{"rendered":"<p>This introductory course covers relational databases in detail, and touches on some &#8220;advanced&#8221; material like non-relational representations and data mining. Other optional material is listed at the bottom.<\/p>\n<h2>Relational Databases (required of all students)<\/h2>\n<ul>\n<li>Querying Relational Databases\n<ul>\n<li>Relational Algebra<\/li>\n<li>SQL (in some depth)<\/li>\n<\/ul>\n<\/li>\n<li>Contraints\n<ul>\n<li>Attribute and tuple constraints<\/li>\n<li>Referential Integrity<\/li>\n<li>General constraints (assertions)<\/li>\n<\/ul>\n<\/li>\n<li>Triggers<\/li>\n<li>Universal Modeling Language (for conceptual database design)<\/li>\n<li>Relational Design Theory\n<ul>\n<li>Functional Dependencies<\/li>\n<li>Normal Forms<\/li>\n<li>Design by Decomposition<\/li>\n<\/ul>\n<\/li>\n<li>Views<\/li>\n<li>Indexing<\/li>\n<li>Transactions<\/li>\n<li>Non-relational\n<ul>\n<li>JSON<\/li>\n<\/ul>\n<\/li>\n<li>Data mining (e.g., association rules)<\/li>\n<\/ul>\n<h2>Optional Material (see the bottom of <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/schedule\/\">Schedule<\/a>)<\/h2>\n<ul>\n<li><span style=\"font-size: 16px\">Multivalued Dependencies<br \/>\n<\/span><\/li>\n<li><span style=\"font-size: 16px\">Online Analytical Processing<\/span><\/li>\n<li><span style=\"font-size: 16px\">Recursion in SQL<\/span><\/li>\n<li>Authorization in SQL<\/li>\n<\/ul>\n<p>I encourage you to pursue these optional topics. We have no second course in database where you might formally study non-SQL database schemes and other advanced database topics such as data mining, so I have included some rudimentary additional material on these topics in this course.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This introductory course covers relational databases in detail, and touches on some &#8220;advanced&#8221; material like non-relational representations and data mining. Other optional material is listed at the bottom. Relational Databases (required of all students) Querying Relational Databases Relational Algebra SQL &hellip; <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/database-topic-overview\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":633,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-494","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/users\/633"}],"replies":[{"embeddable":true,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/comments?post=494"}],"version-history":[{"count":23,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/494\/revisions"}],"predecessor-version":[{"id":1994,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/494\/revisions\/1994"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/media?parent=494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}