❒ MySQL - All in One Concepts (Beginners to Advance)

  •  MySQL (Foundations) 

○ MySQL - Overview
○ MySQL - Features
○ MySQL - Installation
○ MySQL - Workbench
○ MySQL - Connection
○ MySQL - Databases
○ MySQL - Tables
○ MySQL - Data Types

  •  MySQL (Database) 

○ MySQL - Create Database
○ MySQL - Drop Database
○ MySQL - Database Export
○ MySQL - Database Import
○ MySQL - Database Info

  •  MySQL (Users & Security) 

○ MySQL - Users (overview)
○ MySQL - Create Users
○ MySQL - Grant Privileges
○ MySQL - Revoke Privileges
○ MySQL - Change Password
○ MySQL - Lock/Unlock User Account
○ MySQL - SQL Injection

  •  MySQL (Queries) 

○ MySQL - Insert Query
○ MySQL - Select Query
○ MySQL - Update Query
○ MySQL - Delete Query
○ MySQL - Replace Query
○ MySQL - Insert Into Select
○ MySQL - Insert on Duplicate Key Update (Upsert)
○ MySQL - Insert Ignore

  •  MySQL (Views) 

○ MySQL - Create Views
○ MySQL - Drop Views
○ MySQL - Update Views

  •  MySQL (Operators & Clauses) 

○ MySQL - Where Clause
○ MySQL - Limit Clause
○ MySQL - Distinct Clause
○ MySQL - Order By Clause
○ MySQL - Group By Clause
○ MySQL - Having Clause
○ MySQL - Like Operator
○ MySQL - IN Operator
○ MySQL - EXISTS Operator
○ MySQL - Between Operator
○ MySQL - UNION vs UNION ALL
○ MySQL - Aliases

  •  MySQL (Joins) 

○ MySQL - Inner Join
○ MySQL - Left Join
○ MySQL - Right Join
○ MySQL - Full Join
○ MySQL - Cross Join
○ MySQL - Self Join
○ MySQL - Union vs Join

  •  MySQL (Keys & Indexes) 

○ MySQL - Primary Key
○ MySQL - Foreign Key
○ MySQL - Unique Key
○ MySQL - Composite Key
○ MySQL - Indexes (overview)
○ MySQL - Clustered Index vs Non-Clustered Index

  •  MySQL (Triggers) 

○ MySQL - Overview
○ MySQL - Create Trigger
○ MySQL - Before Insert Trigger
○ MySQL - After Insert Trigger
○ MySQL - Before Update Trigger
○ MySQL - After Update Trigger
○ MySQL - Before Delete Trigger
○ MySQL - After Delete Trigger

  •  MySQL (Advanced) 

○ MySQL - Transactions
○ MySQL - SubQuery
○ MySQL - Stored Procedure
○ MySQL - Common Table Expressions (CTEs)
○ MySQL - On Delete Cascade
○ MySQL - JSON
○ MySQL - Partitioning
○ MySQL - Explain
○ MySQL - Database Storage Engines (InnoDB vs MyISAM)

  •  MySQL (Functions & Operators) 

○ MySQL - Date and Time Functions
○ MySQL - String Functions
○ MySQL - Aggregate Functions
○ MySQL - Numeric Functions
○ MySQL - Coalesce() Function
○ MySQL - UUID
○ MySQL - Wildcards