Vistula School of Hospitality

AVAILABLE TRAININGS

• Transport and aerospace industry specialist

  

  Want to be a Transport and aerospace industry specialist?
  Price: 14 980 zł 0 zł

   

  We invite you to FREE TRAININGS for students of the Vistula School of Hospitality (formerly Warsaw School of Tourism and Hospitality Management), which are implemented as part of the project “Tourism Education of the Future – a comprehensive program to improve the quality of teaching process management and teaching quality at the Warsaw School of Tourism and Hospitality Management”.

   

  PROJECT PARTICIPANTS

  The trainings are addressed to full-time and part-time students of the 1st and 2nd degree studies in the fields of “tourism and recreation” and “dietetics”, who are not on the 1st and 2nd semester of bachelor studies.

   

  The trainings include two certified trainings which end with an exam.

  The trainings will be on-line and exercises in the form of e-learning.

   

  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.

  Training dates:

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

  15.02-05.03.2021 (from Monday to Friday, 4:15 pm to 7.30 pm)

  Deadline for the implementation of e-learning exercises: to 21.03.2021

  Exam: 17.04.2021

   

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

  08.03-26.03.2021 (from Monday to Friday, 4:15 pm to 7.30 pm)

  Deadline for the implementation of e-learning exercises: to 10.04.2021

  Exam: 18.04.2021

   

  Your application send here:: szkolenia@vistula.edu.pl

  Deadline: to 15.01.2021

   

  HOW CAN YOU ENROLL FOR THE TRAINING?

  • send the application with information about the year and field of study to the address szkolenia@vistula.edu.pl
  • Complete the recruitment documents provided by the Project Office
  • Provide the documents as indicated in the e-mail by the Project Office
  • Come to the Training!

• Data Analyst-32h

  ⇒ W-16h 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

  ⇒ W-16h 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

• Advanced Data Analyst-48h

  ⇒ T-24h 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

   

  ⇒ W-24h 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.

• Cloud Aplication Developer-112h

  ⇒ T-40h MS 20483 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

   

  ⇒ T-32h MS 20532 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

   

  ⇒ T-40h MS 20487 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

• Team Leader-48h

  ⇒  CT-32h 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

   

  ⇒  W-16h 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

• Project Manager (Agile)-56h

  ⇒ CS-24h Prince2® Foundation

  This training will allow you to gain knowledge about:

  • PRINCE2® rules and business justification
  • final product
  • strategic project management
  • quality, plans, risks in a project
  • control and completion of a project stage and delivery of products
  • project closure

   

  ⇒ W-16h Effective Team Management and Team Motivation Skills

  During this workshop you will gain knowledge about:

  • defining the significance of a vision, mission and values
  • employee involvement in relation to organization strategies, motivation
    theories, leadership styles that help increase the effectiveness of individual people and teams

   

  ⇒ W-16h 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

• Advanced Project Manager -56h

  ⇒ CT-24h Prince2® Foundation

  During this training you will gain knowledge about:

  • PRINCE2® Methodology (Effective Project Management)
  • key issues necessary for the effective use of the PRINCE2® methodology,
    including the correct start-up, conscious running and controlled closure of
    the project

   

  ⇒ CS-24h Prince2® Agile Practitioner

  During this training you will learn more about:

  • project management using Agile techniques based on the PRINCE2 AgileTM
    guide (organization, risk management, product development, progress
    visualization tools)

   

  ⇒ W-8h 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)

• Specialist for managing suppliers in IT projects -72h

  ⇒ W-16h How to talk about services with the Business?

  During this workshop you will gain knowledge about:

  • building the Business – IT and IT – Supplier partner relations
  • roles at the interface between IT and Sub-suppliers: Suppliers Manager,
    Contract Manager and Sub-supplier
  • effective service level management – process, goals, key steps, products,
    challenges
  • effective supplier management – process, goals, key steps, products,
    challenges

   

  ⇒ CT-24h PRINCE2® Foundation

  This training will allow you to gain knowledge about:

  • PRINCE2® Methodology (Effective Project Management)
  • key issues necessary for the effective use of the PRINCE2® methodology,
    including the correct start-up, conscious running and controlled closure of
    the project

   

  ⇒ W-16h 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

   

  ⇒ W-16h 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

• Sales Specialist-40h

  ⇒ W-24h 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

   

  ⇒ W-16h 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

• Accounting and finance department specialist -88h

  ⇒ W-24h 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

   

  ⇒ W-40h 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

   

  ⇒ W-16h 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

   

  ⇒ W-8h 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

• HR & Payroll Specialist-72h

  ⇒ W-24h 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

   

  ⇒ W-24h 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

  ⇒ W-16h 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

  ⇒ W-8h 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

• Leasing Specialist-32h

  • ⇒ W-16h 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

    ⇒ W-16h 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