Oracle Database Training Course

Oracle Database training is offered by AEIT for all skill level. Our courses integrate Practical, Hands-on Training & Exposure with Industry Use Case Studies and Real Projects using datasets from companies like Uber, Amazon, Sandisk, Nike, Swiggy, Yelp, and Walmart, etc.

Content:

• History of Oracle
• Basic Oracle
• Why and Scope of Oracle
• Oracle as Open source Technology
• Oracle for Web Based Application
• Oracle Database Engines (INNODB , MyISAM etc.. )
• Oracle Data Types (INT , Varchar , Date , timestamp etc..)
• Oracle Create Database Query
• Oracle List Database Query
• Oracle Create Table
• Oracle List Tables in database Query
• Oracle Show Table Fields
• Oracle er query
• Oracle Primary Key Constraint
• Oracle Unique Key Constraint
• Oracle Full Text Key Constraint
• Oracle Foreign Key Constraint
• Oracle Where clause
• Oracle Alias
• Oracle Where clause with AND Logic
• Oracle Where clause with OR Logic
• Oracle Where clause with AND & OR Logic
• Oracle Like Query with wild card character
• Oracle Between Query with Example
• Oracle Order By Query with Example
• Oracle Group By Query with Example
• Oracle Having Clause
• Oracle Sub Query Example
• Import and Export through Command line
• Import and Export through PHPMYADMIN Tool
• Oracle Functions - AVG()
• Oracle Functions - MIN()
• Oracle Functions - MAX()
• Oracle Functions - COUNT()
• Oracle Functions - SUM()
• Oracle Functions - ROUND()
• Oracle Functions - CONCAT()
• Oracle Functions - LCASE()
• Oracle Functions - UCASE()
• Oracle Functions - repeat()
• Oracle Functions - substr()
• Oracle Functions - strpos()
• Oracle Functions - sqrt()
• Oracle Functions - power()
• Oracle Functions - abs()
• Oracle Functions - concat_ws()
• Oracle Functions - concat()
• Oracle Functions - curdate()
• Oracle Functions - curtime()
• Oracle Functions - datediff()
• Oracle Functions - hour()
• Oracle Functions - second()
• Oracle Functions - day()
• Oracle Functions - month()
• Oracle Functions - now()
• Oracle inner Join
• Oracle Left Join
• Oracle Right Join
• Oracle Natural Join
• Oracle Roll back and Commit
• Oracle Union
• Oracle Query Optimization Concept
• Oracle Views
• Oracle Stored Procedures
• Oracle Triggers
• Oracle Functions
• Oracle Clustering
• Oracle Indexing
• Oracle Database Normalisation concept