37

ORACLE Courses

ORACLE Programming Courses

The courses are accredited ANC – Programmer Help – COR 351201/h6 >
The courses are exempt from VAT payment./h6
The price includes the course support in electronic format, lunch, coffee breaks and the ANC certificate./h6
The diploma is recognized by the Ministry of Labour, Family and social Protection and the Ministry of Education, Research and innovation and attests all the professional competences of the occupation.

Next

Information about available Courses

Code Description Duration price (exempt from VAT payment) Course Date
Oracle 1 Oracle – Introduction to SQL/PLSQL 40 hours 595 EUR N/a
Oracle 2 Developer 2000, Forms and reports 40 hours 595 EUR N/a
Oracle 3 Oracle – Database Management 40 hours 595 EUR N/a
OR11G-1 Developing SQL Queries for Oracle Database 11g 24 hours 545 EUR N/a
OR11G-2 2 PL/SQL Programming 24 hours 545 EUR N/a
OR11G-3 Oracle Database 11g: Comprehensive Introduction and Administration 40 hours 595 EUR N/a
OR11G-4 Oracle Database 11g: Backup, Recovery and Tuning 40 hours 595 EUR N/a

ORACLE Course AGENDA – Introduction to SQL/PLSQL

ORACLE – Introduction to SQL/PLSQL

Chapter 1
General Concepts
Logical structures of database storage.
Database schema objects
Database Physical Structures
Oracle data dictionary and dynamic performance views.
Transactions
Oracle server architecture.
Oracle database operation
Oracle Products-Database Tools
Identify major components of an Oracle instance
Relational approach
Database design

Chapter 2
SQL language Presentation
Write a basic SQL command
Relational principles and Oracle concepts
Write a basic SQL command
restricting and sorting data
Functions that return values.
displaying data
grouping data using grouping functions
Writing Interviews

Chapter 3
Making interactive reports from SQL
Data manipulation
Creating and managing tables.
Creating views
SQL Recap
Overview about PL/SQL
Declaration of variables
Writing executable Commands
Interaction with Oracle
Writing control structures
Working with Composite data types
Description of the cursors. Advanced Cursor Concepts
Treatment of exceptions
Final Exam

Program: Monday – Friday: 09.00-17.00.

ORACLE DEVELOPER Course Address Book 2000, Forms and reports

Chapter 1

Introduction to Oracle Developer

Running a form building application

Working in the Form Builder environment

Working with blocks and frames given.

Working with test articles

Creation of LOV and editors.

Creating Windows

Chapter 2

General presentation of triggers

Triggering.

Validating navigation

Transaction processing.

Writing Flexible Codes

Concepts of Report Builder

Creating reports using the report Wizard

Management templates for reports

Methods of storing reports

Chapter 3

Creating greyhounds and groups, improving reports using Layout Model

Embed a graph in a report, create and improve matrix reports

Program: Monday – Friday: 09.00-17.00.

ORACLE Course AGENDA – Database management

Chapter 1

Starting and stopping a database

Oracle Instance Management

Oracle Architecture Components

Administration Tools

Create a database. Oracle Database File Management

Maintenance of the matrix control file

Final Exam

Chapter 2

Maintenance of logging files

Management of backgammon-space.

Storage Management and Rollback segments

Maintenance of temporary segments

Management of tables and Indecsilor.

Data integrity Management

Using clusters and Organized files index

Loading and reorganizing data

Chapter 3

Security management

User Management

Profiles Management

Manage privileges

Manage Roles.

Audit

Final Exam

Program: Monday – Friday: 09.00-17.00.

Schedule course developing SQL QUERIES FOR ORACLE DATABASE 11G

