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.