ORACLE SQL Online Training Course Content :

Oracle SQL Online Training

Infrastructure setup
 Installation of Virtual workstation
 Installation of Operating system
 Assigning static ip to Ethernet
 Login to the OS
 Installing Virtual tools
 Sharing of Folders from host OS to virtual OS
 Cloning of OS in virtual workstation
 Start and Shut of OS

Installing ORACLE And Database creation

 Installing Oracle binary

 Database creation

Connecting to Database

 SQLPLUS tool

 Verify database name

 Verify database status

 Verify control file location

 Verify data files location

 Verify redo log files location

 Shut database

 Startup database

Data Definition language : Learn Oracle SQL

 Create

 Alter

 Drop

 Truncate

 Rename

Data Manipulation Language

 Insert

 Update

 Delete

Data Retrieval Language:

 Select

Transaction Control Language

 Commit

 Rollback

 Save point

Data control Language

 Grant

 Revoke

Conditional selections and operators

 Where

 Order by

 Arithmetic operators

 Comparison operators

 Logical operators

Aliases

 Using aliases

 Column aliases

Merge

 Merge

 Multiple inserts

Functions

 Single row function

 Group functions

 Numeric functions

 String functions

 Date functions

 Miscellaneous functions

 Conversion functions

Constraints

 Domain integrity constraints

 Not null

 Check

 Entity integrity constraints

 Unique

 Primary key

 Referential integrity constraints

 Foreign key

Case and default

 Case

 Default

Abstract data types in Learn Oracle SQL

Object view and methods

Varrays and nested tables

Flashback query

External tables

Ref deref value

Object view with references

Partitions

Group by and having

Roll up grouping cube

Set operators

Views

Synonym and sequence

Joins

Sub queries and exists

Walkup trees and inline view

Locks

Thanks…………………….!

Oracle SQL Certification