22047 Courses

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions

Global Project Management In this course, you will dig deeper-and differently-into project management processes, tools, and techniques, developing the ability to see them through the lens of global and cultural project impacts. In today's increasingly global environment, managing a project with customers and support organizations spread across multiple countries and continents is a major challenge. From identifying stakeholders and gathering requirements, to planning, controlling, and executing the project, the basic logistics of a global project present their own standard challenges. However, with additional cultural, language-based, and regional elements, global projects involve more complexities than teams often realize. There are unique communication needs, cultural awareness elements, varying customs and work expectations, and critical legal differences to consider. In this course, you will dig deeper-and differently-into project management processes, tools, and techniques, developing the ability to see them through the lens of global and cultural project impacts. This will leverage you to problem solve differently on global projects, prevent problems, and ensure success. The goal is for you to effectively navigate the challenges of leading projects with multi-regional footprints and globally diverse sets of stakeholders. What you Will Learn At the end of this program, you will be able to: Determine when a project meets the criteria of being a true global one Articulate global project needs based on the project grid and framework Identify and analyze global project stakeholders Recognize cultural differences and articulate how they impact project work Determine global project estimating, scheduling, and staffing challenges Assess global project risks and develop problem-solving responses Analyze complex cultural situations and align optimal project communication and negotiation tools and techniques Apply best practices for conducting virtual team work and mitigating virtual challenges Evaluate ways to control for global project scope, cost, and procurement Align customer management best practices with global customer needs Implement key global project closing activities Foundation Concepts What is a global project? What makes a global project different? A global project management framework Initiating the Global Project Launching a global project Respecting cultural differences Identifying and analyzing stakeholders Developing the communications plan Defining the ideal global project manager Crafting a global project charter Planning the Global Project Gathering requirements for a global project Defining the scope, region by region Estimating and scheduling for global projects Staffing the global project Developing the global risk management plan Executing the Global Project Managing global stakeholder expectations Embracing cultural diversity Honing global negotiation techniques Procuring goods and services on a global basis Managing global legal and regulatory issues at the micro and macro level Monitoring and Controlling the Global Project Status reporting Virtual communication Cost control Schedule control Scope control Customer satisfaction Closing the Global Project Contract closure at the macro and micro levels Administrative closure with global reach Lessons learned

Global Project Management: In-House Training: In-House Training In this course, you will dig deeper-and differently-into project management processes, tools, and techniques, developing the ability to see them through the lens of global and cultural project impacts. In today's increasingly global environment, managing a project with customers and support organizations spread across multiple countries and continents is a major challenge. From identifying stakeholders and gathering requirements, to planning, controlling, and executing the project, the basic logistics of a global project present their own standard challenges. However, with additional cultural, language-based, and regional elements, global projects involve more complexities than teams often realize. There are unique communication needs, cultural awareness elements, varying customs and work expectations, and critical legal differences to consider. In this course, you will dig deeper-and differently-into project management processes, tools, and techniques, developing the ability to see them through the lens of global and cultural project impacts. This will leverage you to problem solve differently on global projects, prevent problems, and ensure success. The goal is for you to effectively navigate the challenges of leading projects with multi-regional footprints and globally diverse sets of stakeholders. What you Will Learn At the end of this program, you will be able to: Determine when a project meets the criteria of being a true global one Articulate global project needs based on the project grid and framework Identify and analyze global project stakeholders Recognize cultural differences and articulate how they impact project work Determine global project estimating, scheduling, and staffing challenges Assess global project risks and develop problem-solving responses Analyze complex cultural situations and align optimal project communication and negotiation tools and techniques Apply best practices for conducting virtual team work and mitigating virtual challenges Evaluate ways to control for global project scope, cost, and procurement Align customer management best practices with global customer needs Implement key global project closing activities Foundation Concepts What is a global project? What makes a global project different? A global project management framework Initiating the Global Project Launching a global project Respecting cultural differences Identifying and analyzing stakeholders Developing the communications plan Defining the ideal global project manager Crafting a global project charter Planning the Global Project Gathering requirements for a global project Defining the scope, region by region Estimating and scheduling for global projects Staffing the global project Developing the global risk management plan Executing the Global Project Managing global stakeholder expectations Embracing cultural diversity Honing global negotiation techniques Procuring goods and services on a global basis Managing global legal and regulatory issues at the micro and macro level Monitoring and Controlling the Global Project Status reporting Virtual communication Cost control Schedule control Scope control Customer satisfaction Closing the Global Project Contract closure at the macro and micro levels Administrative closure with global reach Lessons learned

