Lesson 6

Question 1

String data can be notoriously difficult and annoying to work with because:

Answer 1

• It can be a pain to get strings in the correct format you want
• String data can have a lot of variation and mistakes, which can be hard to account for

Question 2

There are SO many string manipulation functions you can use to modify and manipulate strings— honestly too many to learn and remember!

Do NOT stress about learning them all because:

Answer 2

You can easily Google or ChatGPT the syntax as you have different goals and use cases come up.

Question 3

How can you change a column name?

For example, from the orders table:

• Pull the order_id column
• Pull the order_id column and rename it to nickname_order_id

Answer 3

AS

• Alias
• You can rename your columns at any time, as anything you want

SELECT
    order_id,
    order_id AS nickname_order_id
FROM
    orders

Question 4

len()

Question 5

concat()

Question 6

replace()

Answer 6

• replace() is a great function to sort through strings and replace a certain part with something else
• Can replace with an empty string ''

Question 7

trim()

Answer 7

• chop off part of a string

Question 8

ltrim()

Answer 8

left trim

Question 9

rtrim()

Answer 9

right trim

Question 10

split_part()

Answer 10

• A delimiter is a separator