This project demonstrates an end-to-end data pipeline that transforms a raw accounts receivable (AR) dataset into a structured, queryable SQL database — showcasing skills across Python data ...

The mssql-python driver automatically maps Python data types to SQL Server types when sending parameters and converts SQL Server types to Python types when retrieving results.

Transient failures are temporary errors that can occur when connecting to SQL Server and Azure SQL through the mssql-python driver. These errors often resolve on their own: Network connectivity blips.

I have created a command-line tool that uses DuckDB in Python to perform SQL searches directly on sales data CSVs and displays the results in the terminal as Rich tables. I have compiled a ...

An end-to-end data analytics portfolio project exploring customer shopping behavior using Python in Jupyter Notebook, Microsoft SQL Server with SQL Server Management Studio (SSMS) 22, and Power BI ...

Introducing Widgets, designed to support consistency and help you build a lasting coding habit, one day at a time. Widgets help you stay consistent by making daily learning progress visible at a ...