Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Practical Database Guide with RDBMS(MySQL)
Installation
Installing MySQL on macOS (3:00)
Installing MySQL on Windows (3:55)
SQLYog Installation (2:00)
SQLYog Walkaround & Executing Basic Queries (6:24)
Managing Database
Drop Database (1:22)
Creating & Understanding Database (6:17)
Datatypes
MySQL DataTypes (4:30)
Numeric DataTypes (5:20)
Numeric Datatypes (11:42)
Numeric DataTypes - Decimal (3:46)
Numeric Datatypes - Double & Float, Bool, Boolean (4:34)
Date and Time Datatypes - Date, DateTime, Timestamp (7:18)
String Data Types - Char and Varchar (4:20)
String Data Types - Blob and Text (2:36)
String Data Types - ENUM (2:21)
Managing Tables
Database Storage Engines - Quick Reference (3:50)
Creating and Understanding Tables (8:36)
Introduction to Foreign Key (4:17)
Creating tables with foreign key (11:25)
Alter Table Command - CHANGE, DROP, RENAME (3:22)
Modifying Data in MySQL
Insert Query [Inserting A Record To Table] (6:13)
Insert Ignore Into Clause - INSERT IGNORE INTO & ON DUPLICATE KEY (4:27)
Inserting Hierarchical Data (4:23)
Update Single Row (3:41)
Updating Multiple Records (The “IN” Operator) (2:33)
Querying Data
SELECT clause (4:34)
Sorting Data
ORDER BY Clause (5:16)
Filtering Data
WHERE Clause Introduction (1:21)
WHERE Clause Equality operator (2:58)
WHERE Clause Comparison operators (5:27)
AND operator (5:03)
OR Operator (5:19)
IN Operator (4:18)
BETWEEN Operator (3:37)
LIKE Operator (6:04)
REGEX Operator (9:28)
LIMIT Operator (5:50)
IS NULL Operator (2:30)
Joining Tables
Alias (3:02)
Introduction to JOINS (2:26)
INNER JOIN (10:00)
LEFT JOIN (3:42)
RIGHT JOIN (2:37)
SELF JOIN (4:47)
CROSS JOIN (5:05)
Grouping Data
GROUP BY (5:45)
Aggregate functions (COUNT(), SUM(), AVG(), MIN(), MAX()) (8:52)
HAVING clause (3:56)
Subqueries
Subquery (11:08)
Set Operators
UNION (3:15)
Practice Assignment
Practice Assignment (8:02)
Stored Procedures
Introduction to Stored Procedure (3:56)
Listing Stored Procedure (1:52)
Creating Stored Procedure (12:03)
Modifying Stored Procedure (2:06)
Parameters in SP (9:01)
Variables in SP (3:17)
IF-ELSE Statement in SP (3:20)
Stored Function (3:55)
MySQL Indexing (6:52)
MySQL Transactions - COMMIT and ROLLBACK (8:13)
Updating Multiple Records (The “IN” Operator)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock