К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Managing Big Data with MySQL · LearnSpace
Назад в каталог
courseraАнализ данных

Managing Big Data with MySQL

Курс от Duke University
Уровень не указан≈ 27.3 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

SQLMySQLRelational DatabasesDatabase DesignQuery LanguagesBusiness AnalysisBig DataDatabasesDatabase ManagementData AnalysisData Modeling

Программа курса

6 модулей · 73 учебных материалов

01About this Specialization and Course 9 материалов

Specialization Introduction: Excel to MySQL: Analytic Techniques for Business

About this SpecializationВидеоSpecialization OverviewЧтениеReport a problem with the course Чтение

Introduction to Managing Big Data with MySQL

Important: Teradata Course ChangesЧтение

Учитесь у экспертов

Daniel Egger

Executive in Residence and Director, Center for Quantitative Modeling

Jana Schaich Borg

Assistant Research Professor

Managing Big Data with MySQL
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 27.3 ч

6 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Welcome to Managing Big Data with MySQLВидео
What You Will Learn in This CourseВидео
Course OverviewЧтение
IMPORTANT FOR EVERY LEARNERЧтение
Special Thanks!Чтение
02Understanding Relational Databases16 материалов

Lesson 1: Problems Databases Solve

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

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

How to Make Entity-Relationship Diagrams using ERDPlusВидеоEntity-Relationship Written ExercisesЧтениеEntity-Relationship Written Exercises: Answer KeyЧтение

Lesson 4: Building Your Own Relational Schemas

How to Make Relational Schemas using ERDPlusВидеоRelational Schemas Written ExercisesЧтениеRelational Schemas Written Exercises: Answer KeyЧтение

Lesson 5: Test Your Understanding

Dognition Relational Schema Practice ExerciseЧтениеWeek 1 Graded QuizЗаданиеWeek One Quiz: Answers and FeedbackЧтениеWrapping up Week 1Видео
03 Queries to Extract Data from Single Tables 17 материалов

Lesson 1: Meet Your Business Data Set

Introduction to Week 2ВидеоMeet Your Dognition DataВидеоDognition Database InformationЧтение

Lesson 2: Using the Jupyter Interface for MySQL Queries

Introduction to Query SyntaxВидеоHow to Use Jupyter NotebooksВидеоHow to Use Your Jupyter AccountВидеоHow to Use Jupyter (Written Instructions)ЧтениеLink to Your Jupyter Home PageЛабораторная

Lesson 3: SQL Queries for Looking at Your Data

MySQL Exercise 1: Looking at Your DataЛабораторнаяMySQL Exercise 1: Answer KeyЧтениеWeek 3Задание

Lesson 4: Setting Criteria with WHERE

MySQL Exercise 2: Selecting Data Subsets Using WHEREЛабораторнаяMySQL Exercise 2: Answer KeyЧтение

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

MySQL Exercise 3: Formatting Selected DataЛабораторнаяMySQL Exercise 3: Answer KeyЧтение

Lesson 6: Test Your Understanding

Week 2 Graded QuizЗаданиеYou Have Already Become a Different Level of Business AnalystВидео
04Queries to Summarize Groups of Data from Multiple Tables 17 материалов

Lesson 1: Summarizing Your Data Using Aggregate Functions

Welcome to Week 3ВидеоMySQL Exercise 4: Summarizing Your DataЛабораторнаяMySQL Exercise 4: Answer KeyЧтениеHabits that Help You Avoid MistakesВидео

Lesson 2: Segmenting Your Data Using GROUP BY

MySQL Exercise 5: Breaking Your Summaries into GroupsЛабораторнаяMySQL Exercise 5: Answer KeyЧтениеMySQL Exercise 6: Common Pitfalls of GROUP BYЛабораторнаяThere is NO Answer Key for MySQL Exercise 6Чтение

Lesson 3: Joining Tables

What are Joins?ВидеоJoins with Many to Many Relationships and DuplicatesВидеоA Note about Our Join ExamplesВидео

Lesson 4: Practicing Inner Joins

MySQL Exercise 7: Inner JoinsЛабораторнаяMySQL Exercise 7: Answer KeyЧтение

Lesson 5: Practicing Outer Joins

MySQL Exercise 8: Joining Tables with Outer JoinsЛабораторнаяMySQL Exercise 8: Answer KeyЧтение

Lesson 6: Test Your Understanding

Week 3 Graded Quiz ЗаданиеNo More Waiting to Retrieve Your DataВидео
05 Queries to Address More Detailed Business Questions11 материалов

Lesson 1: Subqueries and Derived Tables

Welcome to Week 4ВидеоMySQL Exercise 9: Subqueries and Derived TablesЛабораторнаяMySQL Exercise 9: Answer KeyЧтение

Lesson 2: Useful Logical Functions

MySQL Exercise 10: Useful Logical FunctionsЛабораторнаяMySQL Exercise 10: Answer KeyЧтение

Lesson 3: Working Through Your Dognition Analysis Plan

Start with an Analysis PlanВидеоDognition Structured Pyramid Analysis Plan (SPAP)ЧтениеMySQL Exercise 11: Queries that Test Relationships Between Test Completion and Dog CharacteristicsЛабораторнаяMySQL Exercise 11: Answer KeyЧтение

Lesson 4: Working Through More of Your Dognition Analysis Plan

MySQL Exercise 12: Queries that Test Relationships Between Test Completion and Testing CircumstancesЛабораторнаяMySQL Exercise 12: Answer KeyЧтение
06Strengthen and Test Your Understanding 3 материалов

Lesson 2: Test Your Understanding

Week 4 Graded Quiz ЗаданиеDon't Be Afraid to Ask Questions!ВидеоShare your learning experience Чтение