This course introduces students to the fundamentals of SQL language using Oracle Database 11g technology. Students will learn the concepts of relational databases and powerful SQL language. The course structure will give students the capability to write interviews on one or more tables, manipulate data from tables and create objects in the database.
Students will also learn how to use the "single-row" functions to customize the output of a query, to condition the results of a query and how to use group functions for reporting.
Participants in this course must be familiar with the use of a graphical interface (GUI) and be familiar with the concepts of data processing. The tools used will be: Oracle SQL Developer and SQL * Plus command line utility.

This course will give participants the capability to:

• Return data (lines and columns) from tables using the SELECT command
• Create reports with data sorted and collated depending on necessity
• Display data from multiple tables
• Use DML (data manipulation language) to work on data from tables
• Use DML (data manipulation language) to work on objects in the database

Course Schedule:

1. Introduction
What is a database? What is SQL language?
Presentation of the architecture of an ORACLE database.
Physical and theoretical aspects of a relational database

Description of SQL Developer tools and exercise structure
Description of the dataset used by this course

2. Return data using the SELECT command
SELECT command Capabilities
Generate a data report from the output of a SELECT command
Use of mathematical expressions and NULL value in a SELECT
Using column Aliases
Using the concatenation operator and the distinctive keyword
Displaying the structure of a table using the describe command

3. Limitation and sorting of interrogated data
Write queries that contain the WHERE clause to limit the returned data
Use of logical and comparison operators
Description of the preceding rules for logical and comparison operators
Use character string data types in WHERE clause
Write querying using the ORDER BY clause to sort the output of a query
Use of substitution variables

4. Using the "Single-Row" functions to customize the OUTPU of a query
The difference between "single-row" and "multiple-row" functions
Handling strings using Character functions
Handling numbers using the functions: ROUND, TRUNC and MOD
Mathematical operations with data type
Handling data type using data type functions

5. Use of conversion functions and expressions Conditional
Description of the conversion of default and explicit data
Using TO_CHAR, TO_NUMBER and TO_DATE functions for conversions
Multiple functions (Unquench functions)
Use of NVL, NULLIF and COALESCE functions on data
Using conditional expressions of IF – THEN – ELSE in a SELECT sentence

6. Reporting aggregate data using Group functions
Use of aggregation functions in select sentences for creating intelligible reports
Using AVG, SUM, MIN and MAX functions
Handling NULL values in group functions
Creating queries that share data in groups using the GROUP BY clause
Create queries that exclude data groups using the HAVING clause

7. Displaying data from multiple tables
Write SELECT sentences to access data from multiple tables
JOIN tables using the SQL standard: 1999
Displaying data that does not meet a JOIN condition using OUTER Join
Using a SELF JOIN
Creating CROSS JOIN

8. Use of sub-queries to solve complex interrogations
Use of sub-queries to solve a problem
Using group functions in a sub-query
Using sub-greyhounds to return multiple lines
Use of any and all in sub-interrogations that return multiple lines

9. Use of operators per crowd (SET operators)
Description of operators on crowds
Use of operators on crowds to combine multiple interrogations in one
Use of Union, Union ALL, intersect and MINUS operators
Using the ORDER BY clause in working with crowds

10. Data manipulation (DML)
Add new lines to a table using the INSERT command
Change data in a table using the UPDATE command
Using Delete and truncated commands
Save or undo changes using COMMIT and ROLLBACK commands
Using the FOR UPDATE clause

11. Using Data Definition Language (DDL) to create and manipulate tables and objects
Categories of objects in Oracle databases
Create new tables using the Create TABBLE command
Description of data types
Description of Constraints
Create a new table using a sub-query
Altering the structure of a table. Delete a table

12. Creating other types of objects
Create, modify, and extract data from a VIEW
Using the data handling language on a VIEW
Delete a VIEW
creating, using and modifying a sequence
Creating and deleting Indecsilor
Creating and deleting synonyms

13. Handling objects using the data dictionary
Data dictionary
How to use the data dictionary VIEW
USER_OBJECTS and ALL_OBJECTS VIEW
Information about tables and columns
Querying data dictionary on constraints
Query the data dictionary on other objects. Ex: VIEW-uri, sequences, INDECSI, synonyms
Add a comment to a table
Query the data dictionary on table comments

