Pro SQL Server Relational Database Design and Implementation

Best Practices for Scalability and Performance
Sixth Auflage
ISBN: 978-1-4842-6496-6
Verlag: Apress

Buch, Englisch, 1154 Seiten, Format (B × H): 178 mm x 254 mm, Gewicht: 2438 g

Zielgruppe

Professional/practitioner

Autoren/Hrsg.

Davidson, Louis

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Datenbankdesign & Datenbanktheorie

Inhaltsverzeichnis

1. The Fundamentals.- 2. Introduction to Requirements.- 3. The Language of Data Modeling.- 4. Conceptual and Logical Data Model Production.- 5. Normalization.- 6. Physical Model Case Study.- 7. Physical Model Implementation.- 8. Data Protection Patterns with Check Constraints and Triggers.- 9.  Patterns and Anti-Patterns.- 10. Database Security and Security Patterns.- 11. Data Structures, Indexes, and Their Applications.- 12. Matters of Concurrency.- 13. Coding Architecture.- 14. Appendix A: Scalar Datatype Reference.

Über Autor(innen)

Louis Davidson has been working with databases for more than 20 years as a corporate database developer and architect. He has been a Microsoft MVP for 15 years. And he has completed a sixth edition of his SQL Server database design book (Apress). Louis has been active speaking about database design and implementation at many conferences over the past 17 years, including SQL PASS, SQL Rally, SQL Saturday events, CA World, Music City Data, and the devLink Technical Conference. Louis has worked for the Christian Broadcasting Network (CBN) as a developer, DBA, and data architect for over 21 years. He has a bachelor’s degree in computer science from the University of Tennessee at Chattanooga. For more information, please visit his website at drsql.org.