6. Importing and Exporting Data

Learning Objectives

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

  • Use psql at the command line to efficiently interact with your database
  • Use the COPY command to upload data to your database in bulk
  • Use Excel to process data from your database
  • Simplify your code using SQLAlchemy in Python
  • Upload and download data to and from your database in bulk with R and Python

This chapter covers how to move data between your database and other analytics processing pipelines.

Introduction

In order to extract insights from your database, you need data. And, while it's possible that some of that data will be populated and updated for you, there are always going to be scenarios where you need more data that is not ...

Get SQL for Data Analytics 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.