Developed and Reviewed Database and Data Science Exercises

2 min read

Developed and Reviewed Database and Data Science Exercises

  • Day: 2025-03-10
  • Time: 11:00 to 11:30
  • Project: Teaching
  • Workspace: WP 1: Strategic / Growth & Development
  • Status: Completed
  • Priority: MEDIUM
  • Assignee: Matías Nehuen Iglesias
  • Tags: Database Management, SQL, Data Visualization, Python, Education

Description

Session Goal

The session aimed at developing and reviewing exercises related to database management and data science, focusing on SQL operations, data integrity, and [[data visualization]].

Key Activities

  • Database Management: Developed exercises for managing airline reservations, including updating reservations, verifying constraints, and analyzing data integrity.
  • Foreign Keys Identification: Created exercises for identifying foreign keys and proposing integrity constraints in database schemas.
  • SQL Queries and Updates: Designed exercises for practicing advanced SQL queries and update operations in relational databases.
  • Data Analysis and Visualization: Developed exercises for data processing and visualization using Python, Pandas, and Plotnine, focusing on datasets about serial killers.
  • Code Review: Reviewed code for [[data visualization]] using Plotnine, including normalization, rankings, and polynomial fitting.

Achievements

  • Successfully created a series of educational exercises covering database management and data science topics.
  • Reviewed and provided insights on [[data visualization]] code, enhancing the learning material.

Pending Tasks

  • Further refinement of exercises to ensure clarity and alignment with educational goals.
  • Additional review sessions for the developed code to ensure accuracy and pedagogical value.

Evidence

  • source_file=2025-03-10.sessions.jsonl, line_number=3, event_count=0, session_id=98ca49f4afb88cd51aba043f004b78f9cd4048abb8b38727e9ce6ebc49edf8ca
  • event_ids: []

Graph View

Backlinks