What is Database?
Database is the place where we store our data in computer or servers.
What is DBMS?
DBMS is the database managnment system which are used to insertion, deletion and updation of data into database.
What is RDBMS?
A Relational DataBase Management System (RDBMS) is a software that :
-Enables you to implement a database with tables, columns and indexes.
-Guarantees the Referential Integrity between rows of various tables.
-Updates the indexes automatically.
-Interprets an SQL query and combines information from various tables.
What is SQL?
-SQL stands for the structured Query language which work as a tool used for manipulate the database or database tables.
What is MYSQL ?
-MySQL is the most popular Open Source Relational SQL Database Management System.
-MySQL is one of the best RDBMS(Relational Database Managnment System) being used for developing various web-based software applications.
-MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company.
MySQL :
- MySQL is a very fast to access and to deal with the databases by the programming languages.
- Easy to use RDBMS(Relational database management system) being used for many big & small businesses.
MySQL is becoming so popular because of many good reasons:
-We not need to pay anything whie using Mysql because it is open source platform.
-It work on many operating systems like windows, unix and linux etc. and with supporting of many languages including PHP, PYTHON,JAVA, PERL C, C++, JAVA etc.
-MySQL is a powerful langauge on its own ways. It handles a huge subset of the functionality of the very expensive and powerful database library or package.
-MySQL is customizable.
-The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.
-MySQL quickly works and also good with large database or datasets.
-MySQL is mostly used by PHP because it is easy in PHP, and PHP is the common language for web development.
-MySQL supports very large databases, up to 50 million rows or more in a table.