From the course: Effective Serialization with Python
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Challenge: ETL from XML to database - Python Tutorial
From the course: Effective Serialization with Python
Challenge: ETL from XML to database
(upbeat music) - [Instructor] Say you have a data of UFO sightings in XML format and you would like to load it to the database for easy query. This process is known as ETL, Extract Transform Load. You need to write the code inside the ETL function. It gets an XML file and an output database file and inserts all the records from the XML into the database returning how many records were inserted. Of course, you will need to write the database schema as well.