Michael Mannino 
Database Design, Query Formulation, and Administration [PDF ebook] 
Using Oracle and PostgreSQL

Chapter 1 Introduction to Database Management
Chapter 2 Introduction to Database Development
Chapter 3 The Relational Data Model in the SQL Standard
Chapter 4 Query Formulation with SQL
Chapter 5 Understanding Entity Relationship Diagrams
Chapter 6 Developing Data Models for Business Databases
Chapter 7 Normalization Concepts and Processes
Chapter 8 Physical Database Design
Chapter 9 Advanced Matching Problems
Chapter 10 Views, Null Values, and Hierarchical Queries
Chapter 11 Stored Procedures and Triggers
Chapter 12 Data Warehouse Concepts and Management
Chapter 13 Conceptual Design of Data Warehouses
Chapter 14 Data Integration Concpets and Practices
Chapter 15 Query Formulation for Data Warehouses
Chapter 16 Data and Database Administration
Chapter 17 Transaction Management
Chapter 18 Client-Server Processing, Parallel Database Processing, and Distributed Databases
Chapter 19 DBMS Extensions for Object and No SQL Databases

Michael V. Mannino has been involved with database technology since 1978 when he began graduate studies at the University of Arizona. 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 tens of thousands of Coursera learners. He has also been active in database research with publications in major journals of the IEEE (Transactions on Knowledge and Data Engineering and Transactions on Software Engineering), ACM (Communications, Journal of Data and Information Quality, Transactions on Management Information Systems, 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 presenting original research. Practical results of his research have been incorporated into Chapter 12 on management of the data warehouse development, especially the design and implementation of the educational game, Emerge2Maturity, for providing insights about data warehouse maturity in organizations.