Module 1 — Database ideas · Database Fundamentals
Database Fundamentals
Programming · Explain → Code → Try → Output → Practice → Quiz
What you will learn
- Organised stored data
- Classroom tables are fake practice
- Not production Dukaan / vendors / users
What will you learn?
A shop that keeps marks and prices only in memory forgets them when the program ends.
The core idea
A database is organised stored data plus rules about who may change it; a relational database stores tables that connect by matching values. This Sharda course uses a tiny classroom SQL engine with fake students and products tables — not live Dukaan, not vendors, not users. This LMS has no video, and completing the course does not make you a DBA.
Key points
- Organised stored data
- Classroom tables are fake practice
- Not production Dukaan / vendors / users
Example
A notebook of student names is a paper database. SQL is a language for asking a computer the same kind of question.
sql
-- classroom idea only
-- tables: students, products
Try this
- Name two things this classroom database is not.
Practice
Name two things this classroom database is not.
Question 1
The Sharda classroom SQL engine talks to…
Summary
Isolation is intentional. No video in this LMS.
Summary
Isolation is intentional. No video in this LMS.