Ch. 1. Introduction to database concepts -- Ch. 2. Data modeling -- Ch. 3. Conceptual data modeling -- Ch. 4. The normalization process -- Ch. 5. Implementing the base table structures -- Ch. 6. Protecting the integrity of your data -- Ch. 7. Securing access to the data -- Ch. 8. Table structures and indexing -- Ch. 9. Coding for concurrency -- Ch. 10. Code-level architectural decisions -- Ch. 11. Database interoperability -- App. A. Codd's 12 rules for an RDBMS -- App. B. Datatype reference.
0
SUMMARY OR ABSTRACT
Text of Note
"Pro SQL Server 2005 Database Design and Optimization" will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005. The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 20.
SYSTEM REQUIREMENTS NOTE (ELECTRONIC RESOURCES)
Text of Note
Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.