← All free certificatesFree learning path Final step
DBMS & SQL
10 short modules. Each one: a simple lesson, two quick games and a 8-question quiz for its own free certificate. Finish them all, then take the full DBMS & SQL certificate.
0 of 10 module certificates
- What is a database?A database stores data in an organised way; a DBMS is the software that manages it.0/4
- Tables, keys and constraintsKeys identify rows and link tables; constraints keep data valid.0/4
- Creating tables: DDLDefine structure with CREATE, ALTER and DROP.0/4
- Changing data: DMLAdd, change and remove rows with INSERT, UPDATE and DELETE.0/4
- Querying with SELECTRead data with SELECT, filter with WHERE and sort with ORDER BY.0/4
- Aggregate functions and GROUP BYSummarise data with COUNT, SUM, AVG, MIN, MAX and GROUP BY.0/4
- JoinsCombine rows from two or more tables with INNER, LEFT, RIGHT and FULL joins.0/4
- NormalizationOrganise tables to remove duplicate data and update problems.0/4
- Transactions and ACIDGroup changes into transactions that are all-or-nothing and safe.0/4
- Indexes, views and real-world SQLSpeed up queries with indexes, simplify them with views, and keep data secure.0/4
🏆 Full DBMS & SQL certificate
20 questions from basic to advanced, 60% to pass. Best taken after the modules.