Modern Database Management 13th Edition by Jeff Hoffer, Ramesh Venkataraman, Heikki Topi – Ebook PDF Instant Download/Delivery: B07R8FYF2M, 978-0134773650
Full download Modern Database Management 13th edition after payment
Product details:
ISBN 10: B07R8FYF2M
ISBN 13: 978-0134773650
Author: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Focusing on what leading database practitioners say are the most important aspects to database development, Modern Database Management presents sound pedagogy and topics that are critical for the practical success of database professionals. The 13th Edition updates and expands materials in areas undergoing rapid change as a result of improved managerial practices, database design tools and methodologies, and database technology – such as application security, multi-user solutions, and more – to reflect major trends in the field and the skills required of modern information systems graduates.
Modern Database Management 13th Table of contents:
Preface
- Introduction to Modern Database Management
- Changes in the 13th Edition
- Acknowledgments
Part 1: Introduction to Databases and Database Management Systems
Chapter 1: Introduction to Databases
- What Is a Database?
- Characteristics of Database Systems
- Database Applications
- Types of Databases: Operational, Analytical, and More
- Benefits of Database Management Systems (DBMS)
Chapter 2: The Database Environment
- Components of the Database Environment
- Database Users and Their Roles
- Database Architectures
- DBMS Functions and Components
- The Database System Development Life Cycle (SDLC)
Chapter 3: Database Design: Overview and Data Modeling
- Database Design Process
- Conceptual, Logical, and Physical Data Models
- Entity-Relationship (ER) Modeling
- Mapping ER Models to Relational Schemas
- Normalization and Its Role in Database Design
Part 2: The Relational Model and SQL
Chapter 4: The Relational Model
- Relational Databases: Concepts and Terminology
- Relational Integrity Constraints
- Relational Operations
- Relational Algebra and Relational Calculus
- Keys and Foreign Keys in the Relational Model
Chapter 5: Structured Query Language (SQL)
- Introduction to SQL
- Basic SQL Queries
- Data Definition Language (DDL) in SQL
- Data Manipulation Language (DML) in SQL
- Advanced SQL Queries: Joins, Subqueries, and Set Operations
- SQL Constraints and Views
Chapter 6: SQL Advanced Topics
- Aggregate Functions and Grouping
- Nested Queries and Correlated Subqueries
- Transactions and SQL
- Triggers and Stored Procedures
- Indexes and Performance Optimization
Part 3: Advanced Database Concepts
Chapter 7: Database Normalization
- The Need for Normalization
- First, Second, and Third Normal Forms
- Boyce-Codd Normal Form (BCNF)
- Fourth and Fifth Normal Forms
- Denormalization and Performance Considerations
Chapter 8: Relational Database Design and Implementation
- Database Design Process and Strategies
- Functional Dependencies and Decomposition
- Lossless Join Decomposition
- Design by Synthesis and Semantic Constraints
Chapter 9: Transaction Management and Concurrency Control
- Introduction to Transactions
- ACID Properties of Transactions
- Concurrency Control Techniques
- Locking and Deadlock Management
- Isolation Levels and Transaction Scheduling
Chapter 10: Database Security and Integrity
- Security Concerns in Database Management
- Database Access Control
- User Privileges and Authentication
- Integrity Constraints
- Auditing and Monitoring Database Systems
Part 4: Distributed and NoSQL Databases
Chapter 11: Distributed Databases
- Introduction to Distributed Database Systems
- Architecture and Design of Distributed Databases
- Distributed Query Processing
- Transaction Management in Distributed Databases
- Replication and Fragmentation
Chapter 12: NoSQL Databases
- Introduction to NoSQL Databases
- Types of NoSQL Databases: Key-Value Stores, Document Stores, Column Family Stores, Graph Databases
- Comparing NoSQL and Relational Databases
- When to Use NoSQL Databases
- CAP Theorem and Consistency Models in NoSQL Systems
Chapter 13: Big Data and Data Warehousing
- Introduction to Big Data
- Characteristics of Big Data (Volume, Variety, Velocity)
- Data Warehousing Concepts and Architecture
- ETL Process and Data Integration
- Big Data Technologies: Hadoop, Spark, and NoSQL
- Data Mining and Analytics in Big Data Environments
Part 5: Database Administration and Emerging Topics
Chapter 14: Database Administration and Management
- Roles and Responsibilities of a Database Administrator (DBA)
- Database Installation and Configuration
- Backup and Recovery Techniques
- Performance Tuning and Optimization
- Database Monitoring and Troubleshooting
Chapter 15: Emerging Topics in Database Management
- Cloud Databases and Database as a Service (DBaaS)
- In-Memory Databases and New Storage Architectures
- Blockchain and Distributed Ledger Technologies
- Machine Learning and Databases
- Future Trends in Database Management
Appendices
- A. SQL Syntax Reference
- B. SQL Query Practice Problems
- C. Glossary of Database Terms
- D. Index
People also search for Modern Database Management 13th:
modern database management 13th edition ppt
modern database management 13th edition chegg
modern database management 13th edition jeff hoffer
modern database management 13th edition pearson
modern database management answer key
Tags:
Jeff Hoffer,Ramesh Venkataraman,Heikki Topi,Modern Database Management