Oracle SQL / PLSQL + Oracle Apps R12 Technical Combo Course

In this Oracle Apps R12 Technical Combo Course includes SQL&PL/SQL, D2K (Forms & Reports 10g), Oracle Apps R12 Technical with real time project. This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organization. Oracle apps technical provides students with a basic understanding of the architecture, database and file system used in Oracle Applications Release 11i. Students will learn about the multi-tier architecture used to provide user access over the Internet or an intranet and the relationship between Oracle Applications and the Oracle database

img
request

Can’t find a batch you were looking for?

 

In this Oracle Apps R12 Technical Combo Course  includes SQL&PL/SQL, D2K (Forms & Reports 10g), Oracle Apps R12 Technical with real time project. This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organization. Oracle apps technical provides students with a basic understanding of the architecture, database and file system used in Oracle Applications Release 11i. Students will learn about the multi-tier architecture used to provide user access over the Internet or an intranet and the relationship between Oracle Applications and the Oracle database

Course content

 

 

SQL

 

 

Introduction to Oracle Database (SQL):
  • What is Database
  • Why Oracle
  • Introduction to SQL and SQL *Plus, More SQL*Plus Commands
  • The Data Dictionary
Data Query Language (DQL):
  • Categories of SQL Statements
  • Oracle Data types
  • The SELECT Statement
  • Practical examples
 Data Definition Language (DDL):
  • DDL Statements
    The CREATE Statement
  • The DROP Command
  • The ALTER Command
  • Practical examples
 Data   Manipulation Language  (DML):                             
  • DML Statements,
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
Transaction Control Language (TCL):
  • TCL Statements
  • COMMIT Statement
  • ROLLBACK Statement
  • SAVEPOINT Statement
 Data Control Language (DCL):
  • DCL Statements
  • GRANT Statement
  • REVOKE Statement
 Integrity Constraints:
  • Introduction to Integrity Constraints
  • Categories of Integrity Constraints
  • NOT NULL Constraints
  • UNIQUE KEY Constraints
  • PRIMARY KEY Constraints
  • FOREIGN KEY or Referential Integrity Constraints
  • CHECK Constraints, Practical examples
 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
  • EXISTS
 Set Operators:
  • Introduction
  • Selection Criteria
  • Union
  • Union All
  • Intersect
  • Minus
 Joining Tables:
  • Joins
  • Table Aliases
  • Cartesian Product
  • Inner Joins
  • Equi- Join
  • Non-Equi Join
  • Non-Key Join
  • Reflexive / Self Join
  • Natural Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
 SQL Sub queries:
  • Introduction
  • Using a Sub query with a DML Statement
  • Typical Sub queries
  • Sub query Operators
  • Standard vs. Correlated Sub queries
  • Correlated Sub query
 Groups:
  • SQL Statements
  • GROUP BY Clause
  • HAVING Clause
  • Order of a SELECT Statement
 SQL BUILT-IN FUNCTIONS:
  • Introduction, Pseudo Columns
  • GROUP Functions
  • MATHEMATICAL / NUMERIC Functions
  • STRING / CHARACTER Functions
  • DATE / TIME Functions
  • CONVERSION Functions
  • MISCELLANEOUS Functions
More Database Objects:
  • More Database Objects
  • VIEWS
  • SEQUENCE
  • SYNONYMS

 

 

 

PLSQL

 

 

Fundamentals
  • Introduction to PL/SQL
  • Benefits of PL/SQL
  • Creating PL/SQL Blocks
Defining Variables and Datatypes
  • Using Variables in PL/SQL
  • Recognizing PL/SQL Lexical Units
  • Recognizing Data Types
  • Using Scalar Data Types
  • Writing PL/SQL Executable Statements
  • Nested Blocks and Variable Scope
  • Good Programming Practices
 Using SQL in PL/SQL
  • Review of SQL DML
  • Retrieving Data in PL/SQL
  • Manipulating Data in PL/SQL
  • Using Transaction Control Statements
Program Structures to Control Execution Flow
  • Conditional Control: IF Statements
  • Conditional Control: CASE Statements
  • Iterative Control: Basic Loops
  • Iterative Control: WHILE and FOR Loops
  • Iterative Control: Nested Loops
Using Composite Datatypes
  • User-Defined Records
  • Indexing Tables of Records
