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!
This course is part of the Excel to MySQL: Analytic Techniques for Business Specialization
Offered By
About this Course
Skills you will gain
- Data Analysis
- MySQL
- Teradata
- SQL
Offered by
Syllabus - What you will learn from this course
About this Specialization and Course
Understanding Relational Databases
Queries to Extract Data from Single Tables
Queries to Summarize Groups of Data from Multiple Tables
Queries to Address More Detailed Business Questions
Reviews
- 5 stars78.75%
- 4 stars16.96%
- 3 stars2.65%
- 2 stars0.75%
- 1 star0.87%
TOP REVIEWS FROM MANAGING BIG DATA WITH MYSQL
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.
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.
It is a good course and I have learnt managing the data which I always felt curious to know .I was difficult for me to understand teradata at first because their is not a lot information about it
Very well structured course. Not that difficult as i thought but it did take me much more time than I expected. You'd better focus on learning for several hours instead of using short time slot.
About the Excel to MySQL: Analytic Techniques for Business Specialization

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.