MariaDB SQL Commands: Index

Select a page below to view the training materials for essential MariaDB SQL commands.

• Page 1: Basic Data Manipulation (SELECT, INSERT, UPDATE, DELETE, FROM)
• Page 2: Data Definition & Basic Querying (CREATE TABLE, ALTER TABLE, DROP TABLE, WHERE, ORDER BY)
• Page 3: Data Retrieval and Aggregation (GROUP BY, HAVING, JOIN, LEFT JOIN, RIGHT JOIN)
• Page 4: Constraints and Data Types (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, DEFAULT)
• Page 5: Advanced Features / Views / Indexes (CREATE VIEW, DROP VIEW, CREATE INDEX, DROP INDEX, LIMIT)