Most databases are organized using relational models. A relational database consists of one or more related tables of information, and the relationship between information in different tables is described using keys. Conventionally, these databases are managed using the Database Management System (DBMS), software which interacts with end users, different applications, and the database itself to capture and analyze data. Commercially available DBMSes use Structured Query Language (SQL) to access and manipulate databases. We can also use Python to access relational databases. In this section, we will explore SQLite and MySQL, two very popular database engines that work with Python.
SQL data
The SQLite database engine
According...