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
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
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 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/