MySQL DBA certification exam
Hi, Folk: I have two questions about the DBA certification exam: 1.how many questions ? 2: how long is the exam? 3.what's the pass score? I could not find the answers on mysql web anybody knows? Thanks a lot
MySQL 5 certification books / trainign material
Good day everyone I think I have asked this question a while back but cant remember whether I have received an answer yet so I will ask again. I am busy studying for my MySQL certification exams, however the only book I have available to me is the MySQL 4 manual. The online pdf versions (for version 5.0 from the mysql website) seem to not be covering quite a bit of the info that is shown as requirements for the exam (or I am just being stupid and not finding it) My first exam is in 13 days and I have been struggling to find the relevant books or resources in order for me to get the study information I need. I tried Amazon,etc... but Amazon apparently does not deliver in SA anymore and the SA sites all show that the suppliers are out of stock. I managed to find one place today that had stock but shipment will take 25 working days which I do not have at this point. Does anybody know where I can get hold of a MySQL 5 certification study guide? Even if it is in pdf format or at this stage even if it has been used before. I would really appreciate the help with this as I can't even seem to get hold of someone at oracle to provide me with possible assistance as they all just say they don't know. Regards Machiel
Re: Mysql Certification exams
Hi Machiel, First of all, obligatory disclaimer: Until 2007, I was in charge of the MySQL certification exams. I'm also co-author of the book I'm about to recommend, but I receive no sales royalties. All of which means that I'm biased and my knowledge may be a bit rusty, but hopefully still useful :-) The best resource for self-study ought to be the MySQL 5 Certification Study Guide, http://www.amazon.com/MySQL-5-0-Certification-Study-Guide/dp/0672328127/ref=sr_1_1?ie=UTF8s=booksqid=1262596558sr=8-1 The book has received very favorable feedback from those doing self-studying for the certification exams. Along with the book you get a number of self-study questions to help you check whether you have understood the material. The questions are open-ended/discussion questions, not multiple-choice like on the exams. Also make sure to read the candidate guide on the mysql web site before you go to the exam. It has a lot of valuable hints. Best of luck on the exam! / Carsten On Mon, 4 Jan 2010 08:06:12 +0200, machiel.richards machiel.richa...@gmail.com wrote: Good day all I hope that someone can help me out with some resources. Due to lack of interest my MySQL training was cancelled in December. However I need to get certified (MySQL DBA) ASAP and need to do this on book knowledge and a bit of experience alone. Due to the cost for the exams I cannot afford to fail any one of the two exams. I am trying to get hold of sample exams, etc... that I can use for preparation to the exams in order to test myself and make sure that I have all the knowledge I need. Does anybody know where I can look for these? Regards Machiel !DSPAM:451,4b41859b3567878853768! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql Certification exams
Hi Machiel, 1) the best resource for the exam is/was the Cerification Study Guide and it is all you need to pass the exam but 2) the exam changed recently (no more from Vue) so that the Guide could be useless I am not telling you that being certified this way makes sense only for some corporate needs or personal CV needs (apart from telling friends at the bar) and when you will be at night with a broken replication your certification will not help you. But I am sure you know it already! Cheers Claudio 2010/1/4 machiel.richards machiel.richa...@gmail.com Good day all I hope that someone can help me out with some resources. Due to lack of interest my MySQL training was cancelled in December. However I need to get certified (MySQL DBA) ASAP and need to do this on book knowledge and a bit of experience alone. Due to the cost for the exams I cannot afford to fail any one of the two exams. I am trying to get hold of sample exams, etc... that I can use for preparation to the exams in order to test myself and make sure that I have all the knowledge I need. Does anybody know where I can look for these? Regards Machiel -- Claudio
Re: Mysql Certification exams
I am certified Dba, the book is all you need for the examwell 8 years experience help as well. What I mean is that On 4 jan 2010 10:20, cars...@bitbybit.dk wrote: Hi Machiel, First of all, obligatory disclaimer: Until 2007, I was in charge of the MySQL certification exams. I'm also co-author of the book I'm about to recommend, but I receive no sales royalties. All of which means that I'm biased and my knowledge may be a bit rusty, but hopefully still useful :-) The best resource for self-study ought to be the MySQL 5 Certification Study Guide, http://www.amazon.com/MySQL-5-0-Certification-Study-Guide/dp/0672328127/ref=sr_1_1?ie=UTF8s=booksqid=1262596558sr=8-1 The book has received very favorable feedback from those doing self-studying for the certification exams. Along with the book you get a number of self-study questions to help you check whether you have understood the material. The questions are open-ended/discussion questions, not multiple-choice like on the exams. Also make sure to read the candidate guide on the mysql web site before you go to the exam. It has a lot of valuable hints. Best of luck on the exam! / Carsten On Mon, 4 Jan 2010 08:06:12 +0200, machiel.richards machiel.richa...@gmail.com wrote: Good day all I hope that someone can help me out with some resources. ... I am trying to get hold of sample exams, etc... that I can use for preparation t... Does anybody know where I can look for these? Regards Mach... !DSPAM:451,4b41859b3567878853768! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: h...
Mysql Certification exams
Good day all I hope that someone can help me out with some resources. Due to lack of interest my MySQL training was cancelled in December. However I need to get certified (MySQL DBA) ASAP and need to do this on book knowledge and a bit of experience alone. Due to the cost for the exams I cannot afford to fail any one of the two exams. I am trying to get hold of sample exams, etc... that I can use for preparation to the exams in order to test myself and make sure that I have all the knowledge I need. Does anybody know where I can look for these? Regards Machiel
Re: Mysql Certification exams
Hi , Look dummies , look mysql basic's, not sure, but google with keyword mysql dump On Mon, Jan 4, 2010 at 11:36 AM, machiel.richards machiel.richa...@gmail.com wrote: Good day all I hope that someone can help me out with some resources. Due to lack of interest my MySQL training was cancelled in December. However I need to get certified (MySQL DBA) ASAP and need to do this on book knowledge and a bit of experience alone. Due to the cost for the exams I cannot afford to fail any one of the two exams. I am trying to get hold of sample exams, etc... that I can use for preparation to the exams in order to test myself and make sure that I have all the knowledge I need. Does anybody know where I can look for these? Regards Machiel -- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/
Re: Mysql Certification exams
On Sun, Jan 3, 2010 at 11:06 PM, machiel.richards machiel.richa...@gmail.com wrote: I am trying to get hold of sample exams, etc... that I can use for preparation to the exams in order to test myself and make sure that I have all the knowledge I need. I have passed all the 5.0 dev and dba exams as well as 5.1 cluster. Buy the official guides and read them well: http://www.amazon.com/MySQL-5-0-Certification-Study-Guide/dp/0672328127 That has all the information you need and practice exam questions. The certification exams are not that hard if you work with MySQL consistently and read through the guide. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Certification Feedback?
I'm considering MySQL certification, and I'm wondering which certifications I should target. I've been developing using MySQL for about 4-5 years, but am looking to get out of development and into a DBA role. I've worked with various database engines for about 20 years, so it would seem that I'd be OK just going for the CMDBA certification. Does anyone have any feedback regarding these tracks? It looks very much like I'd best just go for the CMDBA, but I don't want to leave any gaps. I'd be grateful for any advice. Cheers, Daniel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Certification Feedback?
Dan- I would concentrate on SQL certification first To know package foo does bar method for MySQL is a good extra tool to have in your toolbelt but more important for the bigger companies to be able to use your skillset for MySQL AND DB2 AND Oracle Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. From: daniel.la...@gmail.com To: mysql@lists.mysql.com Subject: Certification Feedback? Date: Sun, 1 Feb 2009 12:29:01 -0800 I'm considering MySQL certification, and I'm wondering which certifications I should target. I've been developing using MySQL for about 4-5 years, but am looking to get out of development and into a DBA role. I've worked with various database engines for about 20 years, so it would seem that I'd be OK just going for the CMDBA certification. Does anyone have any feedback regarding these tracks? It looks very much like I'd best just go for the CMDBA, but I don't want to leave any gaps. I'd be grateful for any advice. Cheers, Daniel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Windows Live™: E-mail. Chat. Share. Get more ways to connect. http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_allup_howitworks_012009
MySQL certification lag
Can anyone comment about how long it takes to a mysql cert letter? I was RIF'ed recently and have since passed the MySQL Developer exams, and would love to not have to wait at a minimum a month to be able to put the certification on my resume. After we receive notice of your results, we send a letter to you with details on how to access the Certification Candidate part of the MySQL Web site. Please allow 4 to 6 weeks delivery time for this letter. If you passed the exam, the letter will also contain your certification diploma and instructions on how to obtain logos for use on your business cards, stationary, personal home page, blog, personal e-mail signature, and so on. With these proofs of knowledge at your disposal, you're well equipped to enhance your career path. http://www.mysql.com/certification/certfaq.html The ZCE (which I plan to take next...) seems to claim a much *faster turn around: Once you have passed the exam, it takes 24-48 hours for your name and credentials to be published in the Zend Yellow Pages for PHP Professionals. http://www.zend.com/en/services/certification/faq?search=page=2 And they charge (125 vs 400) a heck of a lot less. *Snail mail is slow for them also: We will mail your diploma once you have passed the exam. Please allow 8-10 weeks for delivery. -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cluster Certification Study Guide available again
The Cluster Certification Study Guide (CCSG), first published in November 2007, is on sale again! The first edition had a number of issues with general layout, font sizes, and paper quality. For the new edition, we've addressed those issues, and thanks to our new print-on-demand publisher the price could be lowered. :-) For those who can't wait to get their personal copy, here's the link: http://store.vervante.com/c/v/595352502.html?base_cat=Sun%20Microsystems%3aMySQLpard=sun Regards, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.demailto: [EMAIL PROTECTED] Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certified MySQL Associate (CMA) certification value
Thanks for the input, everyone. I've gone back and am now leaning towards a VCC (Vancouver Community College) certificate: Database Developer Certificate (DDC) http://www.vcc.ca/cs/_printable-datesort.cfm? area=CSCOMPUTERprog=DATABASE#CSCOMPUTERDATABASE What I like about this is the cumulative effect of formalised learning with, I hope, job placement help from VCC. It's, I think, an outrageous price, but is fast and gives me something tangible. I don't mind paying the cash, but if it's not worth much more than: Associate (CMA) Certification http://www.mysql.com/certification/ it wouldn't make sense in a cost/benefit analysis. Just curious what others think of this program. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certified MySQL Associate (CMA) certification value
Well, it sounds like something you can learn a lot from. But nobody's ever heard of it. And if you're looking to learn about MySQL in particular, I suspect you won't get much out of this; it will mostly be general knowledge. So if you're looking for a job as a MySQL DBA, I suspect this won't do a whole lot for you. On Mon, Feb 25, 2008 at 3:34 AM, Thufir [EMAIL PROTECTED] wrote: Thanks for the input, everyone. I've gone back and am now leaning towards a VCC (Vancouver Community College) certificate: Database Developer Certificate (DDC) http://www.vcc.ca/cs/_printable-datesort.cfm? area=CSCOMPUTERprog=DATABASE#CSCOMPUTERDATABASE What I like about this is the cumulative effect of formalised learning with, I hope, job placement help from VCC. It's, I think, an outrageous price, but is fast and gives me something tangible. I don't mind paying the cash, but if it's not worth much more than: Associate (CMA) Certification http://www.mysql.com/certification/ it wouldn't make sense in a cost/benefit analysis. Just curious what others think of this program. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certified MySQL Associate (CMA) certification value
So I can relate a little personal knowledge about this. In July of last year I had someone approach me and ask how they could get a job as a DBA. After talking for a bit, it turned out that he had no database experience. He actually use to be a lawyer and decided to make a change. I told him to set up a database on a Linux computer and start playing around with it. The next month he said that he had done so. What next? Well, MySQL AB had just released the CMA exam. As Baron mentioned, it makes a great baseline to show your knowledge when you approach companies. I told him to start studying for the test using the MySQL Certification book (a subset of it covers the exam material). We met twice over the next few months to study a bit and then in December he took the test and passed it. Monday he actually started as our part time junior DBA. Is he making a lot of money? Nope. But, it is a good chance for him to get experience in a rapidly growing production environment and in another nine months or a year he *will *be able to get a decent job. So can you do it? Sure. Do you need a college degree? Not really. He certainly had one, but it had nothing to do with databases. What does it take? Desire, work and reasonable intelligence. That's all. I doubt you will make much at your first job, but learn from the experience and do everything you can to learn more. Once you get done with the CMA start working on the CMDBA exams. Unlike some other cert programs these aren't fluff. I am not sure of the statistics listed on MySQL's website, but there just aren't that many certified DBAs. And you won't find many jobs listed as jr dba. Don't sweat that. Approach companies that already have dbas and tell them you want a chance to learn. Show them through the CMA that you are serious. Working for peanuts. If it were me, and I was just starting out, I would pick what company I wanted to work at and if they wouldn't hire me for eight or ten dollars an hour I would offer to work for free. Just remember it is only temporary. Good luck. Keith Thufir wrote: On Wed, Feb 20, 2008 at 1:51 PM, Baron Schwartz [EMAIL PROTECTED] wrote: [...] In my opinion there is a tremendous shortage of qualified DBAs for MySQL. The certification may establish that you have at least a baseline of knowledge. If you're looking for a job, you could hardly go wrong with it, IMO. [...] Yeah, I think that I'm going for the certification, although I can't imagine what kind of job I could land -- junior DB admin? I don't have a college degree :( -Thufir -- B. Keith Murphy, CMA Paragon Consulting Services http://www.paragon-cs.com http://blog.paragon-cs.com (850) 637-3877 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Certified MySQL Associate (CMA) certification value
I'm considering studying for: Certified MySQL Associate (CMA) http://www.mysql.com/certification/candguide#t21 At first glance, it seems to follow: http://www.mysql.com/training/courses/introduction_to_databases.html I can hit the bookstore to find out more, of course. But, what I was wondering was: what's the value of this certification for me? What doors will it open? thanks, Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certified MySQL Associate (CMA) certification value
Hi, On Feb 20, 2008 6:13 AM, Thufir [EMAIL PROTECTED] wrote: I'm considering studying for: Certified MySQL Associate (CMA) http://www.mysql.com/certification/candguide#t21 At first glance, it seems to follow: http://www.mysql.com/training/courses/introduction_to_databases.html I can hit the bookstore to find out more, of course. But, what I was wondering was: what's the value of this certification for me? What doors will it open? In my opinion there is a tremendous shortage of qualified DBAs for MySQL. The certification may establish that you have at least a baseline of knowledge. If you're looking for a job, you could hardly go wrong with it, IMO. Take a look at one person's perspective: http://mysqldatabaseadministration.blogspot.com/2008/01/mysql-dumped-oracle-loaded-whose-fault.html And then, http://mysqldatabaseadministration.blogspot.com/2008/02/fotolog-seeks-mysql-dba.html I think those are the doors you can expect to open. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certified MySQL Associate (CMA) certification value
On Wed, Feb 20, 2008 at 1:51 PM, Baron Schwartz [EMAIL PROTECTED] wrote: [...] In my opinion there is a tremendous shortage of qualified DBAs for MySQL. The certification may establish that you have at least a baseline of knowledge. If you're looking for a job, you could hardly go wrong with it, IMO. [...] Yeah, I think that I'm going for the certification, although I can't imagine what kind of job I could land -- junior DB admin? I don't have a college degree :( -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.1 Cluster Certification Study Guide
Hi, A little over a year since the project to write this book began, the MySQL 5.1 Cluster Certification Study Guide is now at long last available. Covering the Certified MySQL 5.1 Cluster Database Administrator exam, this study guide is the one authority to look to when you're preparing for the test. The book teaches you all the concepts, principles, and techniques that you'll need to know for the exam, with many practice questions and real-world examples to help you prepare for test day. The book is also an excellent reference guide for your real-world MySQL Cluster administration needs. Whatever your reason for becoming MySQL certified, this book gives you the information you need to help you better understand MySQL Cluster technologies and prepare for and pass the exams. The authors span from Australia over Europe to the East and West coast of the US. We had reviewers from four different continents. Seeing a project like this actually working and producing a great result is really fascinating. Carsten Pedersen helped to get the table of contents in place, wrote the introduction, and made sure certification program and study guide were kept in sync, while Stefan Hinz was the project lead, but, naturally, the lion's share was done by the authors: * Jon Stephens is not only the master of MySQL Cluster Documentation, he has actually moved himself halfway across the world be be closer to the Cluster developers while he works. His author's credits include Beginning MySQL Database Design and Optimization from Apress. * Mike Kruckenberg should be a familiar name to anyone reading Planet MySQL. Mike is co-author of Pro MySQL from Apress, and member of the MySQL Certification Technical Advisory Board. * Roland Bouman, blogger extraordinaire, winner of one of the 2006 MySQL Community awards, and hired in 2006 to (among many other things) develop the Cluster certification exams. If anyone knows what's on the exams, he is the one. * Stewart Smith not only hacks away at Cluster during his working hours, he's also very involved in the Australian Open Source community, and is often heard speaking on MySQL Cluster. * Solomon Chang, a founding member of LAMPSIG of Los Angeles and a professional DBA, has contributed material for exercises and reviewed much of the book. This is the first book we published all on our own. It's printed and shipped via lulu.com, a print-on-demand shop. You can order your copy here: http://www.lulu.com/content/1297960. It will also be available from retailers (Amazon as well as brick and mortar bookstores) soon. -- Regards, Stefan Hinz [EMAIL PROTECTED], MySQL AB Documentation Manager Berlin, Germany (UTC +1:00/winter, +2:00/summer) Skype:stefanhinz Cell:+491777841069 Desk:+493082702940 Fax:+493082702941 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Certification
Thanx for all the messages but I wasn't talking about the list mysql@lists.mysql.com... I get all those mails... I was talking about the speficic certification list [EMAIL PROTECTED]. (Sorry for not being that clear !) And still no words about maximum space between DEV1 and DEV2 !!! Thanx -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Certification
As I understood to attain MySQL Developer you must pass 2 exams... DEV1 and DEV2... What I did not understood, yet... if there is any limit in the timespan between DEV1 and DEV2. Let's say I'll take DEV1 in late March... how many months can pass so that when i'll take DEV2 the results for DEV1 are still valid ? And is the list still ON ? ... I'm subscribed to the list... but didn't got any messages... Thanx for the answers ! -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Certification examples
Hi I have bought the MySQL certification study guide (v 5.0) and am almost ready for the exams, does anyone know if the questions in the self study guide are very similar to the ones that you get in the exam? and is there anywhere else that i can get more questions like this for practice purposes? TIA Ade -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Certification Questions
Hi Does anybody know where i can get a load of sample questiosn for the MySQL certificate exams, i know there are a few on mysql's site but i was hoping to find quite a few to practice on. Thanks Ade -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Certification Questions
the study guide? Adrian Bruce wrote: Hi Does anybody know where i can get a load of sample questiosn for the MySQL certificate exams, i know there are a few on mysql's site but i was hoping to find quite a few to practice on. Thanks Ade -- life is a game... so have fun. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.0 certification
Has anyone been involved with the 5.0 certification program. I purchased three books in regards to 5.0 certification from MySQL but am totally unable to find anything about the new certification program on the web site. The new program is structured COMPLETELY different from the old program and thus it is somewhat useless to study if only the old 4.1 certification program is in place. Anyone know anything?
Re: MySQL 5.0 certification
Has anyone been involved with the 5.0 certification program. I've read that the new MySQL 5 certificates will be available about 2 or 3 months after MySQL 5 becomes a Production Release. http://db4free.blogspot.com/2005/10/mysql-5-certifications.html -- Scott Noyes [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: studying for the certification exam
Hi, I took the MySQL core and professional certification exams and failed both, so now I want to go again, but does anyone have any tips or techniques for studying that they've found useful? Wow, what a drag. Did you read the study guide? How long have you been a MySQL user? I am preparing to take the professional exam and have been reading the study guide. I find it to be very useful and informative in that it lets you know what percentage each topic will be covered in the exam. I also started reading the entire online manual. I skim through a lot of it and spend the most time on the areas that either interest me or are unclear. I have been a MySQL user since 1998. Most my experience was installation/administration for a web hosting provider until around 2001 at which time I began using it for my own projects. It's really only been the last year or two that I started feeling any kind of confidence with MySQL. Although I have not taken the exam, I am feeling pretty confident that I can pass after reading the online manual and the study guide from front to (almost) back. I hope I'm right about that feeling! Wish me luck :-) Best of luck to you, too. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: studying for the certification exam
I would suggest exposing yourself to other developers and them to you as well. They are often found on irc server irc.freenode.net. The more you expose yourself to them and them to you, the better you know and better prepared you get for exam. They also provide resourceful information as they exchange advices. -Original Message- From: Jim Grill [mailto:[EMAIL PROTECTED] Sent: Saturday, September 25, 2004 2:36 PM To: Levi Campbell; [EMAIL PROTECTED] Subject: Re: studying for the certification exam Hi, I took the MySQL core and professional certification exams and failed both, so now I want to go again, but does anyone have any tips or techniques for studying that they've found useful? Wow, what a drag. Did you read the study guide? How long have you been a MySQL user? I am preparing to take the professional exam and have been reading the study guide. I find it to be very useful and informative in that it lets you know what percentage each topic will be covered in the exam. I also started reading the entire online manual. I skim through a lot of it and spend the most time on the areas that either interest me or are unclear. I have been a MySQL user since 1998. Most my experience was installation/administration for a web hosting provider until around 2001 at which time I began using it for my own projects. It's really only been the last year or two that I started feeling any kind of confidence with MySQL. Although I have not taken the exam, I am feeling pretty confident that I can pass after reading the online manual and the study guide from front to (almost) back. I hope I'm right about that feeling! Wish me luck :-) Best of luck to you, too. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
studying for the certification exam
Hi, I took the MySQL core and professional certification exams and failed both, so now I want to go again, but does anyone have any tips or techniques for studying that they've found useful? - Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now.
Training and certification in Kansas City
Where can I get MySQL training and certification in Kansas City? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Training and certification in Kansas City
At 18:19 -0600 7/1/04, Levi Campbell wrote: Where can I get MySQL training and certification in Kansas City? VUE handles MySQL cert testing. If you visit here: http://vue.com/mysql/ Then on the See where Pearson VUE has test centers that deliver MySQL exams. line, click the test centers link and you'll get to a page where you can find test centers. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Professional certification
Hi Brian, On Fri, 2004-06-18 at 19:48, Brian Mansell wrote: I took the certification exam this morning and passed. Congratulations! When should I expect to receive the certificate (and other items) in the mail? It usually takes 4-6 weeks for the certificate to arrive at your address. Best regards, / Carsten -- Warning: Certification can seriously increase your wealth! http://www.mysql.com/certification Carsten Pedersen Coordinator of Development, Certification Manager MySQL AB, http://www.mysql.com Office: +45 56 36 16 10 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Professional certification
-Original Message- From: Brian Mansell [mailto:[EMAIL PROTECTED] I took the certification exam this morning and passed. When should I expect to receive the certificate (and other items) in the mail? I'm thinking of studying for the exam. How much time did you put into studying before you sat for the exam? Which books did you use? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Professional certification
I took the certification exam this morning and passed. When should I expect to receive the certificate (and other items) in the mail? --bmansell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking for reviewers: MySQL Certification Study Guide
Hi! In April, the MySQL Certification Study Guide was published by MySQL Press. By now, it has arrived in bookstores across the world. The main parts of the book are written by Paul DuBois, Stefan Hinz and yours truly. Paul needs no introduction; Stefan has translated several MySQL books to German and is a member of the MySQL documentation team. I'm just the Certification Manager here at MySQL. The MySQL Certification Study Guide is a comprehensive study guide to prepare you for the MySQL Core Certification and MySQL Professional Certification Exams. We like to think that it is useful for anyone that wishes to brush up his or her MySQL skills. We are looking for a few brave individuals that are interested in writing an independent review of the book (to be published on the MySQL web site) in exchange for a free copy of the Study Guide. Being in the MySQL Certification program is *not* a requirement for being selected as a reviewer. The book is some 600 pages; we expect you to complete your review no later than June 30th. You can read some more details on the Study Guide, including a free chapter on http://www.mysql.com/training/certification/studyguides/ If you are interested in giving a review in exchange for a book, please email me directly with the below information, which will be used to select the broadest possible range of reviewers. - Name and e-mail address - Work function - How long you have been using MySQL - Age - Whether you've already signed up for or taken a certification exam(s) - if so, which one(s) - Whether you're primary work with MySQL is as administrator or developer. Best regards, Carsten H. Pedersen Certification Manager, MySQL AB -- Warning: Certification Can Seriously Increase Your Wealth! http://www.mysql.com/certification Carsten H. Pedersen Coordinator of Development, Certification Manager MySQL AB, http://www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Test Questions
* Bob Ramsey [EMAIL PROTECTED] [2004-01-18 22:54 +0100]: So how reflective of the real test is the sample test at mysql.com? They've got sample questions for the core certification only. Their level looks similar, but the real exam offers answers like none of the above and all of the above, which makes things much harder when you are not sure or running out of time. -- Johannes Franken Professional unix/network development mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Test Questions
On Sun, 2004-01-18 at 20:51, Johannes Franken wrote: * Marc Dver [EMAIL PROTECTED] [2004-01-18 18:30 +0100]: 1. What is the format of the test questions? I.e., are they multiple choice, free answer, essay, etc.? They are multiple-choice (but very tricky) and fill-in-the-gaps. For example: Assume a column in a MyISAM table has type VARCHAR, BLOB, or TEXT. Which of the following specifies this table type correctly to save space? Mark all answers that are wrong: [ ] ROW_FORMAT=Static [ ] ROW_FORMAT=default [ ] ROW_FORMAT=dynamic [ ] ROW_FORMAT=compressed [ ] all of the above [ ] none of the above I think I need to clarify a few details regarding this: First of all, we've done all that we possibly could do to remove double negatives in the exam questions. We very rarely ask which of the following are NOT true. Only when the question or answer texts would become much more complicated without this structure, have we submitted to it. And when we do so, we make it very clear what we are asking. There are indeed All/None of the above answers for a few question items. However, because of the way the exams are structured, I can promise you that if you were to go to the exam today, you would only see one (if any) of this type of questions during the entire exam. Now, I'm not saying all this to put Johannes or his observations down -- going to an exam *is* a stressful experience and people do come out with (amazingly) different accounts of what they thought was going on during the exam. During internal testing of the exams, I had MySQL employees be subjected to the exact same set of questions. Afterward, they gave me completely different accounts of their experience: some felt that more than half the questions had been on import/export (it was in fact around 5%); others were saying that they thought there were too many fill-in the blanks questions (on that particular test, they were subjected to *two* such questions during the exam). Are they theory based or is it fact based, i.e., memorize the books to pass? For the CORE certification, it's balanced. In many cases they show you some tables's contents and you have pick either the statements which do some job, or the result if you rune some statement. For this type of questions, memorizing the books is just not enough. You need to *understand* the facts. For the PROFESSIONAL certification, it's different. Here you don't need SQL, but you should memorize every aspect of performance- and security-tuning. ...and again, you need to *understand* how things work. Mere fact memorization won't see you through (which is not contrary to Johannes' statement; I just think it's important to highlight it). I have heard from some candidates that they regard the Core exam as being more of a memorization exam than Professional. Which only goes to show, once again, that perceptions differ quite a bit as people come out of the testing room. Best regards, / Carsten -- Carsten H. Pedersen Coordinator of Development, Certification Manager MySQL AB, http://www.mysql.com Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Test Questions
Carsten Pedersen wrote: I have heard from some candidates that they regard the Core exam as being more of a memorization exam than Professional. Which only goes to show, once again, that perceptions differ quite a bit as people come out of the testing room. Carsten, Do you know when the Professional exam will be coming out of its beta status? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Certification Test Questions
1. What is the format of the test questions? I.e., are they multiple choice, free answer, essay, etc.? Are they theory based or is it fact based, i.e., memorize the books to pass? 2. Upon the recommendation of someone on this list, I purchased two books, one entitled, MySQL by Paul Dubois, and An Introduction to Database Systems by C.J. Date. Would these materials, together with practice on a live server, suffice to give me the knowledge to pass the certification test? 3. What version is the test geared for? Sincerely, Marc DVer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Certification Test Questions
In the Certification section of the mysql web site there is a short sample test which shows the types of questions. There's a lot of information there too including the broad topics covered in each test. According to amazon.com Paul Dubois will have a MySQL Certification study book coming out March 15th. I believe the test is geared toward the 4.x versions, but the web site should say for sure. _ High-speed usersbe more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Certification Test Questions
At 14:27 -0500 1/18/04, Jeremy March wrote: In the Certification section of the mysql web site there is a short sample test which shows the types of questions. There's a lot of information there too including the broad topics covered in each test. According to amazon.com Paul Dubois will have a MySQL Certification study book coming out March 15th. I believe the test is geared toward the 4.x versions, but the web site should say for sure. That book actually is by myself, Stefan Hinz, and Carsten Pedersen. The advice to visit the web site is good advice: http://www.mysql.com/certification/index.html Lots of relevant info there. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Test Questions
* Marc Dver [EMAIL PROTECTED] [2004-01-18 18:30 +0100]: 1. What is the format of the test questions? I.e., are they multiple choice, free answer, essay, etc.? They are multiple-choice (but very tricky) and fill-in-the-gaps. For example: Assume a column in a MyISAM table has type VARCHAR, BLOB, or TEXT. Which of the following specifies this table type correctly to save space? Mark all answers that are wrong: [ ] ROW_FORMAT=Static [ ] ROW_FORMAT=default [ ] ROW_FORMAT=dynamic [ ] ROW_FORMAT=compressed [ ] all of the above [ ] none of the above Are they theory based or is it fact based, i.e., memorize the books to pass? For the CORE certification, it's balanced. In many cases they show you some tables's contents and you have pick either the statements which do some job, or the result if you rune some statement. For this type of questions, memorizing the books is just not enough. You need to *understand* the facts. For the PROFESSIONAL certification, it's different. Here you don't need SQL, but you should memorize every aspect of performance- and security-tuning. 2. Upon the recommendation of someone on this list, I purchased two books, one entitled, MySQL by Paul Dubois, and An Introduction to Database Systems by C.J. Date. Would these materials, together with practice on a live server, suffice to give me the knowledge to pass the certification test? I haven't read them. For the CORE certification, I found O'Reillys Managing Using MySQL by Reese, Yarger, King, Williams plus 6 years of M(y)SQL experience not too bad. You might want to try XML-Mentor's practice test http://www.xmlmentor.net/mysqlcore.htm. I only tried the free demo, which has 10 of 215 questions. For the PROFESSIONAL certification, I printed and read the MySQL reference manual http://www.mysql.com/documentation and actually bought a practice-test from http://www.xmlmentor.net/mysqlprof.htm at 89,- US$. XML-Mentor's practice test for the professional certification was not as hard as the real (beta) exam and it had 10% wrong answers, but it pointed me to the locations of the manual I had to reread. After having passed the real exam, I must admit the practice test was worth the money. And it was fun, too. BTW, I sent a long list of corrections to that xml guy; if he's put them in, the test should be fine now. 3. What version is the test geared for? It's about version 4. -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Test Questions
So how reflective of the real test is the sample test at mysql.com? Normally the little sample tests are easier than the real thing, but I'm curious. I got 8 out of 10. bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Question
On Sat, 2004-01-10 at 12:04, Bernard Clement wrote: Hello Aman, For instructions on taking the exam in India goto the URL: http://www.vue.com/mysql/ and click on test center of To register for exams in India, please contact the test center directly. This will bring you a window containing all the Pearson VUE Test Center in India. You should of course also check up on all the certification material available on the MySQL web site: http://www.mysql.com/certification Most importantly, make sure to read through the Certification Candidate Guide. Best regards and good luck! / Carsten -- Carsten H. Pedersen Coordinator of Development, Certification Manager MySQL AB, http://www.mysql.com Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Question
Hi bernard, Thanks for your swift information on this.. -Aman. Bernard Clement wrote: Hello Aman, For instructions on taking the exam in India goto the URL: http://www.vue.com/mysql/ and click on test center of To register for exams in India, please contact the test center directly. This will bring you a window containing all the Pearson VUE Test Center in India. Good luck! Bernard On Friday 09 January 2004 22:29, Amanullah wrote: I'm also interested to take up the certification exam on Mysql, pl. guide me how to proceed to get certification on the same, I'm in India (chennai). -aman. Arjun Subramanian wrote: I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -Original Message- From: Amanullah [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: New INstall of MySQL Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory run winmysqladmin.exe. mysql service will be strated to work.. -Aman. Chris L. White wrote: Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install MYSQL. I go to setup and run the setup and the status bar does not move much and the installation takes about 5 seconds and then it is done. I get to the finished installing screen, but there are no options to choose from like the test in the screen says there should. Also I have a my.cnf and ny.ini file in the proper places and I still have nothing going. I am confused and the manual I am finding is not clear enough on this. I included what the my.cnf and my.ini file looks like. And also included the error I am getting after installation. Also after MYSQL is installed should there not be some icons for things related to it, because I don't even have them. I am trying to install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP installed. Please help. [mysqld] # set basedir to your installation path # basedir=C:/mysql # set datadir to the location of your data directory #datadir=C:/SQLData # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set
Re: Certification Question
I took the MySQL core certification exam on the 2nd of January and Passed. Congratulations! I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. They do indeed, I have a nice certificate on my wall, a couple of MySQL pens in my drawer, some MySQL stickers on my monitor, and my daughter plays with the MySQL beachball (of course they may have changed the souveniers but I am sure you will get the certificate. Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Question
Hello Aman, For instructions on taking the exam in India goto the URL: http://www.vue.com/mysql/ and click on test center of To register for exams in India, please contact the test center directly. This will bring you a window containing all the Pearson VUE Test Center in India. Good luck! Bernard On Friday 09 January 2004 22:29, Amanullah wrote: I'm also interested to take up the certification exam on Mysql, pl. guide me how to proceed to get certification on the same, I'm in India (chennai). -aman. Arjun Subramanian wrote: I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -Original Message- From: Amanullah [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: New INstall of MySQL Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory run winmysqladmin.exe. mysql service will be strated to work.. -Aman. Chris L. White wrote: Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install MYSQL. I go to setup and run the setup and the status bar does not move much and the installation takes about 5 seconds and then it is done. I get to the finished installing screen, but there are no options to choose from like the test in the screen says there should. Also I have a my.cnf and ny.ini file in the proper places and I still have nothing going. I am confused and the manual I am finding is not clear enough on this. I included what the my.cnf and my.ini file looks like. And also included the error I am getting after installation. Also after MYSQL is installed should there not be some icons for things related to it, because I don't even have them. I am trying to install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP installed. Please help. [mysqld] # set basedir to your installation path # basedir=C:/mysql # set datadir to the location of your data directory #datadir=C:/SQLData # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable
Certification Question
I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -Original Message- From: Amanullah [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: New INstall of MySQL Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory run winmysqladmin.exe. mysql service will be strated to work.. -Aman. Chris L. White wrote: Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install MYSQL. I go to setup and run the setup and the status bar does not move much and the installation takes about 5 seconds and then it is done. I get to the finished installing screen, but there are no options to choose from like the test in the screen says there should. Also I have a my.cnf and ny.ini file in the proper places and I still have nothing going. I am confused and the manual I am finding is not clear enough on this. I included what the my.cnf and my.ini file looks like. And also included the error I am getting after installation. Also after MYSQL is installed should there not be some icons for things related to it, because I don't even have them. I am trying to install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP installed. Please help. [mysqld] # set basedir to your installation path # basedir=C:/mysql # set datadir to the location of your data directory #datadir=C:/SQLData # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout C:\MySQL\binmysqld --console 040109 9:53:02 InnoDB: Started 040109 9:53:02 Fatal error: Can't open privilege tables: Table 'mysql.host' d esn't exist 040109 9:53:02 Aborting 040109 9:53:02 InnoDB: Starting shutdown... 040109 9:53:04 InnoDB: Shutdown completed 040109 9:53:04 mysqld: Shutdown Complete Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com
Re: Certification Question
I'm also interested to take up the certification exam on Mysql, pl. guide me how to proceed to get certification on the same, I'm in India (chennai). -aman. Arjun Subramanian wrote: I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -Original Message- From: Amanullah [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: New INstall of MySQL Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory run winmysqladmin.exe. mysql service will be strated to work.. -Aman. Chris L. White wrote: Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install MYSQL. I go to setup and run the setup and the status bar does not move much and the installation takes about 5 seconds and then it is done. I get to the finished installing screen, but there are no options to choose from like the test in the screen says there should. Also I have a my.cnf and ny.ini file in the proper places and I still have nothing going. I am confused and the manual I am finding is not clear enough on this. I included what the my.cnf and my.ini file looks like. And also included the error I am getting after installation. Also after MYSQL is installed should there not be some icons for things related to it, because I don't even have them. I am trying to install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP installed. Please help. [mysqld] # set basedir to your installation path # basedir=C:/mysql # set datadir to the location of your data directory #datadir=C:/SQLData # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout C:\MySQL\binmysqld --console 040109 9:53:02 InnoDB: Started 040109 9:53:02 Fatal error: Can't open privilege tables: Table 'mysql.host' d esn't exist 040109 9:53:02 Aborting 040109 9:53:02 InnoDB: Starting shutdown... 040109 9
Re: MySQL certification
Douglas, I'm scheduled to take the MySQL certification exam tomorrow morning, thus currently intently cramming with the MySQL reference manual and writing out study notes etc. I'm not too worried as I've been using MySQL for years (although preping for this has been a good exercise and I've learned a number of useful things so far) but I wonder if anyone on this list has thoughts in general about the certification test or has taken this test and would like to offer any tips, hints, or cautions? I've taken the Core exam, but that was a long time ago (November 2002 :-). Mike Hillyer has taken (and passed) both exams, and he's written a nice summary about taking the Pro exam on his blog: http://www.vbmysql.com/mike/blog/archives/09.php If I do well on the test tomorrow, perhapas I'll post my study notes on-line; otherwise I may change my name, retire to the countryside and take up raising mangel-wurzels. Good luck! Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL certification
Thanks, Stefan. Mike's article was interesting. The test was a bit harder than I anticipated. I should have paid more attention to column types and database name, among other things. But I did pass - at least, the preliminary report said pass, but also said that the exam will be reviewed and If you have met the passing score, you will receive your official certificate by mail. This puzzles me, because this exam isn't beta any more? Studying for and taking the exam was a good excercise and I'm glad I did. I learned things I didn't know about MySQL. Now I would like to take the Pro exam. I wrote out pages and pages of notes while studying. If anyone's interested, perhaps I will post those online. -Doug Stefan Hinz wrote: Douglas, I'm scheduled to take the MySQL certification exam tomorrow morning, thus currently intently cramming with the MySQL reference manual and writing out study notes etc. I'm not too worried as I've been using MySQL for years (although preping for this has been a good exercise and I've learned a number of useful things so far) but I wonder if anyone on this list has thoughts in general about the certification test or has taken this test and would like to offer any tips, hints, or cautions? I've taken the Core exam, but that was a long time ago (November 2002 :-). Mike Hillyer has taken (and passed) both exams, and he's written a nice summary about taking the Pro exam on his blog: http://www.vbmysql.com/mike/blog/archives/09.php If I do well on the test tomorrow, perhapas I'll post my study notes on-line; otherwise I may change my name, retire to the countryside and take up raising mangel-wurzels. Good luck! Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query]
Re: MySQL certification
On Mon, 2004-01-05 at 19:56, Douglas Sims wrote: Thanks, Stefan. Mike's article was interesting. The test was a bit harder than I anticipated. I should have paid more attention to column types and database name, among other things. But I did pass Congratulations :-) - at least, the preliminary report said pass, but also said that the exam will be reviewed and If you have met the passing score, you will receive your official certificate by mail. This puzzles me, because this exam isn't beta any more? No, it's not. And don't worry, that's just some standard verbiage from the test center. If your score report says passed, you've passed -- and you will receive your certificate in due time. Studying for and taking the exam was a good excercise and I'm glad I did. I learned things I didn't know about MySQL. ... Yes, many candidates are surprised at the high level of the exam; both the knowledge/skill required and the amount of information covered in the Core exam are quite extensive, despite this being our first level exam. I learned things I didn't know about MySQL while studying is a comment we often hear -- which makes me and others here happy, as this is of course one of the main ideas behind having a certification program in the first place. Best regards, / Carsten -- Carsten H. Pedersen Coordinator of Development, Certification Manager MySQL AB, http://www.mysql.com Want to swim with the dolphins? (April 14-16, 2004) http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL certification
On Mon, 5 Jan 2004, Douglas Sims wrote: The test was a bit harder than I anticipated. I should have paid more attention to column types and database name, among other things. But I did pass - at least, the preliminary report said pass, but also said that the exam will be reviewed and If you have met the passing score, you will receive your official certificate by mail. This puzzles me, because this exam isn't beta any more? It's the Professional exam that is in beta. Once you say you're done reviewing you should get a PASS or FAILED on the screen imediately. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL certification
I'm scheduled to take the MySQL certification exam tomorrow morning, thus currently intently cramming with the MySQL reference manual and writing out study notes etc. I'm not too worried as I've been using MySQL for years (although preping for this has been a good exercise and I've learned a number of useful things so far) but I wonder if anyone on this list has thoughts in general about the certification test or has taken this test and would like to offer any tips, hints, or cautions? If I do well on the test tomorrow, perhapas I'll post my study notes on-line; otherwise I may change my name, retire to the countryside and take up raising mangel-wurzels. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Core Certification
Hi Arjun, I have taken both exams (July and August 2002). The best advice I can give you is to get your hands on the Mysql Certificate study guide coming out in 2 months (from Paul Dubois). I had the chance to preview bits of it and I believe that it will be a VERY good help. Just read through it carefully and playaround with the system at the same time to practice the read things. The exam which I was taking was beta at that time. It was hard but fair I felt. Take your time when reading the guide question the details mentioned (or not) in the book to get a really good grasp of the subject. Thats the best you can do, do get into the exam relaxed and without any unneccesary pressure. Best regards Nils Valentin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 28, 2003 4:51 AM Subject: Core Certification Hello everybody ! I have question regarding the MySQL core certification. Does anybody have any general insights on taking the exam ? I am studying from the manual, but I am pretty nervous about the exam as I don't know how much in depth the questions will be or even if studying from the manual alone will be sufficient. I would appreciate any thoughts or comments from anyone about the exam.Thanks ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Core Certification
Hello everybody ! I have question regarding the MySQL core certification. Does anybody have any general insights on taking the exam ? I am studying from the manual, but I am pretty nervous about the exam as I don't know how much in depth the questions will be or even if studying from the manual alone will be sufficient. I would appreciate any thoughts or comments from anyone about the exam.Thanks ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL certification [slightly-ot]
Hi Jennifer, On Fri, 2003-09-26 at 20:55, Jennifer Goodie wrote: I have recently re-entered the job market and I was wondering if anyone has found that having certification really helps in landing a position. If so, which cert do you have? I can only answer in general terms, but hope you might still find this insight helpful... I have talked to quite a number of hiring managers, and there seems to be some consensus regarding the following points, when it comes to certifications in hiring: If a manager looks at certifications, it's often the first thing he does to split the candidates, with a view to look at the certified people first. While holding certificate XYZ will often make a difference as to who makes it into the stack of interesting candidates, it rarely makes a difference when deciding on the final runner-ups for the position. At this time, your CV and personality are what makes the difference. The value of a given certification also depends on where you are looking for a job. In large corporations, where a centralized HR department is involved, the people making the initial processing of applicants often don't know (or maybe they don't understand) the details of what's being asked of the candidates. To them, even an introductory certification (like MySQL ABs Core certification) can make a big difference. Smaller companies tend to look only at higher-level or specialized certifications when hiring. I hope you found this input helpful -- you (and anyone else reading this reply) are very welcome to contact me directly if you want further details on our certification program. Best regards, Carsten Pedersen Certification Manager, MySQL AB -- Warning: Certification can seriously increase your wealth! http://www.mysql.com/certification Carsten Pedersen Coordinator of Development, Certification Manager MySQL AB, http://www.mysql.com Office: +45 56 36 16 10 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL certification [slightly-ot]
I have recently re-entered the job market and I was wondering if anyone has found that having certification really helps in landing a position. If so, which cert do you have? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL core certification revision - clients
Hello, On Sun, 2003-07-20 at 14:59, Stefan Hinz wrote: Matthew, Hi, I'm clear as to what is meant by The mysql client in the MySQL core certification revision check list. I understand that the mysql database itself is the server. Would client then be any program that talks to the server? Perhaps it is referring to mysql, the command line tool? Just a few small note to qualify Stefan's explanations: The mysql client as written in the list that you speak of in the Candidate Guide on http://www.mysql.com/certification/candguide/sec-core.html does indeed refer specifically to the client program mysql (or mysql.exe on Windows), so your interpretation of this is correct. Client programs are indeed programs that talk with the server. The server, however, is not the database, but rather the program that manages databases (allow/deny access to databases and their tables, modify tables structures, change contained data, etc.). MySQL provides a number of client programs for various purposes, like controlling the server, backing up databases, etc. One of those programs is mysql, which is a command line interface (CLI). The names of programs in a MySQL binary distribution can be somewhat confusing: mysqld is the server, while mysql is the (main) CLI client. I understand client side programs, examples being: mysqladmin, mysqldump, and mysqlimport. These are known as mysql client commands also? Those are client (side) programs, not client commands. You use those programs to issue (client) commands that are sent to the server. Hmm - Stefan, you need to read that particular page more carefully :-) The line that is being discussed is this one, which appears as a subject under The mysql client: * Differentiate between mysql client commands and SQL commands In this context, a client command is one such as quit, rehash, connect (They are listed on http://www.mysql.com/doc/en/mysql.html), which is processed directly by the mysql program. An SQL command, on the other hand, is an e.g. SELECT or INSERT statement that is sent to the server for processing. Note that just because a command is a client command, this does not necessarily infer that no client/server communication takes place. Best regards, Carsten H. Pedersen Certification Manager, MySQL AB -- Warning: Certification can seriously increase your wealth! http://www.mysql.com/certification Carsten Pedersen, Certification Manager MySQL AB, http://www.mysql.com Office: +45 56 36 16 10 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL core certification revision - clients
Matthew, Hi, I'm clear as to what is meant by The mysql client in the MySQL core certification revision check list. I understand that the mysql database itself is the server. Would client then be any program that talks to the server? Perhaps it is referring to mysql, the command line tool? Client programs are indeed programs that talk with the server. The server, however, is not the database, but rather the program that manages databases (allow/deny access to databases and their tables, modify tables structures, change contained data, etc.). MySQL provides a number of client programs for various purposes, like controlling the server, backing up databases, etc. One of those programs is mysql, which is a command line interface (CLI). The names of programs in a MySQL binary distribution can be somewhat confusing: mysqld is the server, while mysql is the (main) CLI client. I understand client side programs, examples being: mysqladmin, mysqldump, and mysqlimport. These are known as mysql client commands also? Those are client (side) programs, not client commands. You use those programs to issue (client) commands that are sent to the server. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL core certification revision - clients
Hi, I'm clear as to what is meant by The mysql client in the MySQL core certification revision check list. I understand that the mysql database itself is the server. Would client then be any program that talks to the server? Perhaps it is referring to mysql, the command line tool? I understand client side programs, examples being: mysqladmin, mysqldump, and mysqlimport. These are known as mysql client commands also? Thank you, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Certification study quide from Dubois, Hinz and Pedersen
Hello Paul Dubois, Stefan Hinz, Carsten Pedersen, hello Mysql List, I was wondering if you guys would let me know about the release schedule of the MySQL Certification Study Guide which is about to be released - as announced on the UC 2 months ago. Any information much appreciated - no info on www.amazon.com so far. Best regards -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification study quide from Dubois, Hinz and Pedersen
offlist Hello Stefan, well I have my sources ... ;-) .. I guess its no secret ,especially as it was announced on the UC. I guess when you say Q3 you mean the english version, will there also be a german version ? If yes , when ? I am not asking to pin you down really I am asking so that I can make plans. I understand (unfortunately) that it is not you 3 guys deciding when it is released. As far as I understand you have finished the text and it is now in the process of proovereading perhaps and will then eventually come when the publisher thinks that it is a good time to marcet point, right ? Anyway to cut a long story short, I would appreciate if you could let me know the ISBN and publisher so that I can write it on my wish-list ;-) . Or ...Perhaps you could even give a hint to the publisher that I would also participate as a proove reader or beta-tester whatever described the position most. That would be marvelous, but we dont want to reach for the stars.. ;-) Best regards Nils Valentin Tokyo/Japan nils(at)knowd.co.jp 2003 6 10 00:31: Nils, Hello Paul Dubois, Stefan Hinz, Carsten Pedersen, Ah! How did you find out? ;-) I was wondering if you guys would let me know about the release schedule of the MySQL Certification Study Guide which is about to be released - as announced on the UC 2 months ago. Any information much appreciated - no info on www.amazon.com so far. I reckon the Study Guides will be in the bookstores end of Q3 -- don't pin me down on this. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification study quide from Dubois, Hinz and Pedersen
Hi Paul, 2003 6 10 01:26Paul DuBois : At 1:08 +0900 6/10/03, Nils Valentin wrote: offlist Hello Stefan, well I have my sources ... ;-) .. I guess its no secret ,especially as it was announced on the UC. I guess when you say Q3 you mean the english version, will there also be a german version ? If yes , when ? Any idea if and /or when there will be a german version ? I am not asking to pin you down really I am asking so that I can make plans. I understand (unfortunately) that it is not you 3 guys deciding when it is released. As far as I understand you have finished the text and it is now in the process of proovereading perhaps and will then eventually come when the publisher thinks that it is a good time to marcet point, right ? Speculation of any kind is unwarranted. Of course. Anyway to cut a long story short, I would appreciate if you could let me know the ISBN and publisher so that I can write it on my wish-list ;-) . I still I would appreciate if you could let me know the ISBN and publisher so that I can write it on my wish-list ;-) . Or ...Perhaps you could even give a hint to the publisher that I would also participate as a proove reader or beta-tester whatever described the position most. That would be marvelous, but we dont want to reach for the stars.. ;-) Best regards Nils Valentin Tokyo/Japan nils(at)knowd.co.jp 2003N 6 10 j 00:31A: Nils, Hello Paul Dubois, Stefan Hinz, Carsten Pedersen, Ah! How did you find out? ;-) I was wondering if you guys would let me know about the release schedule of the MySQL Certification Study Guide which is about to be released - as announced on the UC 2 months ago. Any information much appreciated - no info on www.amazon.com so far. I reckon the Study Guides will be in the bookstores end of Q3 -- don't pin me down on this. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: certification exam
John, Has anyone been successful in signing up for the certification exam? Yes. I took the exam (still beta at that time) November 26, in Berlin, Germany. I've entered dates going up to Jume 30,2003 to schedule an exam and all I get back is exam not available. The V.U.E. registration website sucks, and I reported this to the people in charge of the certification at MySQL AB. When I tried to register, I got similar responses like you. The responses said things like not yet available, not available between 0:00 and 24:00 h, not available before December 30th etc. Whatever I filled in looking for a test centre in Berlin yielded no positive result. I find this _very_ unprofessional. So, finally I decided to try it the good old way - by telephone. A mere 10 minutes later I had a date for the exam the following week. What the V.U.E. person on the phone told me is nearly unbelievable. She said that some test centers do not want their exams to be listed on the web site, or they do not want their possible exam times to be published. Maybe it's true that they do not want to earn money, but I cannot believe that at all. Sad but true: All I can suggest is, go to http://www.vue.com/contact/mysql/, find out the telephone number and give them a call. At least it's toll free :) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: John Coder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 28, 2002 12:44 AM Subject: certification exam sql, query, mysql,I'm a lumberjack and I'm ok for he spam police. Has anyone been successful in signing up for the certification exam? I've entered dates going up to Jume 30,2003 to schedule an exam and all I get back is exam not available. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
certification exam
sql, query, mysql,I'm a lumberjack and I'm ok for he spam police. Has anyone been successful in signing up for the certification exam? I've entered dates going up to Jume 30,2003 to schedule an exam and all I get back is exam not available. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Certification
Hi, I would like to know if are there any certification for MySQL like DBA Oracle or something like that? Grettings Alexander sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Certification
* Alexander Burbello I would like to know if are there any certification for MySQL like DBA Oracle or something like that? They are working on it: URL: http://www.mysql.com/certification/index.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Certification
Alexander, Thursday, November 14, 2002, 2:49:56 PM, you wrote: AB I would like to know if are there any certification for MySQL like DBA AB Oracle or something like that? Yes, MySQL AB is working on a certification program. Visit the following page for more details: http://www.mysql.com/certification/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql certification
Dough! They started behaving like big corporations already; certification, consulting, etc, etc. :-) --- Defryn, Guy [EMAIL PROTECTED] wrote: I was wondering if anybody heard about a possible release of books that help you prepare for the Mysql certification? Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Announce: Upcoming MySQL Certification program
Dear MySQL user, During 2002, MySQL AB will release two levels of official MySQL certification: MySQL Core Certification and MySQL Professional Certification. This e-mail describes the upcoming program as well as some of your opportunities. Contents 1. The MySQL Certification Program in 2002 - an overview 2. Certifications are for version 4.0 3. Go for Beta testing and get ahead of the crowd 4. The ultimate Certification Preparation: Official MySQL training 1. The MySQL Certification Program in 2002 - an overview MySQL AB is proud to announce the upcoming availability of two MySQL certifications: The MySQL Core Certification and the MySQL Professional Certification. The MySQL Core Certification is aimed at the professional MySQL user who wants proof of his or her prowess in the fields of SQL, data entry and maintenance, data extraction for reporting, etc. This certification will be released in the autumn of 2002. For more information on the MySQL Core Certification, see http://www.mysql.com/training/candguide/sec-core.html The MySQL Professional Certification is for the user who has more experience in the world of MySQL, and wants the credentials that prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. This certification will be released in late 2002. For preliminary information on this exam, see http://www.mysql.com/training/candguide/sec-prof.html The Core certification is a prerequisite for the Professional Certification: You must pass the Core exams before you are able to sign up for the Professional exam. Even though the Professional exam might be what you are eventually aiming for, you should start making plans for taking the Core exam already now. For general information on the MySQL Certification Program, see http://www.mysql.com/training/certification.html 2. Certifications are for Version 4.0 - Both certifications will certify your knowledge and competence for MySQL 4.0. There will not be a MySQL certification for version 3.23 or earlier releases. This should, however, not present any difficulties. The user view of the database has not changed significantly, and the extensions and enhancements in moving from MySQL 3.23 to MySQL 4.0 are clearly presented and documented on our website: http://www.mysql.com/products/mysql-4.0/index.html 3. Go for Beta testing and get ahead of the crowd - You now have the opportunity to sign up for our Beta test program for the MySQL Core Certification. Your benefits of taking part in the beta exam program include: * Beta exams and results are delivered well in advance of the official publication date -- you will hold your certification even before the program is officially launched! * Your MySQL Core Certificate is just as valid as a regular certificate delivered after the day of publication * Beta exams are offered at a considerable discount The downside is: You get to do more work (you must answer 2-3 times as many questions during a Beta exam), and you won't know whether you passed or failed until some weeks later. Once the program is officially launched, candidates get their test results as soon as the exam is completed. Read more about how to be part of our beta program on the MySQL Beta Certification page: http://www.mysql.com/training/beta.html 4. The ultimate Certification Preparation: MySQL training - MySQL Training will be invaluable to you in preparation for the certification exam. Learn more about MySQL than you ever thought possible, and ace the exam! Register for training now and be among the first MySQL users with a MySQL Core Certificate! https://order.mysql.com/ Regards, Carsten H. Pedersen MySQL AB Certification Manager -- MySQL Certifications, http://www.mysql.com/training/certification.html __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Carsten Pedersen [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Certification Manager /_/ /_/\_, /___/\___\_\___/ Haslev, Denmark ___/ www.mysql.com Office: +45 56 36 16 10 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql certification
I was wondering if anybody heard about a possible release of books that help you prepare for the Mysql certification? Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Complient Certification
Hi all, I want to know is there any certification saying that a particular package/program is MySQL complient...? Thank You in advance. Yasela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Complient Certification
Hi. On Fri, Dec 14, 2001 at 02:57:52PM +0600, [EMAIL PROTECTED] wrote: I want to know is there any certification saying that a particular package/program is MySQL complient...? I don't think so. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL Certification
There are courses, but there is no certification as yet, AFAIK. See http://mysql.com/training/ Sie schrieben am Samstag, 14. Juli 2001, 04:26:16: Is there some sort of mySQL certification course? sql -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php