Oracle Brochure

Palium Skills

Palium Software Services Pvt. Ltd.

2

Table of Contents About Palium ............................................................................................................................ 3

Why Palium? ......................................................................................................................... 3

Contact ................................................................................................................................. 3

Oracle Courses .......................................................................................................................... 3

Course List ............................................................................................................................ 3

Course Outlines ..................................................................................................................... 4

Oracle SQL ......................................................................................................................... 4

Oracle PL-SQL..................................................................................................................... 5

Oracle Forms Developer ...................................................................................................... 6

Oracle Reports Developer .................................................................................................... 7

Oracle Database 10g: Administration Workshop-I .................................................................... 8

Oracle Database 10g: Administration Workshop-II ..................................................................10

Java Programming .............................................................................................................12

Web Component Development with Servlet & JSP technology..................................................13

Struts Framework ..............................................................................................................13

Hibernate .........................................................................................................................14

Oracle Certification ...................................................................................................................14

Why Certification?.................................................................................................................15

The Benefits of Certification ................................................................................................15

Certification Details ...............................................................................................................15

Oracle 10g DBA OCA /OCP...................................................................................................15

Oracle 10g Developer OCA/OCP ...........................................................................................16

Java Certification: ..............................................................................................................16

Our Trainers.............................................................................................................................18

DBA trainer: .........................................................................................................................18

Forms, Reports, PL-SQL trainer: ...............................................................................................18

Java trainer: .........................................................................................................................18

Policies....................................................................................................................................19

Quality Policy........................................................................................................................19

Refund Policy........................................................................................................................19

3

Guarantee Policy ...................................................................................................................19

About Palium

Palium is an organization focused on developing workforce with the right skills to ensure companies and individuals benefit. Our experienced trainers help individuals to develop the skills that will help them to be a successful IT Professional. Our trainers are highly skilled and qualified professionals with several years of work experience in their respective areas of specialization which helps them to know what corporates are looking for in their future employees.

Why Palium? Palium is not driven by profits. Instead our key differentiators are –

Real world solutions with expert instructors Focus on practice and hands-on exercises ensure development of practical skills Active training which ensures better learning curve

Contact We can be reached at –

Phone: +91-8420594969

Email: Palium.skills@gmail.com

Oracle Courses

Course List Oracle Database 10g: New Features for Administrators 2.1 Oracle Database 10g: Introduction to SQL 3.0 Oracle Database 10g: Administration Workshop I 3.1 Oracle Database 10g: Administration Workshop II 3.1 Oracle Forms Developer 10g: Build Internet Applications 2.0 Oracle Reports Developer 10g: Build Reports Oracle Database 10g: PL/SQL Fundamentals 3.0 Fundamentals of the Java Programming Language, Java SE 6, 1.1 Java Programming Language, Java SE 6, 1.1 Developing Applications for the Java EE 6 Platform, 1.1 Web Component Development with Servlets & JSPs, Java EE 6, 1.1 Data Warehousing Fundamentals Data Warehouse Database Design

4

Course Outlines

Oracle SQL This program provides you with information on Oracle SQL and how it is used to interact with a database. It starts with the basics and goes onto more complex queries and scenarios.

Mode: Classroom or Online

Duration: 40 hours

Target Audience: 1. Developers intending to work with Oracle technical space 2. Project Managers 3. Technical Architects

Contents

Introduction to Oracle SQL Basics of RDBMS Using SQL commands Manipulating and sorting data Using single row sub-function Using group functions Working with data from multiple tables Using subqueries and set operators Data Manipulation (DML) commands Data definition (DDL) commands Working with other objects – Views, Synonyms etc Managing Objects with Data Dictionary Views Controlling User Access Manage Schema Objects Manipulating Large Data Sets Generating Reports by Grouping Related Data Managing Data in Different Time Zones Retrieving Data Using Subqueries Hierarchical Retrieval of data Regular Expression Report

Follow-On Program

• The next logical step is to get an understanding of PL-SQL • Individuals may undergo Training on Oracle Reports or Forms tool to develop their skill set.

