<aside> 💡

BEGINNER LEVEL (BASICS)

</aside>

Query Data (SELECT).

Data Definition Language (DDL)

Data Manipulation Language (DML)

<aside> <img src="/icons/stairs_purple.svg" alt="/icons/stairs_purple.svg" width="40px" />

INTERMEDIATE LEVEL

</aside>

OPERATORS

Comparison Operators

Logical Operators

Range Operators

Membership Operators

Search Operator

<aside> <img src="/icons/warning_red.svg" alt="/icons/warning_red.svg" width="40px" />

IMPORTANT TOPICS OF SQL

</aside>

JOINs IN SQL

There will be two conditions we’ll come across:

1. When you want to combine two different tables (column-wise), we’ll use JOINs.
2. Another is when we want to combine rows different tables, we’ll use SET operators

Why do we need JOINs?

1. Recombine Data: Combine data/records from multiple tables into a single table, “Big Picture.”
2. Data Enrichment: For additional details about records, see “Extra Info.”