6. Importing and Exporting Data
Overview
In this chapter, you will learn techniques that will help you move data between your database and analytics tools. You will start by learning about the psql tool, which will enable you to quickly query data from a database. With psql, you can also leverage the COPY command, which allows the efficient importing and exporting of data. With these simple tools, you will be able to interact with the database and efficiently move data back and forth. Further, you will process and analyze data using Python. You will also explore Python libraries such as SQLAlchemy and pandas' advanced functionality for interacting with your database in Python.
Introduction
To extract insights from your database, you need ...
Get SQL for Data Analytics - Third 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.
