EDUCATION: ZBP (Association of Polish Banks) [2004]

ZBP (Association of Polish Banks)

Professional Degree

Independent Bank Employee

Temporarily please use Google Transaltor on the right panel

Tytuł stanowi potwierdzenie posiadania wiedzy ogólnobankowej z zakresu:

·       Pieniądz i bankowość,

·       Organizacja i zarządzanie bankiem komercyjnym,

·       Operacje bankowe krajowe i zagraniczne,

·       Rachunkowość bankowa,

·       Działalność kredytowa banku,

·       Rynek pieniężny i kapitałowy,

·       Marketing bankowy,

·       Informacja i informatyka bankowa,

·       Stosowanie prawa w działalności banku.

ADDITIONAL TRAININGS: ORACLE 9i - Backup, recovery and network administration

ORACLE: Certificate of Attendance
(Oracle9i Database Administration Fundamentals I)

COURSE TOPICS:

Networking Overview
* Explaining solutions included with Oracle9i for managing complex networks
* Describing Oracle networking add-on solutions

Basic Oracle Net Architecture
* Explaining the key components of Oracle Net architecture
* Explaining Oracle Net Services role in client-server connections
* Describing how web client connections are established through Oracle networking products

Basic Oracle Net Services Server-Side Configuration
* Identifying How the Listener Responds to Incoming Connections
* Configuring the Listener using Oracle Net Manager
* Controlling the Oracle Net Listener by Using the Listener Control Utility
* Describing Dynamic Service Registration
* Configuring the Listener for IIOP and HTTP Connections

Basic Oracle Net Services Client-Side Configuration
* Describing the Difference Between Host Naming and Local Service Name Resolution
* Using Oracle Net Configuration Assistant to Configure Host Naming Method, Local Naming Method, and Net Service Names
* Performing Simple Connection Troubleshooting

Usage and Configuration of the Oracle Shared Server
* Identifying the Components of the Oracle Shared Server
* Describing the Oracle Shared Server Architecture
* Configuring Shared Servers by Using Initialization Parameter
* Configuring Dispatchers by Using Initialization Parameters
* Identifying Useful Data Dictionary Views

Backup and Recovery Overview
* Describing the Basics of Database Backup, Restore, and Recovery
* Listing the Types of Failures that May Occur in an Oracle Environment
* Defining a Backup and Recovery Strategy


Instance and Media Recovery Structures
* Describing the Oracle Processes, Memory Structures, and Files Relating to Recovery
* Identifying the Importance of Checkpoints, Redo Log Files, and Archived Log Files
* Describing Ways to Tune Instance Recovery

Configuration of the Database Archiving Mode
* Noarchivelog and Archivelog Mode Configuration
* Automatic and Manual Archiving of Redo Log Files
* Multiple Archival Destinations and Processes

Oracle Recovery Manager (RMAN) Overview and Configuration
* Identifying the Features and Components of RMAN
* Describing the RMAN Repository and Control File Usage
* Describing Channel Allocation
* Describing Media Management Library Interface
* Connecting to Recovery Manager
* Configuring the RMAN Environment

User-Managed Backups
* Describing User-Managed Backup and Recovery Operations
* Performing Closed Database Backups
* Performing Open Database Backups
* Cleaning Up After a Failed Online Backup
* Backing Up the Control File
* Discussing Backup Issues Associated with Read-Only Tablespaces
* Identifying the Backup Implications of Operations with NOLOGGING Options
* Using DBVerify to Check for Block Corruption

RMAN Backups
* Identifying RMAN Specific Backups
* Using the RMAN BACKUP Command to Create Backup Sets
* Backing Up the Control File
* Backing Up the Archived Redo Log Files
* Using the RMAN COPY Command to Create Image Copies

User-Managed Complete Recovery
* Describing Media Recovery
* Performing Recovery in Noarchivelog Mode
* Performing Recovery in Archivelog Mode
* Read-only Tablespace Recovery
* Relocating and Recovering a Tablespace


