Hi frnds..

Currently i am working as a php developer.i know php,mysql and smarty...
i am interested to change my domain from web developer to mysql admin..
plz give me some suggestions to me...

how can i need to follow? and where can i get information regarding mysql totally.....what should learn mandatory...


sry 4 posting this query in this php forums....try to understand my english...

Thanks
saritha..

why you want to change your working line? But if you are interested you should be strong in Database systems and RDBMS. Learn about it from internet.

Hello Saritha..

I am having so many materials and ebooks on PHP & MYSQL and combined.

If u need, feel free to mail me. <EMAIL SNIPPED>.

Regards
Bhanu

www.mysql.com should be where you should be looking for all materials. Reading about, working with and trying out different things is what would be the best possible approach for gathering knowledge.

So download the MySQL Server, install it (following the guidelines mentioned in the reference manual) and start working out different things with it. MySQL Server's reference manual is considered to be the best source of information about it. It is more than 2000 pages long, with detailed information about the internal working of all things. You can download the manual from the site's documentation pages. Working with the reference manual you can try out the different configurations of the server and get to know which is best suited for what type of use, you can learn about all the data types and how to use the disk space judiciously by assigning the best suited data type for a parameter, you can find out the different storage engines or tables types and what typr of locking mechanism do they use, figure out which storage engine is capable of doing what and hence when to use which, the manual also lists about optimizations that could be done so that your database achieves best performace and a lot of other things that informs you about the best practices of operating a MySQL Server.

You could also look at the Certifications offered by MySQL, these are a way of assurance of your knowlegde to a prospective employer. So you could prepare for and appear for certifications exams. Information about certifications is put on the site too, they also recommend books for certifications and for general reading too.

Lastly you need to be aware that gaining detailed knowledge and masterful insights about all modules of such a huge project is never going to be an overnight activity, so you need to have patience and perseverance and all along you would need to be constantly working with the server this would help in your overall familiarity about the server.

Yes verruckt24 , its correct .
I have, PHP.MYSQL.ebook.collection[ENG][PDF.CHM] files.
These are very user friendly.

Like
1. AJAX And PHP -Building Responsive Web Applications (2006).pdf
2. Creating Your MySQL Database - Practical Design Tips and Techniques.pdf
3. PHP & MySQL For Dummies, 2nd Edition (2004).pdf
4. Learning PHP & MySQL (2006).chm
and so on.

Hi frnds...

Thanks to all...
I am really happy ..i didnt expect these many responses....
Present i know only PHP and MYSQL...till now i worked only on core projects...there is no projects on advance technology like JOOMLA,SMARTY,etc...

Plz suggest me which is the best technology to get good job in present situation...


Thanks once again....

Are you doing projects or doing job??
Do you need that materials ??

Regards
Bhanu

Hi ..

I am doing Job..plz send me that materials..