1.1. What is a Database
1.2. Why Oracle Database
1.3. What is a Table
1.4. UDEMY 101 How to Use Udemy +Some Useful Tips
1.5. What is a Relational Database
1.6. Entity Relationship Logic in Databases
1.7. The Sample (HR) Schema Used in This Course
1.8. What is SQL
2.1. About the Installation
2.2. Which Option to Have a Database
2.3. Option 1 Having The Database with Oracle VirtualBox
2.4. Option 2 Downloading And Installing Oracle Database
2.5. Option 3 Using Oracle Live SQL
2.6. Configuring and Using SQL Developer
2.7. SQL Statement used in this course
3.1. Oracle Data Types
3.2. DESCRIBE Command
3.3. SQL Statement Basics
3.4. Using SELECT Statement
3.5. Using Column Aliases
3.6. Quote (Q) Operator
3.7. DISTINCT Operator
3.8. Concatenation Operators
3.9. Arithmetic Expressions and NULL Values
4.1. Using WHERE Clause
4.2. Comparison Operators
4.3. BETWEEN … AND Operator
4.4. IN Operator
4.5. LIKE Operator
4.6. IS NULL Operator
4.7. Logical Operators (AND, OR, NOT)
4.8. Rules of Precedence
5.1. ORDER BY Clause
5.2. ASC and DESC Operators
5.3. NULLS FIRST and NULLS LAST Operators
6.1. Single Row Functions
6.2. Character Functions (Part 1)
6.3. Character Functions (Part 2)
6.4. Number Functions
6.5. Nesting Functions
6.6. Date Functions
6.7. Date Operations
7.1. Conversion Functions
7.2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)
7.3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)
7.4. NVL, NVL2, NULLIF, COALESCE Functions
8.1. Conditional Expressions (CASE-DECODE)
9.1. Group Functions
9.2. AVG Function
9.3. COUNT Function
9.4. MAX Function
9.5. MIN Function
9.6. SUM Function
9.7. Overview Of Group Functions
10.1. GROUP BY Clause
10.2. HAVING Clause
10.3. Nesting Group Functions
11.1. Joining Multiple Tables & Types of Joins
11.2. Natural Joins
11.3. Join with USING Clause
11.4. Handling Ambiguous Column Names
11.5. Join with ON Clause
11.6. Multiple Join Operations
11.7. Restricting Joins
11.8. Joining Unequal Tables
11.9. SELF JOIN
11.10. OUTER JOINS
11.11. LEFT OUTER JOIN
11.12. RIGHT OUTER JOIN
11.13. FULL OUTER JOIN
11.14. CROSS JOIN (Cartesian Product)
12.1. Using Subqueries
12.2. Single Row Subqueries
12.3. Multiple Row Subqueries
12.4. Multiple Column Subqueries
13.1. SET Operators
13.2. UNION and UNION ALL Operators
13.3. INTERSECT Operator
13.4. MINUS Operator
13.5. Matching Unmatched Queries in SET Operations
13.6. Order By with SET Operators
14.1. Data Manipulation Language (DML)
14.2. INSERT Statement (Part 1)
14.3. INSERT Statement (Part 2)
14.4. UPDATE Statement
14.5. DELETE Statement
14.6. Transaction Control Statements
14.7. COMMIT and ROLLBACK Statements
14.8. SAVEPOINT Statement
14.9. FOR UPDATE Statement
15.1. Data Definition Language (DDL)
15.2. Naming Rules
15.3. CREATE TABLE Statement
15.4. ALTER TABLE Statement
15.5. DROP TABLE Statement
15.6. TRUNCATE TABLE Statement
15.7. COMMENT Statement
15.8. RENAME Statement
16.1. Creating Constraints
16.2. NOT NULL Constraint
16.3. UNIQUE Constraint
16.4. PRIMARY KEY Constraint
16.5. FOREIGN KEY Constraint
16.6. CHECK Constraint
17.1. Conclusion