5

Oracle PL-SQL

This program provides you with information on Oracle SQL and how it is used to interact with a database. It starts with the basics and goes onto more complex queries and scenarios. Mode: Classroom or Online Duration: 40 hours

Target Audience:

1. Developers intending to work with Oracle technical space

2. Project Managers

3. Technical Architects

Contents

Introduction to PL/SQL Declaring PL/SQL Variables Writing Executable Statements Interacting with the Oracle Database Server Writing Control Structures Working with Composite Data Types Using Explicit Cursors Working with Triggers Handling Exceptions Working with Triggers Creating Stored Procedures & Functions

Follow-On Program

Individuals may undergo Training on Oracle Reports or Forms tool to develop their skill set.

6

Oracle Forms Developer

Duration: 40hours

This program will provide you with training on Oracle Forms

Mode: Classroom or Online

Target Audience: 1. Developers intending to work with Oracle technical space 2. Project Managers 3. Technical Architects Contents Introduction to Oracle Forms Developer and Oracle Forms Services Running a forms Builder Application Working in the Forms Developer Environment Creating a Basic Form Module Creating a Master-Detail Form Working with Data Blocks and Frames Working with Text Items Creating LOVs and Editors Creating Additional Input Items Creating Noninput Items Creating Windows and Content Canvases Working with Other Canvas Types Introduction to Triggers 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 Introducing Multiple Form Applications

Follow-On Program

1. Oracle Forms 2. Individuals can undergo Training on Oracle Application Technical to develop their skill set and work in the

Oracle EBS domain.

7

Oracle Reports Developer

Duration: 40hours

Mode: Classroom or Online

Target Audience:

1. Developers intending to work with Oracle technical space 2. Project Managers 3. Technical Architects Contents

Introduction to Oracle Reports Developer Designing and running reports Working in Oracle Reports Builder Creating and modifying paper reports using the Wizard Enhancing a paper report in the Paper Design view Managing templates Creating a Web report Enhancing Reports Using the Data Model: Queries and Groups Enhancing Reports Using the Data Model: Data Sources Enhancing Reports Using the Data Model: Creating Columns Enhancing Reports Using the Paper Layout Controlling the Paper Layout: Common Properties Controlling the Paper Layout: Specific Properties Web Reporting Extending Functionality Using XML Creating and Using Reports Parameters Embedding a Graph in a Report Enhancing Matrix Reports Coding PL/SQL Triggers Extending Functionality Using the SRW Package Maximizing Performance Using OracleAS Reports Services Building Reports: Efficiency Guidelines

Follow-On Program

1. Oracle Forms 2. Individuals can undergo Training on Oracle Application Technical to develop their skill set and

work in the Oracle EBS domain.

8

Oracle Database 11g: Administration Workshop-I Duration: 40 hrs

Audience: Database Administrators Sales Consultants Support Engineer Project Manager Database Designers Technical Consultant

Suggested Prerequisites: Working knowledge of SQL

Course Objectives: Install Oracle Database 10g and configure a database Manage the Oracle instance Manage the Database storage structures Create and administer user accounts Perform backup and recovery of a database Monitor, troubleshoot, and maintain a database Configure Oracle Net services Move data between databases and files

Contents: 1. Installing the Oracle Database Software 9. Implementing Oracle Database Security Explain core DBA tasks and tools Describe DBA responsibilities for security Plan an Oracle installation Apply the principal of least privilege Use optimal flexible architecture Enable standard database auditing Install software with Oracle Universal Installer

(OUI) Specify audit options

Review audit information 2. Creating an Oracle Database Maintain the audit trail Create a database with the Database

Configuration Assistant (DBCA)

Create a database design template with the DBCA 10. Configuring the Oracle Network Environment Generate database creation scripts with the DBCA Use Enterprise Manager for configuring the Oracle

