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 分钟