Skip to content

The Digital Skye

Where I share my stories about business, data and anything in between

  • Infographics
  • About Me

Tag: SQL

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

Skye Tran Google BigQuery Leave a comment February 2, 2021February 2, 2021 5 Minutes

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!

Skye Tran Google BigQuery Leave a comment January 21, 2021January 21, 2021 9 Minutes

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!

Skye Tran Google BigQuery Leave a comment January 19, 2021January 19, 2021 7 Minutes

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?

Skye Tran Google BigQuery 2 Comments January 14, 2021January 18, 2021 3 Minutes

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

Skye Tran Database, SQL Leave a comment October 29, 2020November 10, 2020 4 Minutes

Explore Chocolate with MySQL Workbench

How to choose which chocolate bar to buy, according to expert opinions

Skye Tran Data Analytics, Database, SQL Leave a comment October 28, 2020November 5, 2020 10 Minutes

Understand Database in 5 Minutes

Let's join me and explore database, a universal topic that forms the backbone of every organisation

Skye Tran Back to Basics, Database Leave a comment October 24, 2020November 16, 2020 6 Minutes

Copyright © 2020 Skye Tran

Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×