DataBase

Things Covered in DBMS

• 1. What is DBMS ? Mention advantages..
• 2. What is Database?
• 3. What is a database system?
• 6. ACID properties (VVVVV IMP)
• 12. Indexing in DBMS
• 18. E-R Model ?
• 28. Diff between 2 tier and 3 tier architecture

Things to Cover in DBMS:

4. What is RDBMS ? Properties..

5. Types of database languages

6. Difference between vertical and horizontal scaling

7. What is sharding

8. Keys in DBMS

9. Types of relationship

10. Data abstraction in DBMS, three levels of it

11. What is DDL (Data Definition Language)

12. What is DML (Data Manipulation Language)

13. What is normalization ? Types of them ..

14. What is denormalization ?

15. What is functional dependency ?

16. Conflict Serializability in DBMS ..

17. Explain Normal forms in DBMS

18. What is CCP ? (Concurrency Control Protocols)

19. Entity, Entity Type, Entity Set, Weak Entity Set..

20. What are SQL commands ? Types of them..

21. Nested Queries in SQL ?

22. What is JOIN .. Explain types of JOINs

23. Inner and Outer Join

24. Practice sql queries from leetcode

25. Diff between TRUNCATE and DELETE command ..

26. Difference between Intension and Extension in a DataBase

27. Difference between share lock and exclusive lock, definition of lock

Questions

Q) what is 'distinct' and waht is 'upper' keyword Q) difference between 'count' 'length'

Things to add

about all keys

• primary key
• Foreign key
• Unique key
• candidate key
• Alternate key
• Composite key
• Super key

Resources

• https://winand.at/
• https://use-the-index-luke.com/