How to Concatenate in SQL (Oracle, SQL Server, MySQL, PostgreSQL)

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: https://databasestar.mykajabi.com/sql...

Concatenation is the process of combining two or more strings together to make one string. This process is available in many programming languages, including SQL.

In this video, you’ll learn how to concatenate two string values in multiple ways in each database. You’ll learn how to use the CONCAT function. You’ll also learn how to add space characters if you need them (for example, to separate first and last names). You’ll also see how to concatenate three or more string values.

Timestamps:
00:00 Introduction
00:31 Concatenation in Oracle
02:46 Concatenation in SQL Server
04:40 Concatenation in MySQL
06:01 Concatenation in PostgreSQL
07:08 Summary of methods