Data Wrangling with SQL

3

Data Wrangling on String Data Types

Most business data is stored in the form of strings, which are sequences of characters that store information, and SQL has multiple built-in functions that can slice and dice this data to meet a specific analysis requirement. For example, we may want to extract the month information from a date column. The goal of this chapter is to help you gain hands-on experience of extracting meaningful information after data wrangling on string data.

In this chapter, we will cover the following main topics:

• SQL data types
• The string data type and its use case
• Exploring SQL string functions

SQL data types

Each value stored in a database has a fixed data type that defines its properties, storage size, and what data ...