Course Curriculum
| Introduction |
|
Introduction to MySQL |
|
00:07:00 |
|
Installing MySQL Workbench |
|
00:08:00 |
| Basics of MySQL Query – Part 1 |
|
First Database |
|
00:06:00 |
|
Data Types |
|
00:10:00 |
|
Insert Row Key |
|
00:06:00 |
|
Insert Multiple Rows |
|
00:05:00 |
|
Constraints |
|
00:08:00 |
|
Select key |
|
00:03:00 |
|
Select where Clause |
|
00:05:00 |
| Basics of MySQL Query (Operators) – Part 2 |
|
And, Or, and Not Operators |
|
00:11:00 |
|
In Operator |
|
00:06:00 |
|
Between Operator |
|
00:03:00 |
|
Like Operator |
|
00:10:00 |
| Basics of MySQL Query – Part 3 |
|
Order and Distinct |
|
00:04:00 |
|
Offset and Limit |
|
00:05:00 |
|
Count min and Max Query |
|
00:14:00 |
|
Update |
|
00:08:00 |
|
Commit and Rollback |
|
00:06:00 |
|
Delete |
|
00:02:00 |
|
Primary and Foreign key |
|
00:11:00 |
| Join in MySQL |
|
Left and Right Join |
|
00:07:00 |
|
Cross Join |
|
00:04:00 |
|
Multiple Join |
|
00:07:00 |