{"id":1308,"date":"2016-11-19T22:31:53","date_gmt":"2016-11-20T03:31:53","guid":{"rendered":"http:\/\/my.dev.vanderbilt.edu\/cs265\/?page_id=1308"},"modified":"2017-01-03T08:58:15","modified_gmt":"2017-01-03T13:58:15","slug":"intermediate-sql-tasks-1","status":"publish","type":"page","link":"https:\/\/my.dev.vanderbilt.edu\/cs265\/intermediate-sql-tasks-1\/","title":{"rendered":"Intermediate SQL Tasks 1"},"content":{"rendered":"<ul>\n<li><span style=\"color: #000000\">Watch\u00a0videos (65 min) and answer questions of\u00a0remaining WSPDBC\u00a0DB5 SQL modules (<a href=\"https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/\">https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/<\/a>)<\/span>\n<ul>\n<li><em>The Join Family of Operators (25:00)<\/em><\/li>\n<\/ul>\n<ul>\n<li><span style=\"color: #000000\"><em>Aggregation (25:18)<\/em><\/span><\/li>\n<li><em>Data Modification Statements (14:34)<\/em><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000\">Optionally,\u00a0read Sections 5.2, 6.4-6.5 of U\/W<\/span><\/li>\n<li>Complete all the SQL Exercises from DB5 SQL<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Watch\u00a0videos (65 min) and answer questions of\u00a0remaining WSPDBC\u00a0DB5 SQL modules (https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/) The Join Family of Operators (25:00) Aggregation (25:18) Data Modification Statements (14:34) Optionally,\u00a0read Sections 5.2, 6.4-6.5 of U\/W Complete all the SQL Exercises from DB5 SQL &nbsp;<\/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-1308","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1308","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=1308"}],"version-history":[{"count":3,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1308\/revisions"}],"predecessor-version":[{"id":1493,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1308\/revisions\/1493"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/media?parent=1308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}