Lectures List

What is MYSQL

MYSQL is an RDBMS (Relational Database Management System) software, which is used to manage data in the form of tables that is also called relation in a database.
The relational database was invented by E. F. Codd.

Database

The collection of tables is called a database.

Table

The collection of rows and columns is called a table.

Rows (Record)

A horizontal row in a table is also called a record because it is consists of a number of fields.

Fields (Attributes)

Vertical lines in a table are also called property.

MYSQL is using in vast forms, today most of the tech companies are using MYSQL like FACEBOOK, UBER, etc.

Some key points about which makes it more popular.

  • It is open-source software.
  • It is reliable, scalable, and easy to use.
  • It is a cross-platform RDBMS.

Every table in a database is represented entities like products, users, employees.

In a table, every row is uniquely identified using a key that is called the primary key.

In RDBMS two most popular keys are.

Primary Key

A key that specifies unique every record in a table.

Foreign Key

A key in another table matches with the primary key in another table, and a foreign key may not be unique.