MySQL Database Management System using MySQL. MySQL for ALL!

Course Curriculum

Chapter 1: MySQL Database – Introduction

Lecture 1: Introduction to database

Lecture 2: Using The Files(1)

Chapter 2: MySQL Database – Practice

Lecture 1: MySQL Installation Information

Lecture 2: MySQL – Setup a Package Manager

Lecture 3: MySQL – Setup Working Environment

Lecture 4: Changing Time Zone for MySQL

Lecture 5: MySQL – Select, Keyword, Expressions and Functions

Lecture 6: MySQL Row Selection

Lecture 7: MySQL Column Selection

Lecture 8: ORDER BY ASC and DESC

Lecture 9: WHERE Clause

Lecture 10: LIKE and IN Clauses

Lecture 11: REGEXP and RLIKE

Lecture 12: Using INSERT INTO to Insert Data

Lecture 13: Using UPDATE SET to Update Data

Lecture 14: DELETE and DROP

Lecture 15: MySQL Strings

Lecture 16: What is NULL

Lecture 17: CREATE and USE DATABASE

Lecture 18: Using Tables

Lecture 19: Using Indexes

Lecture 20: Using Constraints

Lecture 21: AUTO_INCREMENT, PRIMARY KEY and SERIAL

Lecture 22: ALTER TABLE

Lecture 23: MySQL Data Type Introduction

Lecture 24: Numeric Types

Lecture 25: MySQL String Types

Lecture 26: MySQL DATE and TIME Types

Lecture 27: BIT

Lecture 28: BOOLEAN Types

Lecture 29: ENUM and SET

Lecture 30: MySQL String Function

Lecture 31: MySQL Numeric Functions

Lecture 32: Date and Time Functions

Lecture 33: MySQL Time Zone Support

Lecture 34: DTAE_FORMAT Function

Lecture 35: MySQL Grouping Functions

Lecture 36: MySQL Conditional Function

Lecture 37: MySQL – How To Use Transactions

Lecture 38: Transactions and Performance

Lecture 39: Using TRIGGER

Lecture 40: Using TRIGGER Preventing Auto Update

Lecture 41: Triggers and Transactions

Lecture 42: How To Use Subselect and SUBSTR

Lecture 43: MySQL – Searching Within a Result Set

Lecture 44: How To Create VIEWs

Lecture 45: How To Create JOIN VIEW

Lecture 46: MySQL – Routines

Lecture 47: MySQL Functions

Lecture 48: MySQL Procedures

Lecture 49: What is PDO

Lecture 50: PDO and Prepared Statement