SQL & Database Fundamentals: Data Modeling, Queries, and Performance

From SQL & Database Fundamentals: Data Modeling, Queries, and Performance

Table of Contents

4 of 25 chapters available · Premium unlocks the rest

• 1 Legal Notices
• 2 About This Book
• 3 Part I: Relational Foundations
• 4 Chapter 1: SQL and the Shop Database
• 5 Chapter 2: Configure PostgreSQL and Your Workspace
• 6 Chapter 3: Model Tables, Keys, and Relationships
• 7 Chapter 4: Build and Seed the Shop Schema
• 8 Part II: Querying Shop Data
• 9 Chapter 5: Select, Filter, and Sort Rows
• 10 Chapter 6: Handle NULL and Data Expressions
• 11 Chapter 7: Join Related Tables Correctly
• 12 Chapter 8: Aggregate Orders and Sales
• 13 Part III: Advanced Queries and Changes
• 14 Chapter 9: Compose Queries with Subqueries, CTEs, and Sets
• 15 Chapter 10: Analyze Data with Window Functions
• 16 Chapter 11: Change Data and Strengthen Constraints
• 17 Chapter 12: Protect Orders with Transactions
• 18 Part IV: Production Readiness
• 19 Chapter 13: Parameterize Queries and Restrict Access
• 20 Chapter 14: Test Queries and Database Rules
• 21 Chapter 15: Measure Plans and Optimize Queries
• 22 Chapter 16: Migrate and Deploy the Shop Database
• 23 Next Steps
• 24 Part V: Review Questions
• 25 Answer Key