About This Course
Course Curriculum
-
Module 1: Introduction on MySQL01:00:00
-
Module 2: Data Types00:51:00
-
Module 3: SELECT Statements00:59:00
-
Module 4: Backticks00:15:00
-
Module 5: NULL00:18:00
-
Module 6: Limit and Offset00:13:00
-
Module 7: Creating databases00:18:00
-
Module 8: Using Variables00:25:00
-
Module 9: Comment MySQL00:14:00
-
Module 10: INSERT Statements00:29:00
-
Module 11: DELETE Statements00:21:00
-
Module 12: UPDATE Statements00:20:00
-
Module 13: ORDER BY Clause00:08:00
-
Module 14: Group By00:18:00
-
Module 15: Errors in MySQL00:10:00
-
Module 16: Joins00:37:00
-
Module 17: Joins continued00:11:00
-
Module 18: UNION00:18:00
-
Module 19: Arithmetic00:20:00
-
Module 20: String operations00:33:00
-
Module 21: Date and Time Operations00:08:00
-
Module 22: Handling Time Zones00:07:00
-
Module 23: Regular Expressions00:19:00
-
Module 24: VIEWS00:20:00
-
Module 25: Table Creation00:23:00
-
Module 26: ALTER TABLE00:23:00
-
Module 27: Drop Table00:05:00
-
Module 28: MySQL LOCK TABLE00:10:00
-
Module 29: Error codes00:08:00
-
Module 30: Stored routines (procedures and functions)00:29:00
-
Module 31: Indexes and Keys00:24:00
-
Module 32: Full-Text search00:18:00
-
Module 33: PREPARE Statements00:09:00
-
Module 34: JSON00:11:00
-
Module 35: Extract values from JSON type00:05:00
-
Module 36: MySQL Admin00:08:00
-
Module 37: TRIGGERS00:12:00
-
Module 38: Configuration and tuning00:07:00
-
Module 39: Events00:08:00
-
Module 40: ENUM00:09:00
-
Module 41: Collations, Transactions, Log files, Replication, Backup00:41:00