Database Systems: A Pragmatic Approach Book PDF, ePub eBook

Join our eBook service for unlimited books & audiobooks. Get a free 7 day subscription! ↓↓↓↓↓


Book Descriptions:

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 learn

• Learn the relational model and the advantages it brings to software systems
• Design database schemas with integrity rules that ensure correctness of corporate data
• Query data using SQL in order to generate reports, charts, graphs, and other business results
• Learn what it means to be a database administrator, and why the profession is highly paid
• Become familiar with the common database brands, their similarities and distinctives
• Explore special topics such as tree-based data, hashing for fast access, distributed and object databases, and more

Who 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 Contents

Part I: Preliminary Topics

1. Introduction to Database Systems

2. The Database System Environment

Part II: 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

Part III: Structured Query Language

10. Overview of SQL

11. SQL Definition Statements

12. SQL Data Manipulation Statements

13. Logical Views and Security

14. The System Catalog

15. Some Limitations of SQL

Part IV: Some Commonly Used DBMS Suites

16. Overview of Oracle

17. Overview of DB2

18. Overview of Microsoft SQL Server

19. Overview of Gupta Team Developer and MySQL

20. Overview of Borland Delphi

Part V: Advanced Topics

21. Database Administration

22. Distributed Database Systems

23. Object Databases

24. Data Warehousing and Information Extraction

25. Web-Accessible Databases

Part VI: Final Preparations

26. Sample Exercises and Examination Questions

Part VII: Appendices

A. Review of Trees

B. Review of Hashing

C. Review of Information Gathering Techniques

Database Systems: A Pragmatic Approach by Elvis C. Foster, Shripad Godbole

From reader reviews:

Melissa Conner:

What do you think of book? It is just for students because they are still students or it for all people in the world, what the best subject for that? Just you can be answered for that query above. Every person has several personality and hobby for each and every other. Don't to be pressured someone or something that they don't wish do that. You must know how great as well as important the book Database Systems: A Pragmatic Approach. All type of book is it possible to see on many options. You can look for the internet resources or other social media.

John Pasko:

Here thing why this Database Systems: A Pragmatic Approach are different and trustworthy to be yours. First of all looking at a book is good nonetheless it depends in the content than it which is the content is as delightful as food or not. Database Systems: A Pragmatic Approach giving you information deeper and different ways, you can find any e-book out there but there is no e-book that similar with Database Systems: A Pragmatic Approach. It gives you thrill reading through journey, its open up your own personal eyes about the thing that happened in the world which is maybe can be happened around you. You can actually bring everywhere like in park your car, café, or even in your means home by train. In case you are having difficulties in bringing the paper book maybe the form of Database Systems: A Pragmatic Approach in e-book can be your choice.

Arthur Freeman:

Does one one of the book lovers? If yes, do you ever feeling doubt if you find yourself in the book store? Try and pick one book that you find out the inside because don't assess book by its handle may doesn't work is difficult job because you are afraid that the inside maybe not because fantastic as in the outside seem likes. Maybe you answer can be Database Systems: A Pragmatic Approach why because the wonderful cover that make you consider regarding the content will not disappoint anyone. The inside or content will be fantastic as the outside or maybe cover. Your reading sixth sense will directly direct you to pick up this book.

Bessie Scudder:

You can find this Database Systems: A Pragmatic Approach by go to the bookstore or Mall. Simply viewing or reviewing it may to be your solve issue if you get difficulties for your knowledge. Kinds of this publication are various. Not only simply by written or printed but can you enjoy this book through e-book. In the modern era just like now, you just looking by your local mobile phone and searching what their problem. Right now, choose your personal ways to get more information about your e-book. It is most important to arrange yourself to make your knowledge are still change. Let's try to choose right ways for you.