Databases and ETL
The earner of this badge has completed a course of study focused on databases and ETL through the Data Analytics Boot Camp. The earner understands how data is stored in relational and non relational databases, SQL and MongoDB. The earner is able to query and modify databases, and organize data into well-structured and easily retrievable formats. The earner has learned the Extract, Transform, Load (ETL) process and applied it to real datasets.
- Data Analytics Boot Camp
Create complex SQL queries that return various data from across multiple tables in a database.
Create a climate analysis using Python and SQLAlchemy for a specific set of dates, creating plots for different variables such as precipitation and temperature.
Design a Flask API based on the queries developed in the climate analysis that returns data in JSON format.
Create a production database that combines 2 or more sources of data from either databases, APIs, or web scraping, and then perform the ETL process on the data in order to populate the production database along with a technical report on the entire process performed.