About this course

This training teaches users how to leverage SQL row functions to standardize customer data pulled from the customer profiles table. It walks through creating a query to clean up inconsistent data, using the SUBSTRING function to truncate zip codes to a five-digit format, and employing a map or associative array combined with dot notation to correctly convert full state names into their two-letter abbreviations. The use of WHERE clauses is also demonstrated

After taking this course, you should be able to write a query that modifies rows in a similar manner.

To read more about building queries on Amperity Docs, click here