RMAN Complete Recovery
* Describing the Use of RMAN for Restoration and Recovery
* Performing Recovery in Noarchivelog Mode
* Performing Completing Recovery in Archivelog Mode
* Restoring Data Files to a Different Location
* Relocating and Recovering a Tablespace

User-Managed Incomplete Recovery
* Describing the Steps of Incomplete Recovery
* Identifying the Situations Which Require Incomplete Recovery
* Performing an Incomplete Recovery
* Recovering from the Loss of Current Online Redo Logs

RMAN Incomplete Recovery
* Performing Incomplete Recovery Using UNTIL TIME
* Performing Incomplete Recovery Using UNTIL SEQUENCE

RMAN Repository Maintenance
* Performing Crosschecking of Backups and Copies
* Updating the Repository When Backups Have Been Deleted
* Changing the Availability Status of Backups and Copies
* Making a Backup or Copy Exempt from the Retention Policy
* Cataloging Backups Made with Operating System Commands

RMAN Catalog Creation and Usage
* Describing the Contents of the Recovery Catalog
* Listing the RMAN Features Which Require the Recovery Catalog
* Creating the Recovery Catalog
* Maintaining the Recovery Catalog by Using RMAN Commands
* Using RMAN to Register, Resynchronize, and Reset a Database
* Querying the Recovery Catalog to Generate Reports and Lists
* Creating, Storing and Executing Scripts
* Describing Methods for Backing Up and Recovering the Recovery Catalog

Transporting Data Between Databases
* Export
* Import
* Guidelines for Using Export and Import

Backup and Recovery and Networking Workshop


COURSE OBJECTIVES:
* Define networking requirements and the solutions provided by Oracle to implement these requirements
* Perform database and datafile backups with and without Recovery Manager (RMAN)
* Configure the network environment for an Oracle client-server system
* List the different Oracle backup methods and recovery operations that can be used to resolve database failure
* Describe the database utilities (Export and Import) and the situations where they can be used
* Develop network configuration and recovery techniques through various workshop scenarios
* List the Oracle architecture components related to backup and recovery operations

ADDITIONAL TRAININGS: ORACLE 9i - Database Administration

ORACLE: Certificate of Attendance
(Oracle9i Database Administration Fundamentals I)

COURSE TOPICS:

Oracle Architectural Components
* Defining an Oracle Database, the Oracle server, and the Oracle Instance
* Establishing a connection and creating a session
* Understanding the physical structure
* Understanding the memory structure
* Understanding the process structure
* Understanding the logical structure
* Outlining the stages of an SQL statement

Getting Started with the Oracle Server
* Identifying database administrative tools

Identifying the features of the Universal Installer

Defining the Optimal Flexible Architecture

Creating a database during installation

Creating a new database

Identifying database administrative users
* Understanding operating system and password file authentication
* SQL*Plus
* Enterprise Manager

Managing an Oracle Instance
* Creating, managing, and using initialization files: PFILE and SPFILE
* Identifying the various states of starting an instance
* Identifying the various options available to shutdown an instance
* Monitoring Alert and Trace files

Creating a Database
* Using the Database Configuration Assistant to create a database
* Creating a database manually

Using the Data Dictionary
* Identifying the uses and contents of the data dictionary
* Using the data dictionary to retrieve information about the database

Maintaining the Control File
* Explaining the uses of the control file
* Listing the contents of the control file
* Multiplexing the control file
* Managing control file with Oracle Managed Files (OMF)
* Obtaining control file information

Maintaining Redo Log Files
* Explaining the purpose of and how online redo log files work
* Control log switches and checkpoints
* Maintaining online redo log files
* Managing online redo log files using OMF
* Multiplexing and maintaining online redo log files
* Archiving online redo log files
* Obtaining online and archived redo log file information

Managing Tablespaces and Datafiles

Describing storage hierarchy

