{"id":40,"date":"2010-05-19T08:44:03","date_gmt":"2010-05-19T13:44:03","guid":{"rendered":"http:\/\/weinshenker.net\/blog\/?p=40"},"modified":"2010-08-21T23:41:34","modified_gmt":"2010-08-22T04:41:34","slug":"mysql-class","status":"publish","type":"post","link":"http:\/\/weinshenker.net\/blog\/2010\/05\/19\/mysql-class\/","title":{"rendered":"Mysql class"},"content":{"rendered":"<p>So although I&#8217;ve\u00a0 been working as an Oracle Apps DBA for over a decade, I&#8217;m spending the next 10 Tuesday evenings going to a beginner class for mysql.\u00a0 You can find the class syllabus at http:\/\/geekaustin.org\/news\/2010\/05\/15\/geekaustin-mysql-certification-class-starts-tuesday-may-18th<\/p>\n<p>With Oracle&#8217;s acquisition on Sun earlier this year, Oracle now has greater influence on the path of mysql (yes, yes, it&#8217;s open source and like Java it isn&#8217;t *owned* by Oracle, but let&#8217;s face it, when you are the company providing much of the developer resources, you can influence the product direction).\u00a0 Although my main job responsibilities are running all of my client Oracle systems, I also am a Redhat Certified Engineer (RHCE) and provide whatever linux services are necessary.\u00a0 Lots of products don&#8217;t need the robustness of products like Oracle and MySQL, being free as-in-beer, is a good choice.\u00a0 So I&#8217;m off to class.<\/p>\n<p>Last night was the first class.\u00a0 I&#8217;d say about 50 people showed up and class covered topics like client vs. server vs. host and how to do basics like importing a mysql database, doing a mysqldump, and &#8220;root&#8221;ing your MySQL dbs if\/when you forget the passwords.\u00a0 There was also discussion on the various clauses of a SELECT statement.\u00a0 Overall, a well taught and fun couple of hours.\u00a0 I look forward to the next class.<\/p>\n<p>The goal of the class is to prepare the students to take and pass the Certified MySQL Associate certification offered at http:\/\/www.mysql.com\/certification\/candguide.html#t21\u00a0 .\u00a0 I&#8217;m not sure if I&#8217;m going to go for that certification or for the more appropriate for me ( Certified MySQL 5.1 Database Administrator (CMDBA 5.1)) certification which will require quite a bit of extra studying on my own.\u00a0 Have to see how my free time pans out over the next couple of months.\u00a0 I do wonder if the MySQL exams will be re-written to be like the other Oracle exams now that Oracle owns Sun.<\/p>\n<p>For those who want to study on their own, supposedly everything for the exams can be found in the book titled &#8220;MySQL 5.0 Certification Study Guide&#8221; .\u00a0 It&#8217;s available on amazon and also online at Safari Books.\u00a0 For those curious, it&#8217;s quite readable on an iphone.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So although I&#8217;ve\u00a0 been working as an Oracle Apps DBA for over a decade, I&#8217;m spending the next 10 Tuesday evenings going to a beginner class for mysql.\u00a0 You can find the class syllabus at http:\/\/geekaustin.org\/news\/2010\/05\/15\/geekaustin-mysql-certification-class-starts-tuesday-may-18th With Oracle&#8217;s acquisition on Sun earlier this year, Oracle now has greater influence on the path of mysql (yes, &hellip; <a href=\"http:\/\/weinshenker.net\/blog\/2010\/05\/19\/mysql-class\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Mysql class<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[41,10],"_links":{"self":[{"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/posts\/40"}],"collection":[{"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/comments?post=40"}],"version-history":[{"count":3,"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/posts\/40\/revisions"}],"predecessor-version":[{"id":136,"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/posts\/40\/revisions\/136"}],"wp:attachment":[{"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/media?parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/categories?post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/weinshenker.net\/blog\/wp-json\/wp\/v2\/tags?post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}