UrbanPro
true

DBMS & RDBMS Training in Kolkata (Aptech Computer Education Hazra)

LIVE
Ongoing

Course offered by Aptech Hazra

0 review

DBMS & RDBMS Training in Kolkata (Aptech Computer Education Hazra)

DATABASE:

Create projects for Oracle Database applications.

Database project is a modern and dynamically developing technology. You have a chance to contribute to concept development.


Introduction to SQL & Programming with PL/SQL
Session Coverage:
Chapter 1: Database Design

    Database Models
    Beginnings
    Some Introductory Terminology
    Codd's 12 Rules
    Normalization
    First Normal Form
    Higher Order Normal Forms

Chapter 2: Oracle Standard Interfaces

    SQL
    SQL*Plus
    Oracle Architecture
    Interfaces to Oracle
    Command Line Interface
    Viewing a Sample Table
    The Graphical User Interface
    The SQL Buffer
    The Web-Based Interface
    Describe

Chapter 3: The Sample Database

    The Entity Relationship Model
    Entity Relationship Diagrams
    The Sample Database
    ER Diagram for Sample Database
    Creating the Sample Data
    Viewing Sample Data
    Data Types of the Sample Data

Chapter 4: Data Definition Language

    Categories of SQL Statements
    Oracle Datatypes
    The CREATE Statement
    The DROP Command
    The ALTER Command
    Integrity Constraints
    Entity Integrity Constraints
    Referential Integrity Constraints
    Modifying Table to Use Constraints
    Checking Constraints
    The Data Dictionary

Chapter 5: Data Manipulation Language

    DML Statements
    The SELECT Statement
    The INSERT Statement
    The DELETE Statement
    The UPDATE Statement
    More SQL*Plus Commands

Chapter 6: Transaction Control

    Transactions
    Command Classification
    Savepoints
    The SET TRANSACTION Command
    The SET TRANSACTION Command
    The SET TRANSACTION Command

Chapter 7: SQL Operators

        Simple Selects
        Comparison Operators
        IN and NOT IN Operators
        BETWEEN Operator
        The LIKE Operator
        Logical Operators
        IS NULL and IS NOT NULL
        ANY
        ALL

Chapter 8: SQL FUNCTIONS

    Introduction
    The DISTINCT Keyword
    Aliases
    Miscellaneous Functions
    Mathematical Functions
    String Functions
    Date Functions
    Conversion Functions
    Pseudo Columns

Chapter 9: Joining Tables

    Joins
    Cartesian Product
    Inner Joins
    Equi-Join
    Table Aliases
    Non-Equi Join
    Non-Key Join
    Reflexive Join
    Natural Join
    Outer Joins
    Right Outer Join
    Left Outer Join
    Full Outer Join
    Oracle-Specific Syntax for Outer Joins

Chapter 10: Set Operators

    Introduction
    Selection Criteria
    Union
    Union All
    Intersect
    Minus

Chapter 11: SQL Subqueries

    Introduction
    Using a Subquery with a DML Statement
    Typical Subqueries
    Subquery Operators
    Standard vs. Correlated Subqueries
    Correlated Subquery Example
    Predicate Operators

Chapter 12: Groups

    SQL Statements
    GROUP BY Clause
    HAVING Clause
    Order of a SELECT Statement

Chapter 13: More Database Objects

    More Database Objects
    Relational Views
    Updating a View
    Create or Replace
    Forcing a View
    The Data Dictionary Revisited
    Indexes
    Synonyms

Chapter 14: Reports

    Report Features
    Session Control
    The SET Command
    The COLUMN Command
    The BREAK Command
    The COMPUTE Command

Chapter 15: Introduction

    SQL vs. PL/SQL
    A Few Simple Examples
    Saving Procedures
    A More Complete Picture
    Comments
    Variable Substitution
    Simple Exception Handling
    Advantages of PL/SQL
    Assignments

Chapter 16: Declarations and Data Types

    Declarations
    Standard Data Types
    Initialization
    Variable Names
    Specialized Data Types - %TYPE
    Specialized Data Types - %ROWTYPE
    Building Your Own Data Types - Records
    A Quick look at Loops
    Arrays
    Tables
    Nested Blocks

Chapter 17: Language Components

    Introduction
    Assignments
    Decision Making Statements
    Simple Loops
    Loops - for
    Loops - indefinite
    Loops - while
    Simple Loops
    Nested Loops
    Boolean Variables
    PL/SQL Relational Operators
    PL/SQL Logical Operators
    The CASE Construct

