Oracle PL/SQL Training

1. Overview of relational database concepts

2. SQL Development environment

3. Introduction to SQL

4. Writing queries for data extraction

5. Restricted and sorted data

6. Usage of single-row functions to customize output

7. Conversion functions and Conditional expressions

8. Aggregated data using Group functions

9. Display data from multiple tables

10. Sub Queries

11. Set Operators

12. DDL statements to create and manage tables

PL/SQL

1. Introduction to PL/SQL

2. PL/SQL Blocks

3. Control Structures – Loops

4. Cursors

5. Exception handling

6. Stored Procedures and Functions

7. Triggers

A Basic knowledge of Computer Systems

Data is the building ground for any organization. Trainers have years of experience in building and extracting data from large databases. They have worked in bigger corporations and know what is required to be a good database developer. They share their knowledge through blogs.  

After the completion of the course and the exam, you will be awarded with the course completion certificate.

16 hours