plsql online training with real time experts

1
PL\SQL ONLINE
TRAINING
2
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

3
Installing ORACLE And Database creation

• Installing Oracle binary
• Database creation

4
Connecting to Database

• SQLPLUS toolVerify database nameVerify database
  statusVerify control file locationVerify data
  files locationVerify redo log files
  locationShut databaseStartup database

5
PLSQL FRAME WORK
6
Functions

• Single row functionGroup functionsNumeric
  functionsString functionsDate
  functionsMiscellaneous functionsConversion
  functions

7
Constraints

• Domain integrity constraintsNot
  nullCheckEntity integrity constraintsUniquePri
  mary keyReferential integrity constraintsForeign
  key

8
Case and default

• Abstract data types
• Object view and methods
• Varrays and nested tables
• Flashback query
• External tables
• Ref deref value

9
(No Transcript)
10
contact india8121311133 usa1-347-606-2716 cont
act_at_ithubonlinetraining.com http//www.ithubonlin
etraining.com/oracle-sql-online-training/