Effortless approach to determine what is in the BigQuery dataset and which tables are useful for analysis with INFORMATION_SCHEMA and TABLES
Stepping up your SQL query game with these 2 advanced SQL concepts is easier than you think. Don’t miss out!
It's time to take your queries up a notch with Date Partition, Analytic Window Functions and WITH clause!
With HyperLogLog algorithm, we trade off some accuracy to get the job done faster. But how much faster and at the expense of what level of accuracy?
Struggle big time with MySQL Trigger? Let me help you get the concept right in 5 minutes
How to choose which chocolate bar to buy, according to expert opinions
Let's join me and explore database, a universal topic that forms the backbone of every organisation