8. RDBMS and SQL
Overview
This chapter will introduce you to the basics of using an RDBMS to query a database using Python and convert data from SQL and then store it in a pandas DataFrame. It will explain the concepts of databases, including their creation, manipulation, and control, and how to transform tables into pandas DataFrames. By the end of this chapter, you will learn some basic SQL commands. This knowledge will make you adept at adding, updating, retrieving, and deleting data from databases; another valuable skill in a budding data wrangling expert's repertoire.
Introduction
This chapter of our data journey is focused on Relational Database Management System (RDBMS) and Structured Query Language (SQL). In the previous chapter, ...
Get The Data Wrangling Workshop - Second Edition 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.
