Master SQL: Discover the 6 Core Language Components in One Course

How well do you know Structured Query Language (SQL)? This article provides a detailed overview of SQL’s six main components and introduces a related course from Alibaba Cloud Developer Academy.

Course recommendation: Database Technology Atlas – Basic Concepts

Course address: https://developer.aliyun.com/graph/database

SQL consists of six parts:

1. Data Query Language (DQL) : Used to retrieve data from tables. Common keywords include SELECT, WHERE, ORDER BY, GROUP BY, and HAVING.

2. Data Manipulation Language (DML) : Includes INSERT, UPDATE, and DELETE for adding, modifying, and removing rows.

3. Transaction Processing Language (TPL) : Ensures that DML operations are applied consistently, using BEGIN TRANSACTION, COMMIT, and ROLLBACK.

4. Data Control Language (DCL) : Manages permissions with GRANT and REVOKE, controlling user access to database objects.

5. Data Definition Language (DDL) : Handles schema creation and removal with CREATE and DROP, as well as index creation.

6. Cursor Control Language (CCL) : Uses statements like DECLARE CURSOR, FETCH INTO, and UPDATE WHERE CURRENT to operate on specific rows.

This lesson guides you into the world of SQL.

Course address: https://developer.aliyun.com/learning/course/64

This course includes 8 lessons:

DDL (Part 1)

DDL (Part 2)

DML – INSERT

DML – Update Records

DML – DELETE

DQL – Basic Column Queries

DQL – Conditional, Fuzzy, and Sorted Queries

DQL – Aggregate Functions, Grouping, and LIMIT

Next session preview: Service Registration and Discovery | Selected Course from the Atlas.