Chapters

← Back to Subjects

MySQL - Chapters

Classification of SQL Commands

MySQL Introduction

MySQL RDBMS Concepts

Installing MySQL with XAMPP

MySQL SQL — Overview

MySQL Data Types

MySQL CREATE DATABASE

MySQL DROP DATABASE

MySQL CREATE and DROP TABLE

MySQL ALTER TABLE

MySQL Constraints

MySQL NOT NULL Constraint

MySQL UNIQUE Constraint

MySQL PRIMARY KEY

MySQL FOREIGN KEY

MySQL CHECK Constraint

MySQL DEFAULT Constraint

MySQL AUTO_INCREMENT

MySQL CREATE INDEX

MySQL Table Relationships

MySQL INSERT INTO

MySQL WHERE Clause

MySQL AND, OR, NOT

MySQL NULL Values

MySQL Wildcards

MySQL — ANY & ALL

MySQL COUNT() Function

MySQL AVG() Function

MySQL SUM() Function

MySQL MIN() Function

MySQL MAX() Function

MySQL INNER JOIN

MySQL LEFT JOIN

MySQL RIGHT JOIN

MySQL CROSS JOIN

MySQL SELF JOIN

MySQL UNION ALL

MySQL Subqueries

Correlated Subqueries

MySQL Temporary Tables

MySQL INSERT INTO SELECT

MySQL Copy Table

MySQL GROUP_CONCAT() Function

MySQL Transactions

MySQL START TRANSACTION

MySQL SAVEPOINT

MySQL Stored Functions

MySQL Isolation Levels

MySQL VARCHAR, ENUM & SET

MySQL Updatable Views

MySQL Indexing Strategies

MySQL EXPLAIN Plan

Slow Query Optimization

MySQL String Functions

MySQL Numeric Functions

MySQL Date Functions

MySQL Advanced Functions

MySQL JSON Data Type

MySQL JSON Indexing

MySQL CREATE USER

GRANT Permissions in MySQL

MySQL REVOKE Permissions

MySQL Roles & Privileges

MySQL Database Backup

Restore Database in MySQL

MySQL mysqldump Tool

MySQL Stored Procedures

MySQL User Defined Functions

MySQL Event Scheduler

MySQL Window Functions

MySQL DECIMAL, CAST & CONVERT