TheHingineer

  • DBMS


  • DBMS Part-1

  • DBMS Part-2

  • DBMS Part-3

  • DBMS Part-4

  • DBMS Part-5

  •  Introduction to SQL 

     SQL kya hai?

    SQL (Structured Query Language) ek standard language hai jo aapko database se baat karne mein help karti hai. Iska use hum database ke andar:

    • Data insert karne 

    • Data retrieve (nikalne) 

    • Data update (badalne) 

    • Data delete (hatane) 

    mein karte hain.

    Simple shabdon mein: SQL ek language hai jo database se kaam karne ke liye use hoti hai.


     SQL ka use kyun hota hai?

    Har company, college ya organization ke paas bahut saari data hoti hai — jaise student records, employee data, etc.
    In data ko manage karne ke liye SQL ka use hota hai.

    SQL se hum:

    • Naya data dalte hain (INSERT)

    • Purana data dekhte hain (SELECT)

    • Data update karte hain (UPDATE)

    • Data delete karte hain (DELETE)

     Basic SQL Commands

    Maan lo humare paas ek Student naam ka table hai:

    StudentID Name Age
    101 Riya 20
    102 Aman 21

    1. SELECT – Data dekhne ke liye

    SELECT * FROM Student;

     Output: Saare students ka data show karega.

    2. INSERT – Naya student add karne ke liye

    INSERT INTO Student (StudentID, Name, Age)
    VALUES (103, 'Nisha', 22);

    3. UPDATE – Kisi ka age change karne ke liye

    UPDATE Student
    SET Age = 23
    WHERE StudentID = 103;

    4. DELETE – Data delete karne ke liye

    DELETE FROM Student
    WHERE StudentID = 103;

     SQL Commands ke Types

    SQL commands 5 categories mein divide hoti hain:

    Type Full Form Kaam kya hai Examples
    DDL Data Definition Language Table banata ya modify karta hai CREATE, ALTER, DROP
    DML Data Manipulation Language Table ke data ke saath kaam karta hai SELECT, INSERT, UPDATE, DELETE
    DCL Data Control Language Access dena ya lena GRANT, REVOKE
    TCL Transaction Control Language Transactions handle karta hai COMMIT, ROLLBACK
    DQL Data Query Language Sirf data ko query karna SELECT

     DDL ka Example:

    CREATE TABLE Student (
    StudentID INT,
    Name VARCHAR(50),
    Age INT
    );

     Ye command ek naya table banata hai jiska naam Student hai.

     SQL ke Benefits (Fayde)

    1. Asaan – Syntax simple hota hai.

    2. Standard Language – Har RDBMS (MySQL, Oracle) mein use hota hai.

    3. Powerful – Badi databases ko easily handle karta hai.

    4. Flexible – Alag-alag types ke data ke saath kaam karta hai.

    5. Secure – Access control aur permission de sakta hai.

     Real-Life Example:

    Aapke college mein ek database hai jisme students ka data store hai.

    • 18 se upar ke students dekhne ke liye:

    SELECT Name FROM Student WHERE Age > 18;
    • Naya student add karne ke liye:

    INSERT INTO Student VALUES (105, 'Ankit', 19);
    • Graduate ho chuke students delete karne ke liye:

    DELETE FROM Student WHERE Age > 22;


     Summary Table

    Feature Explanation
    SQL Database se baat karne wali language
    Basic Commands SELECT, INSERT, UPDATE, DELETE
    Command Types DDL, DML, DCL, TCL, DQL
    Use Data store, update, delete aur query karne ke liye
    Benefits Easy, fast, secure, standard
    Scroll to Top