• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

44232 Courses

Building Successful Work Relationships (Second Edition)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Professionals desiring to improve working relationships and maximize cooperation and productivity will benefit from this course. Overview After completing this workshop, students will be able to: Describe the importance of effective work relationships Identify the interdependencies between you and your colleagues Communicate effectively to create rapport and connect with others Identify and maintain your network of professional relationships Develop collaborative, trust-based relationships that achieve meaningful results In the interdependent workplace, we rely on each other to get things done. A professional network isn?t something we can take for granted ? mapping work relationships can be a complex task and understanding different behavioral styles takes effort - but it pays off! Good working relationships means more than just reducing conflict and misunderstandings. It also means building trust, increasing influence, and benefitting from the knowledge and advice of co-workers and senior managers. This workshop will help you develop relationship building skills so you can communicate who you are, what you need, and why you need it in a way that builds trust, respect, and a professional reputation. The Importance of Work Relationships Expectations of Work Relationships The Value of Relationships Effects of Work Relationships Mapping Your Work Relationships A Network of Relationships Mapping Work Relationships Languages of Appreciation Identifying Interdependencies Clarifying Purpose Systems Thinking Analyzing Independencies Bridging Work Styles Understanding Behavioral Styles Strengths and Trouble Spots Bridging Different Styles Building Your Network Relationships, Communication, and Results Networking Principles Reputation Management Collaborating For Success Understanding Personalities Aspects of Trust Recognizing Blind Spots Additional course details: Nexus Humans Building Successful Work Relationships (Second Edition) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Building Successful Work Relationships (Second Edition) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Building Successful Work Relationships (Second Edition)
Delivered OnlineFlexible Dates
Price on Enquiry

55366 Querying Data with Transact-SQL

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

55366 Querying Data with Transact-SQL
Delivered OnlineFlexible Dates
£2,976

Acting for Film 4 Day Intensive

By Actors Studio

With A-List Acting Coach Mel Churcher Introduction Work directly with World Renowned Acting, Voice and Dialect Coach, Mel Churcher on this highly practical 4 day training course. With over 35 years’ experience and an extensive credits list, Mel has worked with some of the biggest names in Showbusiness, training actors and working closely with Directors on a range of International Film and TV projects. Meet Your Tutor Mel Churcher A-Lister Coach Mel Churcher is one of the Worlds top Acting and Dialogue Coaches in Film and TV. Mel has coached actors such as Daisy Edgar-Jones (War of the Worlds), Michelle Yeoh (The Lady), Daniel Craig & Angelina Jolie (Lara Croft: Tomb Raider), Jet Li (Unleashed), Keira Knightley (The Hole, King Arthur), Henry Cavill (The Count of Monte Cristo), Sam Riley (Control). She has worked in the Voice Department of the Royal Shakespeare Company, Regent’s Park Open Air Theatre (where she was Head of Voice and Text for twelve years), Shakespeare’s Globe, The Young Vic, Manchester Royal Exchange, Birmingham Repertory Theatre and the Royal Court Theatre in London. Mel has published several globally successful books on screen acting. Mel's Work Course Outline Mel takes a holistic approach over 4 full days of in-person process, taking students through the step by step process of creating, developing and delivering assured on screen performances using a physical approach to fuse the actor and the role. This allows you to find freedom and life in your screen performance, put to the test as you film throughout the course. Day 1 Mel will look at you, your unique life, your shining eyes on screen and see how you can use your energy within the specifics of the role – so that your work is alive and truthful. You’ll look at the differences between our essential selves and learnt text. (Everyone will have a solo session on-screen with Mel.) Day 2 Filming will continue alongside tips and games on camera. You will work extensively on scenes. Day 3 You’ll look at rehearsal techniques and strategies to build a life for screen including breathing work, improvisation, psychological gestures, physical metaphor and Mel’s Elemental metaphors. Day 4 You will complete the scene work and summarise your new skills under Mel’s guidance then with a chance to ask Mel any personal questions about your skills and career.  Additional Information Features Work closely with A-List Acting Coach Mel Churcher Film scenes for future development Designed to enhance your screen acting skills Suitable if you are (17 yrs+) with some previous acting training or a professional actor Attracts a varied age range from 17 yrs+. International Students Welcome The course is taught in English, so it is important that you have proficient English language skills Small Class Size Learning Outcomes Build convincing characters Develop a holistic approach you can bring to set Learn to bring truth and life to every take Course Location Old Diorama Arts Centre, Regent’s Place, 201 Drummond St, London NW1 3FE Nearest Tube Stations: Warren Street (5 mins): Northern & Victoria lines Euston Square (5 mins): Circle, Hammersmith & Metropolitan lines Great Portland Street (5 mins): Circle, Hammersmith & Metropolitan lines Euston inc National Rail (10 mins): Northern & Victoria line.

