Optimizing your BigQuery Queries for Performance - ADVANCED Reviews

RAFAEL A. · Reviewed כמעט 2 שנים ago

Pawel P. · Reviewed כמעט 2 שנים ago

Kamil F. · Reviewed כמעט 2 שנים ago

Bruno S. · Reviewed כמעט 2 שנים ago

Charlie G. · Reviewed כמעט 2 שנים ago

sefi r. · Reviewed בערך 2 שנים ago

Julie L. · Reviewed בערך 2 שנים ago

Julie L. · Reviewed בערך 2 שנים ago

Exercise 5 you say the goal is “determine the most common names assigned to both male and female babies in the country over all the years in the dataset” but the initial query inexplicably limits to only year-state combinations where the name was between 30% and 70% male. Where did that come from?! And then the optimized query has different sums because it doesn’t do that group, join, and filter on state and year. I wouldn’t call that optimization, I’d call that correcting a wrong query. This exercise needs another look.

Brian M. · Reviewed בערך 2 שנים ago

Jonathan C. · Reviewed בערך 2 שנים ago

Marcelo G. · Reviewed בערך 2 שנים ago

yugender b. · Reviewed בערך 2 שנים ago

Joyce W. · Reviewed בערך 2 שנים ago

Namita R. · Reviewed בערך 2 שנים ago

very good lab, especially because the answers not in front of u and only at the end.

Hila C. · Reviewed בערך 2 שנים ago

Saar S. · Reviewed בערך 2 שנים ago

Diego R. · Reviewed בערך 2 שנים ago

Carlos Andres F. · Reviewed בערך 2 שנים ago

Carla C. · Reviewed בערך 2 שנים ago

Sindy G. · Reviewed בערך 2 שנים ago

Ana Paula G. · Reviewed בערך 2 שנים ago

Ricardo T. · Reviewed בערך 2 שנים ago

Having no familiarity with origin tables makes this one too hard to complete in one sitting.

Lautaro C. · Reviewed בערך 2 שנים ago

Paloma M. · Reviewed בערך 2 שנים ago

Paloma M. · Reviewed בערך 2 שנים ago