Interview Questions Interview Guides Experiences Mock Interviews Pricing

Modules

Data Analyst

Data Engineer

Product Data Scientist

AI Engineer

Machine Learning Engineer

Prompt Engineer

Text Analysis | SQL Advanced | Dataford

Text Analysis

Text Analysis

Chapter Overview

Time Estimate

2 hrs 4 min

Time Estimate

2 hrs 4 min

Sections

19 sections7 Lessons12 Exercises

1. Intro to Text Analysis

Intro to Text Analysis

2. Using LEFT, RIGHT and LENGTH

Using LEFT, RIGHT and LENGTH

3. First Letter Extraction

First Letter Extraction

4/5

4. Last 4 Digits of your SSN

Last 4 Digits of your SSN

5. Middle Part of the SSN

Middle Part of the SSN

6. Find The Longest Names

Find The Longest Names

Using TRIM

8. Cleaning Product Names

Cleaning Product Names

9. Most Frequently Entered Products

Most Frequently Entered Products

10. Using CONCAT

Using CONCAT

11. Full Name Creation

Full Name Creation

12. Linkedin URL

Linkedin URL

13. Using String Aggregation

Using String Aggregation

14. Product Lists by Sale ID

Product Lists by Sale ID

15. Unique Product List by Country

Unique Product List by Country

Unnesting

17. Twitter Hashtag Analysis

Twitter Hashtag Analysis

18. Top 3 Hashtags

Top 3 Hashtags

19. Congratulations

Congratulations