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

1. Data Definition

1.1. Create

1.2. Alter

1.3. Drop

1.4. Truncate

2. Constraints

2.1. Primary Key

2.2. Unique Key

2.3. Foreign Key

2.4. Check

2.5. NOT NULL

3. Data Types

3.1. Oracle built-in Types

3.1.1. Character

3.1.2. Number

3.1.3. Date Time

3.2. ANSI Supported Data Types

3.2.1. Character

3.2.2. Varchar

3.2.3. Numeric

3.2.3.1. Precision

3.2.3.2. Scale

3.2.4. Decimal

3.2.5. Integer, Int

3.2.6. Float, Double

4. Queries

4.1. Simple

4.2. Join

4.2.1. Inner Join

4.2.1.1. Cross Join

4.2.1.2. Equi Join

4.2.2. Outer Join

4.2.2.1. Left

4.2.2.2. Right

4.3. Nested

4.3.1. Independent

4.3.2. Correlated

5. Operators

5.1. Arithmectic

5.2. Character

5.3. Comparision

5.3.1. Conventional

5.3.2. LIKE

5.3.3. Between

5.3.4. Any

5.3.5. `All

5.3.6. In

5.4. Logical

5.4.1. And

5.4.2. Or

5.4.3. Not

5.5. Set

5.5.1. Union

5.5.2. Intersect

5.5.3. Minus

6. Data Manipulation

6.1. Retrival

6.1.1. Select

6.1.2. From

6.1.3. Where

6.1.4. Orderby

6.1.4.1. ASC

6.1.4.2. DESC

6.1.5. Groupby

6.1.6. Having

6.2. Modification

6.2.1. Insert

6.2.2. Delete

6.2.3. Update

7. Functions

7.1. Aggregate

7.1.1. Max

7.1.2. Min

7.1.3. Avg

7.1.4. Sum

7.1.5. Count

7.2. Single Row

7.2.1. Character

7.2.2. Number

7.2.3. Date

7.2.4. Conversion

7.2.5. Special

8. Data Control

8.1. Commit

8.2. Roll back

8.3. Grant

8.4. Revoke