Beginning Database Design Solutions.pdf

(6271 KB) Pobierz
506879396.051.png
Beginning
Database Design Solutions
Professional Microsoft SQL Server 2008 Integration
Services
978-0-470-24795-2
This book shows developers how to master the 2008 release of SSIS,
covering topics including data warehousing with SSIS, new methods of
managing the SSIS platform, and improved techniques for ETL operations.
Professional SQL Server 2008 Reporting Services
978-0-470-24201-8
This book teaches solutions architects, designers, and developers how
to use Microsoft’s reporting platform to create reporting and business
intelligence solutions.
Professional Microsoft SQL Server 2008 Analysis Services
978-0-470-24798-3
Professional Microsoft SQL Server 2008 Analysis Services shows readers
how to build data warehouses and multidimensional databases, query
databases, and use Analysis Services and other components of SQL Server
to provide end-to-end solutions.
Enhance Your Knowledge
Advance Your Career
Professional Microsoft SQL Server 2008 Programming
978-0-470-25702-9
This updated new edition of Wrox’s best-selling SQL Server book has been
expanded to include coverage of SQL Server 2008’s new datatypes, new
indexing structures, manageability features, and advanced time-zone
handling.
Professional Microsoft SQL Server 2008 Administration
978-0-470-24796-9
A how-to guide for experienced database administrators, this book is loaded
with unique tips, tricks, and workarounds for handling the most difficult SQL Server administration issues. The authors discuss
data capture, performance studio, Query Governor, and new techniques for monitoring and policy management.
Beginning Microsoft SQL Server 2008 Programming
978-0-470-25701-2
This comprehensive introduction to SQL Server covers the fundamentals and moves on to discuss how to create and change
tables, manage keys, write scripts, work with stored procedures, and much more.
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
978-0-470-25703-6
Beginning T-SQL with Microsoft SQL Server 2005 and 2008 provides a comprehensive introduction to the T-SQL programming
language, with concrete examples showing how T-SQL works with both SQL Server 2005 and SQL Server 2008.
Beginning Database Design Solutions
978-0-470-38549-4
Beginning Database Design Solutions introduces IT professionals—both DBAs and database developers—to database design.
It explains what databases are, their goals, and why proper design is necessary to achieve those goals. It tells how to decide
what should be in a database to meet the application’s requirements. It tells how to structure the database so it gives good
performance while minimizing the chance for error.
506879396.062.png 506879396.073.png 506879396.082.png 506879396.001.png 506879396.002.png 506879396.003.png 506879396.004.png 506879396.005.png 506879396.006.png 506879396.007.png 506879396.008.png 506879396.009.png 506879396.010.png 506879396.011.png 506879396.012.png 506879396.013.png 506879396.014.png 506879396.015.png 506879396.016.png 506879396.017.png 506879396.018.png 506879396.019.png 506879396.020.png 506879396.021.png 506879396.022.png 506879396.023.png 506879396.024.png 506879396.025.png 506879396.026.png 506879396.027.png 506879396.028.png 506879396.029.png 506879396.030.png 506879396.031.png 506879396.032.png 506879396.033.png 506879396.034.png 506879396.035.png 506879396.036.png 506879396.037.png 506879396.038.png 506879396.039.png 506879396.040.png 506879396.041.png 506879396.042.png 506879396.043.png 506879396.044.png 506879396.045.png 506879396.046.png 506879396.047.png 506879396.048.png 506879396.049.png 506879396.050.png 506879396.052.png 506879396.053.png 506879396.054.png 506879396.055.png 506879396.056.png 506879396.057.png 506879396.058.png 506879396.059.png 506879396.060.png 506879396.061.png 506879396.063.png 506879396.064.png 506879396.065.png 506879396.066.png 506879396.067.png 506879396.068.png 506879396.069.png 506879396.070.png 506879396.071.png 506879396.072.png
 
 
506879396.074.png 506879396.075.png 506879396.076.png 506879396.077.png 506879396.078.png 506879396.079.png 506879396.080.png
Beginning
Database Design Solutions
Introduction ..................................................................... xxiii
Part I: Introduction to Databases and Database Design 1
Chapter 1: Goals of Effective Database Design .......................................... 3
Chapter 2: Database Types ......................................................... 23
Chapter 3: Relational Database Fundamentals ........................................ 49
Part II: Database Design Process and Techniques 63
Chapter 4: Understanding User Needs ............................................... 65
Chapter 5: Translating User Needs into Data Models .................................. 89
Chapter 6: Extracting Business Rules ............................................... 121
Chapter 7: Normalizing Data ....................................................... 137
Chapter 8: Designing Databases to Support Software Applications ..................... 173
Chapter 9: Common Design Patterns ............................................... 185
Chapter 10: Common Design Pitfalls ................................................ 207
Part III: A Detailed Case Study 225
Chapter 11: User Needs and Requirements .......................................... 227
Chapter 12: Building a Data Model ................................................. 245
Chapter 13: Extracting Business Rules ............................................. 263
Chapter 14: Normalization and Refinement .......................................... 273
Part IV: Implementing Databases (with Examples in Access
and MySQL) 285
Chapter 15: Microsoft Access ..................................................... 287
Chapter 16: MySQL ............................................................... 313
Part V: Advanced Topics 343
Chapter 17: Introduction to SQL .................................................... 345
Chapter 18: Building Databases with SQL Scripts .................................... 369
Chapter 19: Database Maintenance ................................................ 379
Chapter 20: Database Security ..................................................... 389
Appendix A: Exercise Solutions .................................................... 403
Appendix B: Sample Database Designs ............................................. 467
Glossary ......................................................................... 487
Index ........................................................................... 497
506879396.081.png
506879396.083.png
Beginning
Database Design Solutions
506879396.084.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin