Let's now look at how to perform data engineering with SQLite. First, we have to create our tables in the database. Then, we will manipulate them, one by one, to get the desired final table.
Data engineering, one table at a time with SQL
Query Set #0 – creating the six tables
In this mock assignment, let's pretend that the portal at which the data can be downloaded from the cardiology practice is not working. Instead, one of the technicians sends you SQLite commands that you can use to create the six tables. You can follow along with the book and type each command manually. Alternatively, you can go to the book's official code repository and download the commands from there.
