Database Systems: A Pragmatic Approach - Softcover

Foster, Elvis; Godbole, Shripad

Softcover

ISBN 10: 1484208781 ISBN 13: 9781484208786

Publisher: Apress, 2014

Synopsis

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.

About this title

From the Back Cover

This text provides a comprehensive, yet concise introduction to database systems. 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 chances at success. 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.   Upholding his aim for brevity, comprehensive coverage, and relevance, 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. Readers should find this approach useful in their respective needs.

From the Inside Flap

Brief Contents: Division A: Preliminary Topics 1. Introduction to Database Systems 2. The Database System Environment Division B: The Relational Database Model 3. The Relational Model 4. Integrity Rules and Normalization 5. Database Modeling and Design 6. Database User Interface Design 7. Relational Algebra 8. Relational Calculus 9. Relational System - A Closer Look Division C: The Structured Query Language (SQL) 10. Overview of SQL 11. SQL Data Definition Statements 12. SQL Data Manipulation Statements 13. SQL Views and System Security 14. The System Catalog 15. Some Limitations of SQL Division D: Some Commonly Used DBMS Suites 16. Overview of Oracle 17. Overview of DB2 18. Overview of MS SQL Server 19. Overview of MySQL 20. Overview of Delphi Division E: Advanced Topics 21. Database Administration 22. Distributed Database Systems 23. Object Databases 24. Data Warehousing 25. Web-Accessible Databases Division F: Final Preparations 26. Sample Exercises and Examination Questions Division G: Appendices Appendix 1: Review of Trees Appendix 2: Review of Hashing Appendix 3: Review of Information Gathering Techniques

Edition details

• Publisher: Apress
• Publication date: 2014
• ISBN 10: 1484208781
• ISBN 13: 9781484208786
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 587