-
Book Overview & Buying
-
Table Of Contents
SQL for Data Analytics - Fourth Edition
By :
Text data, or string, contains valuable insights. For instance, you can imagine a salesperson keeping notes on prospective clients: Very promising interaction, the customer is looking to make a purchase tomorrow is valuable data, as is The customer is uninterested. They no longer have a need for the product. While this text can be valuable for someone to manually read, it can also be valuable in the analysis. Keywords in these statements, such as promising, purchase, tomorrow, uninterested, and no, can be extracted using the right techniques to try to identify top prospects in an automated fashion.
In this section, you will look at how you can use some PostgreSQL functionality to identify patterns that will help you identify trends. You will also leverage text-related functions in PostgreSQL for better searching.
PostgreSQL provides the following functions for understanding and transforming the string...