Database Systems: A Pragmatic Approach, Second Edition

  • 9h 2m
  • Elvis C. Foster, Shripad Godbole
  • Apress
  • 2016

This book provides a comprehensive, yet concise introduction to database systems, with special emphasis on the relational database model. The book discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. New in this second edition is updated SQL content covering the latest release of the Oracle Database Management System along with a reorganized sequence of the topics which is more useful for teaching. Also included are revised and additional illustrations, as well as a new chapter on using relational databases to anchor large, complex management support systems. There is also added reference content in the appendixes.

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.

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 Elvis Foster's original methodologies that add clarity and creativity to the database modeling and design experience, while making a novel contribution to the discipline. These features combine to make Database Systems: A Pragmatic Approach an excellent textbook for students and reader-friendly resource on database theory for the practitioner.

About the Author

Elvis C. Foster is Associate Professor of Computer Science at Keene State College, New Hampshire. He holds a Bachelor of Science (BS.) in Computer Science and Electronics, as well as a Doctor of Philosophy (PhD) in Computer Science (specializing in strategic information systems and database systems) from University of the West Indies, Mona Jamaica. Dr. Foster has over 22 years of combined experience as a software engineer, information technology executive and consultant, and computer science educator.

Shripad V. Godbole is an independent database administrator/consultant with over 20 years of experience in diverse business environments, information infrastructure planning, diagnostics, and administration. His qualifications include Bachelor of Science (BS) in Physics, Bachelor of Computer Science (BCS), Master of Science (MS) in Physics with specialization in Electronics, all from Poona University in Pune, India. He is also an Oracle Certified Professional Database Administrator (OCPDBA), and holds a Master of Business Administration (MBA) in Technology Management from University of Phoenix.

In this Book

  • Introduction to Database Systems
  • The Database System Environment
  • The Relational Model
  • Integrity Rules and Normalization
  • Database Modeling and Design
  • Database User Interface Design
  • Relational Algebra
  • Relational Calculus
  • Reflective Look at the Relational Database Model
  • Overview of SQL
  • SQL Data Definition Statements
  • SQL Data Manipulation Statements
  • Logical Views and System Security
  • The System Catalog
  • Some Limitations of SQL
  • Database Administration
  • Distributed Database Systems
  • Object Databases
  • Data Warehousing
  • Web-Accessible Databases
  • Using Database Systems to Anchor Management Support Systems
  • Overview of Oracle
  • Overview of DB2
  • Overview of MySQL
  • Overview of Microsoft SQL Server