Skip to content
Beta

SQL and Relational Database Fundamentals

In 1 trail

Last updated on

Course Overview

Section titled “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

Section titled “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

Section titled “Modules”
  • Relational Database Concepts
  • SQL Querying Fundamentals
  • Advanced SQL and Optimization
  • Database Administration Basics
STACKIT documentation university.stackit.cloud View Course on STACKIT University Open the documentation
Asset historyActive 2 of the last 12 weeksTMUpdatedNo updates · 1 bar = 1 week i
Maintainers
TMTobias M.Head of STACKIT Cloud Framework · STACKITOwnerActive 12 of the last 12 weeks · 168 updatesSTACKITwww.linkedin.com/in/tobias-müller-011304172CC.C1SCF Core · STACKITOwnerActive 5 of the last 12 weeks · 23 updatesSTACKITwww.linkedin.com/in/can-celik-645932315can.celik1@digits.schwarzContributed in STACKIT