SQLYog Installation

Installing MySQL on Windows

Installing MySQL on macOS

SQLYog Walkaround & Executing Basic Queries

DROP Database

Creating & Understanding Database

MySQL DataTypes

Numeric DataTypes

Numeric DataTypes - Decimal

Numeric Datatypes - Double & Float, Bool, Boolean

Date and Time Datatypes - Date, DateTime, Timestamp

Date and Time Data Types - Time

String Data Types - Char and Varchar

String Data Types - Blob & Text

String Data Types - ENUM

Database Storage Engines - Quick Reference

Introduction to Foreign Key

Alter Table Command - ADD, MODIFY

Creating Tables With Foreign Key

Alter Table Command - CHANGE, DROP, RENAME

Insert Query [Inserting A Record To Table]

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

Inserting Hierarchical Data

Update Single Row

Updating Multiple Records (The “IN” Operator)

SELECT Clause

ORDER BY Clause

WHERE Clause Introduction

WHERE Clause With Equality Operator

WHERE Clause With Comparison Operators

AND Operator

IN Operator

OR Operator

BETWEEN Operator

LIKE Operator

LIMIT Operator

IS NULL Operator

REGEX Operator

Alias

LEFT JOIN

Introduction to JOINS

INNER JOIN

RIGHT JOIN

SELF JOIN

CROSS JOIN

GROUP BY

HAVING Clause

Aggregate functions (COUNT(), SUM(), AVG(), MIN(), MAX())

Subquery

UNION

Introduction to Stored Procedure SP

Listing Stored Procedure

Modifying Stored Procedure

Creating Stored Procedure

Parameters in SP

Variables in SP

IF-ELSE Statement in SP

Stored Function

MySQL Indexing

MySQL Transactions - COMMIT and ROLLBACK

Practice Assignment

Creating Database

Installing MongoDB on Windows

Create Collection

MongoDB Binary JSON(BSON)

Inserting MultipleBulk document

Inserting Single Document

Updating Document

Loading Sample Datasets

Querying Document

Querying document Using IN & NOT IN

Querying Document With Comparison Operators

Querying documents - Logical Operators ($and & $or)

Querying documents - Logical Operators ($nor and $not)

Limiting Records

Sorting Records

Aggregate Command - countDocuments()

Aggregate Command - distinct()

Aggregate Command - aggregate()

Date Query

$regex Operator

MongoDB Indexes

Introduction

What is NoSQL

What is RDBMS Categories & How it Works

What is SQL Purpose & How it Works

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

RDBMS vs NoSQL Comparison