SQL Riddles to Test Your Wits
SQL is a deceptively simple language. Across its many dialects, users can query databases in a syntax similar to English. What you see is what you get… until you don’t. Every now and then I come across a query that produces a result completely- 23408Murphy ≡ DeepGuide
Create MySQL and Postgres instances using AWS Cloudformation
Infrastructure as Code for database practitioners- 23099Murphy ≡ DeepGuide
3 Essential PostgreSQL Functions You Deserve To Know
Three little-known functions that will elevate your data game- 25778Murphy ≡ DeepGuide
Exploring the Right Fit: Choosing Primary Keys for Your Database
A practical example of navigating key selection trade-offs in a real-world scenario- 29392Murphy ≡ DeepGuide
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