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 ...

Get Python Real-World Projects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.