Complex Retrieval Queries in MySQL Workbench

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

Practice problem-solving skills in SQL query building.

Generate a complex retrieval query using SQL code.

Verify complex query results.

Clock80 minutes
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

In this intermediate-level course you will use MySQL Workbench to expand your basic SQL query-writing skills with more complex examples and activities. In hands-on activities in MySQL Workbench, you will write and execute SQL queries that retrieve data from multiple tables. In addition, you will generate queries that summarize data and perform calculations. Nested queries and SQL scripting rounds out the course content. While the course concentrates on query writing, you also get a taste of the problem-solving and data analysis efforts required for complex query construction and query results verification. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Skills you will develop

  • Mysql Workbench
  • Aggregate Function
  • SQL
  • Nested Query
  • SQL Scripting

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. Database Review

  2. Join with the WHERE Clause

  3. Join with the JOIN Statement

  4. Grouping, Summing, Counting and More

  5. Nested Queries

  6. The Kitchen Sink Script

  7. Check Your Results

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



View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.