Database Systems: A Pragmatic Approach
- 7h 15m
- Elvis C. Foster, Shripad Godbole
- Apress
- 2014
Database Systems: A Pragmatic Approach provides a comprehensive, yet concise introduction to database systems. 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 database administrators desiring to increase their mastery of the theoretical underpinnings of their craft. The book is also aimed at students, and at professors needing a textbook for use by students, who are studying database technology, who aspire to a career as a database administrator or designer.
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 25 years of combined experience as a software engineer, database expert, information technology executive and consultant, and computer science educator. He has lectured at the higher education level in three different countries, including the United States, and has produced several outstanding computer science and information technology professionals, many of whom have excelled at graduate school as well as in the workplace.
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, 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
-
Relational System — a Closer Look
-
Overview of SQL
-
SQL Data Definition Statements
-
SQL Data Manipulation Statements
-
SQL Views and System Security
-
The System Catalog
-
Some Limitations of SQL
-
Overview of Oracle
-
Overview of DB2
-
Overview of MS SQL Server
-
Overview of MySQL
-
Overview of Delphi
-
Database Administration
-
Distributed Database Systems
-
Object Databases
-
Data Warehousing
-
Web-Accessible Databases
-
Sample Exercises and Examination Questions
YOU MIGHT ALSO LIKE