Chapter 18: Cursors

    Introduction
    Cursor Manipulation
    Using the Cursor
    For Loops Cursors
    Cursor Attributes
    Cursor Parameters
    Nested Cursors
    Cursor Exceptions

Chapter 19: Exceptions

    Errors in Programs
    Run Time Exceptions
    Oracle Built In Exceptions
    Unnamed Exceptions
    Built in Exception Functions
    Creating Your Own Exceptions
    Building Non Terminating Exceptions

Chapter 20: Functions and Procedures

    Introduction
    Creating a Procedure
    Example Procedure
    Using Parameters
    Functions
    Procedures and Exceptions

PROJECT WORK
ORACLE: FORMS & REPORTS

The curriculum contents are specially designed for those who are keen on getting themselves a career in the field of web application development.The course focuses on designing full-fledge web applications using J2EE technologies.
Course Highlights:

    The collaborative cloud-based learning platform that adds to your classroom learning experience
    Mapped to Global Certification- Oracle forms developer certified Professional
    Latest Infrastructure
    Certified trainers
    Structured learning

Oracle Forms Training

    Introducing Oracle Forms Developer and Forms Services

    Creating Forms Modules

    Working with Data Blocks and Frames

    Working with Input Items

    Working with Non Input Items

    Working with Windows and Canvases

    Producing Triggers

    Debugging Triggers

    Adding Functionality to Items

    Run-Time Messages and Alerts

    Query Triggers

    Validation

    Navigation

    Transaction Processing

    Writing Flexible Code

    Sharing Objects and Code

    Using WebUtil to Interact with the Client

Oracle Reports Training

    Basic Concepts
    Advanced Concepts
    Visual Index

How To â?¦?

    Access Oracle Reports Documentation
    Set Properties and Preferences
    Perform Common Tasks
    Work with the Object Navigator
    Work with Reports
    Work with Web Reports
    Run and Dispatch a Report
    Work with the Data Model
    Work with the Report Layout
    Work with Report Sections
    Work with Parameters and the Parameter Form
    Define a Template
    Use PL/SQL in a Report or Template
    Debug a Report
    Integrate with Other Products
    Administer Oracle Reports Builder

PROJECT WORK

About the Trainer

Avg Rating

0 Reviews

0 Students

44 Courses

DBMS & RDBMS Training in KOlkata (Aptech Computer Education Hazra)



DATABASE

Create projects for Oracle Database applications.

Database project is a modern and dynamically developing technology. You have a chance to contribute to concept development.


Introduction to SQL & Programming with PL/SQL
Session Coverage:
Chapter 1: Database Design

Database Models
Beginnings
Some Introductory Terminology
Codd's 12 Rules
Normalization
First Normal Form
Higher Order Normal Forms

Chapter 2: Oracle Standard Interfaces

SQL
SQL*Plus
Oracle Architecture
Interfaces to Oracle
Command Line Interface
Viewing a Sample Table
The Graphical User Interface
The SQL Buffer
The Web-Based Interface
Describe

Chapter 3: The Sample Database

The Entity Relationship Model
Entity Relationship Diagrams
The Sample Database
ER Diagram for Sample Database
Creating the Sample Data
Viewing Sample Data
Data Types of the Sample Data

Chapter 4: Data Definition Language

Categories of SQL Statements
Oracle Datatypes
The CREATE Statement
The DROP Command
The ALTER Command
Integrity Constraints
Entity Integrity Constraints
Referential Integrity Constraints
Modifying Table to Use Constraints
Checking Constraints
The Data Dictionary

Chapter 5: Data Manipulation Language

DML Statements
The SELECT Statement
The INSERT Statement
The DELETE Statement
The UPDATE Statement
More SQL*Plus Commands

Chapter 6: Transaction Control

Transactions
Command Classification
Savepoints
The SET TRANSACTION Command
The SET TRANSACTION Command
The SET TRANSACTION Command

Chapter 7: SQL Operators

Simple Selects
Comparison Operators
IN and NOT IN Operators
BETWEEN Operator
The LIKE Operator
Logical Operators
IS NULL and IS NOT NULL
ANY
ALL

Chapter 8: SQL FUNCTIONS

Introduction
The DISTINCT Keyword
Aliases
Miscellaneous Functions
Mathematical Functions
String Functions
Date Functions
Conversion Functions
Pseudo Columns

Chapter 9: Joining Tables

