-
Book Overview & Buying
-
Table Of Contents
SQL for Data Analytics - Fourth Edition
By :
So far, every operation you have done has been based on normal numeric or text calculations. However, certain data types follow their own computing rules. For example, adding 1 to 31 gives you 32, but adding 1 day to January 31st will yield February 1st, not January 32nd. The computing rules of the date/time are different from the rules of normal numbers, so are its storage and display.
Equally important is the text processing power of SQL. Human activities generate textual data every moment. As such, businesses must be able to cleanse and analyze textual data for insights, such as extracting key information, performing transformations, or summarizing large bodies of text. All these require powerful text processing capabilities.
The last important data type is geospatial data. In the past two decades, there has been a significant increase in the usage of geospatial data. With the wide usage of mobile devices, geospatial data...