Description
1. The Fundamentals
2. Introduction to Requirements
3. The Language of Data Modeling
4. Conceptual and Logical Data Model Production
5. Normalization6. Physical Model Case Study
7. Physical Model Implementation
8. Data Protection Patterns with Check Constraints and Triggers
9. Patterns and Anti-Patterns10. Database Security and Security Patterns
11. Data Structures, Indexes, and Their Applications
12. Matters of Concurrency
13. Coding Architecture14. Appendix A: Scalar Datatype Reference.
Author: Louis Davidson
Publisher: Apress
Published: 01/13/2021
Pages: 1154
Binding Type: Paperback
Weight: 4.42lbs
Size: 10.00h x 7.00w x 2.32d
ISBN13: 9781484264966
ISBN10: 1484264967
BISAC Categories:
- Computers | Database Administration & Management
- Computers | Programming | Microsoft
About the Author
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.