Are there any good in-depth books on SQL?

  • Thread starter Thread starter SlurrerOfSpeech
  • Start date Start date
  • Tags Tags
    Books Sql
AI Thread Summary
For someone with a basic level of SQL experience seeking to deepen their understanding, several book recommendations focus on advanced topics such as database transactions, relational database theory, and optimization techniques. Notable titles include "SQL Hacks" by O'Reilly, which provides practical tips and tricks for SQL usage; "SQL Anti-patterns" by Pragmatic Programmers, which addresses common mistakes and how to avoid them; and "SQL Cookbook" by O'Reilly, offering a collection of solutions to common SQL problems. These resources cater to learners who prefer a comprehensive, bottom-up approach rather than introductory content.
SlurrerOfSpeech
Messages
141
Reaction score
11
I want to buy a book on SQL, but since I already have a basic level of professional SQL experience I want to make sure I'm getting a book that goes into depth on the underlying implentations of database transactions, the mathematical theory behind relational databases, how to optimize, etc. I'm the type of person who learns a technology best by learning from the bottom up (understanding what happens at a low-level).

Any suggestions?
 
Technology news on Phys.org
SlurrerOfSpeech said:
I want to buy a book on SQL, but since I already have a basic level of professional SQL experience I want to make sure I'm getting a book that goes into depth on the underlying implentations of database transactions, the mathematical theory behind relational databases, how to optimize, etc. I'm the type of person who learns a technology best by learning from the bottom up (understanding what happens at a low-level). I hate books that start by teaching you "Hello, world!" and then move on to the next thing without explaining what happens when you hit the Any suggestions?
jedishrfu said:
There's SQL Hacks by O'Reilly:

https://www.amazon.com/dp/0596527993/?tag=pfamazon01-20

and SQL Anti-patterns by Pragmatic Programmers:

https://www.amazon.com/dp/1934356557/?tag=pfamazon01-20

and the SQL Cookbook by O'Reilly:

https://www.amazon.com/dp/0596009763/?tag=pfamazon01-20

Thanks, bro
 
Last edited by a moderator:
Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
I have a quick questions. I am going through a book on C programming on my own. Afterwards, I plan to go through something call data structures and algorithms on my own also in C. I also need to learn C++, Matlab and for personal interest Haskell. For the two topic of data structures and algorithms, I understand there are standard ones across all programming languages. After learning it through C, what would be the biggest issue when trying to implement the same data...

Similar threads

Replies
6
Views
2K
Replies
2
Views
1K
Replies
23
Views
2K
Replies
1
Views
4K
Replies
21
Views
2K
Replies
5
Views
1K
Replies
9
Views
2K
Replies
12
Views
4K
Back
Top