Chevron Left
返回到 使用 MySQL 管理大数据

學生對 杜克大学 提供的 使用 MySQL 管理大数据 的評價和反饋

4.7
3,343 個評分
770 條評論

課程概述

This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts. You will also learn how to execute the most useful query and table aggregation statements for business analysts, and practice using them with real databases. No more waiting 48 hours for someone else in the company to provide data to you – you will be able to get the data by yourself! By the end of this course, you will have a clear understanding of how relational databases work, and have a portfolio of queries you can show potential employers. Businesses are collecting increasing amounts of information with the hope that data will yield novel insights into how to improve businesses. Analysts that understand how to access this data – this means you! – will have a strong competitive advantage in this data-smitten business world....

熱門審閱

DQ

Jun 21, 2020

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.

YJ

Aug 20, 2019

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.

篩選依據:

701 - 使用 MySQL 管理大数据 的 725 個評論(共 755 個)

創建者 Nenad Š

Feb 12, 2017

Good introduction

創建者 ayush s

Jun 11, 2020

good instructors

創建者 Narendar R K

Oct 05, 2017

very good course

創建者 Aakanksh M

Jun 14, 2020

Amazing Course

創建者 Minal M

Aug 12, 2020

good course

創建者 dynasty919

Mar 16, 2018

interesting

創建者 Rohit K S

Sep 23, 2020

Awesome!!

創建者 Elvan V

Sep 20, 2020

Well done

創建者 ธนาคาร ฉ

Feb 09, 2017

difficult

創建者 fagner d s

Jun 22, 2016

excelent

創建者 Hemant C

Aug 20, 2018

Thanks.

創建者 Priyadharsini S

Mar 04, 2020

Nice

創建者 Omair A

Jul 24, 2018

okay

創建者 Heeyeon L

Jan 25, 2017

Q

創建者 Alexander S

Apr 06, 2016

g

創建者 Jerry F

Nov 27, 2016

The course structure was well formatted. The order of the lessons and content presented made for learning intuitive. The follow along practice queries and end of lesson practice problems were also helpful interactives for the student.

However there were mistakes in the answer keys or practice problem prompts that became more frequent in the lessons towards the end of the course. This made it difficult to practice the more complicated material and queries. It was also a big time waster when as a student you were unsure whether you were answering the correct question and if so whether your answer was correct. It would also been helpful to have more open ended practice problems at the end of the course in addition to the set provided.

Finally I think this course would be better split into two parts. The first part should be geared towards querying data and focusing more on just pulling data and intermediate queries. The main audience would be analyst/data professionals that have privileges to pull data but not modify data. The second part of the course would be more useful to DBAs or professionals that have database admin privileges to insert/delete/modify data. I would also focus more heavily on database schemas in this second course relative to the first.

創建者 Christopher E

Sep 05, 2017

Managing big data with MySQL helped me learn SQL. That was my primary goal. It was thus valuable and met my needs. My secondary (a close second) was to pick up some skills regarding MySQL, which is a specific and distinct relational database management system (distinct from, say, Microsoft's version or from PostgreSQL). On this front I was disappointed. The course is taught through other interfaces, such as Jupyter and Teradata, and neither offers nor requires any exposure to MySQL. I therefore think the course should be renamed Managing big data with SQL; that is, 'MySQL' should be removed from the name. It is, as it stands, misleading to folks like me interested in specifically getting some exposure to and familiarity with MySQL and the minor-league database administrative tricks that would come with that exposure. Thanks for the chance to comment.

創建者 Kyra-lin H

Jun 27, 2017

I definitely learned a lot from taking this course, but there were several frustrating road blocks along the way. These included items such as mistakes in the answer keys, a lack of explicit assignment instructions, and large jumps in difficulty levels between the later weeks. For those considering this course, be aware that the estimated time commitment provided by the course (8-10 hours a week) is a very *low* estimate. Or rather, that estimate is accurate for Weeks 1 & 2, but expect that amount to double by Week 5.

For readers' reference: I came into this course with a lot of experience with Microsoft Access but only limited experience working with SQL directly.

創建者 Ted Z

Jun 23, 2020

The course starts out well, but by the 2nd half you pretty much end up teaching yourself by reading questions (that sometimes contain wrong information) and non-clickable article links from PDFs that work half the time. The Teradata interface is terrible, limiting you to seeing 10 lines of code in queries that are usually 2-3x that long, and without the line number references that most interfaces have that help you find errors. But it does cover the basics well before veering off into nested subquery logic that could have been done in easier ways.

創建者 Justin F

Dec 09, 2016

This course provided a good introduction to SQL for me as a beginner and through challenging lessons forced me to learn SQL basics. After Week 3 however, I found that the level of difficulty increased steeply and not enough assistance was provided in the lessons to get through the course at a reasonable pace. In addition to providing answers to each week's exercises, further review of how the answer was obtained and the breakdown of the logic behind it would be helpful.

創建者 Max R

Dec 07, 2017

I brute forced my way through this class. Many new topics are shown in the exercises and not discussed. Some of the exercises have misleading (or incorrect) information which made me spin my head for a long long time. However... at the end of it I do understand SQL query formation pretty well. If I could go back in time, I'd force myself to take this class with a friend or partner instead of trying to go it alone.

創建者 Haolei F

Mar 08, 2016

The video instruction are not as helpful as I wished. They were too brief, and all the learning end up with doing the exercises. The regular exercises and the quizzes use different database system, and it sometimes hard to transfer what you learn to the quizzes.

The pre-quiz exercises are more helpful imo, but no answer key is provided. Sometimes I am still confused even after passing the quiz.

創建者 Mohammad A

Jan 20, 2020

Great content, but this was over kill. The course was useful but I found it extremely straining to have to use 2 platforms (Jupyter and Teradata). I pretty much had to keep thinking everything twice, and it was over complicated especially that the Teradata website doesn't run smoothly and had many connection issues.

創建者 SIDDHANT J

Apr 28, 2020

I was continuing with this course and have completed 2 weeks, but the Teradata Viewpoint doesn't seem to work. I am trying for the past 2 days and hence, I will not be able to continue this course. I liked the first 2 weeks though.

創建者 Kaicheng Z

Aug 04, 2020

I recognize the value of this course in terms of the real database it is using. Yet, I don't see this format intuitive for learning SQL. Good course for practicing SQL for experienced leaners, but not that friendly to beginners