About Course Learn the ins and outs of coffee making, from bean to cup This comprehensive course will teach you everything you need to know to become a barista, from beginner to expert. You will learn about the different types of coffee, how to grind and brew coffee beans, and how to create latte art. You will also learn about the business of coffee, including how to create a coffee menu and how to run a coffee shop. The course is divided into 6 modules: Module 1: Introduction to the Barista WorldLearn the history of coffee and the different types of coffee beansUnderstand the different roles of a barista and the skills and qualities needed to be successfulDiscover the different coffee brewing methods and equipment Module 2: Perfecting the BrewLearn how to grind coffee beans for different brewing methodsMaster the art of brewing espresso, cappuccinos, lattes, and other coffee drinksExperiment with different milk steaming techniques to create the perfect foam Module 3: Essential TechniquesLearn how to tamp coffee grounds evenly for a consistent brewMaster the art of latte artClean and maintain espresso machines and other coffee brewing equipment Module 4: Froth & Coffee StylesLearn about the different types of coffee foam and how to create themExplore the different coffee styles, such as black coffee, espresso, and lattesExperiment with different flavor combinations to create your own signature coffee drinks Module 5: Artistic EspressoLearn the basics of latte art and how to create simple designsMaster more advanced latte art techniques, such as tulips and heartsExperiment with different colors and flavors to create stunning latte art Module 6: Becoming a Coffee ProfessionalLearn about the business of coffee, such as how to create a coffee menu and how to run a coffee shopDevelop your customer service skills and learn how to create a positive customer experiencePrepare for a career in coffee by learning about the different job opportunities and how to get started Why enroll in this course? Gain the skills and knowledge you need to become a barista Get hands-on experience with espresso machines and other coffee brewing equipment Create beautiful latte art and other coffee drinks Build your coffee knowledge and explore the different coffee styles Prepare for a career in the coffee industry What Will You Learn? Understand the different types of coffee beans and how to grind them Master the art of brewing espresso, cappuccinos, lattes, and other coffee drinks Create beautiful latte art Use an espresso machine and other coffee brewing equipment Run a coffee shop or cafe Course Content Introduction to the Barista World Learn the history of coffee and the different types of coffee beans Understand the different roles of a barista and the skills and qualities needed to be successful Discover the different coffee brewing methods and equipment Introduction to the Barista World Perfecting the Brew Learn how to grind coffee beans for different brewing methods Master the art of brewing espresso, cappuccinos, lattes, and other coffee drinks Experiment with different milk steaming techniques to create the perfect foam Perfecting the Brew Essential Techniques Learn how to tamp coffee grounds evenly for a consistent brew Master the art of latte art Clean and maintain espresso machines and other coffee brewing equipment Essential Techniques Froth & Coffee Styles Learn about the different types of coffee foam and how to create them Explore the different coffee styles, such as black coffee, espresso, and lattes Experiment with different flavor combinations to create your own signature coffee drinks Froth & Coffee Styles Artistic Espresso Learn the basics of latte art and how to create simple designs Master more advanced latte art techniques, such as tulips and hearts Experiment with different colors and flavors to create stunning latte art Artistic Espresso Becoming a Coffee Professional Learn about the business of coffee, such as how to create a coffee menu and how to run a coffee shop Develop your customer service skills and learn how to create a positive customer experience Prepare for a career in coffee by learning about the different job opportunities and how to get started Becoming a Coffee Professional A course by Xpert Learning RequirementsNo prior experience is requiredAccess to an espresso machine and other coffee brewing equipment is recommended Audience Anyone who wants to learn about coffee or become a barista Coffee enthusiasts who want to improve their skills Coffee shop owners or managers who want to learn more about the business of coffee Anyone who is interested in a career in the coffee industry Audience Anyone who wants to learn about coffee or become a barista Coffee enthusiasts who want to improve their skills Coffee shop owners or managers who want to learn more about the business of coffee Anyone who is interested in a career in the coffee industry

