eBook[PDF]

Modern Database Management, (Global Edition) 13th Edition By Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

$25.00
Secure checkout
Instant digital download
PDF document

Document details

Pages
591
File size
12.94 MB
Format
Digital PDF
Category
eBook[PDF]
About this ebook
The Modern Database Management, (Global Edition) 13th Edition by Jeff Hoffer, Ramesh Venkataraman, and Heikki Topi is structured into four core sections alongside bonus online chapters and appendices. The text covers the foundational to advanced principles of modern database development, design, and analytics. [1, 2]
The book contains the following chapters and main topics:
Part I: The Context of Database Management
  • Chapter 1: The Database Environment and Development Process – Core terminology, comparing database systems with legacy file systems, the 3-schema architecture, and database development life cycles. [1, 2, 3]
Part II: Database Analysis and Logical Design
  • Chapter 2: Modeling Data in the Organization – Foundations of conceptual data modeling using Entity-Relationship (E-R) diagrams.
  • Chapter 3: The Enhanced E-R Model – Advanced data modeling, including supertype/subtype relationships and business rules.
  • Chapter 4: Logical Database Design and the Relational Model – Mapping E-R diagrams into relational structures, normalization fundamentals, and ensuring data integrity. [1]
Part III: Database Implementation and Use
  • Chapter 5: Introduction to SQL – Writing standard Structured Query Language commands, including data definition (DDL) and basic data manipulation (DML). [1]
  • Chapter 6: Advanced SQL – Complex querying techniques, including subqueries, joins, triggers, views, and stored procedures. [1]
  • Chapter 7: Databases in Applications – Connecting databases to software programs, multi-user application architectures, and web-database integration. [1, 2]
  • Chapter 8: Physical Database Design and Database Infrastructure – Selecting storage structures, file organization, indexing for performance optimization, and application security. [1, 2, 3]
Part IV: Advanced Database Topics
  • Chapter 9: Data Warehousing and Data Integration – Architecting data warehouses, data marts, and running Extraction, Transformation, and Loading (ETL) processes.
  • Chapter 10: Big Data Technologies – Introducing NoSQL databases, Hadoop, MapReduce, and managing unstructured data.
  • Chapter 11: Analytics and Its Implications – Leveraging data for business intelligence, descriptive, predictive, and prescriptive analytics.
  • Chapter 12: Data and Database Administration with Focus on Data Quality – Role of the DBA, concurrency control, backup/recovery, data security, and ensuring high-quality data governance. [1, 2, 3, 4, 5]
Supplementary Modules & Appendices
  • Online Chapters:
    • Distributed Databases
    • Object-Oriented Data Modeling [1, 2]
  • Appendices:
    • Appendix A: Data Modeling Tools and Notation
    • Appendix B: Advanced Normal Forms
    • Appendix C: Data Structures [1]

File included

PDF
tmpphpgFFTN5 12.94 MB

Topics