Course Description
In this Session will cover below topics on Oracle SQL
****************************************************************************
01 - Oracle Introduction
***********************************
What is the Data Base and Data Base Management System?
How we Maintain the Database in Our Real Life
What is the Difference Between DBMS and RDBMS
How to use a Data Base System in our Real Life
02 - DDL Commands
******************************
What are the Data Types in Oracle SQL
What are the SQL Statements in Oracle SQL
How to Create a First Table in Oracle Data Base
How to Modify the Table Structure in Oracle Data Base
How to Drop and Rename the Table in Oracle Data Base
How to work with Insert (DML Statements) in Oracle SQL
How to work with Update (DML Statement) in Oracle SQL
How to work with Delete (DML Statement) in Oracle SQL
03 - TCL Commands
******************************
How to work with Commit (TCL Commands) in Oracle SQL
How to work with Rollback (TCL Commands) in Oracle SQL
How to work with Save Point (TCL Commands) in Oracle SQL
How to work with Truncate (TCL Commands) in Oracle SQL
04 - Clauses
******************
How to work with Select and Where Clause in Oracle SQL
How to work with Group By Clause in Oracle SQL
How to work with Having Clause in Oracle SQL
How to work with Order By Clause in Oracle SQL
How to work with Distinct Clause in Oracle SQL
05 - Operators Part
****************************
How to work with Arithmetic Operators in Oracle SQL
How to work with Logical Operators in Oracle SQL
How to work with Relational Operators in Oracle SQL
How to work with Special Operators in Oracle SQL
How to work with Set Operators in Oracle SQL
07 - Functions Part
****************************
How to work with Number Functions in Oracle SQL
How to work with String Functions in Oracle SQL
How to work with Translate Function in Oracle SQL
How to work with Replace Function in Oracle SQL
How to work with Decode Function in Oracle SQL
How to work with Case Function in Oracle SQL
How to work with Sub string Function in Oracle SQL
How to work with In string Function in Oracle SQL
How to work with Date Functions in Oracle SQL
How to work with Conversion Functions in Oracle SQL
How to work with General Functions in Oracle SQL
How to work with Aggregate Functions in Oracle SQL
10 - Constraints
***********************
How to work with Primary Key in Oracle SQL
How to work with Composite Primary Key in Oracle SQL
How to work with Unique Key in Oracle SQL
How to work with Not Null in Oracle SQL
How to work with Check in Oracle SQL
How to work with Default in Oracle SQL
How to work with Foreign Key in Oracle SQL
11 - Joins
*************
How to work with Simple Join in Oracle SQL
How to work with Outer Join in Oracle SQL
How to work with Self Join in Oracle SQL
12 - Synonyms
*********************
What is Synonyms in Oracle SQL
How to work with Private Synonym in Oracle SQL
How to work with Public Synonym in Oracle SQL
13 - Views Part
*********************
How to work with Simple View in Oracle SQL
How to work with Complex View in Oracle SQL
How to work with Force View in Oracle SQL
How to work with Vertical View in Oracle SQL
How to work with Horizontal View in Oracle SQL
How to work with Functional View in Oracle SQL
How to work with Partition View in Oracle SQL
How to work with Materialized View in Oracle SQL
How to work with Inline View in Oracle SQL
15 - Indexes, Clusters & Sequences
**************************************************
How to work with Simple Index in Oracle SQL
How to work with Complex Index in Oracle SQL
How to work with Unique Index in Oracle SQL
How to work with Functional Index in Oracle SQL
How to work with Bitmap Index in Oracle SQL
How to work with Clusters in Oracle SQL
How to work with Sequences in Oracle SQL
16 - Sub Queries
************************
How to work with Sub Queries in Oracle SQL
How to work with Sub Queries with Examples
About the Provider
Course Provider Contact
Let Employers Find You
Upload/Update Your CVFeatured Courses