Beginning Database Design 1st Edition by Gavin Powell – Ebook PDF Instant Download/Delivery: 0764574906, 9780764574900
Full download Beginning Database Design 1st Edition after payment
Product details:
ISBN 10: 0764574906
ISBN 13: 9780764574900
Author: Gavin Powell
- The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently
- Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle
- Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance
- Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements
Beginning Database Design 1st Table of contents:
-
Part 1: Foundational Database Concepts
-
Chapter 1: The Basics of Database Design
-
What Is a Database?
-
Types of Databases
-
The Database Design Process Overview
-
Why Good Design Matters
-
-
Chapter 2: Relational Database Theory
-
Relational Model Fundamentals
-
Keys (Primary, Foreign, Candidate)
-
Relationships (One-to-One, One-to-Many, Many-to-Many)
-
Referential Integrity
-
-
Chapter 3: Normalization
-
Understanding Data Anomalies
-
First Normal Form (1NF)
-
Second Normal Form (2NF)
-
Third Normal Form (3NF)
-
Boyce-Codd Normal Form (BCNF)
-
Beyond 3NF (briefly)
-
Denormalization Considerations
-
-
-
Part 2: The Database Design Process
-
Chapter 4: Requirements Gathering and Analysis
-
Understanding User Needs
-
Identifying Entities and Attributes
-
Documenting Requirements
-
Use Cases and Scenarios
-
-
Chapter 5: Conceptual Data Modeling (ERDs)
-
Introduction to Entity-Relationship Diagrams (ERDs)
-
Entities, Attributes, and Relationships (Notation)
-
Cardinality and Ordinality
-
Building Your First ERD
-
-
Chapter 6: Logical Database Design
-
Mapping ERDs to Relational Schemas
-
Defining Data Types
-
Indexing Strategies
-
Views and Stored Procedures (design considerations)
-
-
Chapter 7: Physical Database Design
-
Choosing a Database Management System (DBMS)
-
Storage Considerations
-
Performance Tuning at the Physical Level
-
Security Design
-
-
-
Part 3: Practical Database Design Solutions
-
Chapter 8: Designing for Common Business Scenarios
-
Customer Relationship Management (CRM)
-
Order Entry Systems
-
Inventory Management
-
Human Resources
-
-
Chapter 9: Advanced Design Patterns
-
Handling Hierarchical Data
-
Time-Series Data
-
Audit Trails and Versioning
-
Geospatial Data (brief introduction)
-
-
Chapter 10: Data Warehousing and OLAP Design
-
Introduction to Data Warehousing
-
Star Schema and Snowflake Schema
-
Fact and Dimension Tables
-
OLAP Cubes
-
-
Chapter 11: NoSQL Database Design (Introduction)
-
When to Use NoSQL
-
Key-Value Stores
-
Document Databases
-
Column-Family Databases
-
Graph Databases
-
-
-
Part 4: Managing and Evolving Databases
-
Chapter 12: Database Security and Administration Considerations
-
User Permissions and Roles
-
Backup and Recovery Strategies
-
Auditing
-
-
Chapter 13: Database Migration and Refactoring
-
Schema Evolution
-
Data Migration Techniques
-
Dealing with Legacy Systems
-
-
Chapter 14: The Future of Database Design
-
Big Data Trends
-
Cloud Databases
-
AI and Machine Learning in Databases
-
-
People also search for Beginning Database Design 1st:
Tags: Gavin Powell, Database,