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.