Installing MySQL on Windows

03:54

Installing MySQL on macOS

02:59

SQLYog Installation

01:59

SQLYog Walkaround & Executing Basic Queries

06:24

Creating & Understanding Database

06:17

Drop Database

01:22

MySQL DataTypes

04:29

Numeric DataTypes

11:41

Numeric DataTypes - Decimal

03:45

Numeric Datatypes - Double & Float, Bool, Boolean

04:33

Date and Time Datatypes - Date, DateTime, Timestamp

07:17

String Data Types - Char and Varchar

04:19

String Data Types - Blob & Text

02:35

String Data Types - ENUM

02:20

Database Storage Engines - Quick Reference

03:49

Creating & Understanding Tables

08:36

Introduction to Foreign Key

04:16

Creating Tables With Foreign Key

11:24

Alter Table Command - CHANGE, DROP, RENAME

03:22

Insert Query [Inserting A Record To Table]

06:12

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

04:27

Inserting Hierarchical Data

04:22

Update Single Row

03:41

Updating Multiple Records (The “IN” Operator)

02:32

SELECT Clause

04:34

ORDER BY Clause

05:15

WHERE Clause Introduction

01:20

WHERE Clause With Equality Operator

02:57

WHERE Clause With Comparison Operators

05:27

AND Operator

05:03

OR Operator

05:19

IN Operator

04:18

BETWEEN Operator

03:37

LIKE Operator

06:04

REGEX Operator

09:27

LIMIT Operator

05:49

IS NULL Operator

02:29

Alias

03:02

Introduction to JOINS

02:26

INNER JOIN

09:59

LEFT JOIN

03:41

RIGHT JOIN

02:36

SELF JOIN

04:47

CROSS JOIN

05:04

GROUP BY

05:44

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

08:52

HAVING Clause

03:56

Subquery

11:07

UNION

03:15

Practice Assignment

08:02

Introduction to Stored Procedure "SP"

03:55

Listing Stored Procedure

01:52

Creating Stored Procedure

12:03

Modifying Stored Procedure

02:06

Parameters in SP

09:00

Variables in SP

03:17

IF-ELSE Statement in SP

03:20

Stored Function

03:55

MySQL Indexing

06:51

MySQL Transactions - COMMIT and ROLLBACK

08:12

Installing MongoDB on Windows

04:34

Creating Database

03:43

Create Collection

05:44

MongoDB Binary JSON(BSON)

01:25

Inserting Single Document

07:11

Inserting Multiple/Bulk document

02:37

Loading Sample Datasets

03:09

Updating Document

05:40

Querying Document

06:18

Querying Document With Comparison Operators

05:59

Querying document Using IN & NOT IN

03:04

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

07:53

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

05:35

Limiting Records

03:26

Sorting Records

03:14

Aggregate Command - countDocuments()

04:03

Aggregate Command - distinct()

02:49

Aggregate Command - aggregate()

06:19

Date Query

04:40

$regex Operator

04:56

MongoDB Indexes

05:42

Introduction

01:19

What is RDBMS? Categories & How it Works?

05:34

What is NoSQL?

04:08

What is SQL? Purpose & How it Works?

03:59

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

03:56