TypeClassroom Training
REGISTER
pl/sql training

Overview

Audience & Prerequisites

Course Outline

Schedule & Fees

Certification

PL/SQL Training 

SQL/PL-SQL course provides basic and advanced concepts of SQL. Our SQL/PL-SQL course is designed for beginners and professionals.

PL/SQL is a block-structured language that can have multiple blocks in it.

Our SQL/PL-SQL course includes all topics of PL/SQL language such as conditional statements, loops, arrays, string, exceptions, collections, records, triggers, functions, procedures, cursors, etc. The course is aimed to enhance the skills in writing a query for extracting data from a database which will help a professional to work with more proficiency.

Objectives

  • Introduction To SQL & RDBMS
  • Concepts & Database, Creating Database & Tables
  • SQL Data Types
  • Using DDL & DML( Insert , Delete, Update, Select Statements
  • Concept of Primary Keys, NULL Constraints, Default Constraint, Unique Constraints, Check Constraints …etc.
  • Use of Where Clause along with AND, OR, NOT, IN Keywords
  • Use of Scalar Functions Like Sum, Count, Avg, Max, Min Functions
  • Modifying the Structure of a Table, Deleting a Table
  • Creating a View, Modifying a View, Deleting a View
  • Using DDL & DML( Insert , Delete, Update, Select Statements
  • Creating and Executing a Procedure
  • Passing Parameters to a Procedure and returning values from a Procedure
  • Creating a View , Modifying a View , Deleting a View
  • Creating a Trigger and its usage
PL/SQL
PL/SQL 1

PL/SQL is a block-structured language that can have multiple blocks in it.

Course Provider: Organization

Intended Audience

  • This course is for persons who are using Databases in their office on day to day basis. This Course is going to help them definitely to understand the concepts of SQL & PL/SQL Commands. A well-defined course curriculum along with highly experienced faculty members will teach the subject matter as simple as possible with enormous practical scenarios.

Pre-requisites

  • Knowledge in using Computers is sufficient. However little bit knowledge in any RDBMS will be an added advantage.

 

PL/SQL
PL/SQL 2

PL/SQL is a block-structured language that can have multiple blocks in it.

Course Provider: Organization

Course Outline                                                  Duration: 4 Days

 
  1. An Introduction to SQL & RDBMS
  • Introduction To SQL & RDBMS
  • Concepts & Database, Creating Database & Tables
  • SQL Data Types
  • Using DDL & DML( Insert , Delete, Update, Select Statements
  • Concept of Primary Keys, NULL Constraints, Default Constrainst,Unique Constraints, Check Constraints …etc.
  • Use of Where Clause along with AND, OR, NOT, IN Keywords
  1. Using DDL ,DML Statements
  • Use of Scalar Functions Like Sum, Count, Avg, Max, Min Functions
  • Modifying the Structure of a Table, Deleting a Table
  • Creating a View, Modifying a View, Deleting a View
  • Using DDL & DML( Insert , Delete, Update, Select Statements
  • Concept of SQL Injection, Concept of SQL Parameters
  1. Triggers, Procedures, Cursors
  • Creating and Executing a Procedure
  • Passing Parameters to a Procedure and returning values from a Procedure
  • Creating a View, Modifying a View, Deleting a View
  • Creating a Trigger
  • Deleting a Trigger
  • Creating a Cursor and use of Cursor
  1. PL-SQL Exceptions
  • Understanding the concept of Exception
  • Exception Handling Techniques
  • Raising an Exception

 

PL/SQL
PL/SQL 3

PL/SQL is a block-structured language that can have multiple blocks in it.

Course Provider: Organization

Please write to us at [email protected] & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

PL/SQL
PL/SQL 4

PL/SQL is a block-structured language that can have multiple blocks in it.

Course Provider: Organization

For more info kindly Contact Us.

PL/SQL
PL/SQL 5

PL/SQL is a block-structured language that can have multiple blocks in it.

Course Provider: Organization

PL/SQL training courses and certification gurgaon gurugram haryana PL/SQL training institutes in gurgaon PL/SQL training and certification PL/SQL training in delhi PL/SQL  pmp training PL/SQL  certification fees PL/SQL training with exam mercury solutions PL/SQL training PL/SQL certification cost PL/SQL certification path PL/SQL certification online PL/SQL certification salary PL/SQL certification cost in india 2019 who should do PL/SQL certification PL/SQL certification quora PL/SQL certification cost in india 2018 PL/SQL  certification PL/SQL training gurgaon PL/SQL  certification cost PL/SQL  full form PL/SQL certification india PL/SQL certification online PL/SQL certification training PL/SQL certification pune PL/SQL certification in delhi

PL/SQL
PL/SQL 6

PL/SQL is a block-structured language that can have multiple blocks in it.

Course Provider: Organization