What a treat! Get Apress Access for just $149 Subscribe now >>

Database Systems

A Pragmatic Approach

Authors: Foster, Elvis, Godbole, Shripad

Download source code
  • A classroom textbook providing a comprehensive yet concise introduction to the theory and practice of database systems as they are used in corporate software development
  • Presents a brief mixture of theory and how-to content designed to keep students interested in the topic while helping practicing professionals polish their grasp on the underlying theory of the technology from which they derive their livelihood
  • A textbook encompassing a one- or two-semester database course useful to professionals who have entered the field without having attained any mastery over the field's theoretical foundations
see more benefits

Buy this book

eBook $54.99
price for USA (gross)
  • ISBN 978-1-4842-1191-5
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $69.99
price for USA
  • ISBN 978-1-4842-1192-2
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

Learn the concepts, principles, design, implementation, and management issues of databases. You will adopt a methodical and pragmatic approach to solving database systems problems. 

Database Systems: A Pragmatic Approach provides a comprehensive, yet concise introduction to database systems, with special emphasis on the relational database model. This 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 learning. 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.

This book is based on lecture notes that have been tested and proven over several years, with outstanding results. It combines a balance of theory with practice, to give you your best chance at success. Each chapter is organized systematically into brief sections, with itemization of the important points to be remembered. Additionally, the book includes a number of author Elvis Foster's original methodologies that add clarity and creativity to the database modeling and design experience.

What You'll Learn

  • Understand 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
  • Understand what it means to be a database administrator, and why the profession is highly paid
  • Build and manage web-accessible databases in support of applications delivered via a browser
  • Become familiar with the common database brands, their similarities and differences
  • Explore special topics such as tree-based data, hashing for fast access, distributed and object databases, and more

Who This Book Is For

Students who are studying database technology, who aspire to a career as a database administrator or designer, and practicing database administrators and developers desiring to strengthen their knowledge of database theory

About the authors

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. 

Table of contents (30 chapters)

  • Introduction to Database Systems

    Foster, Elvis C. (et al.)

    Pages 3-14

  • The Database System Environment

    Foster, Elvis C. (et al.)

    Pages 15-33

  • The Relational Model

    Foster, Elvis C. (et al.)

    Pages 37-72

  • Integrity Rules and Normalization

    Foster, Elvis C. (et al.)

    Pages 73-100

  • Database Modeling and Design

    Foster, Elvis C. (et al.)

    Pages 101-137

Buy this book

eBook $54.99
price for USA (gross)
  • ISBN 978-1-4842-1191-5
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $69.99
price for USA
  • ISBN 978-1-4842-1192-2
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Database Systems
Book Subtitle
A Pragmatic Approach
Authors
Copyright
2016
Publisher
Apress
Copyright Holder
Elvis C. Foster and Shripad Godbole
eBook ISBN
978-1-4842-1191-5
DOI
10.1007/978-1-4842-1191-5
Softcover ISBN
978-1-4842-1192-2
Edition Number
2
Number of Pages
XXXVIII, 604
Number of Illustrations and Tables
5 b/w illustrations, 291 illustrations in colour
Topics