Acting for Film 4 Day Intensive
Delivered In-PersonFlexible Dates
£650

Plugged in: Practical planning for EVI Installation

By Cenex (Centre of Excellence for Low Carbon & Fuel Cell Technologies)

Learn how to plan and connect EV infrastructure effectively. This practical workshop walks you through the key steps, risks and decisions.

Plugged in: Practical planning for EVI Installation
Delivered In-Person in InternationallyFlexible Dates
Price on Enquiry

L 3: Assessor Vocational Level (TAQA) Course

5.0(6)

By Learn More Academy Ltd

Level 3 Award in Assessing Vocational Related Achievement Course is the perfect qualification if you wish to become an assessor in workplace sector and also if you work in, or look to enter roles in assessment and internal quality assurance. The course will provide you with the opportunity to develop and improve your practice, as well as achieving a recognised qualification at the same time. It has been developed by LLUK to replace the Assessor and Verifier (A&V) units and is valid if you want to work in England, Wales and Northern Ireland. Depending on your current role, you can pick and choose the units that you require. ABOUT THIS COURSE: This assessor qualification is intended for people who assess vocational skills, knowledge and understanding in environments other than the work environment (for example a classroom, workshop, or any training environment). It includes the following assessment methods: Assessments of the learner in simulated environments, Skills tests, oral and written questions, assignments, projects, case studies and recognizing prior learning. UNITS COVERED: This Vocational level consists of the following 2 Units: Unit 1: Understanding the principles and practices of assessment D/601/5313 Unit 3: Assess vocational skills, knowledge and understanding F/601/5319 Please note it is not a requirement to do all 3 units to achieve the full qualification, selecting the unit will be depend on the nature of the job you do (Current profession) for example: If you work as a practitioner like assess the demonstration of competence in a work environment then you need to do competence level Unit 1 and Unit 2. ENTRY REQUIREMENT: There are no formal requirements for this course, however, candidates should be working in, or working towards a role in quality assurance. To undertake the full Award candidates are required to have access to two learners. COURSE ASSESSMENT: No closed book exam is required or there is no formal examination is required, however at the end of the course you need to submit a portfolio assignment with other necessary documents. WHY YOU CHOOSE US: • Qualified and long experienced trainers. • Recognised Training Provider. • Tutors support available. • 99% pass rate. • Very reasonable course fees. • No hidden cost/fees. • Quick result and certificates . • We have dedicated team to support you. • Career advise available if needed. HOW MUCH THIS COURSE COST? Level 3 Award in Assessing Vocational Related Achievement (TAQA) course will cost for Online Distance Learning £309.99 and for Webinar Classroom based course £429.99 There is no any hidden fess/cost.

L 3: Assessor Vocational Level (TAQA) Course
Delivered Online & In-PersonFlexible Dates
£429.99

IWFM Level 4 Diploma in Facilities Management

By The Business School (UK) Ltd

The Level 4 Certificate gives a broad understanding of the professional and provides the skills needed to complete complex, non-routine tasks within workplace and facilities management. It's for you if you work at an operational management level or if you are aspiring to these roles and want to stretch and develop your knowledge and capability.

IWFM Level 4 Diploma in Facilities Management
Delivered Online On Demand
£1,925

Combined Level 3 First Aid At Work & Paediatric First Aid (RQF)

By NR Medical Training

The Combined First Aid at Work and Paediatric First Aid course has been specifically designed for those who work in settings that require both First Aiders and Paediatric First Aiders, such as schools, sports clubs, or other childcare settings, and has been perfectly streamlined to avoid the duplication of topics associated with attending both the First Aid at Work and Paediatric First Aid courses separately.

Combined Level 3 First Aid At Work & Paediatric First Aid (RQF)
Delivered In-Person in Bury St Edmunds + 1 more or UK WideFlexible Dates
Price on Enquiry

Introduction to Geothermal Exploration and Development

By EnergyEdge - Training for a Sustainable Energy Future

Enhance your knowledge with EnergyEdge course on geothermal exploration and development. Join us to gain valuable insights and skills.

Introduction to Geothermal Exploration and Development
Delivered In-PersonFlexible Dates
£2,599 to £2,699

Project Management Fundamentals - Japanese: On-Demand

By IIL Europe Ltd

