Chapter 8

RDBMS and SQL

Learning Objectives

By the end of this chapter, you will be able to:

  • Apply the basics of RDBMS to query databases using Python
  • Convert data from SQL into a pandas DataFrame

This chapter explains the concepts of databases, including their creation, manipulation and control, and transforming tables into pandas DataFrames.

Introduction

This chapter of our data journey is focused on RDBMS (Relational Database Management Systems) and SQL (Structured Query Language). In the previous chapter, we stored and read data from a file. In this chapter, we will read structured data, design access to the data, and create query interfaces for databases.

Data has been stored in RDBMS format for years. The reasons behind it are ...

Get Data Wrangling with Python 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.