3312 Design courses in Mayfield delivered Live Online

Duration 5 Days 30 CPD hours This course is intended for Test Programme Managers, Test Managers, and anyone else wishing to take the ISTQB© Certified Tester Advanced Level Test Manager examination. Overview Whilst this course is focused on the syllabus, giving participants the maximum chance of passing the examination, it also contains many real world practical examples. On completion of this course, attendees will have an advanced understanding of test design techniques and will be fully prepared to take the ISTQB© Certified Tester Advanced Level Test Manager examination. ISTQB© is the standard for international qualifications in software testing at an advanced level. The course thoroughly prepares attendees for the ISTQB© Certified Tester Advanced Level Test Manager examination. Testing Process The fundamental test process Test levels and test types Test planning, monitoring and control Test analysis Test design Test implementation Test execution Evaluating exit criteria and reporting Test closure activities Test Management Test management in context Risk-based testing and other approaches for test prioritization and effort allocation Test documentation and other work products Project risk management Other test work products Test estimation Defining and using test metrics Business value of testing Distributed, outsourced, and insourced testing Managing the application of industry standards Reviews Management reviews and audits Managing reviews Metrics for reviews Managing formal reviews Defect Management The defect lifecycle and the software development lifecycle Cross-functional defect management Defect report information Assessing process capability with defect report information Improving the Testing Process Introduction Test improvement process Improving the testing process Improving the testing process with TMMI Improving the testing process with TPI Next Improving the testing process with CTP Improving the testing process with STEP Test Tools and Automation Tool selection Return on investment (ROI) Selection process Tool lifecycle Tool metrics People Skills ? Team Composition Individual skills Test team dynamics Fitting testing within an organization Motivation Communication

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Project Management Fundamentals: Virtual In-House Training Many projects are performed by highly competent and effective people who have little or no project management training. They perform projects like process improvement, marketing campaign development, new product development, event planning and production, and other 'tasks' which are projects. Project Management Fundamentals (PMF) is designed to support those people who need a solid foundation in project management, without being unnecessarily burdened to learn it while on the job. The course offers practical skills, concepts, and principles that can be taken back to the workplace, along with insights needed to adapt them to specific project environments. In today's environment, that means possibly adapting to Agile / Iterative methods. So, we have recently added key Agile concepts to provide a basic understanding of shifting towards agility. Since PMF's course goal is to achieve quality performance by learning effective planning and control, the focus is on a process orientation and an analytical, systems-oriented approach. Together, these frameworks promote project-related problem solving and decision-making skills necessary for real world projects. They honor project needs for collaboration, clear communications among people, and interpersonal and relationship skills. Recognition of these needs are woven throughout PMF, but are highlighted in two specific areas: Module 2 - People and Projects Module 8 - Executing, Communicating, and Developing the Team

Duration 2 Days 12 CPD hours This course is intended for This is an introduction to database security course for intermediate skilled team members. Attendees might include DBAs, system administrators, developers and other enterprise team members. Ideally, students should have approximately 6 months to a year of database working knowledge. Overview Students who attend Securing Databases will leave the course armed with the skills required to recognize actual and potential database vulnerabilities, implement defenses for those vulnerabilities, and test those defenses for sufficiency. This course introduces students to the most common security vulnerabilities faced by databases today. Each vulnerability is examined from a database perspective through a process of describing the threat and attack mechanisms, recognizing associated vulnerabilities, and, finally, designing, implementing, and testing effective defenses. Multiple practical demonstrations reinforce these concepts with real vulnerabilities and attacks. Students will learn how to design and implement the layered defenses they will need in defending their own databases. Securing Databases is an essential training course for DBAs and developers who need to produce secure database applications and manage secure databases. Data, databases, and related resources are at the heart of most IT infrastructures. These assets can have high value from a business, regulatory, and liability perspective, and must be protected accordingly. This course showcases demonstrations on how to repeatedly attack and then defend various assets associated with a fully functional database. This approach illustrates the mechanics of how to secure databases in the most practical of terms. Security experts agree that the least effective approach to security is 'penetrate and patch'. It is far more effective to 'bake' security into an application throughout its lifecycle. After spending significant time trying to defend a poorly designed (from a security perspective) database application, students will learn how to build secure their databases and applications, starting at project inception. Securing Databases Foundation Why Hunt for Security Defects? Fingerprinting Databases Principles of Information Security Database Security Vulnerabilities Database Security Concerns Vulnerabilities Cryptography Overview Database Security Database Security What Next? Secure Development Lifecycle (SDL) SDL Process Overview Taking Action Now Asset Analysis Design Review Making Application Security Real

