AdvancedWeb DevelopmentLive Data
W4: Database Fundamentals
Master database fundamentals through hands-on project development. Build 5 real-world database applications while learning SQL, schema design, normali...
AdvancedWeb DevelopmentLive Data
W4: Database Fundamentals
Master database fundamentals through hands-on project development. Build 5 real-world database applications while learning SQL, schema design, normali...
Lessons
13
Activities
13
Projects
5
Duration
24 sessions • 6 months
About This Course
Master database fundamentals through hands-on project development. Build 5 real-world database applications while learning SQL, schema design, normalization, transactions, and security. From library systems to e-commerce platforms, develop production-ready database skills through practical implement
Prerequisites
- Computer with internet connection
- Code editor (VS Code recommended)
- SQLite Browser (free download, installation covered in Lesson 1)
- Basic programming knowledge helpful but not required
- 3-4 hours per lesson commitment
Skills You'll Learn
SQL
This course consists of 24 structured sessions over 6 months. Each session includes lessons, activities, projects, and assessments to ensure comprehensive learning.
1
Database Fundamentals Part 1
Lesson MaterialsActivity
2
Database Fundamentals Part 2
Lesson MaterialsActivity
3
Introduction to SQL Part 1
Lesson MaterialsActivity
4
Introduction to SQL Part 2
Lesson MaterialsActivity
5
Querying with SELECT
Lesson MaterialsActivity
6
Relationships & JOINs Part 1
Lesson MaterialsActivity
7
Relationships & JOINs Part 2
Lesson MaterialsActivity
8
Aggregations & Grouping
Lesson MaterialsActivity
9
Subqueries & CTEs
Lesson MaterialsActivity
10
Data Integrity & Constraints
Lesson MaterialsActivity
11
Performance & Indexing
Lesson MaterialsActivity
12
Schema Design & Modeling
Lesson MaterialsActivity
13
Advanced Schema Design
Lesson MaterialsActivity
14
Transactions & Security
Lesson MaterialsActivity
15
Project 1: Book Lending System (Part 1)
Activity
16
Project 1: Book Lending System (Part 2)
Activity
17
Project 2: Study Group Organizer (Part 1)
Activity
18
Project 2: Study Group Organizer (Part 2)
Activity
19
Project 3: Personal Health Tracker (Part 1)
Activity
20
Project 3: Personal Health Tracker (Part 2)
Activity
21
Project 4: Online Store Architecture (Part 1)
Activity
22
Project 4: Online Store Architecture (Part 2)
Activity
23
Project 5: Database-Powered Innovation (Part 1)
Activity
24
Project 5: Database-Powered Innovation (Part 2)
Activity
Course Information
Course CodeW4
Age Group13 years old and above
Class SizeMax 8 students
Teacher Ratio1:8
Learning ModeHYBRID
Last Updated4/12/2026
Data SourceGitHub
Key Benefits
SQL
Master SQL through practical application
Learning Outcomes
Practical Skills
Build real-world applications and projects
Problem Solving
Develop computational thinking and problem-solving abilities
Ready to Start?
Join this course and start your learning journey today.