PL/SQL Courses in Kolkata

Course Details

This database language is learnt in depth from our facilities. These are the building blocks of database programmes and has huge market value. You will be trained in areas like: i) Introduction ii) Overview of Oracle Database 12c and related products iii) Overview of relational database management concepts and terminologies iv) Introduction to SQL and its development environments v) The HR schema and the tables used in this course vi) Oracle Database documentation and additional resources vii) Retrieve Data using the SQL SELECT Statement viii) List the capabilities of SQL SELECT statements ix) Generate a report of data from the output of a basic SELECT statement

Course Details

This database language is learnt in depth from our facilities. These are the building blocks of database programmes and has huge market value. You will be trained in areas like: i) Introduction ii) Overview of Oracle Database 12c and related products iii) Overview of relational database management concepts and terminologies iv) Introduction to SQL and its development environments v) The HR schema and the tables used in this course vi) Oracle Database documentation and additional resources vii) Retrieve Data using the SQL SELECT Statement viii) List the capabilities of SQL SELECT statements ix) Generate a report of data from the output of a basic SELECT statement

Course Details

This Course also includes Creating Subqueries, Aggregating Data Using Group Functions, Working With Character Functions. The PL/SQL programming training is an intense course that is designed to give the student hands-on exposure to Oracle PL/SQL.

Course Details

This database language is learnt in depth from our facilities. These are the building blocks of database programmes and has huge market value. You will be trained in areas like: i) Introduction ii) Overview of Oracle Database 12c and related products iii) Overview of relational database management concepts and terminologies iv) Introduction to SQL and its development environments v) The HR schema and the tables used in this course vi) Oracle Database documentation and additional resources vii) Retrieve Data using the SQL SELECT Statement viii) List the capabilities of SQL SELECT statements ix) Generate a report of data from the output of a basic SELECT statement

Course Details

These database language is learnt in depth from our facilities. These are the building blocks of database programmes and has huge market value.

You will be trained on areas like:

i) Introduction

ii) Overview of Oracle Database 12c and related products

iii) Overview of relational database management concepts and terminologies

iv) Introduction to SQL and its development environments

v) The HR schema and the tables used in this course

vi) Oracle Database documentation and additional resources

vii) Retrieve Data using the SQL SELECT Statement

viii) List the capabilities of SQL SELECT statements

ix) Generate a report of data from the output of a basic SELECT statement

Course Details

Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures, Update database content with SQL and transaction handling, Retrieve data with filter conditions and from multiple tables using various types of join, Process data with row and aggregate functions, Creating and modifying tables, constraints and indexes, Modifying table contents, Retrieving data from tables, Applying conditions to filter retrieved rows, Joining multiple tables, Applying row and aggregate functions are some of the topics of this programme.