Hello, and welcome to the last part of our course!
In this part, you'll complete practical tasks and exercises to apply what you learned in this course: variables, functions, exception handling, etc.
During this quiz, you'll create new functions that implement ETL processes for a newsletter subscription system. ETL is short for Extract, Transform, and Load processes used to collect data from various sources, transform the data, and load it into a destination data store. In practice, the destination data store is a data warehouse – a large store of data accumulated from a wide range of sources within a company and used to guide management decisions.
In this part, we'll be working with a sample database that contains
Let's review the core database table. The first table we're going to work with is
log. This table stores our custom log messages for various events, such as:
- The start of a process.
- The end of a process.
- A description of an error that was thrown.
- And the number of record insertions, deletions, and updates that took place while the database was running.