filmov
tv
Mastering DBMS Series: Class 18 - Normalization, MySQL Internals, CAP Theorem, and NoSQL Overview
Показать описание
🔴 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. 0:00 - Introduction and Recap
2. 3:59 - Third Normal Form
3. 8:25 - Introduction to BCNF
4. 11:10 - Advantages of Normalization
5. 12:05 - Disadvantages of Normalization
6. 13:23 - Top-Down Database Design vs Bottom-Up Database Design
7. 14:14 - How SQL Database internally works
8. 20:59 - How do we optimize SELECT queries.
9. 30:09 - Using EXPLAIN statement to analyze query performance
10. 31:49 - Horizontal scaling vs Vertical scaling
11. 48:01 - Sharding
12. 51:44 - Consistency and Availability
13. 55:52 - Conclusion
14. 1:02:43 - Introduction to NoSQL Databases
15. 1:11:54 - Characteristics of NoSQL Databases
16. 1:13:46 - Types of NoSQL Databases
17. 1:14:15 - Use Cases for NoSQL Databases
18. 1:15:28 - Advantages of NoSQL Databases
19. 1:15:38 - Disadvantage of NoSQL Databases
20. 1:16:38 - Examples of NoSQL Databases
21. 1:17:55 - Differences between SQL and NoSQL
22. 1:18:52 - Examples of unstructured and semi-structured
23. 1:23:18 - What is CAP theorem.
24. 1:32:51 - The Three components of CAP theorem
25. 1:34:04 - The CAP theorem trade offs
26. 1:36:32 - Student Questions
27. 1:37:32 - Which one is consistent among SQL and NoSQL
28. 1:37:44 - Why was CAP theorem included in NoSQL.
29. 1:38:48 - Which database is more used in industry foe Web development.
30. 1:39:42 - Do we need two learn databases like MongoDB for Interviews
31. 1:42:40 - Can we do a project using MySQL
🔴 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
🔴 Please do like, share and subscribe so that these lectures can reach wider audience ❤
🔴 Important Links:
🔴 Connect with me here:
🔴 Class Chapters:
1. 0:00 - Introduction and Recap
2. 3:59 - Third Normal Form
3. 8:25 - Introduction to BCNF
4. 11:10 - Advantages of Normalization
5. 12:05 - Disadvantages of Normalization
6. 13:23 - Top-Down Database Design vs Bottom-Up Database Design
7. 14:14 - How SQL Database internally works
8. 20:59 - How do we optimize SELECT queries.
9. 30:09 - Using EXPLAIN statement to analyze query performance
10. 31:49 - Horizontal scaling vs Vertical scaling
11. 48:01 - Sharding
12. 51:44 - Consistency and Availability
13. 55:52 - Conclusion
14. 1:02:43 - Introduction to NoSQL Databases
15. 1:11:54 - Characteristics of NoSQL Databases
16. 1:13:46 - Types of NoSQL Databases
17. 1:14:15 - Use Cases for NoSQL Databases
18. 1:15:28 - Advantages of NoSQL Databases
19. 1:15:38 - Disadvantage of NoSQL Databases
20. 1:16:38 - Examples of NoSQL Databases
21. 1:17:55 - Differences between SQL and NoSQL
22. 1:18:52 - Examples of unstructured and semi-structured
23. 1:23:18 - What is CAP theorem.
24. 1:32:51 - The Three components of CAP theorem
25. 1:34:04 - The CAP theorem trade offs
26. 1:36:32 - Student Questions
27. 1:37:32 - Which one is consistent among SQL and NoSQL
28. 1:37:44 - Why was CAP theorem included in NoSQL.
29. 1:38:48 - Which database is more used in industry foe Web development.
30. 1:39:42 - Do we need two learn databases like MongoDB for Interviews
31. 1:42:40 - Can we do a project using MySQL
🔴 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
1:45:07
Mastering DBMS Series: Class 18 - Normalization, MySQL Internals, CAP Theorem, and NoSQL Overview
1:39:30
Mastering DBMS Series: Class 11 - Practical Examples of Loops, Stored Procedures, and More
1:26:35
Mastering DBMS Series: Class 4 - Functions, INSERT, UPDATE, DELETE, and CREATE SQL Commands
1:52:41
Mastering DBMS Series: Class 16 - Isolation Levels, MySQL Locks, and Effective Data Modeling
1:31:06
Mastering DBMS Series: Class 17 - ER Diagrams and Database Normalization Explained
1:30:33
Mastering DBMS Series: Class 12 - Mastering Views and Trigger Concepts
1:22:00
Mastering DBMS Series: Class 8 - Access Control: Privilege Levels, GRANT/REVOKE, and Subqueries
1:25:46
Mastering DBMS Series: Class 1 - Introduction to SQL, DDL, DML, and TCL
0:00:16
Best Programming Languages #programming #coding #javascript
1:27:40
Mastering DBMS Series: Class 3 - Exploring SQL Operators, Limits, Offset, and Pagination
1:22:08
Mastering DBMS Series: Class 9 - Control Flow Functions: IF, CASE, Stored Functions, and More
21:46:09
Database Engineering Complete Course | DBMS Complete Course
1:27:04
Mastering DBMS Series: Class 7 - Exploring Various Joins with Practical Examples
1:47:31
Mastering DBMS Series: Class 10 - Stored Functions, Loops, and Conditional Statements in MySQL
1:44:53
Mastering DBMS Series: Class 15 - Transactions, ACID Properties, and Error Handling Demystified
1:55:56
Mastering DBMS Series: Class 13 - Events, Index, Cursor, and Real-Life Twitter DB Design Example
3:10:19
SQL Tutorial for Beginners [Full Course]
0:00:34
How much does B.TECH pay?
1:47:19
Mastering DBMS Series: Class 14 - Design Examples: Twitter, Swiggy, YouTube Case Studies
0:06:15
Advanced SQL Tutorial | Stored Procedures + Use Cases
1:27:07
Mastering DBMS Series: Class 5 - CREATE, ALTER, RENAME, DROP, TRUNCATE, Constraints, and Keys
1:29:26
Mastering DBMS Series: Class 2 - Understanding SELECT, WHERE, ORDER BY, and SQL Operators
1:18:02
Mastering DBMS Series: Class 6 - Foreign Keys, Composite Keys, Joins, DELETE vs TRUNCATE vs DROP
0:01:01
Free MERN premium roadmap.....#coding #programming #mern #roadmap #javascript
Комментарии