This course has really helped with optimizing queries that I work with everyday, enhancing my understanding of RDBMS, joins, analyzing and structuring exactly what you need and yielding those results.
A comprehensive course that covers major aspects of query building and retrieval in a management system. The topics were delivered well and the materials/assignments were relevant for skill-building.
автор: Ganesh L•
автор: Annamaria N R L S•
Excellent course. Professor very knowledgeable and professional. A few minor observations -- the presenter could have broken down some of the larger topics (i.e. joins into separate modules and prepared more practice assignments, especially writing queries so the students could get more comfortable with the task. Also, the alerts when a students does not write a query correctly could be a bit more explicit (i.e. which"(" they are referring to). Furthermore, one of the questions in "Graded Assignment"in the Week 4 Module where the first question did not recognize one of my answers as correct, even though it was. Next, some of the questions in both the graded and final assignments were not clearly worded so it was a bit difficult to understand what they were asking. Finally, if I wanted to repeat or pause a portion of the video, it would often jump back on to the very beginning.
On the whole, however, this course was very informative, interesting, and enjoyable. A must for anyone interested in improving their skills in both data/database management and computer skills in general.
автор: Danny N•
This course was my first exposure to SQL. Much of the topics covered were easy to follow. I would have liked to delve deeper into some of the course topics. Some of the lectures were a little vague with only the static PowerPoint background. It would be helpful if the lecture was overlaid with motion pictures to help demonstrate how some of the code works in practice. The option to practice SQL on a computer using SQL Server or SQLite for applicable practice would also have been appreciated. Typing SQL code into the website isn't the same as using the actual programs one would use for work. Also, upon course completion, the Coursera website indicates this is 1 of 3 courses. However, it is unclear what course 2 and 3 are. I would like to learn more as I am hoping to utilize my economics and mathematics background in the work force as a data analyst. Overall, I enjoyed this course and recommend it to other folks if a traditional college course is not a viable option. If the option is available, I strongly suggest enrolling in an accredited, recognized university program.
автор: Gabriel W•
Overall this course provided a great curriculum to begin learning SQL basics as well as thinking about data in a scientific way. My only real feedback would be that I frequently had to look elsewhere on the internet for examples to understand the syntax and rules of each operator or function that was introduced. The core video lessons sometimes provide only one or sometimes zero examples of how to use the operator or function being discussed. More specific examples would be helpful. I am a native English speaker and still had occasional difficulty understanding what the instructor was trying to communicate during some of the video lessons. Many of the sessions could have been edited for clarity, especially when many students of the course are non-native speakers. Overall I learned a great deal and understand the basics of SQL such that I feel confident moving onto the next course and expanding my skillset. Thank you!
автор: Adrian R•
I must say the final could use some improvements some things I wasn't really prepared well for was searching for any nulls that took a huge query and the last question on the final project was kind of vague. I took this course to learn by doing, wish there was some extra help when I ask sometimes nobody responded, so it was supposed to be a three week course, but took me 4 months. I gained alot of weight during taking this course, when studying this it takes me hours on hours sometimes I can't schedule other things in the day in fear of overlapping and forgetting. The instructor was good I had to research more on my own on the different times to use subqueries vs joins. Overall it is good experience I feel this is not like riding a bike and to remember it you have to keep doing it consistently. The readings on Data science are really really long as well the readings actually take a huge amount of time.
автор: Karolina F•
Good introductory course for SQL beginners. Adequate content with plenty of reading to expand interest and find further references. Also an adequate pace that allows to combine learning with busy life. It allows to quickly build understanding of the concepts and their basic application to solve basic business questions as well as confidence. Sanbox practice w/o need to buy into any program is very usefull. The course delivers what it says it will deliver. Looking at others' reviews, expectation far exceeds what this course is designed to deliver in the given timeframe.
The polling questions are excellent during the lecture videos, as they keep the participant engaged and check understanding of subject. Only suggestiion for further improvement would be to split the video tutorials with some sandbox practice, instead leaving it out to the end of the section for a practice quizzes.
автор: Devan A•
Overall good course with a helpful breakdown of concepts and skills needed to get started with SQL. Good structure and flow of information, which slowly builds up your skill and confidence throughout the four weeks.
It could definitely benefit from more code examples, especially in regards to concepts like date and time formats in SQL, and how to manipulate data in relation to these. Also would have been great to get more hands on coding practice before the end of the modules, as it can happen that you think you understand everything throughout the week, only to face up to a barrage of your weaknesses at the very end. Some self-study is also required, but I believe that ends up being a strength, as the course gives you the direction and often lets you figure it out.
Really enjoyed it, and recommend it to anyone starting off in this field.
Hi! I'm still on WEEK 3 of the course and I'm yet to finish the course. The course content for Week 1 and Week 2 was amazing! The explanation, enthusiasm of the instructor in teaching, the examples and the description as well as clear cut definition of each term made it so easy to learn the concepts. Thank you for putting up such a great course material.
That being said, in Week 3, the concepts get tougher so the explanation should be more detailed and there should be more number of examples. However, that's not to be seen in the videos. There are hardly any examples.
The tables and what output we get after submitting the query is not shown. Without looking at the table contents and the kind of output each type of join query gives, it's very difficult to understand the concept. :/ I hope Coursera will do something about this. Thank you. :)
автор: subbiah v•
Really tough assignments. Tests your knowledge of you have learned. A good notes is necessary to attempt the final peer review assignment. Good links to outside sites for reference reading and clarity. Overall enjoyed the course. Learned a lot and understood how important data is in our life and how vital a knowledge to work with it is in today's world.
Small Advice: After each concept videos please make learners attempt questions on the solitary concept alone instead of brain storming the whole weeks total concepts in one coding assignment. It helps the learners to grasp the concept more and to remember it with enthusiasm.
Wonderful course with lot of tricky assignments. Have fun guys. I heard a specialzation is on its way for this. So its worth taking it and following a path.
автор: Alex R•
It's a good intro course to SQL for data science. The videos are helpful but the lack of practice questions or active presentations (showing the presenter using SQL and not just showing code on the screen) made it difficult for me to engage with the course. I had to go find additional practice question resources outside of the course and frequently used outside sources to help understand what I was doing. SQLite is also terrible and frequently times out because your query took more than 3 seconds. This was very frustrating as it leaves you unsure if your code is causing problems, the website/server was busy or SQLite just didnt process in time. I'd like a more robust SQL option similar to the way Hackerrank works.
автор: Rich M•
The overall course is good enough and the quizzes are a good indication of what is to come. There are a handful of typos and errors in the PPT decks that do make the lessons harder because there are enough gaps that I had to search online for the correct way.
I know this isn't a surprise, but the cheating on the peer review project is rampant. I did 6 peer reviews and all but one was a copy and paste - they all had the same typo in a table. One even had generic statements such as FROM [insert table name].
Also, you need to include a 0 option for the peer project grading. Two of the ones that I graded skipped the last several questions and I had to still give them points.
автор: Rachel M•
The course videos were a good introduction to the major tools of SQL. The exercises were targeted at a more beginner level than I expected. It might have been helpful to have more bonus or stretch exercises included in the quizzes, and for there to be more than 1 quiz per week to gain familiarity with a specific tool like subqueries or a specific type of join before moving on.
I would recommend that the course add information on what the different columns in the yelp dataset tables mean, in addition to the database schema, for the final project. Through peer review, it became apparent that this information is missing and would have been helpful.
автор: Fauzi A M•
This class is a good start to learn SQL. It provides the fundamentals and introduction to the world of SQL. However, I am speaking as someone who has learn to code before, so some of the practices are already familiar. Those with no prior coding experience, such as having SQL as their first code language, might have a bit of hard time.
Sadie's explanation is clear.
Some of the example used on the slides and what is being explained by the instructor are different. Maybe one is updated while the other isn't.
Some of the coding syntax are not explained verbally, however if you study the written examples on the slides, there should be no problem.
автор: Aron S T•
Nice course that covers the fundamental aspects of SQL and paves the way for a more in-depth dive into SQL and RDBMS. I really liked the integration of the chinook and yelp datasets in this course, as they give you a glimpse of what it is like in the real world. Quizzes and assignments were not too challenging which is fine considering this is more like an intro course. I also liked Sadie's teaching style, however I do favour a more organic teaching approach in the videos. I understand that, a lot of logistics goes into preparing these videos and I appreciate that. However, the teaching videos were a bit lifeless, if that makes sense.
автор: Samuel A•
I loved the course. I think it is at the right pace with the right amount of information. Normally, I get bore when the instructor explain many things and after I got it, she/he continues explaining.
I loved that the instructor goes right to the point and does not waste time repeating the same thing again and again.
The only piece I was not happy about was the final assignment. It has things not explained in the course that were not easy to solve. Of course, after figuring out the answer, it seems easy, but it is not while the person does not get it.
But overall, I loved it. I would have given 4.5, instead of 4, but I was not able.
автор: Megan R•
Great exercises and quizzes to really test SQL knowledge. I feel confident in my ability to work with basic SQL commands to modify a data set for analysis. I found the videos helpful to introduce topics, but felt like I gained most of my understanding from the exercises.
Instructor was very knowledgeable but explained some of the concepts awkwardly. I appreciated her comparisons and metaphors when included.
Overall, really good course for someone who is brand new to SQL like myself. I look forward to applying these skills in practice and integrating them with other data analysis tools.
автор: David E•
Most of the course is satisfactory. However, the final project has some major problems. First, it will take you longer than the stated 2 hours. Also, documentation on the provided data is lacking. Moreover, a large part of the final project is data analysis that you would never conduct in SQL - what would take a few lines of code in Python becomes cumbersome and frustrating and incomplete in SQL. If you're interested in obtaining the course certificate, just be aware that you won't encounter the most frustrating part of the course until you've completed every other course requirement.
автор: Kathy Z•
Excellent content if you're new to SQL! The videos were a little slower paced than I liked but I simply reset the streaming pace to 1.25 times faster and that did the job. I wish there were some more frequent practice questions. I do appreciate that the assignments and quizzes were slightly more challenging in that you couldn't just regurgitate exactly what you were told during lecture. I'm somewhat disappointed that I ended up googling a good number of concepts in order to better process them. But again, plus side, you don't need to download extra software to practice.
автор: Yirieth M•
The course is very well structured and gave me plenty of skills to be able to retrieve data on my own. I do have a complain, and it is that some questions throughout the exercises and in the final assignment are not very well explained and lead to confusion, it is not immediately clear what the question(s) is asking to do. Also I would have liked that during the lecture videos, the examples come along with the resulting data table. It was done in some but not all which I missed when referring back to the lectures in order to be able to do the coding exercises.
автор: Jared B•
Overall a great course although I'm not sure how well I would have picked this up had I not had prior experience. I used this course as a refresher after having dabbled in SQL a few months back and hardly touched it until recently. This course did help reinforce concepts and better taught ones I was less familiar with. I also liked the amount of problems that were provided and the various resources. All that said, the lecture method doesn't feel the strongest for teaching the content in the depth it requires - at least for me if I were a complete newcomer.
автор: Daniel B•
The course is informative, but there should be more hands-on type questions mid-video. Internalizing information would be much more efficient if there was more than just seeing results of queries and answering poorly worded questions. The final assignment can be one of great effort or minimal effort depending on the individuals interest in trying out complex queries that are out of their comfort zone, but both sides of the coin end up with the same certificate in hand. So, just like most courses in life, you get only what you put into it.
автор: John M D•
I thoroughly enjoyed this course as my first experience in Coursera. The lectures were presented in a well paced manner and the information was sufficiently broken down. However, the first few weeks suffered from insufficient assignments to reinforce the concepts learned. As a result, the final assignment was well beyond the normal intensity of the course and I felt unprepared. The final assignment appears to be developed by someone other than the core instructor and has a completely different understanding of the course scope.
автор: Eric M•
Overall I think the course was pretty good. I think a lot of sections could have used more examples, especially of queries that combined several different types of clauses. There were also too many "choose the better answer" type questions in the weekly quizzes with more than one correct answer. Finally, the wording on many of the final assignment questions was terribly unclear. There are dozens of posts and questions about these on the forums. Ironing out these deficiencies would really help improve the overall course.
автор: David L L R•
The course addresses all the topics necessary to start using SQL for profiling and analyzing data. To improve: 1). For various topics, there weren't enough examples and forth these themes could be confusing 2). It's too much visible that the teacher is reading a teleprompter and there were occasions where the sentences are not well connected, and at least for non-english speakers, this could be annoying and confusing. The assignments are well designed, and in these exercises is when you really start to learn.
автор: Guan-Yuan W•
This course has improved my SQL skills and let me further my knowledge of Database Management System. Also, there are some coding assignments helping cultivate my hands-on SQL coding skills, especially for data science.
However, some of the lecture videos felt disconnected from the coursework, honestly. The lecturer just read out verbatim, showing too few examples and too few coding tests. Moreover, the assignments were too few so I supposed I should have to take another course so as to get massive progress.