Introduction to Design Thinking: Virtual In-House Training Innovation is the cornerstone of highly successful companies, especially those that continue to be successful over the years and decades. Design thinking practices fuel this continual innovation, as they are the critical links from inspiration to delivery, concept to showroom floor, and start-up to global business. Design thinking is a structured approach to promoting innovation and creative problem-solving. It is not a new approach. It has been around for centuries, as the art, architecture, and inventions of mankind illustrate. By examining the steps to achieving great design and maximum utility of product, design thinking approaches provide a framework in which to develop new solutions to problems and new products to sell. This highly interactive course is designed to help participants think like designers to generate innovation, and to help teams to produce more innovation and creativity. Since design thinking is based on doing rather than thinking, we participants are challenged to apply the techniques, in the classroom, to create new ideas and solutions to a case study project. What you will Learn At the end of this program, you will be able to: Explain the underlying principles and value of using Design Thinking for innovation Describe the basic concepts of the Stanford Model for Design Thinking Evaluate a set of basic Design Thinking techniques for application to your projects Apply tools, techniques, and skills aligned with the 5 stages of the Stanford Model Drive innovation through Design Thinking at some level in your work environment Foundation Concepts Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks Stages of Design Thinking Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks General Practices Team formation Visualization Improvisation Personalization Empathize Practices Overview of Empathize techniques Observation Engagement Interviews Define Practices Overview of Define practices Unpacking techniques Defining the customer techniques Integrating the Define experience Ideate Practices Overview of Ideate practices Reusable techniques for the Ideate stage New Ideate techniques to explore Prototype & Test Practices Overview of Prototype practices Examples of prototypes Overview of Testing practices Forms of testing techniques Adopt and Adapt Design Thinking Overview of Design Thinking implementation Design Thinking implementation challenges Success in implementing Design Thinking Summary and Next Steps Workshop summary Next steps: Personal Action Plans

