Important MySQL Data Definition Language (DDL) commands we should know for managing our tables
Learn common database managing commands as a data engineer- 22362Murphy ≡ DeepGuide
Understanding SQL: Order of Execution
A brief guide on how databases interpret your SQL queries- 26031Murphy ≡ DeepGuide
Introduction to Apache Iceberg Tables
A few Compelling Reasons to Choose Apache Iceberg for Data Lakes- 22975Murphy ≡ DeepGuide
Why Do You Need to Use SQL Grouping Sets for Aggregating Data?
Efficiency, readability, and scalability- 27357Murphy ≡ DeepGuide
What is the difference between UNION and JOIN in SQL?
5 minute guide to UNION, EXCEPT and INTERSECT in SQL- 27288Murphy ≡ DeepGuide
Working with MS SQL Server in Julia
Time to supercharge your data analysis workflow- 24428Murphy ≡ DeepGuide
‘Talk' to Your SQL Database Using LangChain and Azure OpenAI
Explore the power of natural language processing using LLMs for your database queries- 25983Murphy ≡ DeepGuide
Embracing Simplicity and Composability in Data Engineering
Lessons from 30+ years in data engineering: The overlooked value of keeping it simple- 30071Murphy ≡ DeepGuide
Denormalisation: Thoughtful Optimisation or Irrational Avant-Garde?
Perspective on Performance Optimisation and Data Quality- 28017Murphy ≡ 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- 22280Murphy ≡ DeepGuide
Data Warehouse Design Patterns
How I organize everything in my new data warehouse- 27290Murphy ≡ 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- 28793Murphy ≡ DeepGuide
Building a Data Platform in 2024
How to build a modern, scalable data platform to power your analytics and data science projects (updated)- 22690Murphy ≡ DeepGuide
The Power of Geospatial Intelligence and Similarity Analysis for Data Mapping
Strategically enhancing address mapping during data integration using geocoding and string matching- 22946Murphy ≡ DeepGuide
Database Data Transformation for Data Engineers
Advanced techniques for beginners- 25444Murphy ≡ DeepGuide
Building a Data Warehouse
Best practice and advanced techniques for beginners- 28011Murphy ≡ DeepGuide
How to Use SQLAlchemy to Make Database Requests Asynchronously
Learn to use SQLAlchemy asynchronously in different scenarios- 26002Murphy ≡ 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- 27685Murphy ≡ DeepGuide
My First Billion (of Rows) in DuckDB
First Impressions of DuckDB handling 450Gb in a real project- 25072Murphy ≡ 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...- 24187Murphy ≡ 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