Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  SQL Data Analysis - Books & Resources

    Posted Tue October 19, 2021 01:34 AM
    Edited by System Admin Wed March 22, 2023 11:45 AM


    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 (clear and concise): 

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


    Are there any others you would suggest?


    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: SQL Data Analysis - Books & Resources

    Posted Tue October 19, 2021 01:35 AM
    Edited by System Admin Wed March 22, 2023 11:52 AM


    On a side note:

    I just recently learned about function-based indexes in Oracle -- which are a game changer when it comes to making 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. 


    ​​
    #Maximo
    #AssetandFacilitiesManagement


  • 3.  RE: SQL Data Analysis - Books & Resources

    Posted Tue October 19, 2021 10:13 AM
    I've had this one on my shelf for a long time...

    https://www.amazon.com/Data-Mining-Statistical-Analysis-Using/dp/1893115542

    ------------------------------
    Tim Ferrill
    Solutions Consultant
    Intelligent Technology Solutions
    tferrill@webuildits.com
    www.webuildits.com
    @tferrill/@webuildits
    ------------------------------

    Original Message


  • 4.  RE: SQL Data Analysis - Books & Resources

    Posted Wed October 20, 2021 02:48 AM
    Edited by System Admin Wed March 22, 2023 11:43 AM
    Good find. I ordered a copy just now.
    I like the look of chapter 5: "Curve Fitting".

    I searched "SQL Data Mining" and "SQL Data Science" on Amazon and found a few others:

    SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis

    SQL for Data Science: Data Cleaning, Wrangling and Analytics with Relational Databases (Data-Centric Systems and Applications)

    Practical SQL: A Beginner's Guide to Storytelling with Data


    #Maximo
    #AssetandFacilitiesManagement


  • 5.  RE: SQL Data Analysis - Books & Resources

    Posted Wed October 20, 2021 08:42 PM
    Edited by System Admin Wed March 22, 2023 11:43 AM
    @Andrew Jeffery mentioned this book a while back:
    SQL Performance Explained by Markus Winand 

    That book was definitely an in interesting read. And I'm glad I have a copy.
    But also, it was pretty advanced and a few chapters were over my head/very detailed. I think a lot of us would benefit from having more concise guidelines about SQL performance best practices -- and clear instructions about how to use explain plans.
    I don't think explain plans and SQL performance troubleshooting need to be as complicated as people make them out to be.​


    #Maximo
    #AssetandFacilitiesManagement


  • 6.  RE: SQL Data Analysis - Books & Resources

    Posted Thu October 21, 2021 03:54 AM
    Hi User1971 - back in the "good old days", SQL Performance was a slightly easier beast to tackle.  Now that we have things such user-defined data structures, materialised views, partitioning, any number of index structures, external tables, new SQL constructs (eg partition by), etc etc, trouble-shooting sql performance can be quite a challenging task.  Explain plans provide the path the database chose to tackle the query at hand, not the reasoning why.  There were more detailed tools such as tkprof back in the day, but I've been out of that game for a while now.  It's not a trivial undertaking when trouble-shooting database performance issues.

    ------------------------------
    Scott Taylor
    Specialist Business Systems
    Port Waratah Coal Services
    ------------------------------

    Original Message


  • 7.  RE: SQL Data Analysis - Books & Resources

    Posted Thu October 21, 2021 03:05 PM
    On a side note, a colleague said this:

    "Learning SQL optimization from books is a bit like learning motorcycle riding or woodworking from books: you can get a basic idea of what you need to do, but the rest is practice. For Oracle Database I can suggest Tom Kyte's books -- and then practice.

    It's important to understand the difference between index organized tables and heaps and how the effects estimation and the amount of data that has to be read. Strangely enough, sometimes it helps to think about things in very simple terms, i.e. "If this was data on pages of paper and it was organized like it was in the database, how would I find what I need" - that's helped me understand why the optimizer makes certain choices."
    Original Message