Scribd
Upload
3 views2 pages

Understanding DBMS and SQL Concepts

A Database Management System (DBMS) is software that facilitates the creation, management, and manipulation of databases, offering advantages like data redundancy control and security. There are various types of DBMS, including hierarchical, network, relational, and object-oriented, with MS SQL Server being a notable relational database. SQL, the language used to interact with databases, includes several sub-languages for different operations such as DDL, DML, DCL, TCL, and DQL.

Uploaded by

ninaddongre1516
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views2 pages

Understanding DBMS and SQL Concepts

A Database Management System (DBMS) is software that facilitates the creation, management, and manipulation of databases, offering advantages like data redundancy control and security. There are various types of DBMS, including hierarchical, network, relational, and object-oriented, with MS SQL Server being a notable relational database. SQL, the language used to interact with databases, includes several sub-languages for different operations such as DDL, DML, DCL, TCL, and DQL.

Uploaded by

ninaddongre1516
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DBMS Concepts

What is DBMS?
A Database Management System (DBMS) is software for creating, managing, and manipulating
databases. It allows users to store, modify, and retrieve data efficiently.

Advantages of DBMS:
- Data redundancy control
- Data integrity and security
- Data sharing
- Data consistency
- Backup and recovery

Types of DBMS:
- Hierarchical
- Network
- Relational (RDBMS)
- Object-oriented

MS SQL Server is an RDBMS developed by Microsoft.

SQL (Structured Query Language)


SQL is used to communicate with databases and perform various tasks.

SQL Sub-languages:
1. DDL (Data Definition Language)
- CREATE
- ALTER
- DROP
- TRUNCATE
- RENAME
2. DML (Data Manipulation Language)
- SELECT
- INSERT
- UPDATE
- DELETE

3. DCL (Data Control Language)


- GRANT
- REVOKE

4. TCL (Transaction Control Language)


- COMMIT
- ROLLBACK
- SAVEPOINT

5. DQL (Data Query Language)


- SELECT

... [Truncated for brevity; would continue with the rest of the content from the study material]

You might also like