دانلود کتاب Database Systems: A Pragmatic Approach

Database Systems: A Pragmatic Approach is a classroom textbook for use by students who are learning about relational databases, and the professors who teach them. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. The book is based on lecture notes that have been tested and proven over several years, with outstanding results. It also exemplifies mastery of the technique of combining and balancing theory with practice, to give students their best chance at success. Upholding his aim for brevity, comprehensive coverage, and relevance, author Elvis C. Foster's practical and methodical discussion style gets straight to the salient issues, and avoids unnecessary fluff as well as an overkill of theoretical calculations. The book discusses concepts, principles, design, implementation, and management issues of databases. Each chapter is organized systematically into brief, reader-friendly sections, with itemization of the important points to be remembered. It adopts a methodical and pragmatic approach to solving database systems problems. Diagrams and illustrations also sum up the salient points to enhance learning. Additionally, the book includes a number of Foster's original methodologies that add clarity and creativity to the database modeling and design experience while making a novel contribution to the discipline. Everything combines to make Database Systems: A Pragmatic Approach an excellent textbook for students, and an excellent resource on theory for the practitioner. What you’ll learnLearn the relational model and the advantages it brings to software systemsDesign database schemas with integrity rules that ensure correctness of corporate dataQuery data using SQL in order to generate reports, charts, graphs, and other business resultsLearn what it means to be a database administrator, and why the profession is highly paidBecome familiar with the common database brands, their similarities and distinctivesExplore special topics such as tree-based data, hashing for fast access, distributed and object databases, and moreWho this book is for Database Systems: A Pragmatic Approach is aimed at students who are studying database technology, who aspire to a career as a database administrator or designer. The book is particularly useful for professors teaching such students, and who are in need of an affordable textbook. Practicing database administrators and developers wanting to strengthen their theoretical grounding in their discipline may also find the book useful. Table of ContentsPart I: Preliminary Topics1. Introduction to Database Systems2. The Database System EnvironmentPart II: The Relational Database Model3. The Relational Model4. Integrity Rules and Normalization5. Database Modeling and Design6. Database User Interface Design7. Relational Algebra8. Relational Calculus9. Relational System a Closer LookPart III: Structured Query Language10. Overview of SQL11. SQL Definition Statements12. SQL Data Manipulation Statements13. Logical Views and Security14. The System Catalog15. Some Limitations of SQLPart IV: Some Commonly Used DBMS Suites16. Overview of Oracle17. Overview of DB218. Overview of Microsoft SQL Server19. Overview of Gupta Team Developer and MySQL20. Overview of Borland DelphiPart V: Advanced Topics21. Database Administration22. Distributed Database Systems23. Object Databases24. Data Warehousing and Information Extraction25. Web-Accessible DatabasesPart VI: Final Preparations26. Sample Exercises and Examination QuestionsPart VII: AppendicesA. Review of TreesB. Review of HashingC. Review of Information Gathering Techniques