Set Reminder Save for later

Managing Big Data with MySQL

This course is a part of Excel to MySQL: Analytic Techniques for Business, a 5-course Specialization series from Coursera.

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.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Coursera.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Coursera

&

Duke University

Rating 4.6 based on 421 ratings
Length 6 weeks
Effort 5 weeks, 8-12 hours per week
Starts Feb 11 (10 weeks ago)
Cost $79
From Duke University via Coursera
Instructors Daniel Egger, Jana Schaich Borg
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science
Tags Data Science Data Analysis

Get a Reminder

Get an email reminder about this course

Send to:

What people are saying

We analyzed reviews for this course to surface learners' thoughts about it

recommend this course in 12 reviews

Great content, a lIttle too fast on the vIdeos Recommend this course for any beginner in sql.

I would highly recommend this course!

I recommend this course although the exercise requires more time than the average courses in Coursera.

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!

So for those who want to learn SQL and willing to spend more than ten hours practicing every week, i strongly recommend this course :) You get a lot of information and really need to invest some time but I highly recommend it, it includes many practical exercises.

I strongly recommend this course!Firstly, This course gives listeners great opportunities to get access to the real world data and the skills to retrieve the data that can be used for analyzing.

I HIGHLY RECOMMEND THIS COURSE FOR ANYONE INTERESTED.

Would recommend this course!!!

real world in 9 reviews

She covers the basic, intermediate and advanced topics one can possibly think of within the context of solving real world problems.

What I loved the most about the course was working messy real world data.FYI, the last week of the course takes significantly longer than the rest.

Very good exercises that teach you how to use SQL to manipulate data in real world Excellent course structure designed for students with no technical background to understand how industry analytics works.Real company databases donated by dognition and dillard's helped a lot to understand real analysis problems.A good experience overall.

To the point and with excellent real world data to train on your assignments VERY HELPFUL!

That's true that data in the real world is messy and missing.

Access to real world data is a huge +.

The instructor is careful to include real world working experience in our learning which makes this course especially interesting and valuable.

data sets in 8 reviews

If you have an interest You can complete these courses with in 2 weeks.The Course gave the full hands on real time data with Dognition and Dillards Data sets.

There are plenty of practice exercises and the data sets also help getting in the taste of business data.

It gives you the confidence of working with big data sets, gives an insight into how other cohorts think and helps you rate your own faculties of logic.

Short but precise in the theory and lot's of practice on real data sets from real businesses.

introduction to sql in 7 reviews

I highly recommend this course to individuals willing to put the time in to learning a A good and not so easy introduction to SQL 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!)

This course is a great introduction to SQL.

Excellent introduction to SQL if students take the extra time to do the optional exercises and really get comfortable with the SQL syntax and nuances.

Perfect for an introduction to SQL.

This course provided a good introduction to SQL for me as a beginner and through challenging lessons forced me to learn SQL basics.

As an introduction to SQL this course is great!

Excellent introduction to SQL.

lot of time in 7 reviews

It took a lot of time, but if you give your time to this course you will learn 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.

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!!

These errors are wasting students a lot of time.

If you choose to follow this course, you will have to invest a lot of time.

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.

A lot of times there are SQL classes that are online that give you a glimpse into what it takes to be great at SQL queries.

it is as great as i think The course should be longer, prepare yourself you are going to need a lot of time, unless you have previous experience from SQL.

highly recommended in 7 reviews

Highly recommended if you want to learn SQL on different (MySql and Teradata) platforms.

Highly recommended!

Highly recommended for beginners as well.

Solid Intro to the SQL - highly recommended.Thank you very much for this knowledge.

Highly recommended.

Highly recommended for SQL starters.

Highly recommended to anyone who needs to learn big data SQL.

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Adjunt Instructor - Databases $56k

Relational DB Analyst $114k

.NET Web Developer / SQL Databases Consultant $119k

UNIX/Perl Developer / Oracle / SQL Server Databases $126k

Senior Software Engineer - Databases $152k

Write a review

Your opinion matters. Tell us what you think.

Coursera

&

Duke University

Rating 4.6 based on 421 ratings
Length 6 weeks
Effort 5 weeks, 8-12 hours per week
Starts Feb 11 (10 weeks ago)
Cost $79
From Duke University via Coursera
Instructors Daniel Egger, Jana Schaich Borg
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science
Tags Data Science Data Analysis

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now