SQL & Database Management

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

Principiante 7 moduli circa 12 h Gratis
Inizia il percorso
  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