Save for later

Managing Big Data with MySQL

Excel to MySQL: Analytic Techniques for Business,

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 and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating 4.5 based on 710 ratings
Length 6 weeks
Effort 5 weeks, 8-12 hours per week
Starts Jun 26 (44 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

Send to:

Similar Courses

What people are saying

duke university

Non course can stand in front of this Mysql course from duke university.

Finally, I enrolled in this Duke University specialization to do four courses (course 1 to course 4 of the specialization Excel to MySQL) This course gave me all the knowledge I need for the SQL learning and the database.

Would definitely be opting for more courses from Duke University!

Thank you so much, it was a pleasure to study SQL with Duke University.

Managing Big Data with MySQL is the fourth and final course in Duke University's Excel to MySQL: Analytic Techniques for Business specialization offered through Coursera.

Thank you, Jana for this wonderful experience, and thank you, Duke University!

Its very awful practically, theoretically and Logically.Thanks to the team and instructors of Coursera and Duke University.MAY ALLAH (GOD) bless you.

This course is now useless since the third-party tool used by this course to open the Jupyter Notebooks is a dead link in the Duke University's server.

Thank you it was relatively time taking course for me but one who keeps on wins at the end.Thank You professor,duke university and coursera for providing such a wonderful course.

Would request Jana to please take note of that.Thanks to Coursera for this wonderful course and to Jana and Daniel Egger, Tara for her quick response during support issues, to Duke University for promoting this course and to Dillards and Dognition team for sharing real-life data for our study and practice purpose.

Read more

highly recommend this course

I would highly recommend this course!

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

Highly recommend this course for people pursuing careers in data analysis/business intelligence - i.e.

Good course for practicing SQL for experienced leaners, but not that friendly to beginners Very advanced and a good coarse to start studying about sql,toughness is also there so if u try hard u will get the benefits I highly recommend this course to anyone who is an aspiring data analyst or anyone who wants to learn MySQL.

I highly recommend this course to all SQL beginners and even intermediate developers!

would highly recommend this course Hands on experience with sql ensures that we learn the concepts properly Great course, great assessment materials and teaching Simply brilliant.

Read more

highly recommended

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

Highly recommended to take this course :).

Read more

step by step

And we don't have the guide step by step like previous weeks.

Step by step instructions let you build a solid foundation.

You move step by step from easy SQL queries to pretty complex ones.

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.

i have to learn something worth my money, then step by step, i start to feel the logic and why and how.

Good great 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.

The course is good structured and you know new things step by step from elementary to more advanced level.

Read more

well structured

Very well structured course.

Well structured, very thorough and making use of some great technological resources for the user to practice their SQL with.

Very well structured and easy to follow.

well structured and intensive course to let me get to know the SQL and I will push myself through it!

I believe that this course is very well structured and that, besides providing the knowledge of SQL language and different functions in it, it also teaches you how to think like a data analyst.

I think the course overall is well structured and let me stretch myself week over week.

Web pages like kaggle.com can give more examples, more interesting and with current data 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.

good instructors Exercises and quizzes are very well structured and everything is explained from scratch.

Really well structured course, with lots of practice exercises to brush your concepts clear.

Course was well structured, I came into it not knowing anything about SQL but I now feel I have the knowledge to comfortably navigate through databases.

Read more

real life data

The course is challenging as it pushed you to deal with real life data set so you not only leaned the language but also how to structure your analysis plan and to execute it.

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

The instructor is really trying to show us that the real life data sets and databases are messy, but providing only written instructions for me it proved useless.

By using real life data, it also accurately presented raw data as not perfectly organized or "clean".

Best Regards and Have a nice day, Mei Not only it teaches you how to use MySQL and Teradata in a technical perspective, it also practice the analytical mind and how you would treat a real life dataset when doing analytical work.

Read more

big data

Managing big data with MySQL helped me learn SQL.

I therefore think the course should be renamed Managing big data with SQL; that is, 'MySQL' should be removed from the name.

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

i would suggest renaming the course Managing Big Data with MySQL and TeraData.

So, I recommend, if anyone interested in Big Data it is worth taking this Course and You get some confidence to go deeper.Big Thanks to Jana.

Loved the course :) i LOVED the course too much exercise Great course about database.This course come from basic background in Relational database rather then go detail to syntax SQL.Beside that, it provide real big dataset (around 100 million records, woa)Thanks for creating such great course Cannot find how do I get certified by coursera.

excellent course for big data and playing with real data//... ... ..

excelent excelente curso, brinda toda la informacion e incluye la practica necesaria para adquirir todo el conocimiento con el mejor software de Big Data It's hard to understand the data that given for quizzes but the teaching of professor Jana is really amazing.when i ask questions in discussion forums there was no tutor to help you out soon.

Managing Big Data with MySQL is a great course for learning practical relational database querying skills with plenty of exercises that let you interact with real-life data sets.

I give Managing Big Data with MySQL 4.5 out of 5 stars: Great.

Read more

learnt a lot

I really learnt a lot about the SQL language and I believe that this course is very helpful to my data analysis jobs.

I really learnt a lot from the course.

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!

Veru Intesnse and challenging course in which I learnt a lot Great course.

Read more

really enjoyed

I really enjoyed this course, and I have no previous experience with SQL.

Really enjoyed it!

Really enjoyed doing all the exercises.

Really enjoyed while working on SQL query exercises.

I Really enjoyed doing all the exercises.

Really enjoyed and accomplished the course timely.

Read more

rather than

Rather than simply explain and demonstrate SQL programming logic and commends, this course provided a comprehansive solution from a business analyst perspective, as well as considerable hands on exercises.

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

The lecture content is high quality but after the first week, you'll be spending most of your time working on exercises rather than watching videos.

Overall the course was very helpful, the exercises informative, the approach to encourage learners to explore stuff rather than being spoon-fed queries.

This course is more on hands on practice rather than videos which is important to learn SQL.

Think the best thing about this course was learning how to apply the technical details to real life examples rather than just learning the theory itself This course is very useful for new students n learners.

Read more

ever taken

Best course I've ever taken.

Best course I've ever taken on coursera because it's all about practice instead of theory - and the quizzes/practice questions are extremely difficult but once you get through it you will definitely say SQL is a skill you own.

goes much deeper than other online SQL courses, problem sets can be hard This is by far the most comprehensive SQL course I have ever taken.

It's very useful for the beginner One of the most amazing MOOC courses I have ever taken.

It was one of the most efficient courses I have ever taken.

Read more

schaich borg

Now I feel quite confident to write any queries.Special Thanks to Professor Jana Schaich Borg for teaching so wonderfully!!!!!

I would be very interested in an advanced course from Jana Schaich Borg, Duke University.

!?I am happy to learn those skills which was essential.I enjoyed studying with Ms. Jana Schaich Borg that she did her hard work to teach me.I appreciate her skills and hard work .Thank you ^_^ The course is designed very thoughtful.

This fabulous course instructed by Dr.Jana Schaich Borg of Duke University have given me the sound principles guide and extensive practices.

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.

Rating 4.5 based on 710 ratings
Length 6 weeks
Effort 5 weeks, 8-12 hours per week
Starts Jun 26 (44 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