Database Design for Software Architects
Master the art of database design, from fundamental concepts to modern data architectures, and build robust, scalable, and efficient solutions.
...
Share
Fundamentals of Data Modeling
Unit 1: Introduction to Data Modeling
What is Data Modeling?
Data Modeling Benefits
Data Model Types
Unit 2: Core Data Modeling Concepts
Entities: The Basics
Attributes: Describing Data
Relationships: Connecting Data
Keys: Identifying Data
Unit 3: Conceptual Data Modeling
Conceptual Models
From Requirements to Model
ERDs: Visualizing Data
Unit 4: Logical and Physical Data Modeling
Logical Data Models
Physical Data Models
Choosing Data Types
Constraints & Rules
Relational Database Model
Unit 1: Relational Model Fundamentals
What is Relational Data?
Keys: The Basics
Data Integrity Rules
RDBMS Overview
ACID Properties
Unit 2: Relational Algebra and SQL
Relational Algebra Intro
Select and Project
Union, Intersect, Diff
RA and SQL
SQL: SELECT Basics
Unit 3: Table Design and SQL Basics
Designing Tables
SQL: INSERT
SQL: UPDATE
SQL: DELETE
SQL: Filtering
Normalization Techniques
Unit 1: Understanding Normalization
Why Normalize?
Functional Dependencies
Normalization Anomalies
Keys to Normal Forms
Unit 2: First Normal Form (1NF)
What is 1NF?
Achieving 1NF
1NF Example
Unit 3: Second Normal Form (2NF)
Understanding 2NF
Reaching 2NF
2NF Example
Unit 4: Third Normal Form (3NF) and BCNF
Intro to 3NF
Achieving 3NF
3NF Example
Boyce-Codd NF (BCNF)
Unit 5: Normalization Trade-offs
Normalization vs. Speed
NoSQL Database Models
Unit 1: Introduction to NoSQL
What is NoSQL?
Why NoSQL?
NoSQL Use Cases
ACID vs. BASE
Unit 2: Key-Value and Document Databases
Key-Value Stores
Use Cases: Key-Value
Document Databases
JSON and BSON
Use Cases: Document
Unit 3: Column-Family and Graph Databases
Column-Family DBs
Wide-Column Stores
Use Cases: Column-Family
Graph Databases
Use Cases: Graph
Unit 4: CAP Theorem and NoSQL Selection
CAP Theorem Intro
CAP in Practice
NoSQL Selection
Graph Database Design
Unit 1: Introduction to Graph Databases
What are Graph Databases?
Graph Database Use Cases
The Property Graph Model
Graphs vs. Relational
Unit 2: Graph Data Modeling
Nodes: The Building Blocks
Edges: Connecting the Dots
Properties: Adding Context
Modeling Relationships
Data Modeling Best Practices
Unit 3: Graph Querying with Cypher
Intro to Cypher
Matching Patterns
Filtering Results
Returning Data
Creating & Deleting Data
Unit 4: Neo4j and Graph Traversal
Neo4j: A Deep Dive
Graph Traversal Basics
Pathfinding Algorithms
Database Design for Cloud-Native Applications
Unit 1: Cloud Database Fundamentals
Cloud Database Landscape
Cloud Database Models
Cloud Database Selection
Cloud Database Provisioning
Unit 2: Scalability, Availability, and Fault Tolerance
Scalability Strategies
Availability & Redundancy
Fault Tolerance Techniques
Disaster Recovery
Unit 3: Cost Optimization, Security, and Compliance
Cost Optimization
Security Best Practices
Compliance Standards
Data Encryption
Monitoring & Logging
Data Architectures and Database Integration
Unit 1: Modern Data Architectures
Data Architecture Overview
Data Lakes: The Basics
Data Warehouses: The Basics
Real-Time Data Streaming
Comparing Architectures
Unit 2: Database Design Considerations
Data Lake DB Design
Data Warehouse DB Design
Streaming DB Design
Polyglot Persistence
Unit 3: Data Integration Techniques
ETL Explained
ELT: The Modern Approach
Data Virtualization
Change Data Capture
Unit 4: Analytical Workloads and BI
Analytical DB Design
BI and Databases
Data Governance