MariaDB 的 SQL 基础知识 - 初学者指南
SQL Essentials with MariaDB - A Beginner's Guide
- 1. Introduction to Databases and MariaDB
- 4. Installing MariaDB and Setting Up Your Environment
- 5. Installing MariaDB Management Tool
- 6. Download Sample Database
- 10. MariaDB VS MySQL
- 6. MARIADB CRUD Operations
- 1. Introduction
- 2. CREATE CRUD Operation
- 3. Adding new data
- 4. READ CRUD Operation
- 5. UPDATE CRUD Operation
- 6. DELETE CRUD Operation
- 7. Truncating Tables
- 8. Dropping Tables
- 9. Removing Duplicates
- 10. Sorting Data
- 7. Aggregate Functions
- 1. Introduction to aggregate functions
- 2. AVG Function
- 3. COUNT Function
- 4. MAX Function
- 5. MIN Function
- 6. SUM Function
- 7. GROUP BY Clause
- 8. HAVING Clause
- 8. TABLE JOINS
- 1. Introduction to table joins
- 2. INNER Join
- 3. CROSS Join
- 4. LEFT Join
- 5. RIGHT Join
- 9. Querying Data with SQL Operators
- 1. UNION Operator
- 2. EXCEPT Operator
- 3. INTERSECT Operator
- 4. COMPARISON Operator
- 5. AND OR Operators