network environment Create additional listeners 3. Managing the Oracle Instance Create Net Service aliases Start and stop the Oracle database & components Configure connect-time failover Use Enterprise Manager (EM) Control the Oracle Net Listener Access database with SQL*Plus & iSQL*Plus Test Oracle Net connectivity Modify database initialization parameters Identify when to use shared vs dedicated servers Understand the stages of database startup View the Alert log 11. Proactive Maintenance Use the Data Dictionary Use statistics Manage Automatic Workload Repository (AWR) 4. Managing Database Storage Structures Use Automatic Database Diagnostic Monitor

(ADDM)

9

Describe table data storage (in blocks) Describe advisory framework Define the purpose of tablespaces & data files Set alert thresholds Understand & utilize Oracle Managed Files (OMF) Use server-generated alerts Create and manage tablespaces Use automated tasks Obtain tablespace information Describe the main concepts and functionality of

Automatic Storage 12. Performance Management

Management (ASM) Use Enterprise Manager pages to monitor performance

5. Administering User Security Use the SQL Tuning Advisor Create and manage database user accounts Use the SQL Access Advisor Authenticate users Use Automatic Shared Memory Management Assign default storage areas (tablespaces) Use the Memory Advisor to size memory buffers Grant and revoke privileges Use performance related dynamic views Create and manage roles Troubleshoot invalid or unusable objects Create and manage profiles Implement standard password security features 13. Backup and Recovery Concepts Control resource usage by users Identify the types of failure that may occur in an

Oracle Database Describe ways to tune instance recovery 6. Managing Schema Objects Identify the importance of checkpoints, redo log

files, and archived log files Define schema objects and data types Configure ARCHIVELOG mode Create and modify tables Define constraints 14. Performing Database Backups View the columns and contents of a table Create consistent database backups Create indexes, views and sequences Back your database up without shutting down Explain the use of temporary tables Create incremental backups Use the Data Dictionary Automate database backups

Monitor the flash recovery area 7. Managing Data and Concurrency Manage data through SQL 15. Performing Database Recovery Identify and administer PL/SQL Objects Recover from loss of a control file Describe triggers and triggering events Recover from loss of a redo log file Monitor and resolve locking conflicts Perform complete recovery following the loss of a

data file 8. Managing Undo Data 16. Performing Flashback Explain DML and undo data generation Describe Flashback database Monitor and administer undo Restore the table content to a specific point in the

past with Flashback Table Describe the difference between undo & redo data Recover from a dropped table Configure undo retention View the contents of the database as of any single

point in time with Flashback Query Guarantee undo retention See versions of a row over time with Flashback

Versions Query Use the undo advisor View the transaction history of a row with

Flashback Transaction Query

10

Oracle Database 11g: Administration Workshop-II Duration: 40 hrs

Audience: Database Administrators Support Engineer Project Manager Database Designers Technical Consultant

Required Prerequisites: Oracle Database 10g: Administration Workshop I

Suggested Prerequisites: Oracle Database 10g: SQL Fundamentals I Oracle Database 10g: SQL and PL/SQL Fundamentals

Course Objectives: Use RMAN to create and manage backup sets and image copies Use Oracle's Flashback technology to recover your database Detect block corruptions and take appropriate measures to correct them Use the various Database advisors and views to monitor and improve database performance Control database resource usage with the Resource Manager Simplify management tasks by using the Scheduler Improve the security of the listener Review database log files for diagnostic purposes Customize language-dependent behavior for the database and individual sessions

Contents:

1. Using Globalization Support 9. Recovering from User Errors Datetimes with Timezones Recycle Bin Specifying Language-Dependent Behavior Flashback Dropped Tables Using EM Locale Variants Querying Dropped Tables Linguistic Sorting Flashback Versions Query Case and Accent Insensitive Sorts Flashback Transaction Query Linguistic Comparisons Flashback Table & Using EM Obtaining Information about the Current NLS

Configuration Using Flashback Versions Query and Flashback

Transaction Query 2. Securing the Oracle Listener 10. Dealing with Database Corruption Listener Password Authentication What is block corruption? Controlling Database Access Interpreting DBVERIFY Securing the EXTPROC Service Entry The ANALYZE command How to Handle Corruptions 3. Configuring Recovery Manager The DBMS_REPAIR Package Using a Flash Recovery Area with RMAN Block Media Recovery (BMR) Setting Parameters for RMAN Detecting Database Corruptions Using

