Mastering DBMS Series: Class 12 - Mastering Views and Trigger Concepts

🔴 Watch at 1.25x to save time and at 1.5x when you are revising
🔴 Please do like, share and subscribe so that these lectures can reach wider audience ❤

🔴 Important Links:

🔴 Connect with me here:

🔴 Class Chapters:
1. 00:00 - Introduction
2. 00:44 - Views
3. 05:17 - Different examples of Views
4. 19:26 - Create Table vs Create View
5. 20:14 - Inserting an item into a table impacts the corresponding view
6. 22:05 - Inserting and deleting a row into a view
7. 29:02- Updating a View
8. 29:36 - WITH CHECK OPTION for Views
9. 34:18 - Dropping a View
10. 34:45 - Uses of Views
11. 35:24 - Triggers
12. 35:32 - What are triggers and why we need them
13. 44:26 - Definition of trigger
14. 45:23 - Syntax for CREATE Trigger
15. 47:10 - Examples of Triggers
16. 1:29:07 - OLD and NEW values in Trigger
17. 1:30:20 - Conclusion

🔴 Why am I doing this course ?
As a course instructor at Atharvo - an edtech company, I instructed 100 students but faced payment issues. Making class videos public for students' access. Atharvo is fake, neglectful, and unethical company — avoid their courses. They fool students in the name of giving placement to everyone by charging 1000 rupees. Please report if you see this company running ads on social media