In this repository, you will find the solution to the exercises of the final exam of module 2 of the Adalab Data Analysis Bootcamp, carried out by the student Carla Biscotti. The content of Module 2 is decribed below:
- ✔️ API: understand what an API, how to use them and what they are useful for.
- ✔️ Data processing: handle the results of a json for cleaning and data extraction.
- ✔️ Web scrapping: know how to extract data using Beautiful Soup and Selenium.
- ✔️ Understanding of SQL and managing the basic queries: SELECT; UPDATE; DELETE; INSERT; "ALTER TABLE¨, DROP TABLE, etc.
- ✔️ Use of agregated functions, GROUP BY, where and HAVING functions
- ✔️ Use of JOINS (including UNION and UNION ALL)
- ✔️ Mastering the use of SUBQUERIES and CORRELATED SUBQUERIES
- ✔️ Use of COMMON TABLE EXPRESSIONS (CTEs)
- Scope of exam: the assessment consists of a series of questions that test the understanding of the student and skills in relation to SQL
- Database to be used: SAKILA DATABASE
- Technical interview: after the exam, the student defends it during an individual technical interview with the teacher.
- Exam statement: exam_statement.txt
- Exam resolution: module_2_final_evaluation_carla.sql
- MySQL Workbench and SQL
- My teacher during this module, César Valle, for his dedication and patiance. Also a special mention to Carla Álvarez López, for her support and Git Master Class 🌱.
- My teammates from promotion Inez Vázquez, for their support and for making this journey an enjoyable one.
- Adalab for granting the Bootcamp.
- My family and friends for their support✨.
Learn more about the bootcamp at https://adalab.es/