🗄 Database

📖 What is a Database?

Database என்பது தகவல்களை (Data) சேமித்து, நிர்வகித்து, தேவைப்படும் போது மீட்டெடுக்க உதவும் அமைப்பு ஆகும்.

🎯 Why Database?

✔ Store Large Amount of Data

✔ Fast Retrieval

✔ Data Security

✔ Data Consistency

✔ Multi User Access

🗄 Popular Databases

✔ MySQL

✔ PostgreSQL

✔ Oracle Database

✔ Microsoft SQL Server

✔ MongoDB

✔ SQLite

📊 Database Components

✔ Tables

✔ Rows

✔ Columns

✔ Records

✔ Keys

🔑 Primary Key

Primary Key என்பது ஒரு Table-ல் ஒவ்வொரு Record-ஐ தனித்தனியாக அடையாளம் காண பயன்படும் Unique Value ஆகும்.

📝 Create Table Example

CREATE TABLE students (

id INT,

name VARCHAR(50),

course VARCHAR(50)

);

➕ Insert Data

INSERT INTO students
VALUES (1,'Raj','Networking');

🔍 Select Data

SELECT * FROM students;

✏ Update Data

UPDATE students

SET course='Linux'

WHERE id=1;

❌ Delete Data

DELETE FROM students

WHERE id=1;

🌍 Real World Usage

✔ Banking Systems

✔ Railway Reservation

✔ E-Commerce Websites

✔ Hospital Management

✔ Telecom Billing Systems

✔ Government Portals

✔ Learning Platforms

🎤 Interview Questions

What is a Database?

What is DBMS?

What is Primary Key?

Difference Between SQL and NoSQL?

What is a Table?

What is a Record?

What is Normalization?

What is MySQL?

What is MongoDB?

What is SQL?

📝 Summary

Database என்பது அனைத்து நவீன Applications மற்றும் Websites-ன் அடிப்படை கூறுகளில் ஒன்றாகும்.

Data Storage, Security மற்றும் Retrieval ஆகியவற்றை Database திறமையாக நிர்வகிக்கிறது.

🎉 Programming Hub Completed

Congratulations! You have successfully completed the Programming Learning Hub.

You are now ready to start the AI & Automation Learning Path.