Chapter 5
Data Acquisition Features: SQL Database
In this chapter, you will be guided through two projects that demonstrate how to work with SQL databases as a source of data for analysis. This will build on the foundational application built in the previous two chapters.
This chapter will focus on SQL extracts. Since enterprise SQL databases tend to be very private, we’ll guide the reader through creating an SQLite database first. This database will be a stand-in for a private enterprise database. Once there’s a database available, we will look at extracting data from the database.
This chapter’s projects cover the following essential skills:
Building SQL databases.
Extracting data from SQL databases.
The first project will build a SQL database for use by the second project.
In an enterprise environment, the source databases will already exist.
On our own personal computers, these databases don’t exist. For this reason, we’ll build a database...
