Databases and SQL Fundamentals teaches you how organisations store, protect and use their data. You will learn what a database is and how the relational model works, then write SQL to retrieve, summarise, combine and change data. You will design well-structured databases using keys, constraints and normalisation, and learn how transactions, indexes and query plans keep data correct and fast.
The course also covers the work of a database administrator: users and privileges, backups and recovery, security, monitoring and maintenance. You will compare relational databases with NoSQL options, see how analytics and reporting use SQL, and connect a database to a small Python program safely.
Every lab uses a realistic fictional supermarket chain, runs on free tools (SQLite and MySQL Community Server) and works offline. The capstone has you design, build, populate, query, secure and back up a database for a fictional business, producing a portfolio project with a schema diagram, tested queries and a recovery runbook.
Prepares you for roles such as Junior Database Administrator, SQL or Data Analyst, Reporting and BI Assistant, Back-End Developer (junior), Data Support Analyst and QA tester for data-heavy systems, and supports further study toward vendor database and cloud data certifications (exams are separate and paid). Completing the course does not guarantee a job.