--- title: "SQL and Relational Database Fundamentals" description: "Relational database concepts, SQL querying, query optimization, and basic database administration as a foundation for data engineering." scfAsset: managed: false category: "guide" maintainers: - user: "can.celik1" external: true tags: ["STACKIT University", "Learning", "SQL", "Databases"] source_url: "https://framework.stackit.cloud/data-and-ai/assetcontainer/stackit/sql-relational-database-fundamentals/" source_file: "docs/data-and-ai/assetcontainer/stackit/sql-relational-database-fundamentals.mdx" --- ## Course Overview A foundational course in relational databases and SQL for anyone about to work with data warehouses and pipelines. It starts with relational database concepts — tables, keys, and normalization — before building up SQL querying skills from basic selects and joins to more advanced querying and optimization, and closes with basic database administration. It's a prerequisite for the Data Modeling and Warehousing course: comfort with joins, normalization, and basic database design is assumed from here on. ### What You'll Learn - Explain core relational database concepts and normalization - Write SQL queries covering selects, joins, and aggregations - Apply advanced SQL techniques and basic query optimization - Perform basic database administration tasks ### Modules - Relational Database Concepts - SQL Querying Fundamentals - Advanced SQL and Optimization - Database Administration Basics