Exactly what is a bestseller being an SQL master? That's, learn to tweak queries, table design, optimizing the server, etc.
I personally use mostly MySQL and Postgres, but perhaps a DBMS agnostic book will come handy. The "optimizing the server" part is most likely specific to every DBMS.
I must are conscious of a bestseller to understand advanced SQL and database design which may help someone get to be the DB Admin.
I learned a lot of things from SQL Performance Tuning.
SQL Performance Tuning is really a guide of practical solutions for busy database professionals billed with controlling an organization's significantly important data. Covering present day most widely used and broadly installed database conditions, this book is definitely an indispensable resource for controlling and tuning SQL across multiple platforms.
Full of tips, techniques, and finest practices, this hands-on guide covers SQL instructions and queries over an array of conditions and conditions. Every part of the SQL atmosphere is included, from concurrency control to optimization—and every problem between. It includes an introduction to each one of the most broadly used database management systems (DBMS) and offers tuning strategies for common day-to-day situations.
Subjects covered include:
- General and particular tuning
- General sort factors and options
- Joins and subqueries
- Posts and tables
- Indexes, including B-trees and bitmaps
- Constraints and saved methods
- ODBC and JDBC
- Data changes and concurrency control (securing)
- Clients, servers, and middleware
Regardless if you are a programmer, consultant, or user, you will discover SQL Performance Tuning a vital help guide to optimizing SQL performance across present day popular database conditions.
Throughout SQL Performance Tuning, ideas and methods are examined on a number of popular SQL conditions, including IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, MySQL, Oracle, and Sybase ASE. The book's practical good examples are designed in ANSI/ISO Standard SQL: 1999.
Specific at SQL server, Adam Machanic's Expert SQL Server 2005 Development is filled with practical gems, and unequalled for many advanced subjects. This book taken care of itself the very first time I opened up it.
The skill of SQL by Stephane Faroult and Peter Robson is excellent.
Some of Itzak Ben Gan's T-SQL books.
For tuning, I suggest:
I'll add Ken Henderson's Guru's Guide books for SQL Server and Tom Kyte's Expert one-on-one Oracle and Effective Oracle by Design for Oracle. He's also written a more recent book known as Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions that we haven't read.
For generic database and SQL programming books, Joe Celko's SQL for Smarties series is a great group of assets covering a multitude of advanced SQL programming subjects, and it is clearly completed in a platform-independent way.
Some point to notice about Oracle is the fact that the correct answer is an adult product and does not change much from release to produce. A lot of that which you read inside a book about older versions continues to be relevant to 11g.