{"id":1298,"date":"2016-11-19T22:17:51","date_gmt":"2016-11-20T03:17:51","guid":{"rendered":"http:\/\/my.dev.vanderbilt.edu\/cs265\/?page_id=1298"},"modified":"2018-01-16T08:40:34","modified_gmt":"2018-01-16T13:40:34","slug":"introductory-sql-exercises-1","status":"publish","type":"page","link":"https:\/\/my.dev.vanderbilt.edu\/cs265\/introductory-sql-exercises-1\/","title":{"rendered":"Introductory SQL Exercises 1"},"content":{"rendered":"<ul>\n<li><span style=\"color: #000000\">Do DB5 Extra QUERY exercises (<a href=\"https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_movie_query_extra\/\">https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_movie_query_extra\/<\/a>\u00a0(<a href=\"https:\/\/www.sqlite.org\/syntax\/select-stmt.html\">https:\/\/www.sqlite.org\/syntax\/select-stmt.html<\/a>) and\u00a0<a href=\"https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_social_query_extra\/\">https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_social_query_extra\/<\/a>)<\/span><\/li>\n<li><span style=\"color: #000000\">In-class SQL and RA exercises using various DB designs\u00a0(<a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2012\/11\/Dept-of-Motor-Vehicles-DB-InClass-Query-Exercise.pdf\">Dept of Motor Vehicles DB InClass Query Exercise<\/a><a href=\"https:\/\/cdn-dev.vanderbilt.edu\/t2-my-dev\/wp-content\/uploads\/sites\/761\/2012\/11\/Dept-of-Motor-Vehicles-DB-Key.pdf\">)<\/a><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do DB5 Extra QUERY exercises (https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_movie_query_extra\/\u00a0(https:\/\/www.sqlite.org\/syntax\/select-stmt.html) and\u00a0https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_social_query_extra\/) In-class SQL and RA exercises using various DB designs\u00a0(Dept of Motor Vehicles DB InClass Query Exercise) &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-1298","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1298","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=1298"}],"version-history":[{"count":10,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1298\/revisions"}],"predecessor-version":[{"id":2042,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1298\/revisions\/2042"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/media?parent=1298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}