Home/

...

/

SQL Databases

SQL Databases

An overview of the most common relational database management system.

In the previous lesson, we discussed the role of database management systems in web development and learned that one type of DBMS is SQL. Now, we will discuss popular SQL Database Management Systems that are available to use in web development.

MySQL #

MySQL is amongst the most commonly used database management systems, and it has formed an integral part of most web applications in the past. MySQL is backed by Oracle and uses Standard Query Language (SQL) to store data in the form of a table, and to retrieve data requires making queries in SQL. MySQL, unlike SQL itself, works across all platforms, including Linux, iOS, and Windows and it has all the simplicity of SQL as it does not require any new syntax to be learned once you know SQL. Let’s look at an example of a MySQL query that creates a new table:

Press + to interact
CREATE TABLE [IF NOT EXISTS] table_name(
    column1 DATATYPE,
    column2 DATATYPE,
    column3 DATATYPE,
    column4 DATATYPE,
    PRIMARY KEY (column1)
) ENGINE=storage_engine

As is clear from the example above, MySQL uses basic SQL queries to create tables and handle ...