Program: Monday – Wednesday: 09.00-17.00.

Schedule Course 2 PL/SQL PROGRAMMING

This course introduces students in the PL/SQL world and locks the benefits of this language. Participants will learn to create PL/SQL blocks that can be shared by multiple applications. This course also provides a detailed perspective of the development, execution and management of stored PL/SQL procedures such as functions, packages, and triggers.
At the same time, the focus is on the management of PL/SQL subprograms, triggers, declaring identifiers and handling exceptions by using standard packages.

This course will give participants the capabilities to:

• Condition of running instructions
• Develop and use PL/SQL Packages
• Create triggers to solve problems.
• Use standard packages to generate outputs
• Create anonymous PL/SQL blocks
• Declares PL/SQL variables

Course Schedule:

1. Introduction to PL/SQL

2. Declaring PL/SQL identifiers

3. Writing executable Statements

4. Interaction with Oracle Server

5. Writing Control structures

6. Working with Composite data

7. Use of explicit cursors

8. Management of exceptions

9. Creating Stored Procedures

10. Creating stored Functions

11. Creating Packages PL/SQL

12. Working with PL/SQL packages

13. Using standard packages in applications

14. Using Dynamic SQL

15. Design considerations of the PL/SQL code

16. Creating triggers

17. Creating DDL triggers and for event management in the database

18. PL/SQL Compiler

19. PL/SQL Code Management

20. Dependency Management

Program: Monday – Wednesday: 09.00-17.00.

ORACLE DATABASE 11G Course Address Book: Comprehensive INTRODUCTION AND ADMINISTRATION

This course will give students a solid basis for the basic administration of the Oracle 11g database. Students will learn how to fix a system for installing Oracle software and how to install Oracle software.
At the same time, students will understand the Oracle database architecture at conceptual architectural level, as the Oracle internal components work. During the course, regular management tasks such as: Creating a new database, database structure management, database security, user management, restoration concepts and techniques will be completed.

This course will give participants the capabilities to:

  • Achieve User management
  • Understand the concepts of backup and restoration
  • Installing Oracle database and operating system configuration to install Oracle

Course Schedule:

1. Oracle Database Architecture
Overview
Working with Oracle database
ORACLE Architecture and internal processes
Dtorage System Architecture
Physical and logical structures of the Oracle database
Tablespace and Datafiles
Tablespace SYSTEM and SYSAUX
Segments, claims, and blocks

2. Preparing the operating system for Oracle installation
Installing Oracle Database: System Requirements
Optimal Flexible Architecture (OFA)
Setting environment variables
Oracle Universal Installer (OUI)
Configuring Options in Oracle Database
Advanced installation Options

3. Create a new database
Oracle Database Types
Configuring Listener
Using the DBCA utility to create a new database
Password management
Creating a Template
Using DBCA to delete a database
Other options when using DBCA

4. Oracle Instance Management
Oracle Enterprise Manager
Initialization parameters
Starting and stopping the database
Database Shutdown types
Alert History View
Using Trace files
Data Dictionary: Concept and architecture

5. Configuring Oracle network Environment
Oracle Net Services & Listener
Tools for network configuration and management
OracleNet Services in Enterprise Manager
Naming methods
SGA and PGA
Using shared Server connections

6. Management of storage structures
Storage structures
How data in tables is stored
Anatomy of a database block
Space management in Tablespaceuri

Tablespaceurile in preconfigured databases
Oracle Managed Files (OMF)
ASM: Concepts

7. User security Management
User accounts in database
Predefined accounts: SYS and SYSTEM
Authentication as Administrator
Advantages of roles
Predefined roles
Implementing Password security Features

8. Management objects in a schema
Understanding the concept of the scheme
Accessing objects in a schema
Creating and modifying tables
Securing Data integrity
Indecsi and View-uri
Sequences
Temporary tables

