Combine Multiple Pieces of Data in SQL

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

Generate an SQL query result in CSV (comma-separated values) format.

Work with SQL functions to concatenate data values.

Write and execute SQL queries in MySQL Workbench.

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

In this project, you will use MySQL Workbench to write SQL queries that concatenate or combine multiple data values. Since a database is typically designed to store pieces of data at the atomic level, it is often necessary to put pieces back together to make data more useful to a user. A good example of that would be concatenating a customer’s first name and last name to produce a mailing label.

Skills you will develop

Mysql WorkbenchConcatenate DataCombine DataConcat()SQL code

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. Use MySQL Workbench to view an SQL script that uses the CONCAT() function to combine first name and last name columns into one full-name column.

  2. Create a CSV (comma-separated values) format by using the SQL CONCAT() function to combine multiple fields while separating them with commas.

  3. Use the SQL CONCAT_WS() function as a shortcut process for creating output in a CSV format.

  4. Use the SQL CONCAT() function inside the SQL CONCAT_WS() function to include full name in a CSV file format.

  5. Switch to the SQL CONCAT_WS() function to combine fields when some of the fields contain null values.

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.