SQL Databases

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: