Datenbanksysteme
Database Fundamentals
Overview
Core concepts of database systems and relational models
Learning Objectives
- Understand relational models
- Master SQL fundamentals
- Work with database design
- Apply normalization principles
- Implement data integrity
Learning Resources
Database Systems
Stanford's DB course
Stanford
SQL Tutorial
Interactive SQL practice
SQLZoo
Database Systems
MIT's database course
MIT OCW
PostgreSQL Docs
PostgreSQL manual
PostgreSQL
SQL Tutorial
Comprehensive SQL guide
Mode Analytics
Database Design
Database concepts
O'Reilly
SQL Practice
SQL challenges
HackerRank
Database Systems
CMU's database course
CMU
CS186
Berkeley's DB course
Berkeley
MySQL Manual
MySQL documentation
MySQL
Practical Applications
Data Management
Database administration
Example: Setting up production databases
Application Development
Backend integration
Example: Building data-driven applications
Data Analysis
Data querying
Example: Complex SQL reporting
Practice Problems
- Design database schema
- Write complex SQL queries
- Implement data normalization
- Create database indexes
Advanced Database Concepts
Overview
Advanced topics in database management and optimization
Learning Objectives
- Master query optimization
- Understand transaction management
- Work with distributed databases
- Apply indexing strategies
- Implement concurrency control
Learning Resources
Advanced Database Systems
MIT's advanced DB course
MIT OCW
Performance Tuning
Database optimization guide
Oracle
Advanced Databases
CMU's advanced course
CMU
Transaction Processing
Classic transaction text
Morgan Kaufmann
SQL Indexing
SQL indexing guide
Use The Index, Luke
Distributed Data
Distributed databases
Berkeley
Performance Guide
MongoDB optimization
MongoDB
Database Tuning
Performance optimization
Stanford
Database Problems
Advanced SQL challenges
LeetCode
PostgreSQL Tuning
Database configuration
PGTune
Practical Applications
Performance Optimization
Query tuning
Example: Optimizing complex queries
Distributed Systems
Scaling databases
Example: Implementing sharding
Transaction Processing
ACID compliance
Example: Implementing transaction managers
Practice Problems
- Optimize query performance
- Implement transaction handling
- Design distributed systems
- Create indexing strategies
Modern Database Systems
Overview
Contemporary database technologies and paradigms
Learning Objectives
- Understand NoSQL databases
- Master data warehousing
- Work with cloud databases
- Apply big data concepts
- Implement data lakes
Learning Resources
Big Data Systems
Modern data systems
Harvard
Cloud Databases
AWS database services
AWS
NoSQL Fundamentals
NoSQL database course
MongoDB University
Data Warehousing
Warehouse architecture
O'Reilly
NoSQL Design
Distributed NoSQL
Cassandra
Big Data
Big data processing
Coursera
Cloud Spanner
Distributed SQL
Google Cloud
Graph Databases
Graph DB tutorials
Neo4j
NoSQL Architecture
NoSQL design patterns
DataStax
Data Warehouse
Modern warehousing
Snowflake
Practical Applications
Cloud Architecture
Cloud-native databases
Example: Implementing cloud scaling
Big Data Processing
Large-scale data
Example: Building data pipelines
NoSQL Solutions
Non-relational data
Example: Document store implementation
Practice Problems
- Design NoSQL databases
- Implement data warehouses
- Create cloud solutions
- Build big data systems