DBMS Basics

Computers · DBMS मूल बातें · 15 facts

DBMS stands for Database Management System

SQL is language used to manage relational databases

MySQL, Oracle, PostgreSQL are popular RDBMS

Primary Key uniquely identifies each record in a table

Foreign Key links two tables together

Normalization reduces data redundancy in databases

SELECT, INSERT, UPDATE, DELETE are basic SQL commands

Table is collection of related data in rows and columns

NoSQL databases handle unstructured data (MongoDB)

ACID properties ensure database transaction reliability

ER diagram shows relationships between database entities

Cloud databases store data on remote servers

DDL (Data Definition Language) creates and modifies database structure

DML (Data Manipulation Language) inserts, updates, deletes data

Index speeds up data retrieval in large database tables