Aliens School
Cinematic Knowledge Experience
0%
Aliens School
Now Playing
Aliens School · HIEN
⌨️ Keyboard Shortcuts
→Next slide ←Previous slide SpacePlay / Pause MNarration on/off FFullscreen ?Show/hide this
Press any key to close
Skill Topic · Cinematic

📊 Topic 02: Database & Tables — Data Ka Ghar Banao!

"A well-designed table is the foundation of a great database." — Unknown "Database = building,…

Topic 1
📥 📥 🧠 🔬 💡 🎯

1. Database Banana — CREATE DATABASE

📊 Database = ek container jisme tables, views, procedures sab store hote hain. Syntax: `sql…
Topic 2
💾 📊 🔬

2. Database Use Karna

💾 Database bana liya, ab use karna padega: `sql -- School database ko active karo USE…
Topic 3
🔒

3. Database Delete — DROP DATABASE

🗄️ `sql -- ⚠️ DANGER! Pura database mit jaayega! DROP DATABASE school; -- Safe version DROP…
Topic 4
📈

4. Table Banana — CREATE TABLE

📈 Basic Syntax: `sql CREATE TABLE table_name ( column1 datatype constraints, column2…
Topic 5
📥 📥 🧠 🔬 💡 🎯

5. SQL Data Types

🔍 Numeric Types: ` ┌─────────────────────────────────────────────────────────┐ │ NUMERIC…
Topic 6
📉 📊 🔬

6. Constraints — Rules Lagao!

📉 Constraints = rules jo data par lagti hain taaki galat data na jaa sake. All Constraints:…
Topic 7
📥 ⚙️ 🔬 💡

7. Primary Key & Auto Increment

🧮 Primary Key: `sql -- ═══════════════════════════════════════════ -- Primary Key = Har row…
Topic 8
🌐

8. Table Badalna — ALTER TABLE

🌐 Column Add Karna: `sql -- Naya column add karo ALTER TABLE students ADD phone…
Topic 9
✨

9. Table Delete — DROP & TRUNCATE

📊 DROP TABLE — Puri Table Mitao: `sql -- ⚠️ Table + structure + data = sab khatam! DROP…
Topic 10
💾 📊 🔬

10. Key Points

💾 ` ╔══════════════════════════════════════════════════════╗ ║ 📝 KEY POINTS ║…
Topic 11
🔒

📝 Practice Exercises

🗄️ Exercise 1: E-Commerce Database In tables ko banao: 1. customers table (id, name, email,…
Topic 12
📈

🧭 Navigation

📈 | Previous | Index | Next | |----------|-------|------| | ← SQL Introduction | 📚 Course…
Quick Quiz
🧠 QUIZ TIME

Quiz — Question 1

📊 Topic 02: Database & Tables — Data Ka Ghar Banao! ka sabse sahi definition kya hai?

Complete! 🎉
COMPLETE

📊 Topic 02: Database & Tables — Data Ka Ghar Banao! Complete!

Aliens School · HIEN · Cinematic Knowledge

✅

📊 Topic 02: Database & Tables — Data Ka Ghar Banao! Complete

1/15
0:00
REC 00:00ESC=Cancel
Aliens School
3
Recording shuru hone wali hai...
✅
Recording Complete
Video process ho rahi hai...
Live Class
Slide 1 / 7
Timer
00:00
📝 Speaker Notes
—
⏭️ Up Next
—
—
🗂️ All Slides