Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.
Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar
Managers at all levels have to be able to introduce, lead and manage change to ensure the organisational objectives of change are met.
Hiring the right staff is one of the most important management and HR skills and it is critical to get it right. This course is designed for managers and HR specialists who either want to improve their interviewing skills or who are just now starting a recruitment role in the organisation.
For anyone who has to deliver presentations who wants to become more confident and improve their speaking skills.
This is a specialist training course for senior managers or newly appointed safeguarding leads who are responsible for safeguarding adults from neglect and harm
Networks demystified training course description A concise overview course covering all aspects of networking with particular emphasis of use of the 7 layer model as a framework for discussing and learning new network terms enabling delegates to recognise the main buzzwords used in the industry. What will you learn Use the 7 layer model to classify networking terms. Differentiate between LANS and WANS. Recognise bandwidth measurements. List LAN and WAN technologies. Recognise cabling issues in a network. Networks demystified training course details Who will benefit: Sales staff, managers and other non-technical personnel. Technical personnel may benefit more from our Intro to data communications and networking course. Prerequisites: None. Duration 1 day Networks demystified training course contents What are networks? What is a network? Types of network, Local Area Networks (LANs), Wide Area Networks (WANs), connecting networks together with routers. The 7 layer model What is the 7 layer model? The importance of standards, using the 7 layer model to classify networking terms. Cables Copper, Fibre, Air, standards, connectors, LAN cables, WAN cables, distance limitations, hubs and repeaters, other issues. The radio spectrum. Bandwidth Bits and bytes. Bandwidth measurements, common technologies and their bandwidth, the impact of applications on bandwidth. Full and half duplex. Joining cables together to increase bandwidth (Link aggregation). LANs and WANs What is Ethernet? What is WiFi? What are Leased lines? What is MPLS? Ethernet switches Ethernet 'packets', MAC addresses, what is a switch, what is the difference between a hub and a switch. TCP/IP What is TCP/IP? What is a protocol? What is IP? What is TCP? The role of routers in joining LANS and WANS, What is the Internet? Applications Ways to use the network, clients, servers, web browsing and HTTP, Email, instant messaging, multimedia applications.
The leadership role of the project manager is increasingly recognised as a key determinant in delivering success. These skills can often be critical in project situations, where tight budgets and deadlines demand the highest levels of team performance and where the working environment presents fresh challenges on a daily basis. This programme focuses on the leadership skills required of project managers and will benefit anyone involved in managing projects large or small wishing to extend or enhance those skills. The objectives of this programme are to help the participants: Understand the significance of leadership skills to the project manager and the impact of these skills on project performance Review the key skills needed to be an effective 'multi-dimensional' project leader and learn how to develop, adapt and apply them in practice Learn how to identify the preferred leadership style for the context and organisational culture of a project and how to develop personal style versatility Understand the role of the project leader in building an effective team and the skills required to promote and sustain team performance Gain a better understanding of the interpersonal skills needed to motivate individual team members and harness the full potential of the team DAY ONE 1 Introduction Aims and objectives Personal objectives 2 Project management and leadership What is a leader? How much can leadership be learned? The project environment and the impact of leadership skills The characteristics of high performance project teams and their leaders 3 Principles of effective leadership Some useful models and theories of leadership explored Types of leadership; choosing how to use leadership power Evaluating personal leadership style; how to develop style flexibility 4 Syndicate case study: Leadership in action Review of the role of leadership in a contemporary project Feedback and plenary discussion: effective project leadership 5 Team exercise: Leadership skills of the project manager Teams compete in performing a project simulation Project review and feedback Discussion of the outcome: role and skills of the project leader 6 Leadership skills for project managers The 3 dimensions of project leadership: inwards, outwards, and upwards The vital role of communication skills and how to develop them Developing a 'project vision': strategic thinking skills Understanding others; emotional intelligence skills Being a visible leader; behavioural and influencing skills Building effective relationships; the importance of trust and respect DAY TWO 7 Leading the project team The role of leadership in developing team performance Understanding individual strengths; recognising team role preferences Managing conflict and promoting positive team dynamics Setting standards, maintaining discipline and rewarding performance Harnessing team potential: building motivation within the team Promoting team learning; the team leader as coach / mentor 8 Leading through the organisation Gaining the support others; developing effective influencing skills Getting empowerment from key stakeholders Knowing when and how to take the initiative and lead Building and maintaining rapport with key partners Becoming an effective team player in leadership teams Becoming a business leader; leading colleagues and co-workers 9 Team exercise: Leadership and negotiation Teams engage in a negotiation exercise Exercise review and feedback Discussion of the outcome: negotiation skills of the project leader 10 Negotiation skills for project leaders Characteristics of effective negotiators Classic problem behaviours and mind-sets to avoid Getting to win-win; building partnership and trust 11 Leading more senior stakeholders The challenges and skills of leading and managing upwards Communicating with more senior stakeholders; building credibility Negotiating upwards: knowing when and how The role of networking skills; building and maintaining rapport Handling disagreements; the art of diplomacy Handling personality and style conflicts with more senior people
This two-day CPD approved programme provides delegates with the skills, competencies and strategies to undertake an effective mediation intervention as part of their existing role. The course is delivered by some of the top mediation trainers in the UK and it is powered by TCM’s award-winning FAIR Mediation Model™.
Why Learn Sketchup and Stable Diffusion Rendering Course? Course Link SketchUp and Stable Diffusion Rendering Course. An AI image creation course designed to explore AI image creation techniques and master the use of advanced AI technology. You'll learn Ai 3D modeling, advanced rendering, and lighting techniques. Duration: 16 hrs. Method: 1-on-1 Online Over Zoom is also available. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. The Sketchup and Stable Diffusion Rendering Course equips students with comprehensive skills for visually stunning Ai (Artificial intelligence) 3D models and renderings. Master Sketchup's user-friendly interface, advanced rendering techniques, and stable diffusion rendering. Hands-on exercises and real-world projects enhance learning. Ideal for architecture, interior design, product development, and visualization careers. The Sketchup and Stable Diffusion Rendering Course equips students with comprehensive skills for visually stunning Ai (Artificial intelligence) 3D models and renderings. Master Sketchup's user-friendly interface, advanced rendering techniques, and stable diffusion rendering. Hands-on exercises and real-world projects enhance learning. Ideal for architecture, interior design, product development, and visualization careers. Sketchup and Stable Diffusion Rendering Course (16 hours) Module 1: Introduction to Sketchup (2 hours) Overview of Sketchup software and interface navigation Basic drawing tools and geometry creation techniques Module 2: Texturing and Materials (2 hours) Applying textures and customizing materials Exploring texture mapping and material libraries Module 3: Lighting and Shadows (2 hours) Understanding lighting principles and light placement Creating realistic shadows and reflections Module 4: Advanced Modeling Techniques (3 hours) Creating complex shapes and utilizing advanced tools Working with groups, components, and modifiers Module 5: Stable Diffusion Rendering (2 hours) Introduction to stable diffusion rendering Configuring rendering settings for optimal results Module 6: Scene Composition and Camera Setup (2 hours) Exploring composition principles and camera perspectives Managing scenes and creating walkthrough animations Module 7: Rendering Optimization (2 hours) Optimizing models for faster rendering Using render passes and post-processing techniques Module 8: Project Work and Portfolio Development (1 hour) Applying skills to complete a real-world project Showcasing work in a professional portfolio Optional: Installing Stable Diffusion and Python (Additional 10 hours) Module 1: Introduction to Stable Diffusion and Python Overview of Stable Diffusion and Python's significance Module 2: System Requirements Hardware and software prerequisites for installation Module 3: Installing Python Step-by-step installation process for different OS Module 4: Configuring Python Environment Setting up environment variables and package managers Module 5: Installing Stable Diffusion Downloading and installing the Stable Diffusion package Module 6: Setting Up Development Environment Configuring IDEs for Python and Stable Diffusion Module 7: Troubleshooting and Common Issues Identifying and resolving common installation errors Module 8: Best Practices and Recommendations Managing Python and Stable Diffusion installations Module 9: Practical Examples and Projects Hands-on exercises demonstrating usage of Stable Diffusion and Python Module 10: Advanced Topics (Optional) Exploring advanced features and techniques Stable Diffusion UI v2 | A simple 1-click way to install and use https://stable-diffusion-ui.github.io A simple 1-click way to install and use Stable Diffusion on your own computer. ... Get started by downloading the software and running the simple installer. Learning Outcomes: Upon completing the Sketchup and Stable Diffusion Rendering Course, with a focus on AI image rendering, participants will: Master AI Image Rendering: Gain expertise in using AI-powered rendering techniques to create realistic and high-quality visualizations. Utilize Sketchup for 3D Modeling: Navigate the software, proficiently use drawing tools, and create detailed 3D models. Optimize Renderings: Apply AI-based rendering to optimize model visuals, achieving faster rendering times and superior image quality. Implement AI-driven Lighting and Shadows: Utilize AI algorithms for lighting placement, shadows, and reflections, enhancing realism in renderings. Create Professional Portfolio: Showcase AI-rendered projects in a professional portfolio, highlighting advanced image rendering skills. Note: The course focuses on AI image rendering using Sketchup and Stable Diffusion techniques, empowering participants with cutting-edge skills for creating exceptional visual representations.