Effortless approach to determine what is in the BigQuery dataset and which tables are useful for analysis with INFORMATION_SCHEMA and TABLES
Tag: SQL
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!
3 Useful SQL Features You Should Start Using in 2021
It's time to take your queries up a notch with Date Partition, Analytic Window Functions and WITH clause!
Counting unique elements faster in Google BigQuery with HyperLogLog
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?
The Why and How of MySQL Triggers (Part 1/2)
Struggle big time with MySQL Trigger? Let me help you get the concept right in 5 minutes
Explore Chocolate with MySQL Workbench
How to choose which chocolate bar to buy, according to expert opinions
Understand Database in 5 Minutes
Let's join me and explore database, a universal topic that forms the backbone of every organisation