š Database Theory ā Deep Dive
Understand relational databases, entities, relationships,
keys, constraints, integrity and modelling.
When ready, continue with SQL or Microsoft Access .
š
Theory 1: What Is a Database?
What databases are, why they exist, and how they store information.
Begin
š§©
Theory 2: ERDs & Relationships
Understand entities, attributes, cardinality and mapping rules.
Begin
š
Theory 3: Normalisation
1NF, 2NF, 3NF and designing clean, efficient database structures.
Begin
š§® SQL Databases
Build and query relational databases using SQL ā the universal language of data.
š§ SQL Fundamentals
š
Lesson 1: Introduction to Databases
Learn what databases are and create your first SQL table.
Not Started
Begin
š
Lesson 2: Data Types & Structure
Understand SQL data types and best-practice field design.
Not Started
Begin
š
Lesson 3: Inserting & Modifying Data
INSERT, UPDATE and DELETE operations.
Not Started
Begin
š
Lesson 4: Retrieving Data (SELECT)
Use SELECT, WHERE and ORDER BY to filter data.
Not Started
Begin
š
Lesson 5: Filtering & Sorting
Advanced filtering, conditions and ordering.
Not Started
Begin
āļø
Lesson 6: Operators & Conditions
AND/OR logic, comparisons and conditional queries.
Not Started
Begin
š Advanced SQL
š§±
Lesson 7: Aggregation & Grouping
SUM, AVG, COUNT & GROUP BY for real analysis.
Not Started
Begin
š
Lesson 8: Joining Tables
Master INNER, LEFT and multi-table joins.
Not Started
Begin
š
Lesson 9: Validation & Integrity
Constraints, rules and data-quality control.
Not Started
Begin
š Coming Soon: Subqueries & Advanced Logic
Learn nested SELECTs, views, advanced reporting and stored logic.
š£ Microsoft Access
Build full database systems visually using forms, queries and reports.
šŖ
Lesson 1: Introduction to Access
Learn the Access interface and how databases work visually.
Begin
š§±
Lesson 2: Table Creation
Build structured tables using data-types and design view.
Begin
š
Lesson 3: Keys & Relationships
Create relationships and enforce referential integrity.
Begin
š
Lesson 4: Forms
Build user-friendly input screens for entering data.
Begin
š
Lesson 5: Queries
Filter, sort and search data using Access Query Builder.
Begin
š
Lesson 6: Reports
Generate printable output for business-ready reporting.
Begin
āļø
Lesson 7: Validation Rules
Use input masks & validation to prevent errors.
Begin
š
Lesson 8: Advanced Queries
Calculated fields, parameters and multi-table queries.
Begin
š§®
Lesson 9: Aggregate Queries
Totals, averages, grouping and roll-ups.
Begin
š
Lesson 10: Full Project
Build a complete functional Access database.
Begin