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.

Set Reminder Save for later

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.5 based on 505 ratings
Length 6 weeks
Effort 5 weeks, 8-12 hours per week
Starts Jun 17 (2 days 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

According to other learners, here's what you need to know

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!

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

Read more

highly recommended in 10 reviews

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

Highly recommended!

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.

Highly recommended!!!

Read more

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.

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.

Read more

data sets in 9 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.

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

The data sets are very hard to understand.

Read more

introduction to sql in 8 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.

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.

very helpful Great course if you want a good introduction to SQL and how relational databases work.

Read more

feel like in 7 reviews

Out of the four courses in this specialization, I feel like I have learned something completely new.

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.

It became challenging enough at the end to really feel like an accomplishment when completing it.

I definitely feel like this course does a great job of teaching applied SQL, rather than just teaching you syntax.

Still a lot to learn but I certainly feel like a can learn it.

Personally I have experience with R and Python, yet I still feel like I learned a lot from the exercises.

Read more

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.5 based on 505 ratings
Length 6 weeks
Effort 5 weeks, 8-12 hours per week
Starts Jun 17 (2 days 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