About this Course

230,547 recent views

Learner Career Outcomes

42%

started a new career after completing these courses

42%

got a tangible career benefit from this course

24%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Approx. 32 hours to complete
English

Skills you will gain

Data AnalysisMySQLTeradataSQL

Learner Career Outcomes

42%

started a new career after completing these courses

42%

got a tangible career benefit from this course

24%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Approx. 32 hours to complete
English

Offered by

Placeholder

Duke University

Syllabus - What you will learn from this course

Content RatingThumbs Up96%(15,457 ratings)Info
Week
1

Week 1

1 hour to complete

About this Specialization and Course

1 hour to complete
3 videos (Total 16 min), 4 readings
3 videos
Welcome to Managing Big Data with MySQL1m
What You Will Learn in This Course10m
4 readings
Specialization Overview10m
Course Overview10m
IMPORTANT FOR EVERY LEARNER10m
Special Thanks!5m
5 hours to complete

Understanding Relational Databases

5 hours to complete
9 videos (Total 55 min), 7 readings, 1 quiz
9 videos
How Relational Databases Help Solve Those Problems8m
Database Design Tools That Will Help You Learn SQL Faster4m
How Entity-Relationship Diagrams Work8m
Database Structures Illustrated by Entity-Relationship Diagrams6m
Relational Schemas9m
How to Make Entity-Relationship Diagrams using ERDPlus4m
How to Make Relational Schemas using ERDPlus4m
Wrapping up Week 130s
7 readings
Entity-Relationship Written Exercises1h
Entity-Relationship Written Exercises: Answer Key5m
Relational Schemas Written Exercises1h
Relational Schemas Written Exercises: Answer Key5m
Dognition Relational Schema Practice Exercise30m
Dillard's Relational Schema Practice Questions30m
Week One Quiz: Answers and Feedback10m
1 practice exercise
Week 1 Graded Quiz45m
Week
2

Week 2

9 hours to complete

Queries to Extract Data from Single Tables

9 hours to complete
8 videos (Total 60 min), 12 readings, 1 quiz
8 videos
Meet Your Dognition Data11m
Meet Your Dillard's Data2m
Introduction to Query Syntax7m
How to Use Jupyter Notebooks16m
How to Use Your Jupyter Account8m
How to Use Teradata Viewpoint and SQL Scratchpad10m
You Have Already Become a Different Level of Business Analyst1m
12 readings
Dognition Database Information10m
Dillard's Database Information10m
How to Use Jupyter (Written Instructions)10m
MySQL Exercise 1: Answer Key10m
MySQL Exercise 2: Answer Key10m
MySQL Exercise 3: Answer Key10m
***Important Weekend Update Regarding Teradata 10/24/201m
How to Login to and Use Teradata Viewpoint (Written Instructions)10m
Week 2 Teradata Practice Exercises Guide1h 30m
Introduction to Teradata10m
Read Before Starting Quiz 210m
Week 2 Quiz: Answers and Feedback10m
1 practice exercise
Week 2 Graded Quiz using Teradata30m
Week
3

Week 3

10 hours to complete

Queries to Summarize Groups of Data from Multiple Tables

10 hours to complete
6 videos (Total 29 min), 7 readings, 1 quiz
6 videos
Habits that Help You Avoid Mistakes4m
What are Joins?8m
Joins with Many to Many Relationships and Duplicates6m
A Note about Our Join Examples2m
No More Waiting to Retrieve Your Data42s
7 readings
MySQL Exercise 4: Answer Key10m
MySQL Exercise 5: Answer Key10m
There is NO Answer Key for MySQL Exercise 65m
MySQL Exercise 7: Answer Key10m
MySQL Exercise 8: Answer Key10m
Week 3 Teradata Practice Exercises Guide2h
Week 3 Quiz: Answers and Feedback10m
1 practice exercise
Week 3 Graded Quiz using Teradata1h 15m
Week
4

Week 4

5 hours to complete

Queries to Address More Detailed Business Questions

5 hours to complete
2 videos (Total 9 min), 6 readings
2 videos
Start with an Analysis Plan5m
6 readings
MySQL Exercise 9: Answer Key10m
MySQL Exercise 10: Answer Key10m
Dognition Structured Pyramid Analysis Plan (SPAP)30m
MySQL Exercise 11: Answer Key10m
MySQL Exercise 12: Answer Key10m
No Week Four Quiz5m

Reviews

TOP REVIEWS FROM MANAGING BIG DATA WITH MYSQL

View all reviews

About the Excel to MySQL: Analytic Techniques for Business Specialization

Excel to MySQL: Analytic Techniques for Business

Frequently Asked Questions

More questions? Visit the Learner Help Center.