Building databases

Along with querying and combining tables in SQL, building a SQL database takes care. In order to practice building a SQL database, we will work with DuckDB. DuckDB is a platform that creates a local server (on your own computer) and uses syntax which is slightly different from MySQL.

In Chapter 5 we walk through creating a database using DuckDB. We note that some of the syntax is identical to MySQL and other syntax is different. Keys, indices, and partitioning help optimize the database for efficient querying.

With an existing database, Chapter 6 walks through how to UPDATE, INSERT, and REPLACE data. Additionally, temporary tables are used to break down complicated queries into shorter more succinct queries.