What is Oracle?
Oracle Database is a fully scalable relational database architecture and is often used by global enterprises which manage and process data across wide and local area networks. the most flexible and cost-effective way to manage information and applications.
Why learn Oracle?
It is widely used in enterprise applications. Oracle database such as insert record, update a record, delete record, select record, create a table, drop table, etc.
Prerequisites for learning Oracle.
What we will learn in Oracle?
- What is DBMS
- What is Database
- Type of Database
- What is RDBMS
- Different Between RDBMS and DBMS
- Syntax
- Datatype
- Operator
- Create database in Oracle/MySQL/SqlServer
- Drop Database
- Rename Database
- Select Database
- Create Table
- Drop Table
- Select Table
- Delete Table
- Rename Table
- Truncate Table
- Copy Table
- Alter Table
- Select Statement
- Select Unique
- Select Distinct
- Select Last
- Select First
- Select Top
- Select Random
- Select As
- Select In
- Select multiple
- Select Date
- Select Sum
- Select Null
- Where
- And
- Or
- With
- As
- Distinct
- From
- Order By
- Group By
- Having
- By Clause
- By Asc
- By Desc
- By Random
- By Limit
- By Multiple Column
- Numeric Function
- Character Function
- Date Time Function
- Conversion Function
- Sum
- Max
- Min
- Avg
- In to Value
- In to Select
- Multiple Row
- Update Join
- Update Row
- Delete Table
- Delete Row
- Delete all row
- Duplicate Row
- Delete Database
- Delete Join
- Delete view
- Outer Join
- Inner Join
- Equi Join
- Left Join
- Right Join
- Cross Join
- Full Join
- Primary Key
- Unique Key
- Foreign Key
- Composite Key
- Alternate Key
- Union
- Union All
- Intersect
- Minus
- Variable
- Constan
- If
- Case
- Loop
- Exit Loop
- While Loop
- For Loop
- Continue
- GoTo
- After Trigger
- Before Trigger
Teaching Mode: Online / Offline
Address: 259, 1A, Vinoba Nagar, Naini, Prayagraj, Uttar Pradesh 211010
Contact number : 05323557581, +91-9555433745