DBVERIFY Starting RMAN Using RMAN to Repair Corrupt Blocks Configuring Persistent Settings for RMAN

11

Control File Autobackups 11. Automatic Database Management Retention Policies Automatic Optimizer Statistics Collection Workload Repository 4. Using Recovery Manager Database Control and Advisors Issuing Recovery Manager Commands Using the SQL Tuning Advisor Parallelization of Backup Sets Using the SQL Access Advisor Compressed Backups Automatic Undo Retention Tuning Copying the Whole Database Making Incremental Backups 12. Monitoring and Managing Storage Block Change Tracking Redo Logfile Size Advisor Incrementally Updating Backups Resumable Statements Monitoring RMAN Backups Tablespace Space Usage Monitoring Accessing the Segment Advisor 5. Diagnostic Sources Shrinking Segments Using SQL The Alert Log Segment Resource Estimation Viewing Alerts with EM Monitoring Index Space Alerts Notification Identifying Unused Indexes Editing Thresholds Trace Files 13. Automatic Storage Management ASM Concepts 6. Recovering from non-critical losses ASM General Architecture Creating New Temporary Tablespace Creating an ASM instance Recreating Redo Log Files Creating tablespaces that use ASM storage Recovering an Index Tablespace Viewing ASM information Read-Only Tablespace Recovery Migrating a tablespace to use ASM storage Loss of Password Authentication File

14. Monitoring and Managing Memory 7. Database Recovery Oracle Memory Structures Recovery Steps Using Automatic Shared Memory Mgmt to

avoid long running query issues User-Managed Recovery Procedures: RECOVER

Command Using the Memory Advisor

Types of incomplete recovery Automatic PGA Memory Management Incomplete Recovery Best Practices Recovery Using EM 15. Managing Resources Simple Recovery Through RESETLOGS Creating a New Resource Plan Point-in-time recovery using RMAN Creating Resource Consumer Groups

Assigning Users to Resource Consumer Groups 8. Flashback database Adaptive Consumer Group Mapping When to Use Flashback Technology Using Sub-Plans to limit CPU Utilization Configuring Flashback Database Administering the Resource Manager Monitoring Flashback Database Resource Plan Directives Best Practices for the Database and Flash

Recovery Area

16. Automating Tasks with the Scheduler Flash Recovery Area Space Usage Creating a Scheduler Job Flashback Database Examples Using Scheduler Programs

Creating and Using Schedules Creating a Job Class Prioritizing Jobs within a Window Viewing Job Execution Details Creating a job that runs a program outside of

the database

12

Java Programming

Duration: 40hours Content: Procedural Paradigm Fall Backs Procedural Vs.Object Oriented Object Oriented Programming Advantage of OOP Approach OOP Core Concepts SDLC Process Getting Started Object - Oriented Programming Identifiers, Keywords, and Types Expression and Flow Control Arrays Class Design and Advance Class Features Exceptions and Assertions Collections and Generics Framework I/O Fundamentals Console / I/O and File I/O Building Java GUIs Using the Swing API Handling GUI-Generated Events GUI-Based Applications Threads Networking and Socket Programming

13

Web Component Development with Servlet & JSP technology Duration: 40hours

Course Content

Introduction to web Application Technologies Developing a View Component Developing a Controller Component Developing Dynamic Forms Sharing Application Resources Using the Servlet Context Designing the Business tier Developing Web Application Using Struts Developing Web Application Using Session Management Using Filters in Web Application Integrating Web Applications with Databases Developing JSP Pages Developing JSP Pages Using Custom Tags Developing Web Applications Using Struts Action Forms Building Reusable Web Presentation Components

Struts Framework Duration: 24hours

Course Content

