Android Programming
Oracle (SQL, PL/SQL)                                                                                              Duration:  1 Month
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::
  • Introduction of RDMS & Oracle
    • Difference between Oracle/SQL Server
    • Features of Oracle
    • What's New in Oracle different versions
  • SQL Commands
    • DDL
      • Create, Alter, Drop
    • DML
      • Insert, Select, Update, Delete, Truncate
    • DCL
    • Views
    • Functions
  • Query with Data Dictionary
  • Import / Export
  • Backup / Recovery
  • Transaction Processing
    (Commit, RollBack)
  • Advance DBA Commands
  • PL / SQL
    • PL/SQL Block
    • Cursor
    • Procedure
    • Function
    • Trigger
    • Exception Handling
  • Oracle GUI Tool

Copyright 2019 Sunrise Technologies