Essentials

The Pareto Principle, also known as the 80/20 rule, states that roughly 80% of the effects come from 20% of the causes. This principle can help prioritize the most important concepts to understand and utilize for SQL. Here’s the list of topics, arranged in an approximate learning order:

Overview of Databases

Syntax and Keywords

DDL: CREATE

Data Types

DDL: ALTER

DDL: DROP

DDL: Schema

DML: SELECT

DML: SELECT FROM

DML: SELECT DISTINCT

DML: SELECT ALL

DML: SELECT with a WHERE clause

DML: SELECT with ORDER BY

DML: INSERT

DML: UPDATE

DML: DELETE

Database Design, Normalization, and SQL JOINs

DML: SELECT with INNER JOIN

DML: SELECT with LEFT (OUTER) JOIN

DML: SELECT with RIGHT (OUTER) JOIN

DML: SELECT with FULL (OUTER) JOIN

DML: SELECT with GROUP BY

SQL Aggregate Functions

DML: SELECT with Subquery

JOIN vs. Subquery

Transaction Control Language

DDL: Indexes

DCL: GRANT

DCL: REVOKE