Winter training for engineering students! Admission open for IT training in kolkata      Looking for a corporate training provider? Know more about the IT training courses in aptech hazra      100% job assured course for unplaced Engineer / MCA ! Know more about the IT training courses

Behala : 9330148679/033-24460725  |  Hazra : 9339408422/033-40731111  |  Budge Budge : 9804084486/033-24701025 icap


ACCP-PRO

DATABASE

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.

Database certification course in kolkata

Request a Call Back

Select and enroll into the most DATABASE learning units:

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

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


INTERESTED TO JOIN IN PROJECT BASED TRAINING

Fill the enquiry form to get a call from our career counsellors.

Our Partners

Best computer training school in kolkata
Grade A certified institute in kolkata Counter for Website hit

Aptech Behala
738,D.H.Road, 2nd Floor,
Kolkata -700008,
Above UBI Bank
033-24460725/
9330148679

/ APTECH BEHALA

Aptech Hazra
96L, S.P.Mukherjee Road,1st Floor,
Kolkata-700026,
Near Jatin Das Metro
033-40731111/9339408422

/ APTECH HAZRA

Aptech Budge Budge
74/A, D.P.J.M Road,
Kolkata -700137,
Above UCO Bank
033-24701025/ 9804084486

/ APTECH BUDGEBUDGE