Skip to content

👾 End of module activities for SQL, ETL and Data Warehouse

Notifications You must be signed in to change notification settings

trixzt/SQL_Bigquery_012024

Repository files navigation

💻 SQL, ETL, and DataWarehouse Module


In this repository, you’ll find the activities from the @Keepcoding course, which are part of the Big Data, Artificial Intelligence & Machine Learning bootcamp.

  • 🔍 clean.integer.txt
    A function that cleans integers if it finds null values and returns the value -999999.

  • 🔍 diagrama_meza_silvia.pdf
    Development of an entity-relationship diagram for an educational institution.

  • 🔍 ivr_detail.txt
    Code to generate a detailed table of a customer service IVR system.

  • 🔍 ivr_summary.txt
    Part of the ivr_detail table to create a new table summarizing the calls.

  • 🔍 kepp_bd.sql
    SQL code to simulate a bootcamp institution's database, created in PostgreSQL.

  • 🔍 script_bootcamp_meza_patricia.txt
    Database code in txt format.

Thank you for taking the time to read me.
I look forward to your feedback.


About

👾 End of module activities for SQL, ETL and Data Warehouse

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published