PL\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
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
Constraints  Domain integrity constraints
Not null Check Entity integrity constraints Unique Primary key Referential integrity constraints Foreign key
Case and 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
contact: india:8121311133 usa:+1-347-606-2716 contact:@ithubonlinetraining.com http://www.ithubonlinetraining.com/oracle-sql-online-training/