Introduction to Struts2 Framework Features of Struts2 Architecture of Struts2 Struts1 Vs Struts2 Benefits of Struts2 Struts2 Servlet Filter Interceptors and Actions Struts2 Tags The Value Stack and OGNL Results and Result Types Struts2 validation model Struts2 support of i18n

14

Hibernate Duration: 16hours

Course Content

Introduction to ORM Introduction to Hibernate as ORM Configuring Hibernate Working with Hibernate Hibernate Query Language The Criteria Query API Native SQL Queries Relationships Annotations

Oracle Certification

Ours is a prominent entity involved in providing credible Oracle Certifications. All

these Certifications of Oracle are among the most sought after badges of high reliability for expertise in the Information Technology marketplace. The OCJP certification training is in a

great demand in the entire IT industry area. It has become a global standard for many successful IT companies. These Oracle certifications covers diverse aspects of Database

administration, Programming and Development, Oracle Middleware, Oracle Applications-Functional, Oracle Apps DBA/Technical, Business Intelligence, Oracle Golden Gate, Data

Warehousing, Oracle Cloud, Application Express (Apex). These certifications are handled by well experienced and skilled professionals. Oracle Database

is the premier database developed for enterprise grid computing, the most flexible and cost efficient way to manage information and applications. Diverse Oracle Certificate

Courses offered include Oracle certified Professional (OCP), Java SE6 Programmer, Oracle certified Professional (OCP), Java SE5 Programmer, Oracle certified Professional (OCP), Java EE 5

Web Component Developer, Oracle Certified Master (OCM), Java SE 6 Developer, Oracle Certified Professional, Java EE 5 Business Component Developer, Oracle Certified Professional,

Java EE 5 Web Services Developer, Oracle Certified Master, Java EE 5 Enterprise Architect and Oracle Certified Professional, Java ME1 Mobile Application Developer.

Components: • Database administration • Programming and Development

15

• Oracle Middleware • Oracle Applications-Functional • Oracle Apps DBA/Technical • Business Intelligence • Oracle Golden Gate • Data Warehousing • Oracle Cloud • Application Express (Apex)

Why Certification?

The Benefits of Certification Increases performance and productivity Optimize return on investment Evaluate oneself against Global Standards Reduce overall support costs and minimize system downtime Keep up with changing technology Career development advantages

Certification Details

Oracle 10g DBA OCA /OCP 3-Exams:

• Oracle Database 10g: Introduction to SQL (exam code 1z0-047) • Oracle Database 11g:Administration –I (exam code 1z0-042) • Oracle Database 11g: Administration –II (exam code 1z0-043)

3-Certifications: • Oracle Database SQL Expert, • Oracle Database 11g Administrator Certified Associate, • Oracle Database 11g Administrator Certified Professional

1Z0-047 Oracle Database SQL expert 70 Questions Objectives

120 minutes Passing at 66% SCE

OCA

OCP 1z0-042 Oracle Database 10g Administration – I

84 Questions Objectives

120 minutes Passing at 68%

1Z0-043 Oracle Database 10g Administration – II

92 Questions Objectives

90 minutes Passing at 70%

16

Oracle 11g Developer OCA/OCP 3 Exams:

• Oracle 10g SQL (exam code 1z0-047) • Oracle 10g Pl/SQL (exam code 1z0-147) • Oracle 10g Forms (exam code 1z0-140) • Oracle 10g Reports

3-Certifications:

• Oracle Database SQL expert • Oracle Pl/SQL Developer Certified Associate • Oracle Forms Certified Professional

1Z0-047 Oracle Database SQL expert 70 Questions Objectives

120 minutes Passing at 66% SCE OCA

OCP 1z0-147 Program with PL/SQL 66 Questions 90 minutes Passing at 77%

1Z0-141 Oracle Forms: Build Internet Applications

69 Questions 120 minutes Passing at 75%

Java Certification:

Oracle certified Professional (OCP), Java SE6 Programmer • (1Z0-851) - Java Standard Edition 6 Programmer Certified Professional Exam

Oracle certified Professional (OCP), Java SE5 Programmer • 1Z0-851 - Java Standard Edition 5 Programmer Certified Professional Exam

