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 मिनट