Text analysis with SQL Introduction to text analysis with SQL

214. Introduction to text analysis with SQL

By now you might have an impression that SQL is all about numbers, calculating conversion rates, etc. It’s true, of course, but contemporary SQL databases offer us much more: smart ways of working with spatial data, working with arrays and key-value objects (common data structures in other programming languages) and, of course, text.

Working with text in SQL is really important because a lot of insights in our data are stored in text columns. It could be user-generated data (emails, encrypted passwords, search queries, comments and profile...

“well worth the money”
Sign up and check out 37 free lessons and exercises.

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type your query here, for example this one -- lists all records from users table: SELECT * FROM users
Loading chart... ⏳
Previous lesson: AB-test analysis recap
Next lesson: Deep dive into pattern matching with LIKE