Database Design, Query Formulation, and Administration, 8e

Using Oracle and PostgreSQL

by Mannino

| ISBN: 9781948426954 | Copyright 2023

Click here to preview

Instructor Requests

Digital Exam/Desk Copy Print Exam/Desk Copy Ancillaries
Tabs
  • Unmatched SQL coverage in both breadth and depth
  • Oracle and PostgreSQL coverage
  • Problem-solving guidelines
  • Sample databases and examples
  • Data modeling tools
  • Data warehouse coverage
  • NoSQL coverage
  • Current and cutting-edge topics
  • Comprehensive enough for multiple database courses
Expand/Collapse All
Preface (pg. xviii)
CH01 Introduction to Database Management (pg. 3)
CH02 Introduction to Database Development (pg. 23)
CH03 The Relational Data Model in the SQL Standard (pg. 43)
CH04 Query Formulation with SQL (pg. 73)
CH05 Understanding Entity Relationship Diagrams (pg. 139)
CH06 Developing Data Models for Business Databases (pg. 175)
CH07 Normalization Concepts and Processes (pg. 227)
CH08 Physical Database Design (pg. 259)
CH09 Advanced Matching Problems (pg. 311)
CH10 Views, Null Values, and Hierarchical Queries (pg. 341)
CH11 Stored Procedures and Triggers (pg. 383)
CH12 Data Warehouse Concepts and Management (pg. 443)
CH13 Conceptual Design of Data Warehouses (pg. 473)
CH14 Data Integration Concpets and Practices (pg. 515)
CH15 Query Formulation for Data Warehouses (pg. 551)
CH16 Data and Database Administration (pg. 605)
CH17 Transaction Management (pg. 639)
CH18 Client-Server Processing, Parallel Database Processing, and Distributed Databases (pg. 681)
CH19 DBMS Extensions for Object and NoSQL Databases (pg. 721)
Index (pg. 774)

Michael V. Mannino

Michael V. Mannino has been involved in the database feld since 1980. He has taught database management since 1983 at several major universities (University of Florida, University of Texas at Austin, University of Washington, and University of Colorado Denver). His audiences have included undergraduate MIS students, graduate MIS students, MBA students, and doctoral students as well as corporate employees in retraining programs. He has also been active in database research as evidenced by publications in major journals of the IEEE (Transactions on Knowledge and Data Engineering and Transactions on Software Engineering), ACM (Communications and Computing Surveys), and INFORMS (Informs Journal on Computing and Information Systems Research). His research includes several popular survey and tutorial articles as well as many papers describing original research. Practical results of his research have been incorporated into Chapter 12 on a form-driven approach to database design and Chapter 17 on management of the refresh process.


Databases
Last Updated: Sep 5 2022
Appendices
Last Updated: Sep 5 2022
Instructors Only
You must have an instructor account and submit a request to access instructor materials for this book.
eBook
Go paperless today! Available online anytime, nothing to download or install.
6 months / $59.00