GitHub

Data Engineering Project: SQL and Python ETL Pipeline

Design and implement an end-to-end ETL (Extract, Transform, Load) pipeline using SQL for data extraction and transformation, and Python for orchestration and automation. Use any open dataset (e.g., ...
IEEE

Next-Generation Database Interfaces: A Survey of LLM-Based Text-to-SQL

Abstract: Generating accurate SQL from users’ natural language questions (text-to-SQL) remains a long-standing challenge due to the complexities involved in user question understanding, database ...
GitHub

jasonjlcl/End-to-End-DWBI-with-Snowflake-Python-SQL-Power-BI

End‑to‑End DWBI Project Overview Built a scalable, maintainable pipeline—from data modeling through synthetic data generation and automated Snowflake ingestion to interactive Power BI dashboards—using ...
University of Vermont

A brief introduction to databases with SQLite

We have seen how to read data from a file, either in unstructured text or CSV format, and how to write data in these formats. We’ve also seen how to read and write JSON. In this chapter we’ll see how ...