Tea 'N Chat discussing the new A-LEVEL ESA (Externally Lead Assessment) themes with fellow teachers

Teachers will become familiar with the software, aiding each learner access to their college dashboard as a designer, so they can complete a heat loss report and other heating design elements. Furthermore each learner will have access to send surveys from the heat engineer app (Apple or Android) which once sent will be received within the college dashboard. Where teachers can assess the survey.

This course will help you and your employees gain the necessary vocabulary, grammar, and conversational abilities from our qualified instructors. Additionally, our interactive lessons and hands-on activities will improve your BSL proficiency and comprehension. This Course At A Glance Live Zoom classes with an expert BSL tutor, Adam Linsdell. Gain an extensive understanding of deaf awareness. Acquire knowledge of several commonly used vocabulary words. CPD Accredited certificates are recognized by employers and professional organisations. Enhance your communication skills through practical exercises. BSL Training Course Overview This BSL training course, CPD certified workplace oriented classes, is an immersive 18-hour duration (3 hours per week) course designed to enhance your communication skills with deaf colleagues and customers in a specific workplace setting. This comprehensive program will equip you with the necessary tools to establish effective interactions and bridge the communication gap. Throughout the course, you will learn essential vocabulary, grammar, and conversational skills in British Sign Language (BSL). Additionally, you will gain insights into deaf culture and develop a deeper understanding of the challenges faced by individuals with hearing impairments in the workplace. By the end of this course, you will be able to confidently communicate using BSL and contribute to a more inclusive and accessible work environment. BSL Training for Workplace, Autumn 2025 Please book your place in advance Weekly via Zoom Online Live Class. You can attend the class online from home/workplace. Total Duration: 18 Hours Class Starts: August 08, 2025-October 10, 2025 Day & Time: 10:00 am – 12:00 pm (Thursday, 2 hours per week) Venue: Zoom Online Teacher: Adam Linsdell Who should take this course? BSL for the Workplace is perfect for individuals, employees, large or small businesses. Those who are seeking to improve their communication with deaf colleagues and customers in their professional environment can opt for this course. Whether you work in health and healthcare, retail and shopping, hospitality, cultural settings, or public services, this course will provide you with the skills needed to connect and engage with the deaf community. Learning Outcomes: Upon completing the BSL for the Workplace course, participants will achieve the following learning outcomes: Learn fingerspelling alphabets and words with accuracy Develop simple conversations and confidently ask questions on a range of everyday topics Fostering meaningful interactions with deaf colleagues and customers. Demonstrate basic vocabulary related to various topics, allowing for effective expression of ideas and needs. Discover workplace-specific vocabularies relevant to their professional setting Help you engage in specialised conversations and enhance workplace communication. Invest in your communication skills and create an inclusive workplace environment. Enrol in a BSL training course CPD certified workplace oriented classes today and unlock new opportunities for effective communication with the deaf community. Course Curriculum Greetings Learn essential BSL greetings to initiate conversations and create a welcoming atmosphere. These greetings include basic phrases such as “hello,” “good morning,” “how are you?” and more which are essential for establishing rapport and building relationships with deaf individuals. The BSL Alphabet and Fingerspelling Master the BSL alphabet and develop the ability to fingerspell words accurately, enabling effective communication of names, technical terms, and unfamiliar vocabulary. This skill is particularly useful in situations where there may be unfamiliar vocabulary or technical terms that need to be spelled out. Meeting People / Questions Enhance your conversational skills by learning how to introduce yourself, engage in small talk, and ask questions in BSL. These skills will allow you to confidently interact with Deaf individuals and create meaningful connections. Additionally, understanding how to ask questions in BSL will enable you to gather information and participate actively in conversations. Numbers and Number Related Vocabulary Acquire the knowledge to express age, money, and dates accurately in BSL, enabling seamless interactions in various contexts. Mastering numbers and number-related vocabulary in BSL will also help you navigate everyday situations such as shopping, making appointments, and discussing schedules. Being able to accurately express age, money, and dates will enhance your ability to communicate effectively and independently in the Deaf community. Transport / Travel Explore BSL vocabulary related to transportation and travel, enabling you to provide clear directions and discuss travel arrangements. You will learn signs for different modes of transportation such as cars, buses, trains, and aeroplanes, as well as how to ask for and give directions. Additionally, you will be able to discuss travel plans, including booking tickets and discussing itineraries. Telling the Time / Calendar Develop proficiency in expressing time and discussing calendar events in BSL, ensuring effective scheduling and time management. You will also become familiar with discussing different calendar events such as birthdays, holidays, and appointments. This will enable you to effectively manage your schedule and plan your activities accordingly. Weather Expand your vocabulary to discuss weather conditions, enabling you to engage in casual conversations and make relevant inquiries. This skill will also allow you to understand weather forecasts and prepare for any upcoming changes in the weather. Colours Learn the BSL signs for various colours, facilitating discussions about visual elements and enhancing your ability to describe objects accurately. This knowledge will enable you to express yourself more effectively and engage in a wider range of conversations. Describing People Develop the skills to describe individuals’ appearance and characteristics in BSL, allowing you to effectively communicate observations and share information. This skill will not only enhance your ability to interact with deaf individuals but also improve your overall communication skills. Additionally, being able to describe people accurately in BSL can help you navigate social situations and build stronger connections with others. Directions Master directional vocabulary in BSL, empowering you to provide clear instructions and navigate through spaces confidently. This skill will also boost your confidence when navigating unfamiliar spaces, as you will have the ability to clearly communicate directions and understand them yourself. Workplace-Specific Vocabulary Discover workplace-specific vocabulary tailored to your professional setting, such as health and healthcare, retail and shopping, hospitality, cultural settings, and public services. Use this vocabulary to develop simple conversations and strengthen your workplace communication skills. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully completing the live training, you will be eligible to receive your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version as well as hardcopy version at a free of cost.

