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