Introduction to Databases in Python

A database (abbreviated DB) is a place where website data is stored. This could be page texts, user lists with their logins and passwords, product catalogs, etc.

The database consists of tables. You know from life what a table is: it is rows and columns. And at the intersection of rows and columns are cells.

In databases, columns are often referred to as fields, and rows are referred to as records.

The database itself is a program that stores data and allows this data to be retrieved and modified.

Receiving and changing data is done using queries. Queries are commands written in a special language - SQL.

Working with databases via Python is not particularly difficult. The only thing that can cause problems is the long initial preparatory stage, which will stretch over several lessons. But after that, everything will become much easier.

SQL DBs work on different engines. The most popular of them are:

• Mysql
• Oracle
• PostgreSQL
• Microsoft SQL Server

In further lessons all examples will be based on working with the Mysql engine.