{"id":377,"date":"2016-05-18T11:20:36","date_gmt":"2016-05-18T16:20:36","guid":{"rendered":"https:\/\/researchbdev.wpengine.com\/digital-computational-studies\/?p=377"},"modified":"2017-04-20T09:21:15","modified_gmt":"2017-04-20T14:21:15","slug":"w3schools-sql-tutorial","status":"publish","type":"post","link":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/student-research\/sql\/w3schools-sql-tutorial\/","title":{"rendered":"W3Schools SQL Tutorial"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">W3Schools is a free site that provides tutorials and documentation for a variety of different languages and elements of web development. \u00a0<\/span><\/p>\n<p><a href=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.51.00-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-381 aligncenter\" src=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.51.00-PM.png\" alt=\"Screen Shot 2016-03-10 at 9.51.00 PM\" width=\"1094\" height=\"402\" srcset=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.51.00-PM.png 1094w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.51.00-PM-300x110.png 300w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.51.00-PM-1024x376.png 1024w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.51.00-PM-250x92.png 250w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.51.00-PM-624x229.png 624w\" sizes=\"auto, (max-width: 1094px) 100vw, 1094px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.w3schools.com\/sql\/\">Here<\/a>, W3Schools offers a step-by step guide to SQL, its uses, and its syntax. \u00a0It begins with a high-level overview of databases,\u00a0their importance, and key definitions. \u00a0this introduction makes\u00a0for a smooth transition into the majority of the content of the tutorial: short chapters that include brief lessons for an extensive range of\u00a0SQL statements, beginning at a very comfortable, basic level. \u00a0The tutorial is supplemented with a SQL quiz to test users&#8217; understanding of the material explored.<\/p>\n<p><strong>Pros:<\/strong><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\"><em>More than just MySQL: <\/em>\u00a0This tutorial teaches general SQL syntax and can be used beyond MySQL, which is just one\u00a0of many relational databases.<\/span><\/li>\n<li><em>Try it yourself:<\/em> \u00a0W3Schools provides users with an integrated, online environment in which to run tests of SQL code. \u00a0This tool is great for trying out SQL syntax without having to create a database yourself.\n<p><figure id=\"attachment_378\" aria-describedby=\"caption-attachment-378\" style=\"width: 1091px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.45.30-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-378 size-full\" src=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.45.30-PM.png\" alt=\"\" width=\"1091\" height=\"523\" srcset=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.45.30-PM.png 1091w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.45.30-PM-300x144.png 300w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.45.30-PM-1024x491.png 1024w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.45.30-PM-250x120.png 250w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-10-at-9.45.30-PM-624x299.png 624w\" sizes=\"auto, (max-width: 1091px) 100vw, 1091px\" \/><\/a><figcaption id=\"caption-attachment-378\" class=\"wp-caption-text\">W3Schools&#8217; &#8220;try it yourself&#8221; functionality<\/figcaption><\/figure><\/li>\n<li><em>Specific syntax documentation:<\/em> \u00a0The thorough documentation of SQL syntax will be useful both for new database designers and database pros. \u00a0New users will appreciate the ability to move step-by-step through the syntax, while pros will be able to easily locate the specific information they need without completing the entire tutorial.<\/li>\n<\/ul>\n<p><strong>Cons:<\/strong><\/p>\n<ul>\n<li><em>Slowness:<\/em> \u00a0Users who are interested in learning SQL syntax from the start may find it tedious or ineffective\u00a0to click through each step in the tutorial.<\/li>\n<li><em>No download\/setup assistance:<\/em> \u00a0This tutorial will not be useful to users who are looking for guidance as to how to use SQL, MySQL, or Sequel Pro outside of the W3Schools website. \u00a0This leads to another potential drawback for users&#8230;<\/li>\n<li><em>No command line how-to:<\/em> \u00a0For Bowdoin Computer Scientists or other users who are experienced working in Linux\/Unix environments, W3Schools does not address the way in which SQL can be used from the command line, which may be limiting.<\/li>\n<\/ul>\n<p><strong>tl;dr?<\/strong> \u00a0W3Schools&#8217; tutorial begins at a very basic, comfortable level and will likely be most useful to students who are just beginning to experiment with databases (or really, coding in general). \u00a0For students looking for help actually creating a database or integrating databases into their already existing websites or other projects, this tutorial may fall short. \u00a0Its strengths lie in its simplicity and try-it-yourself functionality.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>W3Schools is a free site that provides tutorials and documentation for a variety of different languages and elements of web development. \u00a0 Here, W3Schools offers a step-by step guide to SQL, its uses, and its syntax. \u00a0It begins with a high-level overview of databases,\u00a0their importance, and key definitions. \u00a0this introduction makes\u00a0for a smooth transition into [&hellip;]<\/p>\n","protected":false},"author":106,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[17],"tags":[],"class_list":{"0":"post-377","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-sql","7":"entry"},"_links":{"self":[{"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/posts\/377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/users\/106"}],"replies":[{"embeddable":true,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/comments?post=377"}],"version-history":[{"count":0,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/posts\/377\/revisions"}],"wp:attachment":[{"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/media?parent=377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/categories?post=377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/tags?post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}