SQL in MySQL: Learn and Practice

MySQL is a relatively open source Relational database management systems (RDBMs), a concept invented by IBM researcher Edgar Frank Codd in 1970. The programming language SQL is the primary tool used to communicate with your MySQL database. You can add, change, and extract data using Structured Query Language (SQL).

One has to write application programs to access data in case of a file system. However, for database management systems there are special kind of programming languages called query language that can be used to access data from the database. The Structured Query Language (SQL) is the most popular query language used by major relational database management systems such as MySQL, ORACLE, SQL Server, etc.

A MySQL installation has two components: a server that manages the data, and clients that ask the server to do things with the data, such as change entries or provide reports.

A MySQL database server contains many databases (or schemas). Each database consists of one or more tables. A table is made up of columns (or fields) and rows (records).

SQL provides commands for defining the relation schemas, modifying relation schemas and deleting relations. These are called Data Definition Language (DDL) through which the set of relations are specified, including their schema, data type for each attribute, the constraints as well as the security and access related authorizations. Data definition starts with the create statement.