Important MySQL Data Definition Language (DDL) commands we should know for managing our tables
Learn common database managing commands as a data engineer- 22337Murphy ≡ DeepGuide
Understanding SQL: Order of Execution
A brief guide on how databases interpret your SQL queries- 26007Murphy ≡ DeepGuide
Introduction to Apache Iceberg Tables
A few Compelling Reasons to Choose Apache Iceberg for Data Lakes- 22952Murphy ≡ DeepGuide
Why Do You Need to Use SQL Grouping Sets for Aggregating Data?
Efficiency, readability, and scalability- 27337Murphy ≡ DeepGuide
What is the difference between UNION and JOIN in SQL?
5 minute guide to UNION, EXCEPT and INTERSECT in SQL- 27268Murphy ≡ DeepGuide
Working with MS SQL Server in Julia
Time to supercharge your data analysis workflow- 24404Murphy ≡ DeepGuide
‘Talk' to Your SQL Database Using LangChain and Azure OpenAI
Explore the power of natural language processing using LLMs for your database queries- 25961Murphy ≡ DeepGuide
Embracing Simplicity and Composability in Data Engineering
Lessons from 30+ years in data engineering: The overlooked value of keeping it simple- 30050Murphy ≡ DeepGuide
Denormalisation: Thoughtful Optimisation or Irrational Avant-Garde?
Perspective on Performance Optimisation and Data Quality- 27997Murphy ≡ DeepGuide
Empowering Data-Driven Decisions: Embedding Trust in Text-to-SQL AI Agents
Simplify complex data environments for users utilizing reliable AI Agent systems towards better data-driven decision-making- 22260Murphy ≡ DeepGuide
Data Warehouse Design Patterns
How I organize everything in my new data warehouse- 27271Murphy ≡ DeepGuide
Navigating Slowly Changing Dimensions (SCD) and Data Reinstatement: A Comprehensive Guide
Strategies for efficiently managing dimension changes and data restatement in enterprise data warehousing- 28771Murphy ≡ DeepGuide
Building a Data Platform in 2024
How to build a modern, scalable data platform to power your analytics and data science projects (updated)- 22669Murphy ≡ DeepGuide
The Power of Geospatial Intelligence and Similarity Analysis for Data Mapping
Strategically enhancing address mapping during data integration using geocoding and string matching- 22925Murphy ≡ DeepGuide
Database Data Transformation for Data Engineers
Advanced techniques for beginners- 25425Murphy ≡ DeepGuide
Building a Data Warehouse
Best practice and advanced techniques for beginners- 27991Murphy ≡ DeepGuide
How to Use SQLAlchemy to Make Database Requests Asynchronously
Learn to use SQLAlchemy asynchronously in different scenarios- 25980Murphy ≡ DeepGuide
Don't Crash Your App: Load Records from the Database in Batches for Better Performance
Save your Python app's performance by efficiently loading query- 27663Murphy ≡ DeepGuide
My First Billion (of Rows) in DuckDB
First Impressions of DuckDB handling 450Gb in a real project- 25051Murphy ≡ DeepGuide
Best Practices for Technical Columns in Database Design
When architecting a transactional database or a data warehouse, it's important not to forget about various types of technical columns...- 24164Murphy ≡ DeepGuide
1 2
We look at an implementation of the HyperLogLog cardinality estimati
Using clustering algorithms such as K-means is one of the most popul
Level up Your Data Game by Mastering These 4 Skills
Learn how to create an object-oriented approach to compare and evalu
When I was a beginner using Kubernetes, my main concern was getting
Tutorial and theory on how to carry out forecasts with moving averag