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!
About this Course
Skills you will gain
Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.
- 5 stars78.77%
- 4 stars16.94%
- 3 stars2.66%
- 2 stars0.76%
- 1 star0.86%
TOP REVIEWS FROM MANAGING BIG DATA WITH MYSQL
The exercises and quizzes (particularly the teradata sets) were difficult enough that you have to think and structure your approach to arrive at the right solution. Very good learning curve.
Its a very good class to learn to use SQL in a systematic manner, even if you had used SQL or are completely new. The two Databases ( Terradata and Dognition) gave a lot of valuable practice.
Each week's lessons are very well thought and I'd like to thank to the professors who created this amazing course. The last exam is very challenging! Be ready to spend +10 hours in a day :D
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.
About the Excel to MySQL: Analytic Techniques for Business Specialization
Formulate data questions, explore and visualize large datasets, and inform strategic decisions.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
Will I receive a transcript from Duke University for completing this course?
More questions? Visit the Learner Help Center.