Successfully Managing Remote Working

Aims & Objectives
The aim of the training is to work on preparing managers to optimise the performance of their team in the remote working environment, developing key communication skills, relationship management techniques and practical tools and solutions for effectively operating in remote working arrangements.

The training will use reflection and self-development techniques to address the areas of communication, trust, culture wellbeing and individual differences in Remote Working and consider and reflect on key actions required to ensure successful management of remote working.

Who should Attend
The training is aimed at new and existing managers of remote workers and those keen to explore remote work arrangements. The training is tailored to consider the needs of managers managing partly or fully remote employees, operating in partially or fully remote organisations.

Course Content

  • Introduction to remote work: Types, Prevalence, Benefits and Challenges.
  • Culture and Remote Work: Examine and understand how culture supports or impedes the roll out of remote arrangements.
  • Communication and Collaboration in Remote Work: Emphasis on role of communication, Focus on tips for communication remotely, stakeholder identification and management, Differences between Communication and Collaboration.
  • Psychological Safety in Remote Teams: Examining remote team formation, agility and psychological safety.
  • Personality and Remote Working: Type theory and impact on communication, wellbeing, feedback etc. for Remote Working, Self-Reflection and strategy identification to deal with potential challenges.
  • Trust: Role of trust, Iterative nature of trust and how trust can be intentionally fostered in Remote Working Relationships, expectations and responsibilities in remote working relationships.
  • Tools: Types of tools used in Remote Working and how these can be harnessed effectively, including self-assessment of tools used, effectiveness and potential gaps.
  • Performance Management: Examining best practice in delivering feedback and tracking performance in Remote Working Arrangements
  • Well-being: Exploring boundary theory, time management, work environment and social needs and supports.

Skills Learned

  • Reflect on personal management and communication styles and how these impact on managing remote workers
  • Learn how to support a collaborative remote working arrangement
  • Develop tools for effective communication and collaboration with remote workers
  • Develop skills in building trusting working relationships
  • Explore well-being in the remote working context
  • Reflect on and develop personalised action plans for building your own management capacity

Corona virus update

Positive2Work Skillnet is fully supportive of the Government’s efforts to effectively address and limit the spread of COVID-19 and to safeguard the protection of public health and that of our stakeholders.

Positive2Work Skillnet management team are continuing to work and are available to discuss any queries that our businesses or trainees have regarding our scheduled training programmes and supports for businesses.

In support of this national effort, Positive2Work Skillnet has postponed its public training courses until 19th April 2020.

Positive2Work Skillnet will continue to take bookings for programmes commencing at a later date in 2020, and for our online programmes available at this link (if applicable).

We are also available to discuss your queries about any other future programmes we offer to our members.

Our Network contact details are.
NAME Mark Brennan
PHONE 085 1745779
EMAIL Mark@p2w.ie

We would remind our stakeholders that the HSE website www.hse.ie is the authoritative source of information and advice on the situation regarding COVID-19 in Ireland.

We will keep this information updated in the coming weeks. Further information is also available on the Skillnet Ireland website at www.skillnetireland.ie

SQL Fundamentals of Querying

A One Day Training Course
Overview
Students will learn what SQL is and how they can query a database to answer business questions.

Who Should Attend
Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with such terms as computer memory, data files, and program files. Students should also be familiar with the components that make up a personal computer, including input, output and storage devices.

Prerequisites
A basic knowledge of concepts related to database structure and terminology, such as fields (or columns) and records (or rows) is helpful.

Content
Lesson 1: Introduction to databases and SQL
Lesson 2: Introduction to the SELECT statement
Lesson 3: Calculating data
Lesson 4: Selecting specific rows
Lesson 5: Working with other operators
Lesson 6: Grouping data
Lesson 7: Multi-table queries
Lesson 8: Other SQL front-end applications
Appendices
The sample database

Advanced SQL Querying

A One Day Training Course
Overview
To develop the delegate’s use of SQL to and advanced level. this course introduces data manipulation language and database definition language.

Who Should Attend
You should attend this course if you wish to have a good understanding of all DML statements (SELECT, INSERT,
UPDATE, DELETE) and all of the DDL statements needed to build database objects (CREATE, DROP, ALTER). This course also covers the use of views, access control, transaction control, advanced select queries and using SQL scripts.

Prerequisites
Delegates for this course should have a good basic understanding of SQL select statements. This course assumes knowledge of SQL to the level of our Introduction course.

Content
Lesson 1: Querying with unions and advanced joins Querying multiple
tables with unions Advanced Joins Calculating with COMPUTE
Lesson 2: Querying with subqueries Subqueries
Lesson 3: Adding data Inserting data SELECT INTO
Lesson 4: Updating and removing data Updating records Deleting records Deleting the contents of tables
Lesson 5: Manipulating tables and views Creating tables Modifying tables Deleting tables Adding and removing views
Lesson 6: Manipulating indexes Adding and removing indexes
Lesson 7: Ensuring data integrity with transactions Transactions
Lesson 8: Creating databases Creating a database with SQL Deleting a database