Optimizing your BigQuery Queries for Performance 2.5 Reviews

Bryan J. · Reviewed yaklaşık 3 yıl ago

Not enough time for this lab (as contrary to the others). Very weird to only give 1H to finish this lab while it's a lab with a lot of text to read and SQL logic to digest. 2H would be fine, but 1H is much too low. Funnily enough most of the previous labs didn't need 2H but way less. But for this one it's the reverse. Reading and properly understanding all the text and the techniques inside this lab takes time. Also reading and understanding the logic all the SQL queries, even if you know SQL, is not trivial, especially since we don't know what the tables you're referring to look like, and we literally do NOT have the time to look at those in detail by ourselves. Also, sometimes the text in itself is very complex to understand since we don't have a clear table context associated with it (in the tasks after yes, but not in the introductory text). Sentences like "imagine you have a table about this and that, to do this we would need to join this or do that" are very bad : No, i can't imagine this or that since I'm not in your head and I don't know the details of what you're talking about and I don't have enough time to decypher those abstractions. Tell me to go see a specific table in BigQuery, look at these specific columns, and then tell me how we would do something based on THOSE specific columns, not some half-defined abstractions. Especially given the lack of time to read the text and do the lab, we really can't waste time trying to infer what the writer has in his mind here. I can't go back to see the exact text I'm referring to here since I would cancel the rating + comments pop-up where I'm writing currently, but I remember that manifested at least two times in the lab.

Alexandre G. · Reviewed yaklaşık 3 yıl ago

Srisahithi B. · Reviewed yaklaşık 3 yıl ago

Hai X. · Reviewed yaklaşık 3 yıl ago

Ranjith N. · Reviewed yaklaşık 3 yıl ago

Kohki S. · Reviewed yaklaşık 3 yıl ago

Sai Teja R. · Reviewed yaklaşık 3 yıl ago

Ryosuke T. · Reviewed yaklaşık 3 yıl ago

Antoni Y. · Reviewed yaklaşık 3 yıl ago

Vladimir P. · Reviewed yaklaşık 3 yıl ago

Yashi S. · Reviewed yaklaşık 3 yıl ago

Phil A. · Reviewed yaklaşık 3 yıl ago

Jaime Erick S. · Reviewed yaklaşık 3 yıl ago

WENNA L. · Reviewed yaklaşık 3 yıl ago

Justin C. · Reviewed yaklaşık 3 yıl ago

Nguyễn H. · Reviewed yaklaşık 3 yıl ago

Kathy J. · Reviewed yaklaşık 3 yıl ago

Kunal P. · Reviewed yaklaşık 3 yıl ago

Anchisa S. · Reviewed yaklaşık 3 yıl ago

Michael L. · Reviewed yaklaşık 3 yıl ago

Excelent!

Augusto C. · Reviewed yaklaşık 3 yıl ago

João P. · Reviewed yaklaşık 3 yıl ago

Tianhao H. · Reviewed yaklaşık 3 yıl ago

Gnana M. · Reviewed yaklaşık 3 yıl ago

Nivedita B. · Reviewed yaklaşık 3 yıl ago