One of the best course till now I find on Coursera, well structured everything and practice questions made me feel like real life problems as data were from real database of dognition and ua_dillards.
Nice and well-organized course. I joined this course after self-studying on SQL for a few days. The context is really nice. The only problem is the Teradata is not stable. I tried very hard to login.
By Max H•
I have a theoretical background in relational algebra and SQL. This course did a great job of actually applying that theory in practice in the form of business situations. By using real life data, it also accurately presented raw data as not perfectly organized or "clean". Filtering with subqueries, IN, WHERE, and OUTER JOIN statements are absolutely crucial in cleaning data in real life situations; this course did an excellent job of demonstrating that importance.
I have 2 interrelated critiques however: The usage of 2 different platforms (MySQL for the exercises and Teradata for the quizzes) was very confusing given their distinct syntaxes. I think it would have been more powerful to have the exercises and quizzes on the same platform. Furthermore, the Teradata platform was oftentimes overwhelmed by the number of users and frequently crashed. Going forward I would recommend either ensuring that the servers can handle the amount of user-load, or switching over to the MySQL platform entirely.
By Amy H•
This is a really great course for learning MySQL and Teradata. Coming from a background where I've never studied computers or programming, this course was relatively easy to follow (though Teradata was definitely a challenge for me). I found the instructor pleasant and clear in describing query-writing. There were a few times that I thought we needed more explanation (especially for some of the Teradata exercises), but what is learning without a bit of challenge?! I am really excited to get into the field of data analytics, and this course has helped to open doors for me! I highly recommend taking this course - but be prepared to spend many hours in weeks 4 and 5, as the exercises can be extremely difficult.
By Derek O•
I really enjoyed this course, and I have no previous experience with SQL. As we got a few weeks in, queries got very difficult and a lot of times I had to look at the answer key while I was working on exercises to get hints, but that was actually very helpful. I took the course as a part of a specialization, and while it is supposed to be course 4, I took it as the second course because of enrollment dates. Now I'm taking a "Data Visualization and Communication with Tableau" (which is technically the 3rd course in the specialization), but the SQL background I gained from this course gives me a lot of context that helps me feel like I understand the inner workings of Tableau.
I loved the MySQL exercises, it's a very intuitive way to learn how to use SQL properly. My only problem with this course was the lack of guidance for some of the Teradata exercises (most of which were then used on the graded quizzes), and also the fact and a few guidances provided were wrong or needed adjusting - it was very time consuming doing the exercises for hours and hours, and then going to the forum to discover the guidance given was wrong.
Overall, I recommend this course! Just make sure you look through the discussion forum as soon as you get stuck on a particular exercise, it will save you a lot of time!!
By Juan P A•
This course should be divided in 2 o be longer for two main reasons:
1) Weeks are way too long to cover all the material, plus the research you need to do outside the platform. The time required end up being too much.
2) The course is not deep enough - There's just too much topic to cover, and because of time constrains there are a lot of holes in your education at the end.
For this two reason is better con get 2 courses about this topic. That way you can go deeper in to the SQL explanation, and can get at thee same time a better understanding of each topic, instead of getting a lot of thing to cope in just one week.
By Jacob H•
The course was very well structured. I came into the course having a noice level understanding of SQL so was able to dive into the first few weeks quickly. Around half way through the course got significantly more challenging so I would highly recommend taking good notes and saving your queries. I found that saving my queries with a naming convention that as associated to my notes made the class much more manageable.
Also there were a few times I think I crashed the server or had to trouble shoot Teradata or Jupyter so make sure to pay close attention to the early lessons and directions on how to trouble shot.
By wang z•
Very useful and well-designed course. Jana is an effective instructor with a great sense of humor. Her course material is easy at first and gradually gets harder, which is suited for students with no SQL background but eager to learn. But this course does require a lot of your time and dedication ---- Plan 5 hours every week and sometimes even more (week 4 and 5). It took me 2 rounds of enrollment to earn the certificate. All in all, I would recommend this course to people interested in data analytics, who want to update their knowledge beyond excel and have the time and the drive.
By Ytsen d B•
This is actually a very hard course.
It starts off very easy by explaining how relational data bases are shaped.
Then you are taught how to manage real life data bases, which are messy.
By the end, the questions they make you exercise force you to write rather complicated SQL code.
It makes you wonder if SQL really is the best way to store (and retrieve to collate) data ...
But you'll be kind of a SQL ninja if you manage to complete the final quiz :)
By shivangi n•
The course is exceptional! I am a person with non-technical background and loved how all the assignments were so comprehensively laid out which made them easy to follow.
I just felt the last week was quite heavy in comparison with other weeks. Had I practiced the same level of questions in weeks earlier, I would have completed it in less time.
No other complaints. If you are new to the language it is good course to begin with.
By John H•
The pace was really good (may be to fast for some) and I learned a lot during the amount of time. The only really annoying thing was getting on the teradata (and sometimes jupyter) website. If you only have certain timeslots during the week to work on this course, and you can't log in during this time, well, that is annoying and caused me to miss deadlines. For this reason, I had to switch sessions, which cost me another 42€.
By Eunice C•
A very useful and insightful course that accelerates your entry into the SQL world. The course is jam-packed with lectures, exercises and hands-on sessions. Lots of written information and tips were provided to support the learning experience. The only issues are technical ones which many students face, such as not being able to get an account to access the database so we resorted to sharing other students' account.
By priya x•
Good material but heavy work-load, especially since we are learning two new skills -SQL syntax and Data analysis. Request instructors/TA's to guide students more in the forums. Analysis like computing avg daily revenue should be explained better as I spent too much time figuring it out and the forum answers were way off. However, this being an online class I was very impressed with the detailed worksheets in MYSQL.
By Qin C•
It is am amazing course and I learned so much about SQL functions into real-life practice!
The only problem is Teradata. The interface's unstable sometimes, and it may interfere with studying pace of several students and deadline is unable to meet with Teradata broken down.
Anyway, it is a well-prepared, and high-quality course from DUKE University. The teaching staff and mentor's efforts are so appreciated!
By Tatiana O•
It is really good. But If you need fast results and a certificate within a short period of time I strongly recommend to choose another course of SQL for beginners and probably return here later to horn your skills. It`s not like this course provide you very unique or deep information, but working with exercises and quizzes take such a significant time because of the tests themselves and data to work with.
By Zhiqing L•
This is a really good course. Dr Borg's video is easy to understand and the MYSQL exercise is awesome.
I know how to write sql after taking this course and become less afraid of writing code/query.
The only reason I give this course 4 stars is that my experience with Teradata is terrible and frustrating! And their wiki website is down.....Not sure why this course uses such a out-of-date database...
By Viviana V L•
I really enjoyed the course and found it very useful. I can write a basic query now !! and I got a bit more understanding of how to work with databases. My only recommendation for the mentors is to work on more samples of queries using Teradata and add the answers to the week assignments. I'm still wondering a few answers and not sure if the output of my queries was the expected.
By Christoph B•
Started really well, step by step - great!
But in the end I felt a overwhelmed, by really long queries, very complicated, long struggle.
Happy, that new Database was set up just before I got into trouble!
Annoying that Week 5, Last Exercise Question 12 is still not fixed: Min instead of Max. That is REALLY upsetting! Afterall, we are paying a lot of money every month!
Jana was lovely!
By Andrés F M E•
Overall a very complete and intuitive course, a great deal of explanation and resources, aswell as individual work to test our learning. I consider, nevertheless, that the focus on the calculations of revenue, on the Teradata excercises, is unnecessary; it uses a specific methodology for the concrete case, but is hardly applicable in other projects given the nature of the data.
By Diego C•
The course is very well organized and it's very useful to learn SQL. Be patient, take your time and to go through all the excercises to take advantage of its content.
However, the database platforms (in my case Teradata) was shut down for a couple of days, which can delay your accomplishment. I consider that the team of the course should warn when these issues are generalized.
By David H•
Great opportunity to learn the fundamentals of SQL queries. Some of the material gets real complex without much explanation so it can be frustrating trying to track down the right answers and logic. This course definitely takes more time than what they allot so plan accordingly, but in the end I enjoyed learning the fundamentals of SQL from this course.
By Carlos V•
Really good Course if you have the time to follow all the workshops and assignments, because they take quite a lot of time to complete, so allocate some extra time so you can learn properly, the good thing is that at the end you will have a solid understanding of SQL, Query’s and how to mine data for answers. Highly recommended for SQL starters.
By Guisseau G•
Very good inputs and step by step approach to learn sql
Quiz turns out to be quite complex - you really need to practice !
It would be useful to get a written summary of the course and key functions that we have utilized - I understand everything is availabel on the internet - but it would be faster to retireve information in my opinion
By Sean E B•
It's set out quite well and the videos and excercises are generally set out well and allow you to get good practice and learning.
However the difficulty really ramps up during week 4 and especially week 5 (you are warned of this). The spike in time commitment and difficulty is quite overwhelming if you are an actual beginner.
By Jakub K•
The course should be longer, prepare yourself you are going to need a lot of time, unless you have previous experience from SQL. It'll take maybe even more than one session. But it is worth it, because it covers all skills you need for working with SQL. If you really need to learn SQL, there is no better option.
By Nicholas A P•
Overall, it was a great course and I learned a lot from it. I think that what could have been better is if the content of the course was more spaces out right than tight because I think for Weeks 4 and 5, I needed to learn more about how to write advanced queries.