Udemy - Practical Database Guide with RDBMS(MySQL) and NoSQL(MongoDB)

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Installation
• 1. Installing MySQL on Windows.mp4 (23.1 MB)
• 1. Installing MySQL on Windows.srt (4.6 KB)
• 2. Installing MySQL on macOS.mp4 (20.5 MB)
• 2. Installing MySQL on macOS.srt (3.4 KB)
• 3. SQLYog Installation.mp4 (9.2 MB)
• 3. SQLYog Installation.srt (2.0 KB)
• 4. SQLYog Walkaround & Executing Basic Queries.mp4 (36.6 MB)
• 4. SQLYog Walkaround & Executing Basic Queries.srt (7.0 KB)
10. Grouping Data
• 1. GROUP BY.mp4 (39.6 MB)
• 1. GROUP BY.srt (6.7 KB)
• 2. Aggregate functions (COUNT(), SUM(), AVG(), MIN(), MAX()).mp4 (64.8 MB)
• 2. Aggregate functions (COUNT(), SUM(), AVG(), MIN(), MAX()).srt (9.8 KB)
• 3. HAVING Clause.mp4 (23.0 MB)
• 3. HAVING Clause.srt (4.2 KB)
11. Subqueries
• 1. Subquery.mp4 (79.9 MB)
• 1. Subquery.srt (11.6 KB)
12. Set Operators
• 1. UNION.mp4 (18.3 MB)
• 1. UNION.srt (3.4 KB)
13. Practice Assignment
• 1. Practice Assignment.mp4 (75.5 MB)
• 1. Practice Assignment.srt (7.9 KB)
14. Stored Procedures
• 1. Introduction to Stored Procedure SP.mp4 (13.9 MB)
• 1. Introduction to Stored Procedure SP.srt (4.2 KB)
• 10. MySQL Transactions - COMMIT and ROLLBACK.mp4 (55.3 MB)
• 10. MySQL Transactions - COMMIT and ROLLBACK.srt (8.5 KB)
• 2. Listing Stored Procedure.mp4 (16.1 MB)
• 2. Listing Stored Procedure.srt (1.9 KB)
• 3. Creating Stored Procedure.mp4 (86.2 MB)
• 3. Creating Stored Procedure.srt (12.2 KB)
• 4. Modifying Stored Procedure.mp4 (12.1 MB)
• 4. Modifying Stored Procedure.srt (2.2 KB)
• 5. Parameters in SP.mp4 (59.4 MB)
• 5. Parameters in SP.srt (8.8 KB)
• 6. Variables in SP.mp4 (15.8 MB)
• 6. Variables in SP.srt (3.3 KB)
• 7. IF-ELSE Statement in SP.mp4 (18.9 MB)
• 7. IF-ELSE Statement in SP.srt (3.3 KB)
• 8. Stored Function.mp4 (21.7 MB)
• 8. Stored Function.srt (4.0 KB)
• 9. MySQL Indexing.mp4 (47.1 MB)
• 9. MySQL Indexing.srt (7.5 KB)
15. MongoDB
• 1. Installing MongoDB on Windows.mp4 (33.8 MB)
• 1. Installing MongoDB on Windows.srt (4.7 KB)
• 10. Querying Document With Comparison Operators.mp4 (33.0 MB)
• 10. Querying Document With Comparison Operators.srt (6.3 KB)
• 11. Querying document Using IN & NOT IN.mp4 (11.5 MB)
• 11. Querying document Using IN & NOT IN.srt (2.9 KB)
• 12. Querying documents - Logical Operators ($and & $or).mp4 (32.1 MB)
• 12. Querying documents - Logical Operators ($and & $or).srt (8.1 KB)
• 13. Querying documents - Logical Operators ($nor and $not).mp4 (23.2 MB)
• 13. Querying documents - Logical Operators ($nor and $not).srt (5.3 KB)
• 14. Limiting Records.mp4 (17.6 MB)
• 14. Limiting Records.srt (3.6 KB)
• 15. Sorting Records.mp4 (14.9 MB)
• 15. Sorting Records.srt (3.4 KB)
• 16. Aggregate Command - countDocuments().mp4 (14.0 MB)
• 16. Aggregate Command - countDocuments().srt (4.2 KB)
• 17. Aggregate Command - distinct().mp4 (10.5 MB)
• 17. Aggregate Command - distinct().srt (2.8 KB)
• 18. Aggregate Command - aggregate().mp4 (28.7 MB)
• 18. Aggregate Command - aggregate().srt (6.5 KB)
• 19. Date Query.mp4 (18.6 MB)
• 19. Date Query.srt (4.3 KB)
• 2. Creating Database.mp4 (14.1 MB)
• 2. Creating Database.srt (3.7 KB)
• 20. $regex Operator.mp4 (23.0 MB)
• 20. $regex Operator.srt (5.2 KB)
• 21. MongoDB Indexes.mp4 (22.1 MB)
• 21. MongoDB Indexes.srt (5.8 KB)
• 3. Create Collection.mp4 (15.2 MB)
• 3. Create Collection.srt (6.1 KB)
• 4. MongoDB Binary JSON(BSON).mp4 (4.8 MB)
• 4. MongoDB Binary JSON(BSON).srt (1.2 KB)
• 5. Inserting Single Document.mp4 (30.9 MB)
• 5. Inserting Single Document.srt (7.9 KB)
• 6. Inserting MultipleBulk document.mp4 (10.0 MB)
• 6. Inserting MultipleBulk document.srt (3.0 KB)
• 7. Loading Sample Datasets.mp4 (19.4 MB)
• 7. Loading Sample Datasets.srt (3.2 KB)
• 8. Updating Document.mp4 (26.3 MB)
• 8. Updating Document.srt (6.3 KB)
• 9. Querying Document.mp4 (34.3 MB)
• 9. Querying Document.srt (6.5 KB)
16. Database Must-Know concepts
• 1. Introduction.mp4 (5.1 MB)
• 1. Introduction.srt (1.3 KB)
• 2. What is RDBMS Categories & How it Works.mp4 (30.3 MB)
• 2. What is RDBMS Categories & How it Works.srt (6.6 KB)
• 3. What is NoSQL.mp4 (15.7 MB)
• 3. What is NoSQL.srt (4.4 KB)
• 4. What is SQL Purpose & How it Works.mp4 (14.6 MB)
• 4. What is SQL Purpose & How it Works.srt (4.4 KB)
• 5. RDBMS or NoSQL (Which is the better choice What to pick).mp4 (19.4 MB)
• 5. RDBMS or NoSQL (Which is the better choice What to pick).srt (4.3 KB)
• 6. RDBMS vs NoSQL Comparison.mp4 (39.0 MB)
• 6. RDBMS vs NoSQL Comparison.srt (4.6 KB)
17. Relative QuestionsAssignments Summary
• 1. Datatypes.html (1.5 KB)
• 10. Set Operators.html (0.2 KB)
• 11. Practice Assignment.html (0.5 KB)
• 12. Stored Procedures.html (1.1 KB)
• 13. MongoDB.html (2.9 KB)
• 14. Database Must-Know concepts.html (0.8 KB)
• 2. Managing Tables.html (1.1 KB)
• 3. Modifying Data in MySQL.html (0.9 KB)
• 4. Querying Data.html (0.2 KB)
• 5. Sorting Data.html (0.4 KB)
• 6. Filtering Data.html (2.6 KB)
• 7. Joining Tables.html (1.1 KB)
• 8. Grou