{"id":1293,"date":"2016-11-19T22:14:05","date_gmt":"2016-11-20T03:14:05","guid":{"rendered":"http:\/\/my.dev.vanderbilt.edu\/cs265\/?page_id=1293"},"modified":"2017-01-03T13:30:00","modified_gmt":"2017-01-03T18:30:00","slug":"introduction-to-sql","status":"publish","type":"page","link":"https:\/\/my.dev.vanderbilt.edu\/cs265\/introduction-to-sql\/","title":{"rendered":"Introduction to SQL"},"content":{"rendered":"<ul>\n<li><span style=\"color: #000000\">Download and install <a href=\"https:\/\/sqlite.org\/\">SQLite<\/a><\/span><\/li>\n<li><span style=\"color: #000000\">Watch\u00a0videos (about 60 min) and answer questions of initial 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><span style=\"color: #000000\"><em>Introduction to SQL (4:31)<\/em>, <\/span><\/li>\n<li><span style=\"color: #000000\"><em>Basic SELECT statement (9:57)<\/em><\/span><\/li>\n<li><span style=\"color: #000000\"><em>Table Variables and Set Operators (10:33)<\/em> <\/span><\/li>\n<li><span style=\"color: #000000\"><em>Subqueries in WHERE clause (20:14)<\/em> <\/span><\/li>\n<li><span style=\"color: #000000\"><em>Subqueries in FROM and SELECT (8:02)<\/em><\/span><\/li>\n<\/ul>\n<ul>\n<li><em>NULL values (6:25) <strong>Not in order<\/strong><\/em><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000\">Optionally, read Sections 5.1, 6.1 &#8211; 6.3 of U\/W.<\/span><\/li>\n<li><span style=\"color: #000000\">Complete\u00a0<\/span>\n<ul>\n<li>SQL Movie-Rating Query Exercises Q1 &#8211; Q6 at\u00a0<a href=\"https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_movie_query_core\/\">https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_movie_query_core\/<\/a>\u00a0,<\/li>\n<li>SQL Movie-Rating Extras Exercises Q1-Q6 at <a href=\"https:\/\/lagunita.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_movie_query_extra\/\">https:\/\/lagunita.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_movie_query_extra\/<\/a>\u00a0,<\/li>\n<li>SQL Social-Network Query Exercises Q1 &#8211; Q7 at\u00a0<a href=\"https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_social_query_core\/\">https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_social_query_core\/<\/a>), and<\/li>\n<li>SQL Social Networking exercises Q1-Q2 at <a href=\"https:\/\/lagunita.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_social_query_extra\/\">https:\/\/lagunita.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/seq-exercise-sql_social_query_extra\/<\/a>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Download and install SQLite Watch\u00a0videos (about 60 min) and answer questions of initial WSPDBC\u00a0DB5 SQL modules (https:\/\/class.stanford.edu\/courses\/DB\/SQL\/SelfPaced\/courseware\/ch-sql\/) Introduction to SQL (4:31), Basic SELECT statement (9:57) Table Variables and Set Operators (10:33) Subqueries in WHERE clause (20:14) Subqueries in FROM and &hellip; <a href=\"https:\/\/my.dev.vanderbilt.edu\/cs265\/introduction-to-sql\/\">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-1293","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1293","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=1293"}],"version-history":[{"count":6,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1293\/revisions"}],"predecessor-version":[{"id":1507,"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/pages\/1293\/revisions\/1507"}],"wp:attachment":[{"href":"https:\/\/my.dev.vanderbilt.edu\/cs265\/wp-json\/wp\/v2\/media?parent=1293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}