Buy Now AED 274.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Managing Big Data with MySQL
  • Level Foundation
  • Duration 32 hours
  • Course by Duke University
  • Offered by

About

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! By the end of this course, you will have a clear understanding of how relational databases work, and have a portfolio of queries you can show potential employers. Businesses are collecting increasing amounts of information with the hope that data will yield novel insights into how to improve businesses. Analysts that understand how to access this data " this means you! " will have a strong competitive advantage in this data-smitten business world.

Modules

Specialization Introduction: Excel to MySQL: Analytic Techniques for Business

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • About this Specialization

1 Readings

  • Specialization Overview

Introduction to Managing Big Data with MySQL

    • 2 Videos
    • 4 Readings
Show info about module content

2 Videos

  • Welcome to Managing Big Data with MySQL
  • What You Will Learn in This Course

4 Readings

  • Important: Teradata Course Changes
  • Course Overview
  • IMPORTANT FOR EVERY LEARNER
  • Special Thanks!

Lesson 1: Problems Databases Solve

    • 2 Videos
Show info about module content

2 Videos

  • Problems with Having a Lot of Data Used by a Lot of People
  • How Relational Databases Help Solve Those Problems

Lesson 2: Database Design Tools

    • 4 Videos
Show info about module content

4 Videos

  • Database Design Tools That Will Help You Learn SQL Faster
  • How Entity-Relationship Diagrams Work
  • Database Structures Illustrated by Entity-Relationship Diagrams
  • Relational Schemas

Lesson 3: Building Your Own Entity-Relationship Diagrams

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • How to Make Entity-Relationship Diagrams using ERDPlus

2 Readings

  • Entity-Relationship Written Exercises
  • Entity-Relationship Written Exercises: Answer Key

Lesson 4: Building Your Own Relational Schemas

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • How to Make Relational Schemas using ERDPlus

2 Readings

  • Relational Schemas Written Exercises
  • Relational Schemas Written Exercises: Answer Key

Lesson 5: Test Your Understanding

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Week 1 Graded Quiz

1 Videos

  • Wrapping up Week 1

2 Readings

  • Dognition Relational Schema Practice Exercise
  • Week One Quiz: Answers and Feedback

Lesson 1: Meet Your Business Data Set

    • 2 Videos
    • 1 Readings
Show info about module content

2 Videos

  • Introduction to Week 2
  • Meet Your Dognition Data

1 Readings

  • Dognition Database Information

Lesson 2: Using the Jupyter Interface for MySQL Queries

    • 3 Videos
    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • Link to Your Jupyter Home Page

3 Videos

  • Introduction to Query Syntax
  • How to Use Jupyter Notebooks
  • How to Use Your Jupyter Account

1 Readings

  • How to Use Jupyter (Written Instructions)

Lesson 3: SQL Queries for Looking at Your Data

    • 1 Readings
    • 1 Lab
    • 1 Assignment
Show info about module content

1 Assignment

  • Week 3

1 Labs

  • MySQL Exercise 1: Looking at Your Data

1 Readings

  • MySQL Exercise 1: Answer Key

Lesson 4: Setting Criteria with WHERE

    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 2: Selecting Data Subsets Using WHERE

1 Readings

  • MySQL Exercise 2: Answer Key

Lesson 5: Formatting Results Using Aliases, DISTINCT, and ORDER BY

    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 3: Formatting Selected Data

1 Readings

  • MySQL Exercise 3: Answer Key

Lesson 6: Test Your Understanding

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Week 2 Graded Quiz

1 Videos

  • You Have Already Become a Different Level of Business Analyst

Lesson 1: Summarizing Your Data Using Aggregate Functions

    • 2 Videos
    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 4: Summarizing Your Data

2 Videos

  • Welcome to Week 3
  • Habits that Help You Avoid Mistakes

1 Readings

  • MySQL Exercise 4: Answer Key

Lesson 2: Segmenting Your Data Using GROUP BY

    • 2 Readings
    • 2 Lab
Show info about module content

2 Labs

  • MySQL Exercise 5: Breaking Your Summaries into Groups
  • MySQL Exercise 6: Common Pitfalls of GROUP BY

2 Readings

  • MySQL Exercise 5: Answer Key
  • There is NO Answer Key for MySQL Exercise 6

Lesson 3: Joining Tables

    • 3 Videos
Show info about module content

3 Videos

  • What are Joins?
  • Joins with Many to Many Relationships and Duplicates
  • A Note about Our Join Examples

Lesson 4: Practicing Inner Joins

    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 7: Inner Joins

1 Readings

  • MySQL Exercise 7: Answer Key

Lesson 5: Practicing Outer Joins

    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 8: Joining Tables with Outer Joins

1 Readings

  • MySQL Exercise 8: Answer Key

Lesson 6: Test Your Understanding

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Week 3 Graded Quiz

1 Videos

  • No More Waiting to Retrieve Your Data

Lesson 1: Subqueries and Derived Tables

    • 1 Videos
    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 9: Subqueries and Derived Tables

1 Videos

  • Welcome to Week 4

1 Readings

  • MySQL Exercise 9: Answer Key

Lesson 2: Useful Logical Functions

    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 10: Useful Logical Functions

1 Readings

  • MySQL Exercise 10: Answer Key

Lesson 3: Working Through Your Dognition Analysis Plan

    • 1 Videos
    • 2 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 11: Queries that Test Relationships Between Test Completion and Dog Characteristics

1 Videos

  • Start with an Analysis Plan

2 Readings

  • Dognition Structured Pyramid Analysis Plan (SPAP)
  • MySQL Exercise 11: Answer Key

Lesson 4: Working Through More of Your Dognition Analysis Plan

    • 1 Readings
    • 1 Lab
Show info about module content

1 Labs

  • MySQL Exercise 12: Queries that Test Relationships Between Test Completion and Testing Circumstances

1 Readings

  • MySQL Exercise 12: Answer Key

Lesson 2: Test Your Understanding

    • 1 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Week 4 Graded Quiz

1 Videos

  • Don't Be Afraid to Ask Questions!

Auto Summary

"Managing Big Data with MySQL" is a foundational course in Data Science & AI, offered by Coursera. Led by expert instructors, it focuses on using relational databases for business analysis, including entity-relationship diagrams and SQL queries. The course spans 1920 minutes and is available through Starter, Professional, and Paid subscriptions. Ideal for aspiring analysts, it equips learners with essential skills to independently access and analyze business data, offering a competitive edge in the data-driven business landscape.

Daniel Egger
Instructors

Daniel Egger

Jana Schaich Borg
Instructors

Jana Schaich Borg