9. Data management and competing processes
Handling Data using SQL language
PL/SQL
Managing PL/SQL objects
Functions, packages, procedures and triggers
Resolve Locks using SQL
Deadlocks

10. "Undo Data" management
Data manipulation
Transactions and "UNDO DATA"
Undo Date Versus Redo Date
Configuring UNDO Retention (parameter undo_retention)
Using Undo Advisor
View system Activities

11. Implementation of security in Oracle database
High granularity Audit (Fine grained audit)
Auditing DBA
Applying Security Patches

12. Database Maintenance
Optimizer statistics
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
Automatic maintenance tasks
Server-Generated Alerts
Deployment and resolution of alerts

13. Performance management
Performance monitoring
Memory Component Management
Using Automatic Memory Management (AMM)
Automatic shared Memory Advisor
Using Memory Advisors
Dynamic Performance Statistics
Troubleshooting and Tuning Views
Invalid and Null objects

14. Backup and Recovery Concepts
Human error and System errors
Restore the instance
Stages of instant Restoration
Using MTTR Advisory
Media Failure
Archived log files

15. Making Backups
Oracle-Suggested backups
Recovery Manager (RMAN)
Configuring RMAN Settings
Backup of file control in trace file
Monitoring Flash Recovery Area

16. Realization of Restorations
Open a Database
Data Recovery Advisor
Loss of a control file
Loss of a Redo Log file
Data Recovery Advisor
Data Recovery Advisor Views

17. Moving Data
Architecture
directory objects
SQL * Loader
Date Pump
Enterprise Manager and Data Pump jobs
Data dictionary

Program: Monday – Friday: 09.00-17.00.

ORACLE DATABASE 11G Course Address Book: BACKUP, RECOVERY AND TUNING

In this course, the concepts and architecture on which the backup and recovery is based, along with the steps related to this process in various situations, are covered in detail. This includes how to define and test backups and restore in various scenarios.
Students will also learn how to manipulate the memory structures efficiently and perform performance evaluations, including the use of some advisors. All types of flashback technologies, job scheduling and system resource control are also covered.
In the second part of the course students will learn how to use the automated tuning functionality of the Oracle 11g database such as SQL Tuning Advisor, SQL Access Advisor, automatic Workload repository and automatic Database diagnostics Monitor as well Practicing these tuning methods. The second part of the course is based on the tuning tasks expected from a DBA: reactive tuning and maintaining the performance of SQL statements as well as the tuning of Oracle's system components.

This course will give participants the capabilities to:
• Achieve backups and data restorations using RMAN and Enterprise Manager utilities
• Configure the Oracle database for optimal restoration in any situation
• Identify resource-consuming sessions and SQL code chunks with performance issues
• Configure the database instance so that the resources are properly allocated
• Program jobs in the database
• Use statistics and metric database to identify a performance problem
• Interpret tuning diagnostics
• Identify and eliminate performance problems
• Identify SQL statements with problems

Course Schedule:

1. Database architecture and ASM (Automatic Storage Management)
Database architecture
General architecture of ASM
Creating an ASM instance
Managing users of ASM using EM
Concepts of ASM
ASMCMD Utility
Performance of ASM

2. Restore Configuration
Typical tasks in scenario backup/recovery
Working with Recovery Manager (RMAN)
Using the Flash Recovery Area
Flash Recovery Area Management

3. Using a Recovery catalog for RMAN
RMAN Repository: Options
Keeping information about Backup in Recovery catalog
Registering a database in Recovery catalog
Resync Recovery Catalog
Using the RMAN stored scripts
Backup/Recovery for recovery Catalog

4. Configuring Backup Specs
Using RMAN to create backups
Configuring persistent RMAN Settings
Configuring RMAN
Auto-Backup for control files
RMAN Persistent Settings Management
Configuring Backup Devices
Configuring and allocating channels for use in backups
Configuring Backup Optimization

