Managing Big Data with MySQL certification is offered by Duke University by associating with the online education provider platform Coursera. This course is offered as part of the Specialization - Excel to MySQL: Analytic Techniques for Business. Taking around 27 hours to get completed, this certification is course 4 of 5 in the specialization. To make the participant’s life easier there are 11 languages in which subtitles can be accessed.
Managing Big Data with MySQL training is basically introduced for making the participants aware of relational databases. These databases are important for conducting business analysis. The applicants shall also make entity-relationship diagrams for displaying data structures within the database. This online course is apt for participants who can help in understanding what, and how data can be captured for business purposes. It will also enlighten on the aggregation statements used by business analysts for real databases so there is no need for waiting for others to give data insights.
The Highlights
6 weeks programme
100% online course
27 hours of classes
Learning by self
11 subtitles available
Certificate by Coursera
Programme Offerings
Online Course
Shareable Certificate
Flexible Deadlines
assignments
English Course
11 Subtitles Available
Lectures
videos
Readings
Practice Exercises
Final exam.
Courses and Certificate Fees
Certificate Availability
Certificate Providing Authority
yes
Coursera
The Managing Big Data with MySQL certification fee per month is Rs. 4,115 . This fee is usually deducted after the first 7 days of the free trial ends. During the free trial, only the course content except for quizzes will be accessible. But after students start paying everything opens, and becomes accessible including the certificate.
Managing Big Data with MySQL Fee Structure
Course name
Fee in INR
Audit mode
Free
Managing Big Data with MySQL (1 month)
Rs. 4,115
Managing Big Data with MySQL (3 months)
Rs. 8,230
Managing Big Data with MySQL (6 months)
Rs. 12,345
Eligibility Criteria
Educational Qualification
Knowing Spanish, English, Russian, Korean, Italian, Portuguese (European), Vietnamese, French, German, Chinese and Arabic, and, will help with understanding the programme in subtitles.
Certification Qualifying Details
For the Managing Big Data with MySQL certification by Coursera, participants have to complete all the videos, readings, and a final graded quiz that is present in the syllabus.
What you will learn
SQL knowledge
With the Managing Big Data with MySQL certification syllabus, the candidates will have a very strong competitive advantage over others in topics like MySQL, Teradata, SQL and Data Analysis. Candidates will also understand the exact working model of relational databases. The main thing this course will teach is taking care of Big Data with the help of MySQL.
Admission Details
The Managing Big Data with MySQL admission process is as follows:
Step 1: Visit the official website: https://www.coursera.org/learn/analytics-mysql
Step 2: Candidate should next find, and click on the ‘Join for free’ button.
Step 3: As the button gets clicked, a small form asking the candidates to sign up pops out.
Step 4: Then account has to be made, and the fee has to be deposited to earn admission,
Application Details
Creating an account with submitting details like mail address, password, and name will be enough for seeking admission to the mentioned course on Coursera. No additional hassle has to be taken up by the candidates.
The Syllabus
Videos
About this Specialization
Welcome to Managing Big Data with MySQL
What You Will Learn in This Course
Readings
Specialization Overview
Course Overview
IMPORTANT FOR EVERY LEARNER
Special Thanks!
Videos
Problems with Having a Lot of Data Used by a Lot of People
How Relational Databases Help Solve Those Problems
Database Design Tools That Will Help You Learn SQL Faster
How Entity-Relationship Diagrams Work
Database Structures Illustrated by Entity-Relationship Diagrams
Relational Schemas
How to Make Entity-Relationship Diagrams using ERDPlus
How to Make Relational Schemas using ERDPlus
Wrapping up Week 1
Readings
Entity-Relationship Written Exercises
Entity-Relationship Written Exercises: Answer Key
Relational Schemas Written Exercises
Relational Schemas Written Exercises: Answer Key
Dognition Relational Schema Practice Exercise
Dillard's Relational Schema Practice Questions
Week One Quiz: Answers and Feedback
Assignment
Week 1 Graded Quiz
Videos
Introduction to Week 2
Meet Your Dognition Data
Meet Your Dillard's Data
Introduction to Query Syntax
How to Use Jupyter Notebooks
How to Use Your Jupyter Account
How to Use Teradata Viewpoint and SQL Scratchpad
You Have Already Become a Different Level of Business Analyst
Readings
Dognition Database Information
Dillard's Database Information
How to Use Jupyter (Written Instructions)
MySQL Exercise 1: Answer Key
MySQL Exercise 2: Answer Key
MySQL Exercise 3: Answer Key
Assignment
Week 2 Graded Quiz
Week 3
Ungraded Labs
Link to Your Jupyter Home Page
MySQL Exercise 1: Looking at Your Data
MySQL Exercise 2: Selecting Data Subsets Using WHERE
MySQL Exercise 3: Formatting Selected Data
Videos
Welcome to Week 3
Habits that Help You Avoid Mistakes
What are Joins?
Joins with Many to Many Relationships and Duplicates
A Note about Our Join Examples
No More Waiting to Retrieve Your Data
Readings
MySQL Exercise 4: Answer Key
MySQL Exercise 5: Answer Key
There is NO Answer Key for MySQL Exercise
MySQL Exercise 7: Answer Key
MySQL Exercise 8: Answer Key
Week 3 Teradata Practice Exercises Guide
Week 3 Quiz: Answers and Feedback
Assignment
Week 3 Graded Quiz
Ungraded Labs
MySQL Exercise 4: Summarizing Your Data
MySQL Exercise 5: Breaking Your Summaries into Groups
MySQL Exercise 6: Common Pitfalls of GROUP BY
MySQL Exercise 7: Inner Joins
MySQL Exercise 8: Joining Tables with Outer Joins
Videos
Welcome to Week
Start with an Analysis Plan
Readings
MySQL Exercise 9: Answer Key
MySQL Exercise 10: Answer Key
Dognition Structured Pyramid Analysis Plan (SPAP)
MySQL Exercise 11: Answer Key
MySQL Exercise 12: Answer Key
No Week Four Quiz
Ungraded Labs
MySQL Exercise 9: Subqueries and Derived Tables
MySQL Exercise 10: Useful Logical Functions
MySQL Exercise 11: Queries that Test Relationships Between Test Completion and Dog Characteristics
MySQL Exercise 12: Queries that Test Relationships Between Test Completion and Testing Circumstances
Videos
Don't Be Afraid to Ask Questions!
Assignment
Week 4 Graded Quiz
Instructors
Duke University, Durham Frequently Asked Questions (FAQ's)
1: Can certificates with specific URLs be shared on professional platforms?
Since every certificate generated has a specific URL so it is possible to share on professional platforms.
2: Will Coursera keep on charging money from the student’s debit and credit cards for this programme?
Yes, the cards shall be charged unless Coursera has been informed of the course subscription cancellation.
3: What is the attendance requirement for the Managing Big Data with MySQL certification course?
There is no such requirement but all participants attending all the lectures, and quizzes will be appreciated.
4: Can the candidates keep on rewatching the videos until they fully understand the certification course?
The participants of Coursera’s MYSQL programme can rewatch the videos as many times as they want to until their concerts are clear.
5: Is the course materials visible eleven when students cancel their free trial for the Managing Big Data with MySQL programme?
Even if during the free trial, candidates cancel the subscription, they can access the Specialization.