Shortcuts

Basics of air transport and air transport management (60 h)

During this training you will learn more about:

• the emergence and development of the aerospace industry;
• operational and business functions of an airline;
• key airline employees – their responsibilities, tasks, and areas of responsibility;
• ways of effective management;
• crisis management.

Basics of the aerospace industry and management of an aerospace industry company (60 h)

During this training you will learn more about:

• the emergence, development, and the present of the aerospace industry;
• international and regional aerospace organizations and institutions;
• key employees of aerospace institutions and organizations – their duties, tasks, and areas of responsibility.

After each training Participants will have to do exercises via e-learning (20 h) and pass a certified exam.

Data analysis in MS Excel

You will learn more about:

• preparation of data for analysis
• creation of sheets
• use of various Excel functions
• data analysis and evaluation
• carrying out forecasts and simulations
• use of scenarios
• carrying out analyzes with the use of a pivot table

Using Power Pivot tool in data analysis

You will learn more about:

• downloading data to the Power Pivot too
• building and managing database relationships
• creating tables and pivot charts based on prepared data
• the use of Data Analysis Expressions

MS 40364 Basics of database administration

You will learn more about:

• key concepts regarding databases
• creating database object
• data manipulation
• data storage
• selected issues of database administration

Downloading and modification of data from the SQL database

You will learn more about:

• basic concepts of database structure
• connecting the client application to the database
• obtaining information about database objects
• defining the data source for the SELECT command
• selecting columns and the use of aliases
• filtering data, combining files
• sorting the result set
• grouping data (GROUP BY), aggregating data using aggregate functions (sum, average, minimum, max, counter)
• the use of selected built-in functions
• conversion of data types, the use of stored procedures
• the use of auxiliary permanent and temporary tables
• adding new rows using the INSERT command
• modifying the existing data using the UPDATE command
• deleting data using the DELETE command
• MS SQL Window functions: ranking, aggregation, offset, analytic, MS SQL Pivot LINPIVOT, MS SQL Spatial Data, VS SQL XML. VS SQL JSON.

Programming in C#

This training will allow you to gain knowledge about:

• C language syntax
• methods, exception handling and application monitoring
• structure and enumeration
• creating collection classes
• creating a hierarchy of classes using inheritance
• reading and writing data locally
• accessing databases
• remote accessing data via WS and Cloud
• user interface design for graphic applications
• ensuring application performance through multithreading and asynchrony
• integration of unmanaged code
• code management
• data encryption and decryption

Creating Solutions for Microsoft Azure

During this training you will learn more about:

• introduction to the Microsoft Azure platform
• creating a development environment using Azure virtual machines
• hosting web applications on the Azure platform
• storing SQL data in Azure
• designing flexible applications in the cloud
• management of cloud services in Azure
• non-logical data storage in Azure
• storing and the use of files in Azure Storage
• communication strategy design using queues and service bus
• Azure infrastructure management
• automation of integration with Azure resources
• securing web applications in Azure
• maintaining and monitoring web application solutions in Azure

Programming of WEB Services and Azure Services

During this training you will learn more about:

• introduction to cloud technology services
• accessing data using the Entity Framework
• creating and using ASP.NET Web API services
• expanding and protecting services written with the use of Web API
• creating services using WCF
• services hosting
• Windows Azure Service Bus
• implementation of services
• storing data through Windows Azure Storage
• monitoring and diagnostics
• authentication and access management
• service scaling
• Appendix A: Designing and extending WCF services
• Appendix B: Securing services written using WCF

Agile for Project Managers

During this workshop you will gain knowledge about:

• Agile philosophy
• Roles and responsibilities in the project
• Managing the Agile project
• Agile processes and products
• Communication within the project
• Setting priorities
• Steering the Agile project
• Planning agile projects

Business simulation using Citta Ideale business type game

During this workshop you will gain knowledge about:

• effective use of Agile philosophies and techniques in complex, multi-team
  project environments
• possibilities of independent decision making
• analyzing the achieved results in order to draw conclusions for the future
• daily work practices of Scrum teams
• planning and coordination of a complex agile project
• ways of cooperating with the corporate governance bodies of the PRINCE2®
  methodology (Effective Project Management)

SLA agreements for IT services delivery (SLA)

During this workshop you will learn more about:

