{"id":38,"date":"2016-08-16T10:05:30","date_gmt":"2016-08-16T14:05:30","guid":{"rendered":"https:\/\/sites.wcsu.edu\/murthys\/?page_id=38"},"modified":"2019-12-06T18:31:10","modified_gmt":"2019-12-06T23:31:10","slug":"cs205","status":"publish","type":"page","link":"https:\/\/sites.wcsu.edu\/murthys\/teaching\/cs205\/","title":{"rendered":"CS205: Data Modeling and Database Design"},"content":{"rendered":"<p><!--Courses--><\/p>\n<p><strong>Courseware<\/strong><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/connectwcsu-my.sharepoint.com\/:f:\/g\/personal\/murthys_wcsu_edu\/Eikg1lWvLKBNi5j3BgKw_e4Be8hFOUtvZAvAEk4gpIBYzA?e=RQxg17\" target=\"_blank\" rel=\"noopener noreferrer\">OneDrive<\/a> (requires university login)<\/p>\n<p><strong>Textbook (required)<\/strong><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.pearsonhighered.com\/program\/Hoffer-Modern-Database-Management-12th-Edition\/PGM163644.html\" target=\"_blank\" rel=\"noopener noreferrer\">Modern Database Management (12th Edition)<\/a>; Hoffer, Venkataraman, Topi; Pearson Education;\u00a0ISBN 9780133544619<\/p>\n<p style=\"padding-left: 30px\">I will consult\u00a0the 12th edition, but\u00a0students\u00a0may consult the 9th edition or later.<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/media.pearsoncmg.com\/ph\/bp\/bp_hoffer_mdm_12\/index.html\" target=\"_blank\" rel=\"noopener noreferrer\">Textbook Videos<\/a><\/p>\n<p style=\"padding-left: 30px\">Students\u00a0are not required to watch the videos, but I have included\u00a0this link to provide\u00a0an alternative perspective of the subject.<\/p>\n<p><strong>Reference<\/strong><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.pearson.com\/us\/higher-education\/program\/Garcia-Molina-Database-Systems-The-Complete-Book-2nd-Edition\/PGM2429.html\" target=\"_blank\" rel=\"noopener noreferrer\">Database Systems: The Complete Book (2nd Edition)<\/a>; Garcia-Molina, Ullman, Widom; Pearson Education;\u00a0ISBN 9780133002010<\/p>\n<p><strong>Try SQL Online<\/strong><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/tunweb.teradata.ws\/trial\/\" target=\"_blank\" rel=\"noopener noreferrer\">Teradata University Network\u00a0SQL Assistant<\/a> (may require <a href=\"http:\/\/www.teradatauniversitynetwork.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">registration<\/a>)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/www.w3schools.com\/sql\/trysql.asp?filename=trysql_select_all\" target=\"_blank\" rel=\"noopener noreferrer\">W3Schools SQL<\/a><\/p>\n<p><strong>SQL<\/strong><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/en.wikibooks.org\/wiki\/Structured_Query_Language\" target=\"_blank\" rel=\"noopener noreferrer\">SQL:2011 (ISO\/IEC 9075:2011)<\/a><\/p>\n<p style=\"padding-left: 30px\">SQL:1999 &#8211; Understanding Relational Language Components;\u00a0Melton, Simon; Morgan Kaufman; \u00a0ISBN\u00a09781558604568<\/p>\n<p><strong>PostgreSQL<\/strong><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.postgresql.org\/docs\/9.6\/static\/sql.html\" target=\"_blank\" rel=\"noopener noreferrer\">SQL\u00a0Reference<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.postgresql.org\/docs\/9.6\/static\/plpgsql.html\" target=\"_blank\" rel=\"noopener noreferrer\">PL\/pgSQL Reference<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.postgresql.org\/docs\/9.6\/static\/app-psql.html\" target=\"_blank\" rel=\"noopener noreferrer\">psql Reference<\/a> (command-line client)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.pgadmin.org\/docs\/pgadmin3\/1.22\/\" target=\"_blank\" rel=\"noopener noreferrer\">pgAdmin 3 Reference<\/a> (GUI client)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.postgresql.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">PostgreSQL<\/a> (free\u00a0for any kind of \u00a0use)<\/p>\n<p><strong>Oracle Database<\/strong><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/docs.oracle.com\/database\/121\/SQLRF\/toc.htm\" target=\"_blank\" rel=\"noopener noreferrer\">SQL\u00a0Reference<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/www.oracle.com\/technetwork\/database\/application-development\/index-101230.html\" target=\"_blank\" rel=\"noopener noreferrer\">PL\/SQL Reference<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/docs.oracle.com\/database\/121\/SQPUG\/toc.htm\" target=\"_blank\" rel=\"noopener noreferrer\">SQL*Plus Reference<\/a>\u00a0(command-line client)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\/overview\/index.html\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle SQL Developer<\/a> (GUI client)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/www.oracle.com\/technetwork\/database\/database-technologies\/express-edition\/overview\/index.html\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Database 11<em>g<\/em> Express Edition<\/a> (free to develop, deploy, and distribute)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/www.oracle.com\/technetwork\/topics\/dotnet\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle .NET Developer Center<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/system.data.oracleclient(v=vs.110).aspx\" target=\"_blank\" rel=\"noopener noreferrer\">System.Data.OracleClient\u00a0Namespace<\/a> (.NET)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/asktom.oracle.com\" target=\"_blank\" rel=\"noopener noreferrer\">Ask Tom<\/a><\/p>\n<p><strong>Microsoft SQL Server<\/strong><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb510741.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">Transact-SQL Reference<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/msdn.microsoft.com\/library\/mt238290.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Management Studio<\/a> (integrated development environment; GUI)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.microsoft.com\/en-us\/cloud-platform\/sql-server-editions-express\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Express<\/a> (free to develop, deploy, and distribute)<\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=11774\" target=\"_blank\" rel=\"noopener noreferrer\">JDBC Drivers<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/system.data.sqlclient(v=vs.110).aspx\" target=\"_blank\" rel=\"noopener noreferrer\">System.Data.SqlClient Namespace<\/a> (.NET)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Courseware OneDrive (requires university login) Textbook (required) Modern Database Management (12th Edition); Hoffer, Venkataraman, Topi; Pearson Education;\u00a0ISBN 9780133544619 I will [&hellip;]<\/p>\n","protected":false},"author":33,"featured_media":0,"parent":17,"menu_order":15,"comment_status":"closed","ping_status":"closed","template":"","meta":{"wpo365_audiences":[],"wpo365_private":false,"footnotes":""},"class_list":["post-38","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/sites.wcsu.edu\/murthys\/wp-json\/wp\/v2\/pages\/38","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.wcsu.edu\/murthys\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.wcsu.edu\/murthys\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.wcsu.edu\/murthys\/wp-json\/wp\/v2\/users\/33"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.wcsu.edu\/murthys\/wp-json\/wp\/v2\/comments?post=38"}],"version-history":[{"count":0,"href":"https:\/\/sites.wcsu.edu\/murthys\/wp-json\/wp\/v2\/pages\/38\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/sites.wcsu.edu\/murthys\/wp-json\/wp\/v2\/pages\/17"}],"wp:attachment":[{"href":"https:\/\/sites.wcsu.edu\/murthys\/wp-json\/wp\/v2\/media?parent=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}