Database Systems: A Pragmatic Approach

Database Systems: A Pragmatic Approach

Elvis C. Foster, Shripad V. Godbole

This textual content presents a accomplished, but concise creation to database structures. It discusses the database as an integral part of a software program approach, in addition to a useful, venture serious company source. The ebook relies on lecture notes which have been confirmed and confirmed over a number of years, with striking effects. It additionally exemplifies mastery of the means of combining and balancing concept with perform, to provide scholars their top probabilities at success.

The booklet discusses strategies, ideas, layout, implementation, and administration problems with databases. every one bankruptcy is prepared systematically into short, reader-friendly sections, with itemization of the details to be remembered. It adopts a methodical and pragmatic method of fixing database platforms difficulties. Diagrams and illustrations additionally sum up the salient issues to augment studying. also, the e-book features a variety of Foster s unique methodologies that upload readability and creativity to the database modeling and layout adventure, whereas creating a novel contribution to the discipline.

Upholding his objective for brevity, accomplished assurance, and relevance, Foster s useful and methodical dialogue variety will get directly to the salient concerns, and avoids pointless fluff in addition to an overkill of theoretical calculations. Readers may still locate this strategy helpful of their respective wishes.

Brief Contents:

Division A: initial Topics

1. creation to Database Systems

2. The Database procedure surroundings

Division B: The Relational Database version

3. The Relational Model

4. Integrity principles and Normalization

5. Database Modeling and Design

6. Database consumer Interface Design

7. Relational Algebra

8. Relational Calculus

9. Relational procedure a better Look

Division C: dependent question Language (SQL)

10. review of SQL

11. SQL Definition Statements

12. SQL information Manipulation Statements

13. Logical perspectives and Security

14. The process Catalog

15. a few obstacles of SQL

Division D: a few usual DBMS Suites

16. review of Oracle

17. evaluate of DB2

18. evaluation of Microsoft SQL Server

19. review of Gupta crew Developer and MySQL

20. evaluation of Borland Delphi

Division E: complicated Topics

21. Database management

22. allotted Database Systems

23. item Databases

24. info Warehousing and knowledge Extraction

25. Web-Accessible Databases

Division F: ultimate Preparations

26. pattern workouts and exam Questions

Division G: Appendices

Appendix-1: assessment of timber

Appendix-2: overview of Hashing

Appendix-3: assessment of knowledge accumulating Techniques

Show sample text content

Download sample