Establishing the difference between SYSTEM and Non-SYSTEM tablespaces
* Creating and managing tablespaces
* Creating a tablespace when using OMF
* Obtaining tablespace and datafile information

Storage Structures and Relationships
* Describing the logical structure of the database (segments, extents, blocks)
* Listing the segment types and their uses
* Understanding the use of extents and their allocation and deallocation
* Understanding the structure of a database block
* Maintaining storage structures with automatic segment - space management
* Maintaining storage structures manually
* Obtaining storage structure information

Managing Undo Data
* Understanding the difference between automatic undo management and manual undo management

Creating and maintaining UNDO tablespaces
* Obtaining undo information

Managing Tables
* Creating and maintaining tables using appropriate storage settings
* Obtaining table information

Managing Indexes
* Listing the different types of indexes and their uses
* Creating b-tree and bitmap indexes
* Maintaining Indexes

Identifying unused indexes
* Obtaining index Information


COURSE OBJECTIVES:
* Manage tablespaces, segments, extents, and blocks
* Manage users, privileges, and resources
* Create an operational database
* Start up and shut down an Oracle instance and database
* Manage Oracle database files
* Use Globalization Support features

ADDITIONAL TRAININGS: ORACLE 9i - Introduction to SQL

ORACLE: Certificate of Attendance

COURSE TOPICS:

Introduction

* Describing the Life Cycle Development Phases
* Defining a Relational Database
* Discussing the Theoretical, Conceptual, and Physical Aspects of a Relational Database
* Describing How a Relational Database Management System (RDBMS) Is Used to Manage a Relational Database
* Describing the Oracle Implementation of Both the RDBMS and the Object Relational Database Management System (ORDBMS)
* Describing How SQL Is Used in the Oracle Product Set

Writing a Basic SQL Statement
* Describing the SQL Select Capabilities
* Executing a Basic Select Statement with the Mandatory Clauses
* Differentiating Between SQL and iSQL*Plus Commands

Restricting and Sorting Data
* Limiting the Rows Retrieved by a Query
* Sorting the Rows Retrieved by a Query

Single Row Functions
* Describing Various Types of Functions Available in SQL
* Using a Variety of Character, Number, and Date Functions in SELECT Statements
* Explaining What the Conversion Functions Are and How They Are Used
* Using Control Statements

Displaying Data from Multiple Tables
* Writing SELECT Statements to Access Data from More Than One Table
* Describing the Cartesian Product
* Describing and Using the Different Types of Joins
* Writing Joins Using the Tips Provided

Aggregating Data by Using Group Functions
* Identifying the Different Group Functions Available
* Explaining the Use of Group Functions
* Grouping Data by Using the GROUP BY Clause

Writing Subqueries
* Describing the Types of Problems That Subqueries Can Solve
* Describing Subqueries
* Listing the Types of Subqueries
* Writing Single-Row and Multi-Row Subqueries
* Describing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved

Producing Readable Output with iSQL*Plus
* Producing Queries That Require an Input Variable
* Customizing the iSQL*Plus Environment
* Producing More Readable Output
* Creating and Executing Script Files

Manipulating Data
* Describing Each Data Manipulation Language (DML) Command
* Inserting Rows into a Table
* Updating Rows in a Table
* Deleting Rows from a Table
* Merging Rows into a Table
* Controlling Transactions
* Describing Transaction Processing
* Describing Read Consistency and Implicit and Explicit Locking

Creating and Managing Tables
* Describing the Main Database Objects
* Creating Tables
* Describing the Oracle Data Types
* Altering Table Definitions
* Dropping, Renaming, and Truncating Tables

Including Constraints
* Describing Constraints
* Creating and Maintaining Constraints

Creating Views
* Describing Views and Their Uses
* Creating a View
* Retrieving Data by Means of a View
* Inserting, Updating, and Deleting Data Through Views
* Dropping Views
* Altering the Definition of a View
* Inline Views
*Top 'N' Analysis

