Databases
10 modules.
🗄️ Introduction to SQLQuery relational databases: SELECT, filtering with WHERE, and sorting with ORDER BY. 🔍 Advanced filteringCombine conditions with AND/OR/NOT, use IN, BETWEEN, LIKE and IS NULL, and limit results with DISTINCT and LI… 📊 Aggregations: GROUP BY and HAVINGSummarize data with aggregate functions (COUNT, SUM, AVG, MIN, MAX), group it with GROUP BY, and filter group… 🧮 Sets and functionsCombine queries with UNION, INTERSECT and EXCEPT; handle NULL with COALESCE and three valued logic; transform… 📐 Design, normalization and data modificationDesign solid relational schemas (PK, FK, 1:1, 1:N and N:M relationships), normalize up to 3NF and modify data… 🔗 JOINs: combining tablesSpread information across several related tables and bring it back together with INNER JOIN, LEFT JOIN, alias… 🪆 Subqueries and CTEsNest queries to answer complex questions: scalar subqueries and subqueries in WHERE, correlated EXISTS and CT… 🪟 Advanced SQL: windows, views and CASEConditional logic with CASE, window functions (OVER, PARTITION BY, ROW NUMBER, RANK, running totals), views a… ⚡ Performance, transactions and NoSQLSpeed up queries with indexes, guarantee integrity with ACID transactions and get to know the NoSQL world: do… 🏆 Capstone: design and query a databaseFinal project of the track: an online store with customers, products, orders and order items. It combines JOI…Databases
DevPath is a hands-on course: you read the theory here; in the app you put it into practice with exercises that really run, offline.
Start free in the app →