Learn Oracle
By DigiGrowHub Mentor
Uncategorized
Course Content
Module 1 : Oracle Tutorial
-
What is Oracle?
Module 2 : Oracle Tables
-
Create Table
-
CREATE TABLE AS
-
ALTER TABLE
-
DROP TABLE
-
Global Temporary tables
-
Local Temporary tables
Module 3: Oracle Views
-
Oracle CREATE VIEW
Module 4 : Oracle Query
-
Oracle Queries
-
Oracle SELECT
-
Oracle Insert
-
Oracle INSERT ALL
-
Oracle UPDATE
-
Oracle DELETE
-
TRUNCATE TABLE
Module 5 : Oracle Clauses
-
Oracle DISTINCT
-
Oracle FROM
-
Oracle ORDER BY
-
Oracle GROUP BY
-
Oracle HAVING
Module 6 : Oracle Operators
-
Oracle Union
-
Oracle Union All
-
Oracle Intersect
-
Oracle Minus
Module 7 : Oracle Joins
-
Oracle Joins
-
Inner Join
-
Outer Join
-
Equi Join
-
Self Join
-
Cross Join
-
Anti Join
-
Semi Join
Module 8 : Oracle Advance
-
Oracle Procedure
-
Oracle Function
-
Oracle Cursor
-
Oracle Trigger
-
Oracle BEFORE Trigger
-
Oracle AFTER Trigger
-
Oracle DROP Trigger
-
Oracle DISABLE Trigger
-
Oracle ENABLE Trigger
Module 9 : Oracle Misc
-
ALIASES
-
AND
-
AND & OR
-
BETWEEN
-
COMPARISON OPERATORS
-
EXISTS
-
IN
-
INTERSECT
-
IS NOT NULL
-
LIKE
-
NOT
-
OR
-
SUBQUERY
-
TRUNCATE
-
WHERE
-
Change Password
-
Check Constraints
-
Comments
-
Primary Key
Module 10 : Interview Questions
-
Oracle Interview
-
SQL Interview
-
PL/SQL Interview
-
MongoDB Interview
Student Ratings & Reviews
No Review Yet