Introduction of Mysql and its features

 

Summary

In this tutorial we will learn aboutintroduction of mysql. Also we will learn about what is database,type of database, what is mysql, advantages or we can sayfeatures of mysql.

What is database

Database is collection of datas which will stored in the organized manners in database and it will be easily accessed by database admin.

Lets take an example to explain database. Suppose in a school there will be many students and each student has name , age ,roll no so school authority collects each and every record from every student and store all datas into a database. Therefore we can access each and every students data in organized manner and if required we can view ,modify and delete the particular data from the database.

Type of database

Now we have learned what is database. Now we will learn type of database. There is two types of database one is relational database and other is no sql database.
Relational database will stored the data in structure manner and it will be easy to understand and easy to access. Relational database usesSQL (structured query languages). Example of the  relational  is oracle,mysql,postgresql.

Introduction of MySql

No SQL database will not stored data in structured manner . It will stored data in document format. It will no used SQL language.It can not be maintain any relation between table like relational database. Example of noSQL database is mongodb.
 

What is  Mysql

MySQL is free and open source most popular and well known relational database management system all over the world. It is used for various web based software application.Mysql can be integrated with php,java and many others programming languages.Mysql has cross platform feature means we can use / install mysql server in windows,linux and mac operating system.
 

Advantage of Mysql

1. Mysql is a free and open source database . so that we can download mysql free.
2.  Mysql is relational database management system  because in one mysql database there will be many tables and each table has a relation with the other table.
3.  Mysql supports cross platform because we can use mysql in  the various operating system like Windows , linux and mac operating system.
4.  Mysql stores data in the structured manner using sql language.
5.  Mysql is very fast, reliable and scalable database . mysql can handle small site as well as large sites due to its scalability.
6.  Mysql supports many programming languages like php,java and so on.
7.  Mysql is very secure database.
8.  Mysql database is used by many big companies like google,facebook etc.
9.  Mysql supports roll back and commit operation.
10.  Moreover mysql is easy to learn.

 

Conclusion

In this tutorial we have learned about introduction of mysql. Also we have learned about what is database,type of database, what is mysql, advantage or we can sayfeatures of mysql.

In next article we will learn how to install mysql in linux. 

SHARE

Admin

• 
• 
• 
• 
•