sam15
asked on
MySQL_Development_Traininng..
I am an oracle developer for last 10 years trying to get experienced with MySQL for some database conversion project.
Few questions:
1) How long do you think it would it take to learn to write database code in MySQL like stored procedures, triggers, etc (i.e ability to rewrite oracle SP (pl/sql) into MySQL SP).
I think the SQL syntax should be similar in both platforms.
2) I could not find any live training courses offered by oracle in our area.
Would a MySQL virtual training course for 4 days work the same and be worth it (about 2k)?
3) Do you know of any good online training sites that offer MySQL training courses?
Thanks,
Few questions:
1) How long do you think it would it take to learn to write database code in MySQL like stored procedures, triggers, etc (i.e ability to rewrite oracle SP (pl/sql) into MySQL SP).
I think the SQL syntax should be similar in both platforms.
2) I could not find any live training courses offered by oracle in our area.
Would a MySQL virtual training course for 4 days work the same and be worth it (about 2k)?
3) Do you know of any good online training sites that offer MySQL training courses?
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Everything you seek is in the online documentation:
https://dev.mysql.com/doc/
Specific to procedures:
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
Short answer: No, they aren't interchangeable in any way. Can you convert COBOL to C++? Sure, just rewrite it. Same with Stored code between databases. Many times a direct porting attempt isn't the best solution.
https://dev.mysql.com/doc/
Specific to procedures:
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
Short answer: No, they aren't interchangeable in any way. Can you convert COBOL to C++? Sure, just rewrite it. Same with Stored code between databases. Many times a direct porting attempt isn't the best solution.
ASKER
It does not seem there is a name for MySQL programming procedural language like oracle.
Is the SQL code the same syntax for both databases? Can it be transported?
Is the SQL code the same syntax for both databases? Can it be transported?
>> like oracle.
I wouldn't really call PL/SQL a "name". If you want to get specific, call it Ada:
https://en.wikipedia.org/wiki/Ada_(programming_language)
>>Is the SQL code the same syntax for both databases? Can it be transported?
See my comment above: No.
All databases that use SQL have the same basic constructs but it is rare that you can just copy SQL from one and expect it to run without changes in another.
Try between Access and Oracle? SQL Server and Access are close because they have the same parent company but I bet you still cannot copy/paste between them 100% of the time since they have different database engines underneath.
I wouldn't really call PL/SQL a "name". If you want to get specific, call it Ada:
https://en.wikipedia.org/wiki/Ada_(programming_language)
>>Is the SQL code the same syntax for both databases? Can it be transported?
See my comment above: No.
All databases that use SQL have the same basic constructs but it is rare that you can just copy SQL from one and expect it to run without changes in another.
Try between Access and Oracle? SQL Server and Access are close because they have the same parent company but I bet you still cannot copy/paste between them 100% of the time since they have different database engines underneath.
ASKER
PL/SQL is the name. Just search for Pl/SQL on amazon and see how many books on that PL/SQL programming language.
Ada is an old obsolete language now. I don't thin MySQL has anything to do with it.
I was trying to find a book on just the MySQL programming language.
Ada is an old obsolete language now. I don't thin MySQL has anything to do with it.
I was trying to find a book on just the MySQL programming language.
>> I don't thin MySQL has anything to do with it.
No MySQL, Oracle. PL/SQL is ADA. So, how obsolete is it?
>>PL/SQL is the name.
I understand that is what it goes by but "Procedural Language/Structured Query Language" really doesn't make much sense to me.
>>I was trying to find a book on just the MySQL programming language.
They are called "Routines". I cannot say how good it is but I found this one on Amazon:
https://www.amazon.com/MySQL-Stored-Routines-Procedures-Functions-ebook/dp/B00NUS1FUS/ref=sr_1_1?ie=UTF8&qid=1495230326&sr=8-1&keywords=mysql+routines
No MySQL, Oracle. PL/SQL is ADA. So, how obsolete is it?
>>PL/SQL is the name.
I understand that is what it goes by but "Procedural Language/Structured Query Language" really doesn't make much sense to me.
>>I was trying to find a book on just the MySQL programming language.
They are called "Routines". I cannot say how good it is but I found this one on Amazon:
https://www.amazon.com/MySQL-Stored-Routines-Procedures-Functions-ebook/dp/B00NUS1FUS/ref=sr_1_1?ie=UTF8&qid=1495230326&sr=8-1&keywords=mysql+routines
ASKER
I think oracle is written mostly using C and C++.
I found these 2 books which seem to have much more info on the SQL and stored procedure of MySQL
https://www.amazon.com/MySQL-Stored-Procedure-Programming-High-Performance/dp/0596100892/ref=pd_lutyp_cxhsh_1_1?_encoding=UTF8&pd_rd_i=0596100892&pd_rd_r=SFWN072CYG0J8NY3EA88&pd_rd_w=TwMlE&pd_rd_wg=5my6T&psc=1&refRID=SFWN072CYG0J8NY3EA88
https://www.amazon.com/Murachs-MySQL-2nd-Joel-Murach/dp/1890774820/ref=pd_lutyp_simh_2_2?_encoding=UTF8&pd_rd_i=1890774820&pd_rd_r=SFWN072CYG0J8NY3EA88&pd_rd_w=ansvI&pd_rd_wg=5my6T&psc=1&refRID=SFWN072CYG0J8NY3EA88
Since you are an expert in both databases. How long did it take you to program in MySQL and become proficient in MySQL database?
It seems to be easier to learn than oracle.
I found these 2 books which seem to have much more info on the SQL and stored procedure of MySQL
https://www.amazon.com/MySQL-Stored-Procedure-Programming-High-Performance/dp/0596100892/ref=pd_lutyp_cxhsh_1_1?_encoding=UTF8&pd_rd_i=0596100892&pd_rd_r=SFWN072CYG0J8NY3EA88&pd_rd_w=TwMlE&pd_rd_wg=5my6T&psc=1&refRID=SFWN072CYG0J8NY3EA88
https://www.amazon.com/Murachs-MySQL-2nd-Joel-Murach/dp/1890774820/ref=pd_lutyp_simh_2_2?_encoding=UTF8&pd_rd_i=1890774820&pd_rd_r=SFWN072CYG0J8NY3EA88&pd_rd_w=ansvI&pd_rd_wg=5my6T&psc=1&refRID=SFWN072CYG0J8NY3EA88
Since you are an expert in both databases. How long did it take you to program in MySQL and become proficient in MySQL database?
It seems to be easier to learn than oracle.
>>I think oracle is written mostly using C and C++.
You are missing what I'm saying.
The Oracle software itself, correct. The PL/SQL programming language is Ada. Go look at some Ada code examples.
This look familiar:
http://sandbox.mc.edu/~bennet/ada/examples/hello_adb.html
Many more examples here:
http://sandbox.mc.edu/~bennet/ada/examples/
>>Since you are an expert in both databases.
I'm not an Expert in MySQL. I took a week of online training and have experimented with it. I've never developed anything that went into production so I'm not sure how it would perform.
You are missing what I'm saying.
The Oracle software itself, correct. The PL/SQL programming language is Ada. Go look at some Ada code examples.
This look familiar:
http://sandbox.mc.edu/~bennet/ada/examples/hello_adb.html
Many more examples here:
http://sandbox.mc.edu/~bennet/ada/examples/
>>Since you are an expert in both databases.
I'm not an Expert in MySQL. I took a week of online training and have experimented with it. I've never developed anything that went into production so I'm not sure how it would perform.
ASKER
Excellent information.
ASKER
What language does MySQL use? Is the SQL embedded in oracle and MySQL the same syntax and can be converted from one SP to another?
My understanding is that MySQL is somehow primitive compared to oracle and similar in features to Oracle 7 or 8? Is this accurate.