3.2 Data-cleaning with SQL functions

LENGTH() / LEN()

Return the length of a string of text by counting the number of characters it contains

SUBSTR()

Return a limited number of characters to create substrings from longer strings of text

SELECT FROM WHERE

Pull data from a specific place in a table, typically a table column

SELECT FROM

Pull data from any table in a database

DELETE

Remove data from a database

TRIM()

Remove leading, trailing, and repeated spaces in data

UPDATE

Change existing data in a database

CONCAT()

Add strings together to create new text strings that can be used as unique keys

COALESCE()

Return non-null values in a list

INSERT INTO

Add new data into a database

CAST()

Convert data from one data type to another