SQL Tutorial for Data Analysis 7: String Concatenation

In this lesson we’re going to learn how to concatenate strings. String concatenation is useful in cases where we want to merge data of several columns, and display the output as one single value. For example: taking the data of first_name and last_name columns and displaying the output as one single column - full_name

Course Examples -

ACDB Database -

Written SQL tutorials including exercises -

About Myself -

My Linkedin Page -

My Facebook Page -

SQL Platform Differences (comparing MySQL & Oracle)
* MySQL - we use the CONCAT() / CONCAT_WS() functions instead of the + sign:

* Oracle -In Oracle we use the || sign instead of the + sign: