Community

SQL Data Analysis - Books & Resources

840
2
10-18-2021 10:06 PM
Bud
by
Notable Contributor
‎10-18-2021 10:06 PM

 

What are some SQL data analysis books/resources that you like?

1. For example, I like the Profiling: Distributions and Profiling: Data Quality sections in this book: 

2. When I was first learning SQL, I liked these books (they're clear and short): 

3.  And these video courses cover advanced SQL topics like window functions: 


Are there any others you would suggest?

Tags (1)
2 Replies
Bud
by
Notable Contributor
‎10-18-2021 10:19 PM

 

I just recently learned about function-based indexes in Oracle -- which are a game changer when it comes to making spatial functions faster. I wish one of the SQL books I'd read had mentioned function-based indexes and function-based spatial indexes. They would have really helped me in the past.


And there are other things that are often overlooked in SQL books that I've read -- like the fact that databases can't utilize indexes if the query wraps a column in a function. 

0 Kudos