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