Types of database languages in hindi – DBMS

Database languages ke alag-alag prakar hote hain, jo database management systems (DBMS) ke saath interact karne aur data ko manipulate karne ke liye istemal kiye jaate hain. Yahan main kuch pramukh database languages ko samjha deta hoon:

DBMS के ये Topics के बारे में जानें :-

Types of database languages in hindi

  1. Data Definition Language (DDL): DDL database schema ko define aur modify karne ke liye istemal hoti hai. Ismein shamil hote hain:
    • CREATE: CREATE statement database mein naye tables, views, aur indexes ko create karne ke liye istemal hota hai.
    • ALTER: ALTER statement existing database schema ko modify karne ke liye istemal hota hai, jaise ki table structure, column, aur constraints ko badalne ke liye.
    • DROP: DROP statement existing database objects, jaise ki tables, views, indexes, ko delete karne ke liye istemal hota hai.

Types of database languages in hindi
Types of database languages in hindi
  1. Data Manipulation Language (DML): DML database mein data ko insert, update, retrieve, aur delete karne ke liye istemal hoti hai. Yeh kuch important DML commands hote hain:
    • INSERT: INSERT statement naye data ko database mein insert karne ke liye istemal hota hai.
    • SELECT: SELECT statement database se data retrieve karne ke liye istemal hota hai. Query ke through specific columns aur rows ko select kiya ja sakta hai.
    • UPDATE: UPDATE statement database mein existing data ko modify karne ke liye istemal hota hai.
    • DELETE: DELETE statement database se data ko delete karne ke liye istemal hota hai.

  2. Data Control Language (DCL): DCL database ke security aur access control ko manage karne ke liye istemal hoti hai. Yeh kuch pramukh DCL commands hote hain:
    • GRANT: GRANT statement users aur roles ko specific privileges aur permissions dene ke liye istemal hota hai.
    • REVOKE: REVOKE statement users aur roles se privileges aur permissions ko wapas lene ke liye istemal hota hai.

  3. Data Query Language (DQL): DQL database se data retrieve karne ke liye istemal hoti hai. Pramukh DQL language hai:
    • SQL (Structured Query Language): SQL relational databases ke liye standard DQL language hai. Iska upyog data retrieval, filtering, sorting, aggregation, aur joins jaise operations ke liye hota hai.

Iske alawa, kai aur specialized database languages hote hain jo specific database systems ya specific use cases ke liye banaye jaate hain, jaise ki MongoDB ke liye MongoDB Query Language (MQL) aur PostgreSQL ke liye PL/pgSQL.

Database languages ki madad se users database ke saath interact kar sakte hain, data ko manipulate kar sakte hain aur data retrieval ke liye queries likh sakte hain. Yeh languages DBMS ke capabilities ko access karne aur data management ko sambhalne mein madad karte hain.

Leave a Comment