5. Creating backups
Oracle-Suggested backups
Creating Backup Sets & Image Reviews
Create a full backup
Backup types in RMAN
Monitoring of changes in blocks
Backups for archiving
Encrypt backup

6. Perform backup/restore operations by users
Restoration and recovery
Critical and non-critical losses
Restore after loss of a temporary file (TEMPFILE)
Recreating Indecsilor
Restoration after loss of Tablespace INDECSI
Authentication Methods for DBA
Restoring a read-only tablespace

7. Using the RMAN utility to restore
Using RMAN commands: Restore and recover
Restoring your database using Enterprise Manager
Restoring your database using incremental backups
Making a FastSwitch to a copy image
Restoring the database to another server
Disaster restoration

8. Using RMAN to duplicate the database
Create a duplicate database
Creating pfile for the new instant
Allocation of channels required
Understanding the duplication operation
Using Enterprise Manager to clone a database
Cloning a database started

9. Realization of restorations of tablespace in time
Concepts
Architecture
How to use the restoration of tablespace in time
Using Enterprise Manager to achieve restorations in time

10. Monitoring and optimizing the RMAN utility
Parallelization Backups
Monitoring RMAN Sessions
Interpretation of RMAN Results
Optimizing RMAN
Multiplezarea RMAN

11. Using Flashback Technology
Description of Flashback Technology
Transactions and UNDO
Securing UNDO Retention
Preparing the database for Flashbak restorations
Drop Flashback and Recycle Bin

12. Using Flashback Database
Flashback Table
Starting Row-Movement in a table
Architecture Flashback Database
Configuring Flashback Database
Flashback Database using Enterprise Manager
Considerations of Use

Part Two: Oracle Database 11g: Tuning

13. Introduction to Oracle Database tuning
Reasons for tuning
Who, when and what is optimized in the database

14. Monitoring using basic tools
Enterprise Manager
V $ views, stats and metrics
"Wait" events

15. Using Automatic Workload Repository
Automatic Workload repository: Concept
Automatic Workload Repository Data
Enterprise Manager and AWR
Generating AWR reports in SQL * Plus

16. Identify SQL statements with problems
Features of a SQL statement with problem
The role of the optimizer
Generating a plan explain
Monitoring execution

17. SQL Execution Plan Management
Automatic maintenance tasks
SQL Profiles
SQL Access Advisor
SQL Outlines
SQL Plan baselines

18. Change Management
Types of Changes
SQL Performance Analyzer
DB Replay

19. Use of metrics and alerts

20. AWR-based utilities
Automatic maintenance tasks
ADDM
Active Session History

21. Baselines

22. PGA and temporary space tuning

23. Automatic Memory Management
Architecture
SGA Dynamic: Use
Using Automatic Memory Management

24. Statspack
Introduction
Snapshots Statspack
Reporting with Statspack
Statspack and AWR

Program: Monday – Friday: 09.00-17.00.

INFORMATII DESPRE CURSURILE DISPONIBILE

Cod Descriere Durata Pret (fara TVA) Data urmatorului curs
Oracle Linux 7 Oracle Linux 7: System Administration 40 ore 990 EUR N/A

COURSE AGENDA ORACLE LINUX 7: SYSTEM ADMINISTRATION

  • Course Introduction
  • Introduction to Oracle Linux
  • Installing Oracle Linux 7
  • Oracle Linux 7 Boot Process
  • System Configuration
  • Package Management
  • Ksplice
  • Automate Tasks
  • Kernel Module Configuration
  • User and Group Administration
  • Partitions, File Systems, and Swap
  • Implementing the XFS File System
  • Implementing the Btrfs File System
  • Storage Administration
  • Network Configuration
  • File Sharing
  • OpenSSH Service
  • Security Administration
  • Oracle on Oracle
  • System Monitoring
  • System Logging
  • Troubleshooting