A Simple Way to Query Table Metadata in Google BigQuery

Effortless approach to determine what is in the BigQuery dataset and which tables are useful for analysis with INFORMATION_SCHEMA and TABLES

Explore Arrays and Structs for Better Query Performance in Google BigQuery

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