vlr training

Oracle SQL & PLSQL Online Training Course Details

Course Duration

60 Days



Mode of Training


Oracle SQL & PLSQL Course Content

  • What is Data?
  • What is database?
  • What is DBMS &
  • RDBMS?
  • What is Schema?
  • Creation
  • Grant Privileges
  • Connect to DB
  • Character Data Type
  • Numeric Data Type
  • Date Data Type
  • Nchar Data Type
  • Lob
  • Raw
  • Long
  • Single line comment —
  • Multiline comment /*….*/
  • Drop
  • Truncate
  • Rename
  • Update
  • Delete
  • Insert
  • Commit
  • Rollback
  • Savepoint
  • Comparison Operators (=,!=,<,>,>=,<=)
  • Arithmetic Operators (+,-,*,/)
  • SQL*PLUS operators : Between, Not Between, IN, NOT IN, IS NULL, IS NOT NULL
Primary Key     Assign Constraint
Foreign Key /Reference Key                             At Column Level
Unique KeyAllow Null values and restrict Duplicates                           At Table Level
Not NullAllow duplicate values and not allow null values  Alter Constraints
Check ConstraintsApplying condition    Enable Constraints
DefaultIt is not constraint   Disable Constraints
      Drop Constariants
General Functions  Types Of Function      
 UPPER General Functions      
 Lower Charcter Functions      
 NVL Numaric Functions      
 NVL2 Date Function      
AliasColumn Alias        
 Table Alias        
 CONCAT Key Word        
 CONCAT SYMBOL ||        
Character Functions   DATE Functions    
 UPPER   Date Format    
 LOWER   Change Session Date format   
 SUBSTRING(SUBSTR)   Date Arithmetic funcitons    
 PADDINGLPADRPAD Months Between    
 TRIMLTRIMRTRIM Next Day Function    
 REPLACE   Last Day Function    
 TRANSLATE   Rounding of Dates    
 DECODE   Truncating Dates    
 CASE  Conversion Functions    
Numaric Funcitons    TO_CHAR Dollar Indicator Month Day Indicator
 Round   TO_DATE Zero indicator Year Day indicator
 TRUNC   TO_NUMBER Digit Place Marker Abbrebiated Week Day
 CEIL   Decimal Indicator ISO currency Indicator ISO standard Year Week  IW
 FLOOR   Group Separator Date Format Moels ISO standard 4 digit year IYYY
 MODULE   Local Currency Indicator AD or BC Indicator  
 POWER   Trailing minus Indicator Meridian Indicator  
 SQUARE ROOT   Negative Number IndicatorCurrncy Indicator  
 ABSOLUTE   Roman Number Indicator Numeric Week day  
 SIGN   Sign Indicator Week Day Spelling  
Group Functions  HAVING Miscellaneous Functions    
 SUM   Least    
 MIN   Greatest    
 Equi Join Non Equi Join
 Inner Join/ Natural Join/ Simple Join 
 Outer Join  
      Left Outer Join  
      Right Outer Join  
      Full Outer join  
 Sef Join  
 Cartesian Products / Cross Join  
Parent Query/ Outer Query / Main Query
Child Query / Inner Query / Sub Query
Sub Query       
 Root Query Purpose of a sub Query Single Row Sub Query !=, =,>,>=,<,<=
 Parent Query / Root Query / Main QuerySub Query Principle Multiple Row Sub Query IN, ANY, ALL
 Child Query / Inner Query / Sub QuerySub Query Usage Co-Related Sub Query  
   Guidelines ofr using Subquery    
 Appling Group function in Sub query     
 Appling Having clause in sub query     
 Null values In a sub Query      
Set Operators      OBJECTS
 UNION ALL     Type
 UNION     REF()
ViewsSimple View     1*2=2
 Materialized View      
 Inline View      
IndexsSimple Index/ Normal Index Bitmap Index Composite Index
 Partitioned Index Function Based Indexes Domain Indexes
Hierarchical QueriesStarts With Connect BYLEVELLISTAGG
PSEUDO ColumnsSYSDATERowidRownumCurrvalNextVAL
  • RANK

Oracle SQL & PLSQL Demo Videos

Register Now for Oracle SQL & PLSQL Live Demo