~Get Your Files Here !

  1. Installation

   1. Installing MySQL on Windows.srt

   2. Installing MySQL on macOS.srt

   3. SQLYog Installation.srt

   4. SQLYog Walkaround & Executing Basic Queries.srt

  10. Grouping Data

   1. GROUP BY.srt

   2. Aggregate functions (COUNT(), SUM(), AVG(), MIN(), MAX()).srt

   3. HAVING Clause.srt

  11. Subqueries

   1. Subquery.srt

  12. Set Operators

   1. UNION.srt

  13. Practice Assignment

   1. Practice Assignment.srt

  14. Stored Procedures

   1. Introduction to Stored Procedure SP.srt

   10. MySQL Transactions - COMMIT and ROLLBACK.srt

   2. Listing Stored Procedure.srt

   3. Creating Stored Procedure.srt

   4. Modifying Stored Procedure.srt

   5. Parameters in SP.srt

   6. Variables in SP.srt

   7. IF-ELSE Statement in SP.srt

   8. Stored Function.srt

   9. MySQL Indexing.srt

  15. MongoDB

   1. Installing MongoDB on Windows.srt

   10. Querying Document With Comparison Operators.srt

   11. Querying document Using IN & NOT IN.srt

   12. Querying documents - Logical Operators ($and & $or).srt

   13. Querying documents - Logical Operators ($nor and $not).srt

   14. Limiting Records.srt

   15. Sorting Records.srt

   16. Aggregate Command - countDocuments().srt

   17. Aggregate Command - distinct().srt

   18. Aggregate Command - aggregate().srt

   19. Date Query.srt

   2. Creating Database.srt

   20. $regex Operator.srt

   21. MongoDB Indexes.srt

   3. Create Collection.srt

   4. MongoDB Binary JSON(BSON).srt

   5. Inserting Single Document.srt

   6. Inserting MultipleBulk document.srt

   7. Loading Sample Datasets.srt

   8. Updating Document.srt

   9. Querying Document.srt

  16. Database Must-Know concepts

   1. Introduction.srt

   2. What is RDBMS Categories & How it Works.srt

   3. What is NoSQL.srt

   4. What is SQL Purpose & How it Works.srt

   5. RDBMS or NoSQL (Which is the better choice What to pick).srt

   6. RDBMS vs NoSQL Comparison.srt

  17. Relative QuestionsAssignments Summary

   10. Set Operators.html

   12. Stored Procedures.html

   14. Database Must-Know concepts.html

   3. Modifying Data in MySQL.html

   5. Sorting Data.html

   7. Joining Tables.html

   9. Subqueries.html

  2. Managing Database

   1. Creating & Understanding Database.srt

   2. DROP Database.srt

  3. Datatypes

   1. MySQL DataTypes.srt

   2. Numeric DataTypes.srt

   3. Numeric DataTypes - Decimal.srt

   4. Numeric Datatypes - Double & Float, Bool, Boolean.srt

   5. Date and Time Datatypes - Date, DateTime, Timestamp.srt

   6. Date and Time Data Types - Time.srt

   7. String Data Types - Char and Varchar.srt

   8. String Data Types - Blob & Text.srt

   9. String Data Types - ENUM.srt

  4. Managing Tables

   1. Database Storage Engines - Quick Reference.srt

   2. Creating & Understanding Tables.srt

   3. Introduction to Foreign Key.srt

   4. Creating Tables With Foreign Key.srt

   5. Alter Table Command - ADD, MODIFY.srt

   6. Alter Table Command - CHANGE, DROP, RENAME.srt

  5. Modifying Data in MySQL

   1. Insert Query [Inserting A Record To Table].srt

   2. Insert Ignore Into Clause - INSERT IGNORE INTO & ON DUPLICATE KEY.srt

   3. Inserting Hierarchical Data.srt

   4. Update Single Row.srt

   5. Updating Multiple Records (The “IN” Operator).srt

  6. Querying Data

   1. SELECT Clause.srt

  7. Sorting Data

   1. ORDER BY Clause.srt

  8. Filtering Data

   1. WHERE Clause Introduction.srt

   10. LIMIT Operator.srt

   11. IS NULL Operator.srt

   2. WHERE Clause With Equality Operator.srt

   3. WHERE Clause With Comparison Operators.srt

   4. AND Operator.srt

   5. OR Operator.srt

   6. IN Operator.srt

   7. BETWEEN Operator.srt

   8. LIKE Operator.srt

   9. REGEX Operator.srt

  9. Joining Tables

   1. Alias.srt

   2. Introduction to JOINS.srt

   3. INNER JOIN.srt

   4. LEFT JOIN.srt

   5. RIGHT JOIN.srt

   6. SELF JOIN.srt

   7. CROSS JOIN.srt

  Bonus Resources.txt