Lesson 1: Introduction to Oracle SQL
What is database?
What is SQL?
What are the types of SQL?
Lesson 2: SQL "SELECT" statement
Lesson 3: Limiting Rows using "WHERE" clause
Lesson 4: Functions in SQL and Single Row Function
Lesson 5: Multi Row Functions ,"HAVING" & "GROUP BY" clause
Lesson 6: Display data from Multiple tables using "JOINS" in SQL
Lesson 7: Subqueries
Lesson 8: SET Operators
UNION, UNION ALL, INTERSECT, MINUS
Lesson 9: DML Statements
Lesson 10: DDL Statements
Lesson 11: TCL and DCL Statements
Lesson 12: Views in SQL
What is view?
What is Simple View?
What is Complex View?
Are DML's allowed on view?
Difference between "Simple" & "Complex" view?
Lesson 13: Synonym, Sequence
Lesson 14: Index
What is database?
What is SQL?
What are the types of SQL?
Lesson 2: SQL "SELECT" statement
Lesson 3: Limiting Rows using "WHERE" clause
Lesson 4: Functions in SQL and Single Row Function
Lesson 5: Multi Row Functions ,"HAVING" & "GROUP BY" clause
Lesson 6: Display data from Multiple tables using "JOINS" in SQL
Lesson 7: Subqueries
Lesson 8: SET Operators
UNION, UNION ALL, INTERSECT, MINUS
Lesson 9: DML Statements
Lesson 10: DDL Statements
Lesson 11: TCL and DCL Statements
Lesson 12: Views in SQL
What is view?
What is Simple View?
What is Complex View?
Are DML's allowed on view?
Difference between "Simple" & "Complex" view?
Lesson 13: Synonym, Sequence
Lesson 14: Index
