SQL vs NoSQL - Studyopedia Certifications

SQL vs NoSQL - Studyopedia Certifications

MySQL Certification SQL vs NoSQL

MySQL Certification

0% Completed

MySQL – Introduction

MySQL Introduction & Features

Video - 3:49 mins

Video - 3:26 mins

MySQL – Installation & Setup

Install MySQL on Windows 11

Video - 7:06 mins

MySQL – Create and Insert

Create a Database in MySQL

Video - 1:11 mins

Create a Table in MySQL

Video - 3:26 mins

Insert Records in MySQL

Video - 5:42 mins

MySQL – Select Records

SELECT Statement in MySQL

Video - 3:29 mins

SELECT DISTINCT Statement in MySQL

Video - 2:07 mins

WHERE Clause in MySQL

Video - 3:14 mins

MySQL – Constraints

Not Null Constraint in MySQL

Video - 3:59 mins

Primary Key Constraint in MySQL

Video - 3:17 mins

Foreign Key Constraint in MySQL

Video - 2:52 mins

Unique Constraint in MySQL

Video - 1:45 mins

Default Constraint in MySQL

Video - 3:02 mins

Check Constraint in MySQL

Video - 3:47 mins

MySQL – Alter a Table

Alter Table and add a new column in MySQL

Video - 1:40 mins

Alter Table and drop a column in MySQL

Video - 1:54 mins

Alter Table and modify a column in MySQL

Video - 3:19 mins

MySQL – Operators

AND Operator in MySQL

Video - 2:39 mins

OR Operator in MySQL

Video - 3:17 mins

NOT Operator in MySQL

Video - 2:39 mins

IN Operator in MySQL

Video - 2:48 mins

LIKE Operator in MySQL

Video - 6:25 mins

BETWEEN Operator

Video - 2:52 mins

MySQL – Case Statement

Case Statement in MySQL

Video - 4:17 mins

MySQL – Comments

Add a comment in MySQL

Video - 2:58 mins

MySQL – Built-in Functions

sum() function in MySQL

Video - 2:09 mins

avg() function in MySQL

Video - 1:37 mins

count() function in MySQL

Video - 2:48 mins

max() function in MySQL

Video - 1:55 mins

min() function in MySQL

Video - 2:01 mins

MySQL – Statements

UPDATE Statement in MySQL

Video - 3:24 mins

DELETE Statement in MySQL

Video - 2:59 mins

MySQL – Order Records

ORDER BY Statement in MySQL

Video - 2:43 mins

MySQL – Limit Records

How to select limited records with the LIMIT Clause in MySQL

MySQL – Alias and Auto Increment

Video - 3:10 mins

Auto Increment in MySQL

Video - 7:22 mins

MySQL – Indexes

Create, Drop, and Show Indexes in MySQL

Video - 4:05 mins

MySQL – Joins

INNER, LEFT, and RIGHT Joins in MySQL

Video - 6:57 mins

MySQL – Drop Table and Database

DROP TABLE Command in MySQL

Video - 1:54 mins

DROP DATABASE Command in MySQL

Video - 1:33 mins

Announcements Reviews Live Classes Certificate Course Info