Managing Big Data with MySQL

This course looks at large databases and business analysis. It teaches how they work and how to work with them to solve problems and answer questions.

Created by: Daniel Egger

Produced in 2016

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

icon
Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a data science course? Or looking for more detail on Daniel Egger's Managing Big Data with MySQL? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

icon
Course Description

icon
data science Awards Best Free Course

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.

icon
Pros

icon
Cons

    • Examples are extremely practical and help to build a marketable portfolio.
    • Students who complete this course will be adept at writing queries.
    • Course manages to fit roughly two semesters’ worth of concepts into a single, accessible tutorial.
    • Teradata resources suffer from frequent downtime.
    • Course time estimates are grossly understated.
    • Instruction glosses over data sets themselves and focuses more on applications.

icon
Instructor Details

Daniel Egger

Daniel Egger has more than seventeen years experience creating new software products and services, as founder and CEO of a series of venture-backed information technology companies, and as Managing Partner in a venture capital fund. Egger is Executive in Residence in Duke University's Master of Engineering Management Program and has taught courses in entrepreneurship and venture capital at Duke since 2003. He was formerly the Howard Johnson Foundation Entrepreneur-in-Residence in Duke's Markets and Management Program for undergraduates.

icon
Students also recommend

Free

Free

$10.44

icon
Reviews

4.7

140 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Justin G on 9-Oct-17

Sorry, I need to give this a course a 0 but since the review won't let me submit without scoring it, I'll give it a 1. It was designed beautifully and to maximize skill building. I really like the idea of using two different databases. However, the Teradata database was down way too long, much longer than it was up. People had to pay extra than planned to continue taking the course as a result. The instructors planned everything beautifully-except developing a backup plan in case the third party Teradata server went down, which it did. If the instructors or the university with they are affiliated have no control over this additional server, leaving the students helpless, they really should reconsider their use of materials outside of which they have direct control.

By Franklin D on 14-Dec-17

I thought it was good overall for teaching SQL and I enjoy Jana a lot... howeverbiggest issues were the time taking much longer than expected and the Junyper Notebooks not functioning, giving me even more time issues.Also some typos in the quiz answer sheets and lack of clarity in questions (when clarity is extremely important for the answer!)

By Milad R on 24-Jan-18

The Jupyter notebook of the course had been not working for two days and I could not even see the course material in the notebook.

By Schwinn C on 29-Aug-18

The data sets are very hard to understand. The teacher should spend more time to explain the data set before assigning excesses and quiz with them. It took me two courses to understand what Dognition is doing (the video from the CEO is a very bad introduction, he did not explain the company very well). When you ask questions in the course discussion forum, NO ONE answers your questions.

By Zhang J on 27-May-17

too long for the practise and just getting too long to finish one week

By Venkat M K on 13-Sep-17

pretty useless seriously

By Pablo V I on 26-Dec-17

I recommend this course although the exercise requires more time than the average courses in Coursera. If you complete it seriously on your own you will learn a lot in order to apply it at work.

By Giulio C on 9-Jan-19

I legitimately believe this is the best source for Data/Business Analysts who would like to learn how to use SQL for analyzing datasets. They take you through the step by step process of learning everything and also provide a lot of material (weekly quizzes and exercises) to review and truly test your understanding of what you've learnt. This course takes quite a lot of time which is great because it means that if you get through it you will have learnt a lot!

By Justin on 1-Mar-16

It's a good class and I learned a lot. The learning curve shoots up exponentially around the fourth week. I could see this course being perfect if broken down into two classes.

By Zhu Y on 4-Aug-18

one star for the certificate;one for let me learn basic knowledge of SQL;the website often breaks down,so is the Teredata system ;the problem-solution system is also troublesome,hard to get the solution on time, maybe it is better to set a all-time online problem solver. No answer for teredata exercise also trap me for the hint in the teredata excersise sometimes not clear. Hope advancement for this course and the better experience of users.

By Neal D on 5-Feb-17

Poor performance of Jupyter and the wildly underestimated time commitments really sunk this one for me. The latter, especially is inexcusable. The syllabus is lopsided and, while organized, not enough thought has been given to the exercise workload.

By Christine D on 8-Jul-19

The exercises force you to think deeply about what you're doing, and use a variety of useful sql logic. However the environment works against you: both environments lack the syntax highlighting that would make these questions so much easier in sql server. The Teradata environment only allows you to view about 10 lines of code without scrolling, and has no tab or autocomplete. This was fine up until the last test where some of my queries were 30 lines or more. The last week was so painful that I would recommend other learners find a different course. Such a shame because the exercises are thoughtfully designed and I did learn a lot.