-
Notifications
You must be signed in to change notification settings - Fork 104
4.3.3.Transforming data
Example:
SELECT
CAST(purchase_price AS FLOAT64)
FROM
customer_data.customer_purchase
ORDER BY
CAST(purchase_price AS FLOAT64) DESC;
SELECT
CAST(date AS date) AS date_only,
purchase_price
FROM
customer_data.customer_purchase
WHERE
date BETWEEN '2020-12-01' AND '2020-12-31'
- Adds strings together to create new text strings that can be used as unique keys
Example:
SELECT
CONCAT(product_code, product_color) AS new_product_code
FROM
customer_data.customer_purchase
WHERE
product = 'couch'
- Can be used to return non-null values in a list
Example:
SELECT
COALESCE(product, product_code) AS product_info
FROM
customer_data.customer_purchase
In this course, you've been introduced to many different tools available to you in SQL. These SQL tools, when used correctly, make tasks like removing duplicates or cleaning up string data much easier, especially when you work with datasets that are too large to work effectively with spreadsheets.
As a brief review, you learned how to complete tasks like:
- Getting data from a table using SELECT statements
- De-duplicating data using commands like DISTINCT and COUNT + WHERE
- Manipulating string data with TRIM(), SUBSTR, and LENGTH
- Changing data types with CAST
As you've learned, some of these tasks in SQL are more challenging than others, and processing data with SQL has a learning curve. Keep in mind that getting SQL to work the way you want it to is achievable as you learn, and master, the various commands. Take a moment to think about the parts of SQL that you’ve found to be easy, and those you've found to be challenging.
https://www.coursera.org/professional-certificates/google-data-analytics
© 2021 Coursera Inc. All rights reserved.