best sql dba books

  • Please suggest me the best sql dba books in the world. It should explain each topic in full depth.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • So, probably not going to have a single book that explains "each topic in full depth".

    I have two books that I've written, totaling about 1,300 pages between the two of them. One covers query tuning. The other covers execution plans. Yet, neither covers every topic "in full depth". There's always more depth. Always.

    My recommendations are to get several books. First, Itzik Ben Gan's T-SQL book, a must. Peter Carter has an introductory book that's probably decent. Then, yeah, I'd suggest my two books on query tuning & execution plans. After that, there are books specializing in topics like Availability Groups, AWS, Azure, Query Store, all sorts of stuff. Get the ones that you need.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • something I wish I had studied earlier in my dba career is normalization; Either before or alongside studying the materials on using SQL server.

    Also, hugely useful thing to watch if you are starting from zero experience: how to think like SQL server, video from Brent Ozar on youtube.

  • Database design books - college level

    SQL server hand books - lots to choose from.  Grant Fritchey has some!

    Videos:

    Brent Ozar videos / Pinal Dave - SQL authority / (Jonathan Kehayias / SQL skills.com)

    SQL Server Database Administration Tips / Developer tips

    MSSQLTips.com

     

     

    DBASupport

  • Hey, that's really nice that you want to learn SQL deeply. Here are some book suggestions; maybe you'll like them.

    1. Data System Concepts by Abraham Silberschatz

    2. Designing Data-Intensive Applications By Martin Kleppmann

    3. SQL Server 2022 Administration Inside Out by Randolph West, William Assaf, Sven Aelterman, and Mindy Curnutt.

    4. Database Internals by Alex Petrov

    Start with the database system concept because this book builds a core foundation for you.

    Then next move to Designing Data-Intensive Application because this book is best for learning modern systems

    Then, SQL Server 2022 Administration Inside Out, because this book teaches you configurations, turning backup, etc., and is the best for a hands-on practical guide.

    Then finally move to Database Internals because this book gives you deep knowledge about how databases work under the hood.

    I hope this will help you.

  • thansk for suggestions

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply