Itzik Ben-gan T-sql Fundamentals ((better))
Most people learn SQL by googling syntax. That works until it doesn't. This book fills the gaps you didn't know you had.
You stop writing "Heavy Metal" SQL (queries that are loud, complex, and slow). You start writing elegant, set-based logic that executes in milliseconds. You become the person on your team that everyone asks for code reviews. itzik ben-gan t-sql fundamentals
: Learn to create robust tables with constraints and primary keys that enforce business rules at the database level . Most people learn SQL by googling syntax