Database Design, Query Formulation, and Administration
If you’re in North America, please visit our Sage College Publishing website to purchase or sample this book:
Go to College Publishing WebsiteDescription
Formerly published by Chicago Business Press, now published by Sage
Database Design, Query Formulation, and Administration, Eighth Edition, offers a comprehensive understanding of database technology. Author Michael Mannino equips students with the necessary tools to grasp the fundamental concepts of database management, and then guides them in honing their skills to solve both basic and advanced problems for operational databases and data warehouses in query formulation, database design, and administration.
Features of the Eighth Edition:
- Unmatched SQL coverage in both breadth and depth
- Oracle and PostgreSQL coverage
- Problem-solving guidelines
- Sample databases and examples
- Normalization
- Physical database design
- Triggers
- Data modeling tools
- Data warehouse design
- Data integration
- NoSQL coverage
- Current and cutting-edge topics
- Comprehensive enough for multiple database courses
Contents
Chapter 1 Introduction to Database Management
Chapter 1 Introduction to Database Management
Chapter 2 Introduction to Database Development
Chapter 2 Introduction to Database Development
Chapter 3 The Relational Data Model in the SQL Standard
Chapter 3 The Relational Data Model in the SQL Standard
Chapter 4 Query Formulation with SQL
Chapter 4 Query Formulation with SQL
Chapter 5 Understanding Entity Relationship Diagrams
Chapter 5 Understanding Entity Relationship Diagrams
Chapter 6 Developing Data Models for Business Databases
Chapter 6 Developing Data Models for Business Databases
Chapter 7 Normalization Concepts and Processes
Chapter 7 Normalization Concepts and Processes
Chapter 8 Physical Database Design
Chapter 8 Physical Database Design
Chapter 9 Advanced Matching Problems
Chapter 9 Advanced Matching Problems
Chapter 10 Views, Null Values, and Hierarchical Queries
Chapter 10 Views, Null Values, and Hierarchical Queries
Chapter 11 Stored Procedures and Triggers
Chapter 11 Stored Procedures and Triggers
Chapter 12 Data Warehouse Concepts and Management
Chapter 12 Data Warehouse Concepts and Management
Chapter 13 Conceptual Design of Data Warehouses
Chapter 13 Conceptual Design of Data Warehouses
Chapter 14 Data Integration Concpets and Practices
Chapter 14 Data Integration Concpets and Practices
Chapter 15 Query Formulation for Data Warehouses
Chapter 15 Query Formulation for Data Warehouses
Chapter 16 Data and Database Administration
Chapter 16 Data and Database Administration
Chapter 17 Transaction Management
Chapter 17 Transaction Management
Chapter 18 Client-Server Processing, Parallel Database Processing, and Distributed Databases
Chapter 18 Client-Server Processing, Parallel Database Processing, and Distributed Databases
Chapter 19 DBMS Extensions for Object and NoSQL Databases
Chapter 19 DBMS Extensions for Object and NoSQL Databases
Description
Formerly published by Chicago Business Press, now published by Sage
Database Design, Query Formulation, and Administration, Eighth Edition, offers a comprehensive understanding of database technology. Author Michael Mannino equips students with the necessary tools to grasp the fundamental concepts of database management, and then guides them in honing their skills to solve both basic and advanced problems for operational databases and data warehouses in query formulation, database design, and administration.
Features of the Eighth Edition:
- Unmatched SQL coverage in both breadth and depth
- Oracle and PostgreSQL coverage
- Problem-solving guidelines
- Sample databases and examples
- Normalization
- Physical database design
- Triggers
- Data modeling tools
- Data warehouse design
- Data integration
- NoSQL coverage
- Current and cutting-edge topics
- Comprehensive enough for multiple database courses
Contents
Chapter 1 Introduction to Database Management
Chapter 1 Introduction to Database Management
Chapter 2 Introduction to Database Development
Chapter 2 Introduction to Database Development
Chapter 3 The Relational Data Model in the SQL Standard
Chapter 3 The Relational Data Model in the SQL Standard
Chapter 4 Query Formulation with SQL
Chapter 4 Query Formulation with SQL
Chapter 5 Understanding Entity Relationship Diagrams
Chapter 5 Understanding Entity Relationship Diagrams
Chapter 6 Developing Data Models for Business Databases
Chapter 6 Developing Data Models for Business Databases
Chapter 7 Normalization Concepts and Processes
Chapter 7 Normalization Concepts and Processes
Chapter 8 Physical Database Design
Chapter 8 Physical Database Design
Chapter 9 Advanced Matching Problems
Chapter 9 Advanced Matching Problems
Chapter 10 Views, Null Values, and Hierarchical Queries
Chapter 10 Views, Null Values, and Hierarchical Queries
Chapter 11 Stored Procedures and Triggers
Chapter 11 Stored Procedures and Triggers
Chapter 12 Data Warehouse Concepts and Management
Chapter 12 Data Warehouse Concepts and Management
Chapter 13 Conceptual Design of Data Warehouses
Chapter 13 Conceptual Design of Data Warehouses
Chapter 14 Data Integration Concpets and Practices
Chapter 14 Data Integration Concpets and Practices
Chapter 15 Query Formulation for Data Warehouses
Chapter 15 Query Formulation for Data Warehouses
Chapter 16 Data and Database Administration
Chapter 16 Data and Database Administration
Chapter 17 Transaction Management
Chapter 17 Transaction Management
Chapter 18 Client-Server Processing, Parallel Database Processing, and Distributed Databases
Chapter 18 Client-Server Processing, Parallel Database Processing, and Distributed Databases
Chapter 19 DBMS Extensions for Object and NoSQL Databases
Chapter 19 DBMS Extensions for Object and NoSQL Databases
Database Design, Query Formulation, and Administration
Using Oracle and PostgreSQL
September 2022 | 812 pages | Sage US
| Format | Published Date | ISBN | Price |
|---|
Formerly published by Chicago Business Press, now published by Sage
Database Design, Query Formulation, and Administration, Eighth Edition, offers a comprehensive understanding of database technology. Author Michael Mannino equips students with the necessary tools to grasp the fundamental concepts of database management, and then guides them in honing their skills to solve both basic and advanced problems for operational databases and data warehouses in query formulation, database design, and administration.
Features of the Eighth Edition:
- Unmatched SQL coverage in both breadth and depth
- Oracle and PostgreSQL coverage
- Problem-solving guidelines
- Sample databases and examples
- Normalization
- Physical database design
- Triggers
- Data modeling tools
- Data warehouse design
- Data integration
- NoSQL coverage
- Current and cutting-edge topics
- Comprehensive enough for multiple database courses
Table Of Contents:
- 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 NoSQL Databases