Why Learn Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course? Course info Master architectural visualization and photorealistic renderings. In-person or live online options available. Learn Revit and 3dsMax, V-Ray rendering, and advanced techniques. Hands-on projects for real-world experience. Duration: 40 hrs Method: 1-on-1 - Individual support. 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. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Part 1: Revit (16 hours) Module 1: Introduction to Revit Familiarizing with the Revit interface and workspace Embracing the Building Information Modeling (BIM) workflow Creating a fundamental building model as a starting point Module 2: Basic Modeling in Revit Working with essential elements such as walls, doors, and windows Constructing floors and roofs to complete the building structure Crafting functional and visually appealing stairs and railings Module 3: Advanced Modeling in Revit Delving into the creation and manipulation of families Utilizing parameters and constraints to enhance modeling efficiency Exploring intricate geometries for complex designs Module 4: Annotation and Documentation in Revit Enhancing project documentation by adding text and dimensions Generating informative schedules for better project management Mastering the printing and exporting processes for professional output Part 2: 3ds Max (16 hours) Module 1: Introduction to 3ds Max Navigating the 3ds Max interface and workspace Understanding the 3D modeling workflow for design visualization Initiating the creation of basic 3D models Module 2: Basic Modeling in 3ds Max Working with primitive shapes to build foundational models Creating and refining splines to form versatile shapes Advancing to complex 3D model development for intricate designs Module 3: Materials and Textures in 3ds Max Exploring the material editor and its functionalities Skillfully applying and adjusting materials for realistic renders Incorporating textures to add depth and detail to the models Module 4: Lighting and Cameras in 3ds Max Mastering the art of lighting creation and manipulation Utilizing the daylight system for enhanced realism Understanding cameras and perspectives for compelling visual storytelling Part 3: V-Ray (8 hours) Module 1: Introduction to V-Ray Getting acquainted with the V-Ray interface and workflow Exploring V-Ray materials and textures for high-quality renders Module 2: Lighting and Rendering in V-Ray Creating and refining lighting setups for stunning renders Utilizing global illumination to enhance the realism of scenes Implementing advanced rendering techniques for professional output Module 3: Materials and Textures in V-Ray Crafting and modifying V-Ray materials for realistic surfaces Applying V-Ray textures to add depth and realism to objects Utilizing V-Ray displacement maps for intricate details For 3ds Max free trial, visit: https://www.autodesk.co.uk/products/free-trial. To access the V-Ray free trial, visit: https://www.chaosgroup.com/. Start your journey to becoming a proficient designer and renderer in the world of 3D modeling and visualization. Download Revit Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course: Proficient Software Skills: Acquire a strong command of Revit and 3dsMax, along with advanced techniques in V-Ray rendering. High-Quality Visualizations: Create realistic and visually stunning architectural visualizations using V-Ray. Architectural Modeling: Master the process of modeling architectural elements with precision and efficiency. Materials and Textures: Understand how to apply realistic materials and textures to enhance visualizations. Lighting Setup: Set up lighting environments to achieve optimal illumination and ambiance in renderings. Rendering Techniques: Explore advanced rendering techniques, including global illumination, caustics, and ambient occlusion. Real-World Projects: Complete industry-relevant projects to build a professional-grade portfolio. Problem-Solving Skills: Develop the ability to troubleshoot and resolve rendering challenges effectively. Efficient Workflows: Learn time-saving workflows and best practices for efficient visualization production. Portfolio Showcase: Showcase your newly acquired skills through a diverse range of visualizations.

Sacred Sounds for the Soul ~ an afternoon and evening of Sacred Drum Circle, songs, chants and Sacred Sound Journey sound bath with Edwin and Harshani https://mindbodywellbeing.co.uk/ @ Mill Farm Retreat Centre, Great Cransley, Kettering, Northamptonshire