Other Database Objects
* Creating, Maintaining, and Using Sequences
* Creating and Maintaining Indexes
* Creating Private and Public Synonyms

Controlling User Access
* Understanding the Concepts of Users, Roles, and Privileges
* Granting and Revoking Object Privileges
* Creating Roles and Granting Privileges to Roles
* Creating Synonyms for Ease of Table Access

SQL Workshop
* Applying Techniques Learned in This Course
* Preparing for Future Oracle Courses

Using Set Operators
* Describing the Set Operators
* Obeying the Set Operators Rules and Guidelines
* Using a Set Operator to Combine Multiple Queries into a Single Subquery
* Controlling the Order of Rows Returned

Oracle 9i Datetime Functions
* Using DATETIME Functions
* Using the NVL2 Function to Handle NULL Values

Enhancements to the GROUP BY Clause
* Using ROLLUP as an Extension to the GROUP BY Clause to Produce Subtotal Values
* Using CUBE as an Extension to the GROUP BY Clause to Produce Cross-Tabulation Values
* Using the GROUPING Function to Identify the Row Values Created by ROLLUP or CUBE Operators
* Using GROUPING SETS to Produce a Single Result Set That Is Equivalent to a UNION ALL Approach
* Using the WITH Clause

Advanced Subqueries
* Multiple-Column Subqueries
* Writing a Subquery in the FROM Clause
* Writing and describing Correlated Subquery
* Using EXISTS and NOT EXISTS Operators
* Updating and Deleting Rows Using Correlated Subqueries
* Using Scalar Subqueries in SQL

Hierarchical Retrieval
* Discussing the Benefits of the Hierarchical Query
* Ordering the Rows Retrieved by a Query in a Hierarchical Manner
* Formatting Hierarchical Data so That It Is Easy to Read
* Excluding Branches from the Tree Structure

Oracle9i Extensions to DML and DDL Statements
* Discussing Multitable Inserts
* Creating and Using External Tables
* Naming the Index and Using the CREATE INDEX Command at the Time of Creating Primary Key Constraint

COURSE OBJECTIVES:
* Describe relational and object relational database concepts
* Retrieve, insert, update, and delete data
* Use the Single row and Group functions
* Retrieve data using additional advanced techniques like using ROLLUP, CUBE, set operators, correlated subqueries and hierarchical queries
* Solve problems by using multicolumn subqueries, subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
* Use the iSQL*Plus environment
* Write scripts to generate script files
* Generate reports using iSQL*Plus
* Create and maintain database objects
* Control transactions
* Control data/user access
* Use the Oracle9i Single row functions
* Use GROUPING SETS and the WITH clause
* Use the Oracle9i extensions to DML and DDL statements
* Apply techniques in real life simulation

ADDITIONAL TRAININGS: IBM - AU14 – AIX 5L System Administration I: Implementation

IBM POLAND: CERTIFICATE

Learn how to install, customize, and handle common AIX system administration tasks using the AIX 5L Version 5.3 operating system in a multiuser environment; basic commands and skills for administering the AIX 5L Version 5.2 operating systems also.

Course outline
* Introduction (overview of pSeries)
* System management tools - System Management Interface Tool (SMIT) and the Web- based System Manager
* Software installation and management
* System startup and shutdown devices
* Printers and queues
* Managing queues
* System storage overview
* Working with the Logical Volume Manager
* Working with file systems
* Managing file systems
* Paging space
* Backup and restore
* Security
* User administration
* Scheduling
* Networking overview

Skills taught
* Install the AIX 5L Version 5.3 operating system, software bundles, and filesets
* Perform system startup and shutdown
* Understand and use the system management tools
* Manage physical and logical devices
* Perform file systems management
* Create and manage user and group accounts
* Perform and restore system backups
* Utilize administrative subsystems, including cron to schedule system tasks, and security to implement customized access of files and directories
* Describe basic AIX networking concepts