Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Database Systems: A Pragmatic Approach

Buy
Database Systems: A Pragmatic Approach, 9781484208786 (1484208781), Apress, 2014

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

(HTML tags aren't allowed.)

2021 Microsoft Formulas and Functions: A Simplified Guide With Examples on how to take advantage of built-in Excel Formulas and Functions
2021 Microsoft Formulas and Functions: A Simplified Guide With Examples on how to take advantage of built-in Excel Formulas and Functions

You can master the use of over 101 Microsoft Excel Formulas and Functions if you make the decision to purchase this book. 

This guide is what should be called; a one-fit approach to understanding the basis of Excel formulas. This guide is useful especially for business owners, workers, and financial analysts who...

Fair Management: How to Stop Ruling and Start Leading
Fair Management: How to Stop Ruling and Start Leading
Contemporary personnel management is faced with a number of challenges as work becomes increasingly digital and more flexible in terms of time. 'New Work', 'agile management' and a genuine culture of dealing with errors have revolutionised personnel management. What becomes especially apparent in this respect is that managers can...
An Invitation to Analytic Combinatorics: From One to Several Variables (Texts & Monographs in Symbolic Computation)
An Invitation to Analytic Combinatorics: From One to Several Variables (Texts & Monographs in Symbolic Computation)

This book uses new mathematical tools to examine broad computability and complexity questions in enumerative combinatorics, with applications to other areas of mathematics, theoretical computer science, and physics. A focus on effective algorithms leads to the development of computer algebra software of use...


Design for Software: A Playbook for Developers
Design for Software: A Playbook for Developers

A unique resource to help software developers create a desirable user experience

Today, top-flight software must feature a desirable user experience. This one-of-a-kind book creates a design process specifically for software, making it easy for developers who lack design background to create that compelling user experience....

Python Data Structures and Algorithms: Improve application performance with graphs, stacks, and queues
Python Data Structures and Algorithms: Improve application performance with graphs, stacks, and queues

Implement classic and functional data structures and algorithms using Python

Key Features

  • A step by step guide, which will provide you with a thorough discussion on the analysis and design of fundamental Python data structures.
  • Get a better understanding of advanced Python...
Comfy Canned Food Recipes: Tasty, Timesaving, And Splendid Everyday Meals
Comfy Canned Food Recipes: Tasty, Timesaving, And Splendid Everyday Meals
Pause! Do you know that you can use canned foods in tastier ways than just a food toss?

Canned foods have a beautiful reputation of making cooking easy and you should not sideline them as an inferior addition to foods. With the best and healthy canned foods, one can make delicious and pleasant foods to love.

...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy