Lesson 1
What is DBMS?
A comprehensive introduction to Database Management Systems and their role in modern applications.
Lesson content
What is DBMS?
A Database Management System (DBMS) is software that allows users to create, update, retrieve, and manage data efficiently. It provides a structured way to store and organize data.
Advantages of DBMS
- Data consistency and integrity
- Efficient data retrieval
- Data security
- Concurrent access control
- Backup and recovery mechanisms
- Reduced data redundancy
- Easy maintenance
Types of DBMS
- Relational DBMS (RDBMS): SQL, MySQL, PostgreSQL, Oracle
- NoSQL DBMS: MongoDB, Cassandra, Redis
- Graph DBMS: Neo4j
- Document DBMS: CouchDB
- Time-Series DBMS: InfluxDB
SQL example
Practical SQL code
-- Basic SQL SELECT query
SELECT * FROM students WHERE age > 18;
-- Create a table
CREATE TABLE users (
id INT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100)
);
-- Insert data
INSERT INTO users (id, name, email)
VALUES (1, 'Alice', 'alice@example.com');