MySQL

My SQL Course 

MySQL Course

• MySQL Introduction 

• MySQL Features

• MySQL Versions

• MySQL Data Types

• MySQL Variables

• Install MySQL

• My SQL Connection

MySQL Workbench

• MySQL Workbench

User Management

• MySQL Create User

• MySQL Drop User

• MySQL Show User

• Change User Password

MySQL Database

• MySQL Create Database

• MySQL Select Database

• MySQL Show Database

• MySQL Drop Database

• MySQL Copy Database

Table & Views

• MySQL CREATE Table

• MySQL ALTER Table

• MySQL SHOW Table

• MySQL RENAME Table

• MySQL TRUNCATE Table

• MySQL DESCRIBE Table

• MySQL DROP Table

• MySQL TEMPORARY Table

• MySQL COPY Table

• MySQL REPAIR Table

• MySQL ADD/DELETE Column

• MySQL SHOW Columns

• MySQL RENAME Columns

• MySQL Views

• MySQL Table Locking

• MySQL Account Lock

• MySQL Account Unlock

MySQL Queries

• MySQL Queries

• MySQL Constraints

• MySQL INSERT Record

• MySQL UPDATE Record

• MySQL DELETE Record

• MySQL SELECT Record

• MySQL Replace

• Insert On Duplicate Key Update

• MySQL Insert IGNORE

• Insert Into Select

MySQL Indexes

• MySQL Create Index

• MySQL Drop Index

• MySQL Show Indexes

• MySQL Unique Index

• MySQL Clustered Index

• MySQL Clustered vs Non-Clustered Index

MySQL Clauses

• MySQL WHERE

• MySQL DISTINCT

• MySQL FROM

• MySQL ORDER BY

• MySQL GROUP BY

• MySQL HAVING

MySQL Privileges

• MySQL Grant Privilege

• MySQL Revoke Privilege

Control Flow Function

• MySQL IF()

• MySQL IF NULL()

• MySQL NULL()

• MySQL CASE

• MySQL IF Statement

MySQL Conditions

• MySQL AND

• MySQL OR

• MySQL AND OR

• MySQL Boolean

• MySQL LIKE

• MySQL IN

• MySQL ANY

• MySQL Exists

• MySQL NOT

• MySQL Not Equal

• MySQL IS NULL

• MySQL IS NOT NULL

• MySQL BETWEEN

MySQL Join

• MySQL JOIN

• MySQL Inner Join

• MySQL Left Join

• MySQL Right Join

• MySQL CROSS JOIN

• MySQL SELF JOIN

• MySQL DELETE JOIN

• MySQL Update Join

• MySQL EquiJoin

• MySQL Natural Join

• Left Join vs Right Join

• MySQL Union vs Join

MySQL Key

• MySQL Unique Key

• MySQL Primary Key

• MySQL Foreign Key

• MySQL Composite Key

MySQL Triggers

• MySQL Trigger
• MySQL Create Trigger
• MySQL Show Trigger
• MySQL DROP Trigger
• MySQL Insert Trigger
• After Insert Trigger
• MySQL BEFORE UPDATE Trigger
• MySQL AFTER UPDATE Trigger
• MySQL BEFORE DELETE Trigger
• MySQL AFTER DELETE Trigger

Aggregate Functions

• MySQL Aggregate Functions
• MySQL count()
• MySQL sum()
• MySQL avg()
• MySQL min()
• MySQL max()
• MySQL GROUP_CONCAT()
• MySQL First()
• MySQL Last()