SQL & Database Management

Model data, write queries, join tables, index for speed and keep production databases healthy.

Einsteiger 7 Module ca. 12 Std. Kostenlos
Lernpfad starten
  1. 1 How Relational Databases Work Tables, rows, keys and relationships, and why nearly every app stores data this way. 25 Min.
  2. 2 Creating Tables and Choosing Types CREATE TABLE, data types, constraints and default values that protect your data. 30 Min.
  3. 3 Querying Data with SELECT Filter, sort, limit and shape results: the SQL you will write most often. 35 Min.
  4. 4 Joins: Combining Tables INNER, LEFT and self joins, join tables, and how to avoid duplicated rows. 35 Min.
  5. 5 Aggregation, Subqueries and CTEs GROUP BY, HAVING, subqueries, common table expressions and window functions for reports. 40 Min.
  6. 6 Changing Data Safely: INSERT, UPDATE, DELETE and Transactions Modify data, use transactions, avoid SQL injection and prevent lost updates. 35 Min.
  7. 7 Indexes, Performance and Migrations Make queries fast with indexes, read query plans, and change schemas with migrations. 40 Min.