Databases (DBMS) for GATE — Complete Playlist

Watch and track your favorite playlist.

Curated by: GATE CSE LECTURES BY AMIT KHURANA (225 videos)

---

Tracks in this Playlist

• DBMS REVISION IN 15 MIN | HOW TO REVISE SUBJECTS EFFICIENTLY?? | GATE
• DBMS Syllabus for GATE | GATE 2023
• How to prepare DBMS from my playlist efficiently for gate 2023 | How to get full marks in DBMS
• 1. DBMS introduction part 1
• 2. DBMS intro part 2
• 3. DBMS intro part 3
• 4. ER model introduction
• 5. Attributes in ER model
• 6. introduction to keys
• 7. types of keys
• 8. relationships introduction
• 9. Maximum cardinality
• 10. minimum cardinality
• 11. relationship between strong and weak entity type
• 12. existance dependencies
• 13. Generalization and specialization
• 14. 3 questions on genralization and specialization
• 15. constraints on generalization and specialization
• 16. Aggregation
• 17. Relational model introduction
• 18. concept of keys in relational model
• 19. Integrity constraints in relational model
• 20. converting ER model to tables(Entity type and attributes)
• 21. transforming binary relationships (one to many or many to one)to tables
• 22. converting binary relationships (one to one) to tables
• 23. transforming binary relationships (many to many)to tables
• 24. summary of transforming binary relationships to tables
• 25. question on conversion of binary relationships to tables
• 26. question on er model to tables
• 27. GATE 2004,2005,2008 QUESTION ON CONVERTING ER MODEL TO TABLES
• 28. GATE 2015 AND 2018 QUESTION ON CONVERTING ER MODEL TO TABLES
• 29. transforming unary relationships into tables
• 30. converting generalization or specialization into tables
• 31. converting aggregation into tables
• 32. relational algebra intro
• 33. selection operator in relational algebra
• 34. projection operator in relational algebra
• 35. union operator in relational algebra
• 36. set difference operator in relational algebra
• 37. cartesian product operator in relational algebra
• 38. queries using cartesian product
• 39. query explaining renaming operator
• 40. more queries explaining renaming operator
• 41. optimizing queries using renaming operator
• 42. how to find largest and smallest in relational algebra
• 43. important queries on cartesian product
• 44. how to find greater than least and lesser than greatest
• 45. intersection operator in relational algebra
• 46. types of joins in relational algebra
• 47. natural join in relational algebra
• 48. queries on natural join
• 49. Semi and anti join in relational algebra
• 49.1 outer join in relational algebra
• 50. Division operator in relational algebra
• 51. queries on division operator
• 52. null in relational algebra
• 53. modification of database in relational algebra
• 55. gate 1999 question on relational algebra
• 54. gate 1998 question on relational algebra
• 57. gate 2004 question on relational algebra
• 56. gate 2007 question on relational algebra
• 58. gate 2004 question 2 on relational algebra
• 59. gate 2007 question 2 on relational algebra
• 60. gate 2007 question on relational algebra
• 62. gate 2008 question on relational algebra
• 61. gate 2014 question on relational algebra
• 63. gate 2012 question on relational algebra
• 64. gate 2017 question on relational algebra
• 65. minimum and maximum tuples in natural join
• 66. gate 2018 question on relational algebra
• 67. Introduction to tuple calculus
• 68. join in tuple calculus
• 69. Gate 2007 question on tuple calculus
• 70. Gate 2001 question on tuple calculus
• 71. Difference between for all and their exists quantifier
• 72. Gate 2009 question on tuple calculus
• 73. intro to domain relational calculus
• 74. Gate 2013 question on domain calculus
• 75. Introduction to SQL
• 76. INTRO TO SET OPERATORS UNION INTERSECTION AND MINUS
• 77. IN SOME ALL set operation in SQL
• 78. finding greatest and least using ALL operator
• 79. Few queries on IN operator
• 80. CONTAINS set operation in SQL
• 81. EXISTS AND NOT EXISTS set operation in SQL
• 82. unique set operation in SQL
• 83. Gate 2003 question on SQL
• 84. Gate 2006 question on SQL
• 85. gate 2007 question on SQL
• 86. gate 2011 question on SQL
• 87. Gate 2012 question on SQL
• 88. Gate 2014 question on SQL
• 89. SORTING TUPLES IN OUTPUT OF SQL QUERY
• 90. aggregate functions in SQL
• 91. GROUP BY clause in SQL
• 92. important points about GROUP BY clause
• 93. important query on GROUP BY clause
• 93.1. GATE 2015 QUESTION ON SQL
• 94. HAVING clause in SQL
• 94.1. having clause part 2