Get Started. It's Free
or sign up with your email address
Rocket clouds
SQL by Mind Map: SQL

1. Aggregate functions

1.1. COUNT

1.2. MIN

1.2.1. with integers

1.2.1.1. lowest value

1.2.2. with varchar

1.2.2.1. first value (alphabetically - A to Z)

1.3. MAX

1.3.1. with integers

1.3.1.1. largest value

1.3.2. with varchar

1.3.2.1. last value (alphabetically - Z to A)

1.4. AVG

1.4.1. used with numbers only!

1.5. SUM

1.5.1. used with numbers only!

2. Data Types

2.1. Integer

2.2. Varchar

2.3. Datetime

3. Statements

3.1. DDL

3.1.1. Create

3.1.2. Alter

3.1.3. Drop

3.2. DML

3.2.1. Insert

3.2.2. Update

3.2.3. Delete

3.2.4. Select

4. Key Constraints

4.1. Primary Key

4.2. Foreign Key

4.3. Unique Key

5. Clauses

5.1. Where

5.1.1. filters rows based on a condition

5.2. Having

5.2.1. filters groups based on a condition

5.3. Order by

5.3.1. sorts records based on specified columns

5.4. Group by

5.4.1. arranges similar data into groups (based on specified criteria)