{"id":389,"date":"2016-05-18T11:20:48","date_gmt":"2016-05-18T16:20:48","guid":{"rendered":"https:\/\/researchbdev.wpengine.com\/digital-computational-studies\/?p=389"},"modified":"2017-04-20T09:20:53","modified_gmt":"2017-04-20T14:20:53","slug":"tutorialspoint-mysql-tutorial","status":"publish","type":"post","link":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/student-research\/sql\/tutorialspoint-mysql-tutorial\/","title":{"rendered":"TutorialsPoint MySQL Tutorial"},"content":{"rendered":"<p>TutorialsPoint provides online users with a variety of free educational content. \u00a0The company&#8217;s mission, &#8220;Simply Easy Learning,&#8221; is strictly educational.<\/p>\n<p><a href=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-28-at-9.04.11-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-391\" src=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-28-at-9.04.11-PM.png\" alt=\"Screen Shot 2016-03-28 at 9.04.11 PM\" width=\"703\" height=\"523\" srcset=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-28-at-9.04.11-PM.png 703w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-28-at-9.04.11-PM-300x223.png 300w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-28-at-9.04.11-PM-250x186.png 250w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-28-at-9.04.11-PM-624x464.png 624w\" sizes=\"auto, (max-width: 703px) 100vw, 703px\" \/><\/a><\/p>\n<p>TutorialsPoint provides beginner SQL users with an introduction to MySQL in a PHP environment <a href=\"http:\/\/www.tutorialspoint.com\/mysql\/\">here<\/a>. \u00a0The tutorial begins at a most basic level with an introduction to databases, MySQL, and its syntax. \u00a0As users click through the pages of the tutorial, they will learn the basic definitions, relational database management systems (RDBMS), and their related content. \u00a0It presents a definition of terms useful to understanding databases, allowing users to understand the workings of databases before diving into specific syntax for creating a new MySQL instance or managing data.<\/p>\n<p><strong>Pros:<\/strong><\/p>\n<ul>\n<li><em>Download\/setup assistance:<\/em>\u00a0 Users are\u00a0guided in downloading and installing MySQL on Linux\/Unix and Windows, setting up MySQL accounts, and getting started on creating their own database.<\/li>\n<li><em>Quick reference:<\/em> \u00a0The tutorial provides a &#8220;Useful Functions&#8221; section, which allows for quick syntax reference supplemented with examples.\n<p><figure id=\"attachment_394\" aria-describedby=\"caption-attachment-394\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-29-at-10.53.18-AM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-394\" src=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-29-at-10.53.18-AM-300x241.png\" alt=\"Function example section\" width=\"300\" height=\"241\" srcset=\"https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-29-at-10.53.18-AM-300x241.png 300w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-29-at-10.53.18-AM-250x201.png 250w, https:\/\/research.bowdoin.edu\/digital-computational-studies\/files\/2016\/03\/Screen-Shot-2016-03-29-at-10.53.18-AM.png 465w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-394\" class=\"wp-caption-text\">Function example section<\/figcaption><\/figure><\/li>\n<li><em>Connection to web development:<\/em> \u00a0Users who are experienced with web development, specifically those using PHP, will likely find this a great resource for integrating databases into their sites.<\/li>\n<\/ul>\n<p><strong>Cons:<\/strong><\/p>\n<ul>\n<li><em>No Mac assistance:<\/em> \u00a0The site unfortunately does not provide instruction for downloading and installing MySQL on OS X.<\/li>\n<li><em>Assumption of experience working from command-line or using PHP:<\/em> \u00a0TutorialsPoint suggests that the information presented will be most easily understood by users who are at all familiar with web development and\/or working in a Linux environment. \u00a0The specifics of MySQL syntax are presented for both\u00a0PHP files and the command line, which may be limiting to new users unfamiliar with these environments.<\/li>\n<\/ul>\n<p><strong>tl;dr? \u00a0<\/strong>Ultimately, this resource is both comprehensible and thorough enough to be useful to anyone who is beginning to use SQL, regardless of their level of programming experience; however, new users may likely find other tutorials more useful as a more general starting point for database creation and design. \u00a0TutorialsPoint provides an introduction to MySQL that will be most useful for users experienced with web design who are looking to add database functionality to their websites.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TutorialsPoint provides online users with a variety of free educational content. \u00a0The company&#8217;s mission, &#8220;Simply Easy Learning,&#8221; is strictly educational. TutorialsPoint provides beginner SQL users with an introduction to MySQL in a PHP environment here. \u00a0The tutorial begins at a most basic level with an introduction to databases, MySQL, and its syntax. \u00a0As users click [&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-389","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\/389","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=389"}],"version-history":[{"count":0,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/posts\/389\/revisions"}],"wp:attachment":[{"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/media?parent=389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/categories?post=389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/research.bowdoin.edu\/digital-computational-studies\/wp-json\/wp\/v2\/tags?post=389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}