GIT Solutions Pvt Ltd is a comprehensive repository for online, offline courses offering high quality state-of-the-art IT and business related training and courses. GIT commenced its IT Education & training business and has trained over thousands of students. GIT is an ISO 9001:2008 certified training institute with its presence in and around Andhra Pradesh and Telangana

Grafx-IT-Solutions

ORACLE PL/SQL

  • About
  • Duration

SQL lets you work with data at the logical level. You need to be concerned with the implementation details only when you want to manipulate the data. For example, to retrieve a set of rows from a table, you define a condition used to filter the rows. All rows satisfying the condition are retrieved in a single step and can be passed as a unit to the user, to another SQL statement, or to an application. You need not deal with the rows one by one, nor do you have to worry about how they are physically stored or retrieved. All SQL statements use the optimizer, a part of Oracle Database that determines the most efficient means of accessing the specified data. Oracle also provides techniques that you can use to make the optimizer perform its job better.

Length : 30 Hours

Course Content

  • SQL
  • Introduction Database
  • Database Models
  • SQL Statements
  • Operators
  • SQL Functions
  • Clauses
  • Constraints
  • Joins
  • User Creation
  • Creating duplicate tables
  • Set Operators
  • Savepoints
  • Sequences
  • Subqueries
  • Synonyms
  • PL/SQL
  • Introduction PL/SQL Programming
  • Basic PL/SQL Programs
  • PL/SQL Progam with Conditions
  • PL/SQL Progam with Loops
  • Procedures
  • Functions
  • Cursors
  • Triggers
  • Exception Handling
  • Packages