Managing Big Data with MySQL
Learn to make use of relational databases, and understand how they work exactly in cases of business analysis.
Online
3 Weeks
1,699 INR Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Course Overview
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
- 3 weeks programme
- 100% online course
- 10 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 |
Managing Big Data with MySQL Fee Structure
Course name | Fee in INR |
| Audit mode | Free |
Managing Big Data with MySQL (1 month) | Rs. 1,699 |
| Managing Big Data with MySQL (3 months) | Rs. 3,499 |
| Managing Big Data with MySQL (6 months) | Rs. 5,199 |
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
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)
Since every certificate generated has a specific URL so it is possible to share on professional platforms.
Yes, the cards shall be charged unless Coursera has been informed of the course subscription cancellation.
There is no such requirement but all participants attending all the lectures, and quizzes will be appreciated.
The participants of Coursera’s MYSQL programme can rewatch the videos as many times as they want to until their concerts are clear.
Even if during the free trial, candidates cancel the subscription, they can access the Specialization.