Using Cursors and Parameters
  • Introduction to Explicit Cursors
  • Using Explicit Cursor Attributes
  • Cursor FOR Loops
  • Cursors with Parameters
  • Using Cursors for UPDATE
  • Using Multiple Cursors
Exception Handling
  • Handling Exceptions
  • Trapping Oracle Server Exceptions
  • Trapping User-Defined Exceptions
  • Recognizing the Scope of Exceptions
Using and Managing Procedures
  • Creating Procedures
  • Using Parameters in Procedures
  • Passing Parameters
Using and Managing Functions
  • Creating Functions
  • Using Functions in SQL Statements
  • Review of the Data Dictionary
  • Managing Procedures and Functions
  • Review of Object Privileges
  • Using Invoker’s Rights and Autonomous Transactions
Using and Managing Packages
  • Creating Packages
  • Managing Package Concepts
  • Advanced Package Concepts
Getting the Best out of Packages
  • Persistent State of Package Variables
  • Using Oracle-Supplied Packages
Improving PL/SQL Performance
  • Using Dynamic SQL
  • Improving PL/SQL Performance
Using and Managing Triggers
  • Introduction To Triggers
  • Creating DML Triggers, Part I
  • Creating DML Triggers, Part II
  • Creating DDL and Database Event Triggers
  • Managing Triggers
Recognizing and Managing Dependencies
  • Introduction to Dependencies
  • Understanding Remote Dependencies
Using the PL/SQL Compiler
  • Using PL/SQL Initialization Parameters
  • Displaying Compiler Warning Messages
  • Using Conditional Compilation
  • Hiding Your Source Code

 

 

Oracle Apps R12 Technical

 

 

Introduction to ERP
  • Definition of ERP, Overview of popular ERP’S
  • Comparison of Oracle Apps with other ERP’S
  • Types of Roles
  • Types of Projects
  • AIM documentation standards
  • Oracle Application Architecture.
  • Database structure of OA
  • Using TOAD
Application Object Library
  • Creating Users
  • WHO columns
  • Creating Responsibilities
  • Menu construction
  • Request group construction
Application development
  • Defining concurrent program
  • Concurrent programs with parameters
  • Working with multiple concurrent programs
  • Scheduling the Concurrent Program
  • Concurrent Program incompatibilities
  • Creating Request Set
  • Procedure registration
  • Value sets
Reports registration
  • Report development
  • Report registration
  • Parametric report registration
  • Reports with repeating frames
Module Overviews
  • Inventory Module flow with base tables
  • Accounts Payable module flow with base tables
  • Accounts Receivable module flow with base tables
  • Order Management module flow with base tables
Form registration
  • fmb
  • fmb
  • Form development using templates
  • Form customization concepts
  • Form Registration Process
  • Pll
  • Using function Zoom_available( )
  • Using procedure Event( )
Interfaces
  • Introduction to Interfaces
  • Outbound Interfaces
  • – Using UTL_FILE package
  • Inbound Interfaces –
  • Using SQL * Loader tool
Conversions
  • Overview on conversions
  • Difference between Interfaces and conversions
  • Working with staging table script
  • Developing validations package
  • Standards to be followed in conversions
Flex Fields
  • Types of Flex Fields
    • Descriptive Flex Fields
    • Key Flex Fields
Workflows
  • Introduction to workflow
  • Workflow builder
  • Attributes
  • Creating Processes
  • Sending notifications using workflows
XML Publisher
  • Introduction to XML Publisher
  • Generating XML file using reports
  • Creating Data Definitions

 

To see the full course content Download now

Course Prerequisites

 
  • Previous experience with at least one programming language
  • Database Design and Database Programming with SQL

Who can attend

 
  • Students who wish to learn the techniques and tools to automate database application tasks
  • Students who possess basic mathematical, logical, and analytical problem-solving skills
  • Novice programmers, as well as those at advanced levels, to learning the PL/SQL programming language to an advanced level

Number of Hours: 70hrs

Certification

OCA / OCP

Key features

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Virtual Live Experience
  • Preparing for Certification

FAQs

DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Materials
  • Preparing for Certification

Call now: +91-99003 49889 and know the exciting offers available for you!

We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.

Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.

All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.

No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.

DASVM Technologies provides many suitable modes of training to the students like:

  • Classroom training
  • One to One training
  • Fast track training
  • Live Instructor LED Online training
  • Customized training

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.

Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.

Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.

We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.

DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com

like our courses