How to Use SQL with Large Datasets

Offered By
Coursera Project Network
In this Guided Project, you will:

Use SQL to manage a large dataset using MySQL Workbench.

Clock2 hours
IntermediateIntermediate
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will use SQL to manage a large COVID-19 dataset using MySQL Workbench. MySQL is a widely used relational database and can be used with large datasets if it is managed appropriately. This may include using the proper database engine, indexing the database, creating summary tables, and using proper database queries.

Skills you will develop

Mysql WorkbenchSummary TablesDataSet AnalysisSQL IndexingSQL

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Analyze an existing dataset.

  2. Create queries to verify data values.

  3. Create an SQL index to improve query performance.

  4. Create a Summary database table for specific data.

  5. Populate the summary table using SQL.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.