Practical Database Guide with RDBMS(MySQL) & NoSQL(MongoDB)

Course Curriculum

Chapter 1: Installation

Lecture 1: Installing MySQL on Windows

Lecture 2: Installing MySQL on macOS

Lecture 3: SQLYog Installation

Lecture 4: SQLYog Walkaround & Executing Basic Queries

Chapter 2: Managing Database

Lecture 1: Creating & Understanding Database

Lecture 2: DROP Database

Chapter 3: Datatypes

Lecture 1: MySQL DataTypes

Lecture 2: Numeric DataTypes

Lecture 3: Numeric DataTypes – Decimal

Lecture 4: Numeric Datatypes – Double & Float, Bool, Boolean

Lecture 5: Date and Time Datatypes – Date, DateTime, Timestamp

Lecture 6: Date and Time Data Types – Time

Lecture 7: String Data Types – Char and Varchar

Lecture 8: String Data Types – Blob & Text

Lecture 9: String Data Types – ENUM

Chapter 4: Managing Tables

Lecture 1: Database Storage Engines – Quick Reference

Lecture 2: Creating & Understanding Tables

Lecture 3: Introduction to Foreign Key

Lecture 4: Creating Tables With Foreign Key

Lecture 5: Alter Table Command – ADD, MODIFY

Lecture 6: Alter Table Command – CHANGE, DROP, RENAME

Chapter 5: Modifying Data in MySQL

Lecture 1: Insert Query [Inserting A Record To Table]

Lecture 2: Insert Ignore Into Clause – INSERT IGNORE INTO & ON DUPLICATE KEY

Lecture 3: Inserting Hierarchical Data

Lecture 4: Update Single Row

Lecture 5: Updating Multiple Records (The “IN” Operator)

Chapter 6: Querying Data

Lecture 1: SELECT Clause

Chapter 7: Sorting Data

Lecture 1: ORDER BY Clause

Chapter 8: Filtering Data

Lecture 1: WHERE Clause Introduction

Lecture 2: WHERE Clause With Equality Operator

Lecture 3: WHERE Clause With Comparison Operators

Lecture 4: AND Operator

Lecture 5: OR Operator

Lecture 6: IN Operator

Lecture 7: BETWEEN Operator

Lecture 8: LIKE Operator

Lecture 9: REGEX Operator

Lecture 10: LIMIT Operator

Lecture 11: IS NULL Operator

Chapter 9: Joining Tables

Lecture 1: Alias

Lecture 2: Introduction to JOINS

Lecture 3: INNER JOIN

Lecture 4: LEFT JOIN

Lecture 5: RIGHT JOIN

Lecture 6: SELF JOIN

Lecture 7: CROSS JOIN

Chapter 10: Grouping Data

Lecture 1: GROUP BY

Lecture 2: Aggregate functions (COUNT(), SUM(), AVG(), MIN(), MAX())

Lecture 3: HAVING Clause

Chapter 11: Subqueries

Lecture 1: Subquery

Chapter 12: Set Operators

Lecture 1: UNION

Chapter 13: Practice Assignment

Lecture 1: Practice Assignment

Chapter 14: Stored Procedures

Lecture 1: Introduction to Stored Procedure "SP"

Lecture 2: Listing Stored Procedure

Lecture 3: Creating Stored Procedure

Lecture 4: Modifying Stored Procedure

Lecture 5: Parameters in SP

Lecture 6: Variables in SP

Lecture 7: IF-ELSE Statement in SP

Lecture 8: Stored Function

Lecture 9: MySQL Indexing

Lecture 10: MySQL Transactions – COMMIT and ROLLBACK

Chapter 15: MongoDB

Lecture 1: Installing MongoDB on Windows

Lecture 2: Creating Database

Lecture 3: Create Collection

Lecture 4: MongoDB Binary JSON(BSON)

Lecture 5: Inserting Single Document

Lecture 6: Inserting Multiple/Bulk document

Lecture 7: Loading Sample Datasets

Lecture 8: Updating Document

Lecture 9: Querying Document

Lecture 10: Querying Document With Comparison Operators

Lecture 11: Querying document Using IN & NOT IN

Lecture 12: Querying documents – Logical Operators ($and & $or)

Lecture 13: Querying documents – Logical Operators ($nor and $not)

Lecture 14: Limiting Records

Lecture 15: Sorting Records

Lecture 16: Aggregate Command – countDocuments()

Lecture 17: Aggregate Command – distinct()

Lecture 18: Aggregate Command – aggregate()

Lecture 19: Date Query

Lecture 20: $regex Operator

Lecture 21: MongoDB Indexes

Chapter 16: Database Must-Know concepts

Lecture 1: Introduction