{"id":403,"date":"2016-05-18T11:20:22","date_gmt":"2016-05-18T16:20:22","guid":{"rendered":"https:\/\/researchbdev.wpengine.com\/digital-computational-studies\/?p=403"},"modified":"2017-04-20T09:21:45","modified_gmt":"2017-04-20T14:21:45","slug":"oracles-mysql-tutorial","status":"publish","type":"post","link":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/digital-computational-studies\/oracles-mysql-tutorial\/","title":{"rendered":"Oracle MySQL Tutorial"},"content":{"rendered":"<p>This tutorial comes from the official MySQL website, which is technically under the ownership\u00a0of Oracle. \u00a0Oracle is a global software and technology company, whose services are widely used &#8211; likely by many of the technologies you use every day. \u00a0MySQL alone is used to power the functionality of Twitter, Facebook, YouTube, and much more.<\/p>\n<p><a href=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.23.50-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-413 size-full aligncenter\" src=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.23.50-PM.png\" alt=\"Screen Shot 2016-03-30 at 10.23.50 PM\" width=\"795\" height=\"526\" srcset=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.23.50-PM.png 795w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.23.50-PM-300x198.png 300w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.23.50-PM-250x165.png 250w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.23.50-PM-624x413.png 624w\" sizes=\"auto, (max-width: 795px) 100vw, 795px\" \/><\/a><\/p>\n<p>While the MySQL documentation available on this site extends far, far beyond its tutorial, the tutorial itself can be found <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/tutorial.html\">here<\/a>. \u00a0Oracle offers users\u00a0very direct walkthroughs of connecting to the MySQL server, creating and using databases, entering queries, getting information about databases, using MySQL in batch mode, and using MySQL with Apache. \u00a0The guidance is straightforward, yet thorough, but it certainly assumes a certain level of user knowledge.<\/p>\n<p><strong>Pros:<\/strong><\/p>\n<ul>\n<li><em>Reputable: \u00a0<\/em>Since Oracle created MySQL, the company certainly knows MySQL best. \u00a0This is the most reliable MySQL resource available. \u00a0This is especially important to users who may be troubleshooting, as the site is far more likely to be correct than your average StackOverflow post.<\/li>\n<li><em>Straight to the point:<\/em>\u00a0 As was mentioned, Oracle knows how MySQL should work better than any other resource. \u00a0This tutorial is reliable without any excess information.<\/li>\n<li><em>Thorough directions:<\/em> \u00a0Though the tutorial is straightforward, it does cover all of the essential information needed to get started with MySQL &#8211; and, likely, needed to fix certain problems that even seasoned database designers may need. \u00a0With every explanation comes an example straight from the<\/li>\n<\/ul>\n<figure id=\"attachment_414\" aria-describedby=\"caption-attachment-414\" style=\"width: 779px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.29.01-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-414\" src=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.29.01-PM.png\" alt=\"Oracle provides useful examples\" width=\"779\" height=\"242\" srcset=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.29.01-PM.png 779w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.29.01-PM-300x93.png 300w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.29.01-PM-250x78.png 250w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-30-at-10.29.01-PM-624x194.png 624w\" sizes=\"auto, (max-width: 779px) 100vw, 779px\" \/><\/a><figcaption id=\"caption-attachment-414\" class=\"wp-caption-text\">Oracle provides users with useful examples<\/figcaption><\/figure>\n<p><strong>Cons:<\/strong><\/p>\n<ul>\n<li><em>Straight to the point:<\/em> \u00a0One may notice that this very quality was also listed as a &#8220;Pro.&#8221; \u00a0Oracle assumes that users have an understanding of such topics as batch mode and Apache. \u00a0It does not take time to explain anything extremely thoroughly, which may prove to be limiting to users who are new to programming or MySQL.<\/li>\n<li><em>Only command line\u00a0documentation: \u00a0<\/em>This tutorial will really only be useful for those who are looking to use MySQL from the command line in a Linux\/Unix or Windows environment. \u00a0Anyone who is looking to use MySQL largely from a GUI (a Graphic User Interface, like Sequel Pro or Windows MySQL Workbench) will benefit from other resources.<\/li>\n<\/ul>\n<p><strong>tl;dr? \u00a0<\/strong>Oracle provides a reliable, straightforward tutorial for connecting to MySQL server, creating and using databases, entering queries, and more, all in a Unix\/Linux environment. \u00a0For users who are looking to use databases using a GUI, other resources will likely be more helpful.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial comes from the official MySQL website, which is technically under the ownership\u00a0of Oracle. \u00a0Oracle is a global software and technology company, whose services are widely used &#8211; likely by many of the technologies you use every day. \u00a0MySQL alone is used to power the functionality of Twitter, Facebook, YouTube, and much more. While [&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":[1,17],"tags":[],"class_list":{"0":"post-403","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-digital-computational-studies","7":"category-sql","8":"entry"},"_links":{"self":[{"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/posts\/403","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=403"}],"version-history":[{"count":0,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/posts\/403\/revisions"}],"wp:attachment":[{"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/media?parent=403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/categories?post=403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/tags?post=403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}