Dusan Petkovic
Auteur van Microsoft SQL Server 2005: A Beginner''s Guide (Beginner's Guide (Osborne Mcgraw Hill))
Over de Auteur
Dusan Petkovic is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany.
Werken van Dusan Petkovic
Microsoft SQL Server 2005: A Beginner''s Guide (Beginner's Guide (Osborne Mcgraw Hill)) (2006) 16 exemplaren
Microsoft SQL server 2008 : a beginner's guide 1 exemplaar
MICROSOFT SQL SERVER 2008 A BEGINNER'S GUIDE 4/E 1 exemplaar
SQL objektorientiert . 1 exemplaar
Tagged
Algemene kennis
Er zijn nog geen Algemene Kennis-gegevens over deze auteur. Je kunt helpen.
Leden
Besprekingen
Statistieken
- Werken
- 15
- Leden
- 55
- Populariteit
- #295,340
- Waardering
- 5.0
- Besprekingen
- 1
- ISBNs
- 14
- Talen
- 2
The author explains many of the concepts using SQL queries and diagrams. He has provided a custom db script with fewer number of records in about 4 tables. I found this to be good to get things going and then the author switches to the AdventureWorks database to illustrate advanced concepts like indices, joins and query optimization.
The chapter on concurrency is highly informative and I am finally able to wrap my head around optimistic and pessimistic concurrency. The book then segues into the various intricacies of transactions.
The parts detailing creation and usage of indices and query optimization are the best sections of the book. The journey of query parsing to its execution is exceptionally written which helps understand table / index scan, index seek, selectivity and column statistics very thoroughly.
The remarkable organization of this book helps clarify the concepts of SQL Server. This is definitely a must read for someone who has just gotten his hands dirty with SQL. Something tells me even experts would refer to this book a few times.… (meer)