DBMS Crash Course | Database Management Systems Concepts Explained Simple - 2025 | Tamil
Checkout GFG Premium here : https://gfgcdn.com/tu/S2l/
1. DBMS (Database Management System)
DBMS: Software for efficient data storage, retrieval, and management (e.g., MySQL, PostgreSQL).
ACID:
Atomicity: Transaction must be all or nothing.
Consistency: Valid state transitions only.
Isolation: Independent transaction processing.
Durability: Permanent transaction effects.
2. Normalization
Primary Key: Unique identifier for records.
Foreign Key: Links two tables based on a relationship.
Candidate Key: Potential primary key.
1NF (First Normal Form): Eliminate duplicate columns, ensure atomicity.
2NF (Second Normal Form): Remove partial dependencies (non-key attributes depend on full primary key).
3NF (Third Normal Form): Remove transitive dependencies (non-key attributes depend only on the primary key).
3. Denormalization
Denormalization: Merging tables for read optimization at the cost of write complexity.
4. Types of Databases
Relational (RDBMS): Data stored in tables, SQL used (e.g., MySQL).
NoSQL: For unstructured data (e.g., MongoDB).
5. SQL Queries
SELECT: Retrieve data.
INSERT: Add records.
UPDATE: Modify data.
DELETE: Remove records.
JOINS:
INNER JOIN: Return matching records.
LEFT JOIN: Return all left table records and matched right table records.
RIGHT JOIN: Return all right table records and matched left table records.
FULL JOIN: Return all records from both tables.
GROUP BY: Aggregate data by columns.
HAVING: Apply conditions to groups.
Aggregate Functions: COUNT(), SUM(), AVG(), MIN(), MAX().
00:00 Intro
00:49 What is DBMS?
01:52 What is Database?
02:35 Acid properties
06:20 Geeks for Geeks course
09:55 Normalisation
13:35 1NF
14:05 2NF
15:52 3NF
17:22 Denormalization
18:25 Types of Database
19:44 Sql Queries
30:50 Transaction and concurrency control
32:10 Table level
32:28 Row level
33:12 Page level
34:13 Optimistic locking and Pessimistic locking
36:05 Deadlock
37:17 Indexing
40:00 Advantages and Disadvantages
41:05 DBMS keys recap
42:40 Stored procedure
42:55 Trigger
43:30 View
44:05 Usecases to know
45:20 Cap theorem
49:20 Conclusion
-------------------------------------------------------------------------------------------------------------------------------------------------------
Whatsapp Channel: https://whatsapp.com/channel/0029VaYI...
Join Membership: / @hareeshrajendran
📢📢📢📢 Social Media Links 📢📢📢📢
Buy me a coffee ☕️ : https://www.buymeacoffee.com/hareeshr...
LinkedIn: / hareesh-r
Instagram: / hareesh_._r
Facebook: / hareeshprogrammer
Twitter: / hareesh_dev
GitHub: https://github.com/hareesh-r
Curious to know more about me?: https://hareesh.web.app🚀
Your support means the world to me! 🙌 Let's build an awesome community together. 🌍✨
