Simple Guide to Follow to Learn MySQL

This goes for a friend who asked me to make this for him.

Python is very specific and is very open to most of the problems. MySQL on the other hand is very specific to data storage. Hence it requires not just problem solving but also experience to do it better. You can create the same database differently using different experiences.

So what is MySQL?

MySQL is an open-source SQL database management system. Due to its open-source nature, it is widely used to create other application that Manage Databases. (source: www.mysql.com)

The source website is great if you want to know the literature of MySQL. If you want to code in MySQL, there is nothing specific but first learning MySQL basics like:

1. Learn Query Creation
2. Learn DBMS and Relational Algebra
3. Tutorial Point for overview/revising
4. Practice with real life scenarios
5. MySQL detailed Literature

P.S: I have not followed this path for myself. I followed this book

Discuss the difference between the InnoDb and MyISAM. Why would you use one over the other when creating a table?

InnoDB and MyISAM are both storage engines for MySQL with their Pros and Cons.
InnoDB:
  1. gives ACID property with transaction support.
  2. Lock are integerated at row level such that a query working on one row will not lock the entire table from letting other query work on other row.
  3. Supports Foriegn Key constraints
  4. Resistive to table corruption
  5. buffer pools and indexes are very large

MyISAM:
  1. Supports full text search
  2. Easy to learn for beginners
  3. Faster than InnoDB due to table level locks
  4. Completey read intensive.

MyISAM is used when your application doesn't have too many CRUD operations, which in later stages of application development may become troublesome to manage. Although obsolete, MyISAM is still preffered for development of many applications due to its speed.
On the other hand, InnoDB is more secure and reliable in terms of data protection. Due to row level locks, all the ACID and CRUD operations can be performed smoothly without worrying about locks on table. Although  previous versions of InnoDB did not support full-text search feature, MySQL 5.6 and above have incorporated this feature. This allows full text search features to be built effectively and creatively in the application.


Original from CoachCrocodile