ORACLE TRAINING PROGRAM
DURATION | 1.5 MONTHS
The Oracle Database is a relational database management system (RDBMS). A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.
PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java.
What we offer:
- What is Oracle , History and Development
- Features of Oracle
- Difference between Oracle/SQL Server
- What’s New in Oracle different versions
- Other Databases
- Fundamentals of Datatypes Used
- Create Table / Create Table As
- Alter Table / Drop Table
- Global Temp / Local Temp Tables
- Oracle Views
- Oracle Index
- Oracle Queries
- Oracle Select
- Oracle Insert / Insert All
- Oracle Update
- Oracle Delete
- Truncate
- Import / Export
- Backup / Recovery
- Transaction Processing
- (Commit, RollBack)
- Advance DBA Commands
- Orcale GUI Tool
- PL/SQL Variables
- PL/SQL Constant
- PL/SQL Control Statements
- PL/SQL Cursor
- PL/SQL Procedure
- PL/SQL Function
- PL/SQL Trigger
- PL/SQL Exception Handling