Oracle certified Professional (OCP), Java EE 5 Web Component Developer

Prior Certification • Oracle Certified Professional, Java (SE 5 or SE 6) Programmer or Sun Certified Java Programmer (any edition) • 1Z0-858 - Java Enterprise Edition 5 Web Component Developer Certified Professional Exam.

Oracle Certified Master (OCM), Java SE 6 Developer

Prior Certification • Oracle Certified Professional, Java (SE 5 or SE 6) Programmer OR Sun Certified Java Programmer (any edition)

Training • Complete one of the approved instructor-led online or in-class courses.

Assignment • 1Z0-855 - Java Standard Edition 6 Developer Certified Master Assignment (Step 1 of 2) *

Assignment must be submitted before you can register for the essay

Essay • 1Z0-856 - Java Standard Edition 6 Developer Certified Master Essay Exam (Step 2 of 2)

Form

17

• Complete the Course Submission Form

Oracle Certified Professional, Java EE 5 Business Component Developer

Prior Certification • Oracle Certified Professional, Java (SE 5 or SE 6) Programmer or Sun Certified Java Programmer (any edition)

Exam • 1Z0-860 - Sun Certified Business Component Developer for the Java Platform,

Enterprise Edition 5

Oracle Certified Professional, Java EE 5 Web Services Developer

Prior Certification • Oracle Certified Professional, Java Programmer (SE 5 or SE 6) or Sun Certified Java Programmer (any edition)

Exam • 1Z0-862 - Java Enterprise Edition 5 Web Services Developer Certified Professional Exam

Oracle Certified Master, Java EE 5 Enterprise Architect

Training • Complete one of the approved instructor-led online or in-class courses.

Exam • 1Z0-864 - Java Enterprise Edition 5 Enterprise Architect Certified Master Exam (Step 1 of 3)

Assignment • 1Z0-865 - Java Enterprise Edition 5 Enterprise Architect Certified Master Assignment • (Step 2 of 3) Assignment must be submitted before you can register for the essay

Essay • 1Z0-866 - Java Enterprise Edition 5 Enterprise Architect Certified Master Essay Exam (Step 3 of 3)

Form • Complete the Course Submission Form

Oracle Certified Professional, Java ME 1 Mobile Application Developer

Prior Certification • Oracle Certified Professional, Java Programmer (SE 5 or SE 6) or Sun Certified Java Programmer (any edition)

Exam • 1Z0-869 - Java Mobile Edition 1 Mobile Application Developer Certified Professional Exam

18

Our Trainers

We are proud of our trainers because of whom we are able to deliver real value to participants. Each of them have long years of work experience in their respective area of specialization.

DBA trainer: He has 8+years of industry experience having worked with top tier IT companies. He is patient and tutoring is a passion to him. He believes ‘knowledge is wealth’ which ensures each of his class is a treat in itself during which participants learn the intricacies of database administration.

Forms, Reports, PL-SQL trainer: He is a industry veteran of over 21 years having worked with several companies over the years. He believes that teaching is a sacred task which requires dedication and concentration. For each of his class he gives his own notes and project which complements the standard courseware.

Java trainer: She has over 12 years of industry experience having worked with top MNC companies. Over the last couple of years, she is into full time training delivery. She is knowledge, patient and dedicate to her work. Participants derive tremendous value from her inputs and coaching.

19

Policies

Quality Policy

We strive to provide affordable education and skills through qualified professionals so that individuals are better prepared to face the interview & work

independently at their workplace which will help them to work productively.

Refund Policy

We are confident that you will never need to get a refund because we provide Quality education through well Qualified professionals. However, incase you are not satisfied then let us know and we will strive to remedy the situation. Incase

you still need to get a refund then ask for it. We will refund the remaining amount after deducting enrollment expenses and pro-rata value of classes attended.

Guarantee Policy

WE DO NOT GUARANTEE JOBS.

WE GUARANTEE KNOWLEDGE WHICH WILL HELP YOU GET THE RIGHT JOB.