Building High-Performance Teams: In-House Training This course pulls together the most current and popular theories and writings on this complex topic and presents this amalgamated view in a highly interactive workshop and activity-based approach. Students will understand and have the skills required to build and participate in high-performance project teams and will possess the insight to proactively affect change within their respective organizations by guiding the existing culture to one that promotes high performance. What you will Learn At the end of this program, you will be able to: Define a team and describe the optimum team size for effective performance Describe characteristics and guiding behaviors of high-performance teams Describe the major elements of each development stage in two distinct models Recognize cultural barriers in achieving high performance List the attributes of a high-performing corporate culture Assess your own corporate culture Discuss corporate leadership as a factor in building high-performance project teams Describe the three A's of selecting team members State three leadership responsibilities Describe leadership responsibilities, styles, and roles List and describe the eight components of the team charter model for building high-performance teams Foundation Concepts The Nature of Teams Characteristics of High-Performance Teams Understanding Team Development Stages of Team Development - Model 1 Stages of Team Development - Model 2 Designing a High-Performance Culture Corporate Cultures Corporate Leadership Establishing the Attributes of High Performance Choosing the Right People Team Effectiveness Team Leadership The Team Charter Model

Effective Negotiation Skills for Business Success: In-House Training Become skillful at dealing with unworkable differences - situations where there appears to be no acceptable compromise or acceptable solution. This interactive workshop shows you how to work towards agreements where all parties are satisfied that they have reached a wise outcome efficiently, and where they can come back to the table in the future because the relationship is intact. You will have the opportunity to re-visit a difficult / challenging negotiation that you experienced in the past as well as take part in progressively more challenging case studies that are tailored to the work you do. You will enhance your personal and professional life with powerful new negotiating skills. The goal of this workshop is to improve your negotiation skills by helping you to identify your own preferred negotiation style and strategies, and to learn about the need to plan for any upcoming negotiation. The workshop is also designed for you to experience typical negotiation situations at certain key points of the life cycle of a project, enabling you to develop an awareness of your effectiveness during negotiations at these stages. The majority of time is spent on practicing newly presented negotiation techniques and receiving feedback on application for further development and improvement. What you will Learn At the end of this program, you will be able to: Identify your preferred negotiation style and strategies Examine the Principled Negotiation Model Adapt your negotiation strategy to the progress of the negotiation Experience typical negotiation situations during the life cycle of a project Develop an awareness of your effectiveness during negotiations Improve your negotiation skills Negotiation Model Negotiation defined Negotiation phases Common approaches to negotiating Principled Negotiating Principled negotiation and the four rules Best alternative to a negotiated agreement Project Negotiation Simulation: Part 1 and Part 2 Project Negotiation Simulation: Part 1 Project Negotiation Simulation: Part 2 Negotiating Cases Negotiating cases