• support@conveytechlabs.com

online_training [woocommerce_currency_switcher_drop_down_box]


In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language.
SKU: WOO-SINGLES Categories: ,

Course Description

SQL is a standard language for storing, manipulating and retrieving data in databases. SQL stands for Structured Query Language. SQL lets you access and manipulate databases. SQL is an ANSI (American National Standards Institute) standard.

Course Information

  • Duration: 30 hrs
  • Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
  • Method: Online/Classroom Training
  • Study Material: Soft Copy

Course Content

SQL, PL SQL Course Out Line

Introduction to RDBMS


  •   Writing Basic  SQL SELECT Statements
  •   Restricting and Sorting Data
  •   Single-Row Functions
  •   Displaying Data from Multiple Tables
  •   Aggregating Data  Using Group Functions
  •   Subqueries
  •   Manipulating Data
  •   Creating and Managing Tables
  •   Including Constraints
  •   Creating Views
  •    Other Database Objects
  •     Controlling User Access

—   Pl/SQL

  •     Declaring Variables
  •   Writing Executable Statements
  •   Interacting with the Oracle Server
  •    Writing Control Structures
  •    Working with Composite Data Types
  •   Writing Explicit Cursors
  •   Advanced Explicit Cursor Concepts
  •   Handling Exceptions
  •   Creating Procedures
  •   Creating Functions
  •   Managing Subprograms
  •    Creating Packages
  •   More Package Concepts
  •   Creating Database Triggers
  •   Advanced Database coding techniques

Key Features

  • Career oriented training.
  • One to One live interaction with a trainer.
  • Demo project end to end explanation.
  • Interview guidence with resume preparation.
  • Support with the trainer through E-mail.

Live Traffic

Live Traffic Feed