Skip to Main Content
The Data Wrangling Workshop - Second Edition
book

The Data Wrangling Workshop - Second Edition

by Brian Lipp, Shubhadeep Roychowdhury, Dr. Tirthajyoti Sarkar, John Wesley Doyle, Harshil Jain, Robert Thas John, Akshay Khare, Nagendra Nagaraj, Samik Sen, Dr. Vlad Sebastian Ionescu
July 2020
Beginner to intermediate content levelBeginner to intermediate
576 pages
9h 12m
English
Packt Publishing
Content preview from The Data Wrangling Workshop - Second Edition

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

The Data Analysis Workshop

The Data Analysis Workshop

Gururajan Govindan, Shubhangi Hora, Konstantin Palagachev, Brent Broadnax, John Wesley Doyle, Ashish Jain, Robert Thas John, Ravi Ranjan Prasad Karn, Pritesh Tiwari
The Data Visualization Workshop

The Data Visualization Workshop

Mario Döbler, Tim Großmann, Rohan Chikorde, Joshua Görner, Anshu Kumar, Piotr Malak, Ankit Verma
The Data Science Workshop - Second Edition

The Data Science Workshop - Second Edition

Anthony So, Thomas Joseph, Robert Thas John, Andrew Worsley, Dr. Samuel Asare
The Machine Learning Workshop - Second Edition

The Machine Learning Workshop - Second Edition

Hyatt Saleh, John Wesley Doyle, Akshat Gupta, Harshil Jain, Vikraman Karunanidhi, Subhojit Mukherjee, Madhav Pandya, Subhash Sundaravadivelu

Publisher Resources

ISBN: 9781839215001Supplemental Content