Inserting and extracting relational data in Python
When you hear the word database, you probably picture a relational database – that is, a database made up of tables containing columns and rows with relationships between the tables; for example, a purchase order system that has inventory, purchases, and customer information. Relational databases have been around for over 40 years and come from the relational data model developed by E. F. Codd in the late 1970s. There are several vendors of relational databases – including IBM, Oracle, and Microsoft – but all of these databases use a similar dialect of SQL, which stands for Structured Query Language. In this book, you will work with a popular open source database – PostgreSQL. In the next section, you will learn how to create a database and tables.
Creating a PostgreSQL database and tables
In Chapter 2, Building Our Data Engineering Infrastructure, you created a database in PostgreSQL using pgAdmin...