PMI-ACP® Exam Prep: On-Demand This course builds on the candidates' practical experience of Agile in the workplace to equip them with the broad range of knowledge and skills required for the PMI® Agile Certification exam. It will follow the PMI® requirements and reference the suggested reading list, including the Agile Practice Guide, but will not be limited to those areas. Within the profession and discipline of project management, Agile continues to develop as a significant and important aspect of bringing change to an organization. Where the products of change must be delivered to the business 'on time,' Agile is often the chosen methodology. In addition to equipping candidates for the PMI® Agile Certification examination, this course will also support candidates in taking a more informed and effective role in Agile projects. It will also enable them to take a significant role in encouraging and enabling the organization to become or develop as an Agile environment. What you will Learn You will learn how to: Appreciate the wider aspects of Agile project management tools and techniques Integrate various disciplines within Agile Tailor / customize Agile to suit the needs of different projects Prepare yourself for the PMI® Agile Certification examination Getting Started Introductions Agenda Expectations Foundation Concepts Defining 'Traditional' Project Management Project management parameters The 'traditional' approach to the parameters Strengths and weaknesses of the traditional approach Defining 'Agile' Project Management Project management parameters revisited The 'agile' approach to the parameters Strengths and weaknesses of agile Managing projects with traditional and agile methods Can the two approaches co-exist? Leveraging the benefits of both methods Options for using both methods on a project Avoiding the elephant traps Key aspects of the PMI® Agile Certified Practitioner (PMI-ACP)® Handbook Overview Eligibility requirements Exam information Exam Blueprint Continuing certification requirements Key aspects of the PMI Agile Certification Examination Content Outline Introduction Agile exam content outline Tools and techniques Knowledge and skills Domains and tasks (not examined) An Introduction to Agile and Implementing Agile Definable work vs. high-uncertainty work Project factors that influence tailoring The Agile Manifesto and 12 Principles Agile mindset Agile domains and tasks Agile Tools and Techniques Related to PM 'Hard Skills' Planning, monitoring, and adapting The need for planning, monitoring, and adapting The Agile approach to planning and plans The Agile planning tools and techniques The Agile monitoring tools and techniques The Agile approach to adapting Product quality A definition of 'product quality' Setting the standard for product quality Agile tools and techniques for achieving product quality Risk management A definition of 'risk' What is 'at risk'? The acceptability of risks The Agile tools and techniques for managing risks Agile Tools and Techniques Related to PM 'Soft Skills' The difference between PM 'hard and soft' skills Communications The importance of communications Forms of agile communications Communications within the project Communications from the project Communications to the project Making communications the cultural norm Interpersonal Skills Defining and understanding management Defining and understanding leadership Defining and understanding servant leadership Delegating vs. empowering Playing to people's strengths Overcoming the roadblocks Core Agile Tools and Techniques The philosophy of core Agile tools and techniques Agile estimation Will traditional forms of estimating work for agile? The relationship between estimating and guessing The relationship between estimating and sizing The where, who, and how of agile estimating Agile analysis and design Product analysis and design from a user point of view Product analysis and design from a supplier point of view Product analysis and design from an agile project point of view Value-Based Agile Tools and Techniques The role of value-based tools and techniques in bridging traditional PM with Agile Value-based prioritization Value-based prioritization and agile projects Investment appraisal methods Regulatory driven Customer driven Ranking methods (MMF, MoSCoW) Metrics What should we measure / track? Methods of measuring / tracking Adding value with metrics Process Improvement Value-stream analysis Value-stream mapping Agile Knowledge and Skills Context of Agile Knowledge and Skills vis-à-vis Agile Tools and Techniques Agile Knowledge and Skills Process focused People focused Product focused Project focused Exam Preparation and Course Closure The application process - where are you now? The 'Exam-Focused Journal' - what you still have to do Further preparation - self-study schedule Exam topic review Practice exam Practice exam debrief Course closure

This Beginners Barbering Course is aimed at those looking to be work-ready upon completion and working towards an internationally recognised Barbering qualification. After an initial induction, on day 2 you will learn to cut & style utilising the 5 Alan d Foundation haircuts before moving on to the practical elements of Barbering, incorporating all the latest techniques using scissors, scissor-over-comb, clippers & trimmers and learning beard and moustache trimming and wet shaving.

Why not treat yourself to a deluxe culinary experience? A two week cookery course immersing you in a wonderful world of tastes, techniques and cookery skills to leave you a more confident cook. This course is ideal for the home cook who is looking to get more from their cookery and learn new tricks and techniques as well as discovering a wider range of cuisines and ingredients. Or maybe you are thinking about a career in food and drink? This is the perfect taster as you begin your culinary journey. What’s included on the course? International dishes from India, Thailand, North Africa, China, France, Italy and the Middle East. How to make Fresh Pasta and delicious Ravioli and Tortellini with different sauces to accompany them. A range of pastries including Rough Puff, Shortcrust, Hot Water Crust and Choux. Seafood - Preparing gorgeous local scallops from scratch as well as filleting a Flat Fish, a Round Fish and learning different techniques to cook them. A range of Breads. Farmhouse, Ciabatta, Soda Bread, Flat Breads and Sourdough are all covered. Basic butchery. How to joint a chicken. Ice creams and sorbets. Dairy. How to make your own Butter, Yoghurt and Soft Cheese. Stocks and Sauces. Cover Vegetarian and Vegan Cookery. How to use Herbs to best effect. The importance of Seasoning. A visit to a local Scottish Assured Venison Park and Venison Cookery. And lots more…