Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Introduction
1. Introduction
Concatenation
Simple text functions
How to modify strings
Review

Instruction

In this part, we'll teach the basic SQL text functions to help you manipulate text values in your queries. You will learn:

  • how to concatenate multiple text values into one.
  • simple text conversions: how to change all text to uppercase, lowercase, etc.
  • how to select substrings and replace parts of the text with another text.

We're going to work with some data we've acquired from a marketing agency. Let's find out more.

Exercise

Select all columns from the table item.

As you can see, it contains:

  • item identifiers (column id).
  • names (column name).
  • a third column which tells us what it actually is (column type).