Project Management Fundamentals - Japanese: On-Demand Many projects are run by highly qualified, talented people with little or no training in project management. They carry out projects such as process improvement, marketing campaign development, new product development, event planning and production, as if they were "work". Project Management Fundamentals (PMF) was created to help those who need a solid foundation in project management to learn on the job without undue burden. is. This course provides practical skills, concepts and principles that you can take back to the workplace, and the insight you need to adapt them to your specific project environment. PMF's course goal is to achieve quality performance by learning effective planning and control, so it emphasizes process-oriented and analytical, systems-oriented approaches. These frameworks promote the project-related problem-solving and decision-making skills needed in real-world projects. We also focus on the collaboration, clear person-to-person communication, interpersonal and interpersonal skills required for the project. These needs are recognized throughout PMF, but are highlighted in two areas: Module 2 - People and Projects Module 8 - Execution, Communication and Team Development What You Will Learn By the end of this course, you should be able to: Explain the value of strong project management Identify the characteristics of successful projects and project managers Recognize how current agile/adaptive practices fit into project management Learn project management processes such as initiation, planning, execution, monitoring and control, and closing Leverage project management processes and tools based on case studies and real-world situations Create initial project plan Using standard project management terminology Basic Concepts Project management and its definition PM value and key points Competing Constraints and Project Success Project life cycle People and Projects Overview of people and projects Project manager Project team people and projects in the organization Module 3 - Initiation and Requirements Definition Project launch Formulation of project charter Conducting stakeholder evaluations Requirements definition Using the Work Breakdown Structure Define Work Breakdown Structure (WBS) Development of usable WBS Utilization of WBS Project Risk Management Need for risk management Overview of risk-aware planning Identification of risks Risk analysis Risk response plan Implementing countermeasures and monitoring risks Environmental considerations that require adaptability Quotation Quote definition Quotation approach How to estimate cost estimate Quotation Validation Scheduling Definition of the scheduling process and related terms Defining sequences and dependencies Determining the critical path Examination of schedule risk and optimization of schedule Execution, Communication and Team Development From baseline to execution Project communication and stakeholder relationships high performance team Monitoring and Control Definition of monitoring and control See control through the lens of competing demands Variance analysis and corrective action (earned value) Adaptive environment considerations Project Closure Closing the project Focus on project migration Focus on post-project evaluation

Project Management Fundamentals - Japanese: On-Demand
Delivered Online On Demand12 hours
£1,250

Project Management Fundamentals - Japanese: On-Demand

By IIL Europe Ltd

Project Management Fundamentals - Japanese: On-Demand Many projects are run by highly qualified, talented people with little or no training in project management. They carry out projects such as process improvement, marketing campaign development, new product development, event planning and production, as if they were "work". Project Management Fundamentals (PMF) was created to help those who need a solid foundation in project management to learn on the job without undue burden. is. This course provides practical skills, concepts and principles that you can take back to the workplace, and the insight you need to adapt them to your specific project environment. PMF's course goal is to achieve quality performance by learning effective planning and control, so it emphasizes process-oriented and analytical, systems-oriented approaches. These frameworks promote the project-related problem-solving and decision-making skills needed in real-world projects. We also focus on the collaboration, clear person-to-person communication, interpersonal and interpersonal skills required for the project. These needs are recognized throughout PMF, but are highlighted in two areas: Module 2 - People and Projects Module 8 - Execution, Communication and Team Development What You Will Learn By the end of this course, you should be able to: Explain the value of strong project management Identify the characteristics of successful projects and project managers Recognize how current agile/adaptive practices fit into project management Learn project management processes such as initiation, planning, execution, monitoring and control, and closing Leverage project management processes and tools based on case studies and real-world situations Create initial project plan Using standard project management terminology Basic Concepts Project management and its definition PM value and key points Competing Constraints and Project Success Project life cycle People and Projects Overview of people and projects Project manager Project team people and projects in the organization Module 3 - Initiation and Requirements Definition Project launch Formulation of project charter Conducting stakeholder evaluations Requirements definition Using the Work Breakdown Structure Define Work Breakdown Structure (WBS) Development of usable WBS Utilization of WBS Project Risk Management Need for risk management Overview of risk-aware planning Identification of risks Risk analysis Risk response plan Implementing countermeasures and monitoring risks Environmental considerations that require adaptability Quotation Quote definition Quotation approach How to estimate cost estimate Quotation Validation Scheduling Definition of the scheduling process and related terms Defining sequences and dependencies Determining the critical path Examination of schedule risk and optimization of schedule Execution, Communication and Team Development From baseline to execution Project communication and stakeholder relationships high performance team Monitoring and Control Definition of monitoring and control See control through the lens of competing demands Variance analysis and corrective action (earned value) Adaptive environment considerations Project Closure Closing the project Focus on project migration Focus on post-project evaluation

Project Management Fundamentals - Japanese: On-Demand
Delivered Online On Demand3 hours
£1,250