From the course: Data Engineering Foundations
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Challenge: Loading data
From the course: Data Engineering Foundations
Challenge: Loading data
(upbeat music) - [Narrator] So you have learned how to load a data frame back to the database. So here's another quick challenge for you. You have to fill in these blanks with the right parameters or functions to make the loading possible. So, first of all, you'd have to mention the mode that you're going to use to load the data frame back to the database. Then you have to provide the right data frame function to load the data frame back to the database. And then lastly, you would have to pass the right arguments to the transform average ratings function in order to aggregate the data. And at last, use this aggregated data frame and call the loading function that you have defined above and load it back to the database by providing the right data frame in the arguments. So, best of luck.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Sources of data extraction4m 46s
-
(Locked)
Data extraction from a PostgreSQL database6m 55s
-
(Locked)
Challenge: Data extraction40s
-
(Locked)
Solution: Data extraction51s
-
(Locked)
Transforming data2m 3s
-
(Locked)
Challenge: Transforming data42s
-
(Locked)
Solution: Transforming data58s
-
(Locked)
Loading data into a DB4m 11s
-
(Locked)
Challenge: Loading data59s
-
(Locked)
Solution: Loading data1m
-
(Locked)
Scheduling ETL pipeline using Airflow9m 3s
-
(Locked)
-