In this tutorial you will learn about the MySQL Introduction and its application with practical example.
What is Database?
MySQL is a open source Relational Database Management System. This is called relational database because all the data is stored into different tables and relations are established using different constraints like primary keys or other keys known as foreign keys.MySQL is very efficient,fast, reliable and flexible Database Management System. It provides a high performance and it is multithreaded and multiuser Relational Database management system.
A is a separate application that stores a collection of data. Every database management system has one or more distinct APIs for creating, accessing, managing, searching, and replicating the data it stores.
What Is Relational DataBase Management System (RDBMS):
RDBMS stands for Relational Database Management System. It is the system which manages your data structures in table format with fields,columns and rows. It also maintain the relation between one data to other data. To manage the relation between the data, it users primary key and foreign key concept.
- Implement a database with tables, columns, and indexes.
- Provides facility primary key, to uniquely identify the rows.
- Referential Integrity and constraints between rows of various tables.
- Creates indexes for quicker data retrieval
- Provides a virtual table creation in which sensitive data can be stored and simplified query can be applied.(views).
- Sharing a common column in two or more tables(primary key and foreign key)
- Provides multi user accessibility that can be controlled by individual users
- Interprets an SQL query and combines information from various tables.
- Database: A database is a collection of tables, with related data.
- Table: A table is a matrix with data. A table in a database looks like a simple spreadsheet.
- Column: One column (data element) contains data of one and the same kind, for example the column postcode.
- Row: A row or record is a group of related data
- Redundancy: Data replication enables to make the system faster.
- Primary Key: Primary key is the column of your table which can uniquely identify the row of that column
- Foreign Key: Is the column which is referencing to other table from this table. The foreign key of one table must be a primary key of the one it is referencing to.
- Compound Key: A compound key (composite key) is a key that consists of multiple columns, because one column is not sufficiently unique.
- Index: Index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns
- Referential Integrity: Referential Integrity assure that a foreign key value always points to an existing row.
MySQL is a fast, easy-to-use RDBMS used being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons.
Feature Of MySQL:
- MySQL is an open-source RDMS.
- MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
- MySQL uses a standard form of the well-known SQL data language.
- MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA etc.
- MySQL works very quickly and works well even with large data sets.
- MySQL is very friendly to PHP, the most popular language for web development.
- MySQL supports large databases. The default file size limit for a table is 4GB, but you can increase this.
- MySQL is customizable.
Advantages Of MySQL:
- It’s easy to use: While a basic knowledge of SQL is required, MySQL is very easy to use. With only a few simple SQL statements, you can build and interact with MySQL.
- It’s secure: MySQL includes solid data security layers that protect sensitive data from intruders. Rights can be set to allow some or all privileges to individuals. Passwords are encrypted.
- It’s inexpensive
- It’s fast: In the interest of speed.
- It’s scalable: MySQL can handle almost any amount of data, up to as much as 50 million rows or more.
- It manages memory very well
- It runs on many operating systems: MySQL runs on many operating systems, including Novell NetWare, Windows* Linux*, many varieties of UNIX* (such as Sun* Solaris*, AIX, and DEC* UNIX), OS/2, FreeBSD*, and others.
- It supports several development interfaces: Development interfaces include JDBC, ODBC, and scripting (PHP and Perl), letting you create database solutions that run not only in your NetWare 6.5 environment, but across all major platforms, including Linux, UNIX, and Windows.
Prerequisites To Learn MySQL:
Before you begin this tutorial you must have basic knowledge of SQL.