6. Importing and Exporting Data
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
pandas' advanced functionality for interacting with your database in Python.