SQL
by Aparna Chaparala
1. Constraints
1.1. Primary Key
1.2. Unique Key
1.3. Foreign Key
1.4. Check
1.5. NOT NULL
2. Data Types
2.1. Oracle built-in Types
2.1.1. Character
2.1.2. Number
2.1.3. Date Time
2.2. ANSI Supported Data Types
2.2.1. Character
2.2.2. Varchar
2.2.3. Numeric
2.2.3.1. Precision
2.2.3.2. Scale
2.2.4. Decimal
2.2.5. Integer, Int
2.2.6. Float, Double
3. Operators
3.1. Arithmectic
3.2. Character
3.3. Comparision
3.3.1. Conventional
3.3.2. LIKE
3.3.3. Between
3.3.4. Any
3.3.5. `All
3.3.6. In
3.4. Logical
3.4.1. And
3.4.2. Or
3.4.3. Not
3.5. Set
3.5.1. Union
3.5.2. Intersect
3.5.3. Minus
4. Functions
4.1. Aggregate
4.1.1. Max
4.1.2. Min
4.1.3. Avg
4.1.4. Sum
4.1.5. Count
4.2. Single Row
4.2.1. Character
4.2.2. Number
4.2.3. Date
4.2.4. Conversion
4.2.5. Special
5. Data Definition
5.1. Create
5.2. Alter
5.3. Drop
5.4. Truncate
6. Queries
6.1. Simple
6.2. Join
6.2.1. Inner Join
6.2.1.1. Cross Join
6.2.1.2. Equi Join
6.2.2. Outer Join
6.2.2.1. Left
6.2.2.2. Right
6.3. Nested
6.3.1. Independent
6.3.2. Correlated
7. Data Manipulation
7.1. Retrival
7.1.1. Select
7.1.2. From
7.1.3. Where
7.1.4. Orderby
7.1.4.1. ASC
7.1.4.2. DESC
7.1.5. Groupby
7.1.6. Having
7.2. Modification
7.2.1. Insert
7.2.2. Delete
7.2.3. Update