• creating good contracts for the provision of IT services (SLAs, OLA contracts with external suppliers)
• daily contract management
• reporting and acceptance of provided services

Purchasing Negotiations

During this workshop you will learn more about:

• the essence of purchasing negotiations
• evaluation of the negotiating partner
• exerting influence on the negotiating partner
• techniques used during purchasing negotiations
• selected elements of training assertiveness used in negotiations

Team Skills and Leadership (Team Management and Leadership)

During this training you will learn about:

Team management through:

• defining roles in a team
• identification of manager values and behaviors
• recognizing your own style of management to increase the efficiency of individual people and teams
• organization of your own work and the work of the team

How to increase teamwork efficiency by:

• analysis of the influence of the leadership style on the team’s performance based on case study
• defining the importance of team performance in achieving organizational goals
• recognizing and eliminating poor results
• application of incentive techniques to increase team and individual performance
• resolving conflicts

Training of Creative Thinking Techniques and Problem Solving

During this training you will learn:

• how to effectively identify problems in the workplace
• methods of generating appropriate solutions
• techniques of delegating activities within given solutions
• methods for assessing solutions and monitoring their implementation

IT support for budgeting provided services

During this workshop you will learn about:

• preparation data for analysis
• organizing the data on the sheet
• monitoring data correctness with respect to defined assumptions
• creating sheets and reports
• using built-in functions
• making investment decisions in the context of the results of the analysis
• using scenarios to compare simulation values
• analysis of reports using a PivotTable and PivotChart report
• integrating Microsoft Excel with other programs

Using CRM type of applications

During this workshop you will learn:

• account and contacts data management
• handling activities
• bidding, ordering
• scheduling the salesman’s work
• queue management
• sales analysis

Analysis of financial and accounting data in Microsoft Excel

During this workshop you will learn more about:

• preparing data to conduct a financial analysis
• organizing the data on the sheet
• monitoring data correctness of with respect to defined assumptions
• creating financial sheets
• use of financial functions
• investment assessment and analysis
• making investment decisions in the context of a changing financial situation
• financial forecasting and simulation
• using scenarios to compare the value of financial sheets
• analysis of financial statements using the PivotTable and PivotChart report
• integration of Microsoft Excel with other programs

Support for full accounting in the enterprise using industry-specific software

During this workshop you will learn more about:

• account assignment and booking of documents
• the use of an automatic account assignment
• preparing e-Declaration and e-transfers
• VAT registers handling
• cost planning

Fixed asset management using industry-specific software

During this workshop you will gain knowledge about:

• keeping records of fixed assets of the enterprise
• keeping equipment records
• handling fixed assets
• depreciation calculation

Analysis and reporting of data using industry-specific software

During this workshop you will gain knowledge about:

• creating multidimensional financial analyzes
• creating multidimensional analyzes in the area of controlling

The Use of Excel by an HR & Payroll Specialist

During this workshop you will learn more about:

• preparing data for analysis
• organizing data on the sheet
• monitoring the correctness of data with respect to defined assumptions
• creating HR and payroll statements
• using financial functions
• using scenarios to compare the values of generated sheets
• data visualization
• analysis of reports using a PivotTable and PivotChart report
• Microsoft Excel integration with other programs

Support of industry-specific software for HR and payroll processes

During this workshop you will learn more about:

• creating HR and payroll documents and declarations
• servicing civil law contracts
• remuneration budgeting and settlement
• exporting of data to the Płatnik program and the use of PFRON system

The use of the Płatnik program

During this workshop you will gain knowledge about:

• data import in the Płatnik program
• creating and handling sets of settlement declarations
• bilateral information exchange with the Social Insurance Institution system

Analysis of data and reporting using industry-specific software

During this workshop you will gain knowledge about:

• creating multidimensional analyzes in the HR area
• use of IT applications for recording and analyzing of concluded contracts
  (employment contract, contract of mandate or task-specific contract)
• exporting to generally used file formats

Basic use of IT applications supporting the process of concluding a leasing contract

During this workshop you will learn more about:

• handling customer records
• establishing new contracts
• servicing active contracts
• contracts transfer and closure

Basic use of applications conducting financial and accounting processes in leasing

During this workshop you will learn more about:

• booking documents regarding leasing contracts
• settlement of accounts with Users
• invoicing and re-invoicing
• the use of VAT registers and generating reports