Simple Retrieval Queries in MySQL Workbench

4.6
stars
67 ratings
Offered By
Coursera Project Network
1,720 already enrolled
In this Guided Project, you will:

Describe the components of a relational table.

Retrieve data from a table using an SQL Query.

Modify the appearance of query results with filtering and sorting.

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

In this beginning-level course you will use MySQL Workbench to write basic SQL queries that retrieve data from tables in a relational database. As a DBMS (database management system), MySQL is used by many organizations for managing a variety of types and sizes of databases. MySQL Workbench acts as an integrated development environment allowing users to work with relational databases using a visual user interface rather than the command line. In hands-on activities in MySQL Workbench, you will write and execute the SQL code that retrieves data to satisfy a request. In addition, you will include the filters, sorting, and calculated columns to produce required output. 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 WorkbenchDatabase ApplicationQueriesMySQLSQL

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. Tables in MySQL Workbench

  2. Queries in MySQL Workbench

  3. The SELECT Statement

  4. The WHERE Clause

  5. The Combination WHERE Clause

  6. The ORDER BY Clause

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

Reviews

TOP REVIEWS FROM SIMPLE RETRIEVAL QUERIES IN MYSQL WORKBENCH

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.