coursecontent


Hadoop Online Training




Data Warehouse Training




Java Online Training




Microsoft Online Training




Oracle Online Training




SAP Online Training




Siebel Online Training




Testing Tools Training




Tibco Online Training




Android Online Training




Scripting Online Training




PeopleSoft Online Training




Web Design Online Training




Other Courses



Oracle SQL Online Training

Oracle SQL Online Training by Real time Experts:

Oracle SQL Online Training Course Content:

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

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

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

Enquiry Now

Our HighLights

Please check your short code, no records available.