• support@conveytechlabs.com

SQL, PL SQL

Duration
30 - 36 Hours
Type
online

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.

     

    • Duration: 30 – 36 hrs
    • Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
    • Method: Online/Classroom Training
    • Study Material: Soft Copy
    Introduction to RDBMS
    SQL
    • 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
    • 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.