SQL & Database Management

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

初級 7 モジュール 約 12 時間 無料
トラックを始める
  1. 1 How Relational Databases Work Tables, rows, keys and relationships, and why nearly every app stores data this way. 25 分
  2. 2 Creating Tables and Choosing Types CREATE TABLE, data types, constraints and default values that protect your data. 30 分
  3. 3 Querying Data with SELECT Filter, sort, limit and shape results: the SQL you will write most often. 35 分
  4. 4 Joins: Combining Tables INNER, LEFT and self joins, join tables, and how to avoid duplicated rows. 35 分
  5. 5 Aggregation, Subqueries and CTEs GROUP BY, HAVING, subqueries, common table expressions and window functions for reports. 40 分
  6. 6 Changing Data Safely: INSERT, UPDATE, DELETE and Transactions Modify data, use transactions, avoid SQL injection and prevent lost updates. 35 分
  7. 7 Indexes, Performance and Migrations Make queries fast with indexes, read query plans, and change schemas with migrations. 40 分