Oracle SQL certification

Oracle SQL Online Training Course Overview :


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

 Create
 Alter
 Drop
 Truncate
 Rename

Data Manipulation Language

 Insert
 Update
 Delete

Data Retrieval Language:ORACLE SQL Online Training

 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 ORACLE SQL Online Training

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

HOMEWHY USOUR STRATEGY
PROJECT SUPPORTBLOGBECOME AN Instructor
CONTACT USWEB DESIGNINGOUR SERVICES
LEARNER SIGN UPTRAINER SIGN UPREFER A FRIENDSITEMAP
Copy rights © HyderabadSys.com