Intro to MySQL
Starting from this lesson we begin to learn mysql database management system and SQL (structure query language). Today we start from basics. Database is complex data which stores in a certain way for further search and management this data.
Database management system is set of software for working with database.
There are two databases types: relational database and non-relational (NoSQL) databases. In NoSQL databases developers management data without sql queries.
Now we’ll talking about MySQL in details. You can download mysql installer from MySQL site. If you use local environment server such as openserver or wampserver they already have necessary tools for work with databases.
MySQL has got two engines: MyISAM and INNOdb. What do you choose? If you are not experienced developer, you can choose INNOdb. There are a lot of differences in these engines. I notice the most important:
- INNOdb has got transactions mechanism. MyISAM has not. Transaction is mechanism which allows to rollback data if some error occured.
- INNOdb has got foreign keys.
Necessity of foreign keys we will discuss in next lesson.
Next we’ll create first database and first table.