Mastering DBMS Series: Class 13 - Events, Index, Cursor, and Real-Life Twitter DB Design Example

🔴 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:
🔗 Access all the questions and presentations here: github.com/urguru/Mastering-DBMS-Series/tree/main
🔗 Practice basic SQL queries here: www.sql-practice.com/

🔴 Connect with me here:
Twitter: twitter.com/urguru_4648
Instagram: www.instagram.com/urguru_4648/
LinkedIn: www.linkedin.com/in/urguru/
GitHub: www.github.com/urguru

🔴 Class Chapters:
1. 00:00 - Introduction
2. 00:15 - Advantages of using triggers
3. 03:35 - Disadvantages of using triggers
4. 05:15 - Limitations of triggers
5. 06:31 - OLD and NEW columns available for trigger events
6. 07:03 - MySQL Events
7. 13:20 - Events examples
8. 47:09 - What are Indexes and why we need them
9. 57:23 - Need for Indexing in MySQL
10. 57:40 - Create Index examples
11. 58:51 - Show Indexes command
12. 59:53 - Drop Index
13. 59:58 - Algorithm to use while deleting an index
14. 1:01:45 - Lock options during drop index
15. 1:03:08 - Clustered vs non clustered Index
16. 1:03:56 - When should indexes be avoided ?
17. 1:04:46 - How indexes are actually implemented ?
18. 1:10:49 - MySQL Cursor
19. 1:12:45 - How to use a cursor
20. 1:13:13 - Cursor statement examples
21. 1:20:37 - STUDENT - What is the difference between Triggers and Events
22. 1:24:20 - Twitter MySQL DB Example

🔴 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

🔴 [Playlist]Mastering DBMS Series: From Basics to Advanced -    • Mastering DBMS: From Basics to Advanced  
Class 1 - Introduction to SQL, DDL, DML, and TCL -    • Mastering DBMS Series: Class 1 - Introduct...  
Class 2 - Understanding SELECT, WHERE, ORDER BY, and SQL Operators -    • Mastering DBMS Series: Class 2 - Understan...  
Class 3 - Exploring SQL Operators, Limits, Offset, and Pagination -    • Mastering DBMS Series: Class 3 - Exploring...  
Class 4 - Functions, INSERT, UPDATE, DELETE, and CREATE SQL Commands -    • Mastering DBMS Series: Class 4 - Functions...  
Class 5 - CREATE, ALTER, RENAME, DROP, TRUNCATE, Constraints, and Keys -    • Mastering DBMS Series: Class 5 - CREATE, A...  
Class 6 - Foreign Keys, Composite Keys, Joins, DELETE vs TRUNCATE vs DROP -    • Mastering DBMS Series: Class 6 - Foreign K...  
Class 7 - Exploring Various Joins with Practical Examples -    • Mastering DBMS Series: Class 7 - Exploring...  
Class 8 - Access Control: Privilege Levels, GRANT/REVOKE, and Subqueries -    • Mastering DBMS Series: Class 8 - Access Co...  
Class 9 - Control Flow Functions: IF, CASE, Stored Functions, and More -    • Mastering DBMS Series: Class 9 - Control F...  
Class 10 - Stored Functions, Loops, and Conditional Statements in MySQL -    • Mastering DBMS Series: Class 10 - Stored F...  
Class 11 - Practical Examples of Loops, Stored Procedures, and More -    • Mastering DBMS Series: Class 11 - Practica...  
Class 12 - Mastering Views and Trigger Concepts -    • Mastering DBMS Series: Class 12 - Masterin...  
Class 13 - Events, Index, Cursor, and Real-Life Twitter DB Design Example -    • Mastering DBMS Series: Class 13 - Events, ...…
Class 14 - Design Examples: Twitter, Swiggy, YouTube Case Studies -    • Mastering DBMS Series: Class 14 - Design E...  
Class 15 - Transactions, ACID Properties, and Error Handling Demystified -    • Mastering DBMS Series: Class 15 - Transact...  
Class 16 - Isolation Levels, MySQL Locks, and Effective Data Modeling -    • Mastering DBMS Series: Class 16 - Isolatio...  
Class 17 - ER Diagrams and Database Normalization Explained -    • Mastering DBMS Series: Class 17 - ER Diagr...  
Class 18 - Normalization, MySQL Internals, CAP Theorem, and NoSQL Overview -    • Mastering DBMS Series: Class 18 - Normaliz...