good

good

Good

GOOD

good

best

good

Good

Good

good

good

good

good

well

good

good

nice

good

good

...

gh

OK

Dear teachers, These’re a couple of obstacles I found along the way: 1. In reference to the syntax symbols, I find it very difficult to know before hand when I have to introduce one between ‘___’   or “___”. Would you be clearer on that explanation? 2. Optional: upload the store transactions dataset to BigQuery: I could not cut and paste Step 11, for some reason (I tried several times). 3. Why must some functions be written in parentheses and some other not? DISTINCT, for example, doesn’t have parentheses, while CAST does. Could you please explain those basic concepts of the SQL syntax?

4. In one of the videos, “Documenting results and the cleaning process”, you jump from Pivot Tables and other spreadsheet features like Find and Replace, to Big Query without telling, which makes it difficult to follow along. I'm doing my best, but sometimes, especially in reference to the SQL syntax learning, I'm not achieving my goals, and feel very frustrated.

several practical exercices don't actually bring the expected results. I struggled more with using bigquery than i spent time actually learning SQL. I think the most troublesome part was creating tables (creating datasets was not a problem) : there was always a problem and it took me a long time to solve most of it (it's kind of okay now). I'll probably have to find more information somewhere else to catch up. The teacher is good and so is the pace but the practice is not as efficient as the one I had with the spreadsheets. I may also add that it would be great in the future to allow Coursera students to get access to some functions in the sandbox like updating or deleting in SQL, just so we get a chance to try it. To summarize : good teacher, good content but BigQuery is definitely not as user-friendly as R.

This course is structured poorly. More reading materials are needed for SQL. Also, content and materials for inidviduals with no prior experience in progrmaing are necessary, because the right foundation is key for proper understanding and mastering of whatever is taught.

another consideration is the stagerred and overlapping topics among different courses is really confusing.

It is much better to make courses more especialized. For example, one for basics, one for spreadsheets, one for SQL, one for CV and findng the right job instead of talking a little about each topic in each course, which is really impractical and confusing if not provoking.