From the course: Data Engineering Foundations

Schalten Sie den kompletten Kurs noch heute frei

Join today to access over 23,300 courses taught by industry experts.

Data extraction from a PostgreSQL database

Data extraction from a PostgreSQL database

From the course: Data Engineering Foundations

Start my 1-month free trial Buy for my team

Data extraction from a PostgreSQL database

"

- [Instructor] So let's apply our knowledge to a practical project. Here's an example of a movie rating application. I have Movies Data and I have Users Data. In the movies.csv, you see I have ID of the movie, name, description and the category to which that movie belongs to. Similarly, I have Users. Users.csv contains ID of the user, the movie ID that the user is rating, and finally, the rating that the user has provided. On the job, you will be given access to an already existing database. But here, we'll have to set up our database from scratch. So let's quickly do that. The installation process is already provided in the Resources, so you can defer to that document, in order to download and install PostgreSQL onto your systems. Now the first step is to start your Postgres Server. The command for that is psql postgres. Hit Enter, now your Postgres Server is running. Now the next step is to create the database. The command for that is CREATE DATABASE, and then the name of the…

Inhalt