Joins
Cartesian Product
Inner Joins
Equi-Join
Table Aliases
Non-Equi Join
Non-Key Join
Reflexive Join
Natural Join
Outer Joins
Right Outer Join
Left Outer Join
Full Outer Join
Oracle-Specific Syntax for Outer Joins

Chapter 10: Set Operators

Introduction
Selection Criteria
Union
Union All
Intersect
Minus

Chapter 11: SQL Subqueries

Introduction
Using a Subquery with a DML Statement
Typical Subqueries
Subquery Operators
Standard vs. Correlated Subqueries
Correlated Subquery Example
Predicate Operators

Chapter 12: Groups

SQL Statements
GROUP BY Clause
HAVING Clause
Order of a SELECT Statement

Chapter 13: More Database Objects

More Database Objects
Relational Views
Updating a View
Create or Replace
Forcing a View
The Data Dictionary Revisited
Indexes
Synonyms

Chapter 14: Reports

Report Features
Session Control
The SET Command
The COLUMN Command
The BREAK Command
The COMPUTE Command

Chapter 15: Introduction

SQL vs. PL/SQL
A Few Simple Examples
Saving Procedures
A More Complete Picture
Comments
Variable Substitution
Simple Exception Handling
Advantages of PL/SQL
Assignments

Chapter 16: Declarations and Data Types

Declarations
Standard Data Types
Initialization
Variable Names
Specialized Data Types - %TYPE
Specialized Data Types - %ROWTYPE
Building Your Own Data Types - Records
A Quick look at Loops
Arrays
Tables
Nested Blocks

Chapter 17: Language Components

Introduction
Assignments
Decision Making Statements
Simple Loops
Loops - for
Loops - indefinite
Loops - while
Simple Loops
Nested Loops
Boolean Variables
PL/SQL Relational Operators
PL/SQL Logical Operators
The CASE Construct

Chapter 18: Cursors

Introduction
Cursor Manipulation
Using the Cursor
For Loops Cursors
Cursor Attributes
Cursor Parameters
Nested Cursors
Cursor Exceptions

Chapter 19: Exceptions

Errors in Programs
Run Time Exceptions
Oracle Built In Exceptions
Unnamed Exceptions
Built in Exception Functions
Creating Your Own Exceptions
Building Non Terminating Exceptions

Chapter 20: Functions and Procedures

Introduction
Creating a Procedure
Example Procedure
Using Parameters
Functions
Procedures and Exceptions

PROJECT WORK
ORACLE: FORMS & REPORTS

The curriculum contents are specially designed for those who are keen on getting themselves a career in the field of web application development.The course focuses on designing full-fledge web applications using J2EE technologies.
Course Highlights:

The collaborative cloud-based learning platform that adds to your classroom learning experience
Mapped to Global Certification- Oracle forms developer certified Professional
Latest Infrastructure
Certified trainers
Structured learning

Oracle Forms Training

Introducing Oracle Forms Developer and Forms Services

Creating Forms Modules

Working with Data Blocks and Frames

Working with Input Items

Working with Non Input Items

Working with Windows and Canvases

Producing Triggers

Debugging Triggers

Adding Functionality to Items

Run-Time Messages and Alerts

Query Triggers

Validation

Navigation

Transaction Processing

Writing Flexible Code

Sharing Objects and Code

Using WebUtil to Interact with the Client

Oracle Reports Training

Basic Concepts
Advanced Concepts
Visual Index

How To â?¦?

Access Oracle Reports Documentation
Set Properties and Preferences
Perform Common Tasks
Work with the Object Navigator
Work with Reports
Work with Web Reports
Run and Dispatch a Report
Work with the Data Model
Work with the Report Layout
Work with Report Sections
Work with Parameters and the Parameter Form
Define a Template
Use PL/SQL in a Report or Template
Debug a Report
Integrate with Other Products
Administer Oracle Reports Builder

PROJECT WORK

Students also enrolled in these courses

LIVE
3 Hours

Course offered by Sourav Saha

0 review
LIVE
4 Hours

Course offered by Dip dey

0 review
LIVE
2 Hours

Course offered by Dibyendu mazumder

0 review
LIVE
3 Hours

Course offered by Rakesh Prasad

0 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

DBMS & RDBMS Training in Kolkata (Aptech Computer Education Hazra) by Aptech Hazra

Aptech Computer Education Hazra picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

DBMS & RDBMS Training in Kolkata (Aptech Computer Education Hazra) by Aptech Hazra

Aptech Computer Education Hazra picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more