Quiero resaltar los grandes cambios que ha tenido esta plataforma en pro de fortalecer por medio de la práctica de labs y diferentes ayudas audiovisuales los diferentes conceptos y temarios.

Muy entendible y muy practico, muy recomendado para principiantes en Excel y SQL / Very understandable and practical, highly recommended for beginners in Excel and SQL.

I love love love all of the new SQL and spreadsheet functions I've learned. I am really excited to use this skills to making an impact in my future projects.

The course was awesome .I feel very happy when i work through spreadsheet calculation and SQL calculation .Wants to thank my Instructor and also google.

Slightly difficult for a person like me, who does not have any prior knowledge about SQL and databases. But still nice experience.

Great course and great introduction to the technical side of data analytics.

instructor wasn't as good as previous course

amazing course and instructor!

One of the video instructions on using SQL to create a temp table gave me a tough time to debug and run until I carried out an online search for the answer. The instruction omitted a line of instruction. I wish this can be looked into and created. Below is the syntax of the omission and correction.

WITH   

longest_used_bike AS (    

SELECT      bikeid,      

SUM(duration_minutes) AS trip_duration   

 FROM     

 bigquery-public-data.austin_bikeshare.bikeshare_trips    

GROUP BY     

 bikeid    

ORDER BY     

 trip_duration DESC    

LIMIT 1  

)

SELECT  

trips.start_station_id,  

COUNT(*) AS trip_ct

FROM  longest_used_bike AS longest  

INNER JOIN   

 bigquery-public-data.austin_bikeshare.bikeshare_trips AS trips  

ON longest.bikeid = trips.bikeid

**WHERE  

trips.start_station_id IS NOT NULL**

GROUP BY  trips.start_station_id

ORDER BY  trip_ct

 DESC

LIMIT 1;

The missing line is having double asterisks at the beginning and closing **^**

This section covers a LOT of information at a pretty rapid pace. Unfortunately, some of the practice datasets have been updated since the videos were made, so be ready to look in the discussions for answers to how things are supposed to work when they don't. This is also a section where you'll probably want to do a lot of independent study. This is really the nitty gritty of SQL and it's no joke. But if you stick with it, and are dedicated to figuring things out when they don't work the first, second, or sometimes third time, you'll get through it.

I wish I could give it 4.5 stars. The content got more advanced, but the pace is still reasonable. Sometimes there are stupid questions on the quizzes and even some wrong formulations. I liked the organization (for the most part) and most of the practice. However, sometimes you still don't need to think enough and can copy/paste in too many places. I believe the instructor is knowledgeable, but so far is the driest of them all. Nevertheless, I learned a lot.

This course was more difficult to follow compared to the other courses (especially some of sql queries). I have previous sql knowledge but i feel like the instructor was doing a lot of complex examples for doing a query for the first time. I think a more step by step approach and building the query would have been easier. I have realized that I will need to take an additional course on SQL bc some of the concepts in this module i did not follow.

The course is amazing, it is rich in important topics and material. It is very interesting for how much practical exercises and hands-on activities it comprises. Learning has been a lot at this level. But in the sections Work with sub-queries / Queries within queries, and Using sub-queries to aggregate data, more elaboration and visual explanation was required to understand the complex concept of nested queries and data aggregation

This course was critical to the entire certification; unfortunately, it was plagued with errors, particularly in the videos. In two of the tests I had to select the WRONG answer in order to get scored correctly. The access to the weekly Glossary was not working, and two of the Qwiklabs were horrible. FYI... (A/B*100) is not the same as (A/B)*100.

I appreciate the many follow along exercises in this course. However, given how much this step is featured within Analytics, I felt fours did not give us ample time to practice the many functions. An additional week where we could practice such functions as Temp Tables and JOINS would be time well spent for the students.

There could be more use cases on analyzing and identifying the trends. I learnt the necessary tools now, but don't feel prepared enough to identify the trends. Lecturers always mention "let data tell the story". But we did not focus on analyzing the data to transform insights. Hope we will do so on part 7.

4 ratings because I loved the new knowledge in excel and SQL. Not 5 because I thought the SQL part was bit fast for me and took time to understand compared to other course lessons. The subquery part was bit confusing at first for which I had to do some research. Overall I'm happy to learn something new.

Lots of valuable information but as I only had basic understanding of SQL coming into this course, it didn't really improve my confidence level in using it. I had to purchase a SQL course from another vendor that was much more helpful in improving my understanding of the why, what and the how.

This was the hardest course for me. There were times when it was difficult to follow the instructor because she was going to fast on her explanation and typing SQL series so quick when I thought this program is supposed to be for beginners or those who doesn't have analytics background.

not a lot of details about sql even some videos required some more information

and all the files require permission to open so no files for any exercise

It hasn't been as descriptive and as consistent as the previous courses were and faced very minute trouble catching up with the instructor at times.

This course provides a solid introduction to intermediate spreadsheet and basic SQL skills. The instructor is clearly a skilled user of these tools and communicates most concepts and techniques clearly. Occasionally the instructor while demonstrating a taught technique will use unexplained shortcuts in supporting code. This makes replication as a novice more difficult. Supporting information such as https://www.w3schools.com/sql/sql_count_avg_sum.asp is recommended for students to allow less frustration navigating BigQuery. Discussion forums are full of students needing help with SQL syntax, case sensitive error, etc. Responses are understandably slow and an ineffective way of addressing the students need. This course has some sequencing issues where concepts/techniques required are taught after being required to complete an earlier activity. The course should make use of the intracourse SQL functionality more frequently and in graduated complexity before introducing the use of BigQuery. The gates, tested material is too simple to ensure that students have acquired pre-requisite skills before introducing subsequent material.

I think the course materials are excellent and relevant, but it didn't do a good job explaining some important concepts, specifically the Subqueries in SQL. Not only did the course fail to explain the relevance and the motivation to initiate subquery, the pace of how different lines do and interact with the core main query way too fast. In addition the time needed to debug the queries to make it work quadrupled at least. How different commands interact (Count/Group By) is also not adequately explained. Going forward, I think it would be more important to use visualization to explain the different parts of the Queries and how they interact, together to form a complex query on SQL. In the final quiz, the spreadsheet had a bug that prevents SORT function to function properly, with regards to sometime about circular and such. Overall it is a challenging course compare to the previous ones, and I hope they could make it much more clearer when doing these type of analysis.

I'd like to share my thoughts on the course I recently took, giving it a rating of 3 out of 5 stars. Overall, it was a valuable experience, but there are some areas where it could improve. One aspect that stood out to me was the SQL section. While the content was there, it felt a bit rushed. I believe it would have been more beneficial to separate the teaching of subqueries and JOINS. By introducing and providing hands-on experience with each separately, learners could grasp the concepts more effectively. Then, once both were understood, combining them in practical exercises would have solidified the learning process. Despite this criticism, the course still offered valuable insights, and I was able to gain a good understanding of the material. With some adjustments to the teaching approach, it could become even more beneficial for future students.

The whole specialisation so far (courses 1-5) is just talking without doing. Hands-on experience/practice is really crucial for us to learn and debug our programs. Although labs are provided, it is mostly copy and paste without further explanation. Comparing this to "Managing Big Data with MySQL" by Duke University, the latter has more training to hone our SQL skills and learn through practice. I would not have understood the queries if it weren't for my previous encounter with SQL in another course. Also, the learning curve is gradual in the latter, while Google's goes from 0 to 100 quickly. Last but not least, I think Google should have separate courses dedicated to joins and subqueries respectively. Subqueries are complicated man, give us exercises instead of just links to external sources!