Creating Dynamic Pivots on Snowflake Tables with dbt medium.com Post date November 14, 2024 No Comments on Creating Dynamic Pivots on Snowflake Tables with dbt External Tags data-engineering, data-science, dbt, snowflake, SQL
The Four Pillars of a Data Career towardsdatascience.com Post date November 10, 2024 No Comments on The Four Pillars of a Data Career External Tags career-change, data analytics, data-analysis, data-visualization, SQL
To Index or Not to Index towardsdatascience.com Post date November 8, 2024 No Comments on To Index or Not to Index External Tags data-science, programming, python, SQL, tips-and-tricks
Comparing Pandas and (%%SQL) for Data Analysis in Python medium.com Post date October 28, 2024 No Comments on Comparing Pandas and (%%SQL) for Data Analysis in Python External Tags data-science, hands-on-tutorials, programming, python, SQL
Transforming Data Quality: Automating SQL Testing for Faster, Smarter Analytics towardsdatascience.com Post date October 26, 2024 No Comments on Transforming Data Quality: Automating SQL Testing for Faster, Smarter Analytics External Tags ai, automation, qa, SQL, testing
A Comprehensive Guide to RAG-to-SQL on Google Cloud feeds.feedburner.com Post date October 18, 2024 No Comments on A Comprehensive Guide to RAG-to-SQL on Google Cloud External Tags Advanced, blogathon, Database, nlp, RAG, SQL
Top 5 Principles for Building User-Friendly Data Tables medium.com Post date October 13, 2024 No Comments on Top 5 Principles for Building User-Friendly Data Tables External Tags data-engineering, data-science, Database, SQL, tips-and-tricks
Understanding SQL Data Type Conversion analyticsvidhya.com Post date October 3, 2024 No Comments on Understanding SQL Data Type Conversion External Tags Beginner, data types, Database, SQL
Automating CSV to PostgreSQL Ingestion with Airflow and Docker analyticsvidhya.com Post date October 3, 2024 No Comments on Automating CSV to PostgreSQL Ingestion with Airflow and Docker External Tags Advanced, airflow, Apache, blogathon, CSV, DAG, Database, docker, Dockerfile, python, SQL, workflow
SQL: Mastering Data Engineering Essentials (Part II) towardsdatascience.com Post date October 1, 2024 No Comments on SQL: Mastering Data Engineering Essentials (Part II) External Tags data-science, Database, deep-dives, programming, SQL