8564 Courses in Cardiff delivered Online

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

PfMP® Exam Prep: In-House Training This is an intensive PfMP® Exam preparation course. This learning experience guides you through the multi-faceted discipline of portfolio management by focusing on the related technical, leadership, and business skills required to navigate it in the real world. First and foremost, this is an intensive PfMP® exam preparation course. Over the course, we go beyond exam prep to provide selected practice in applying key portfolio management skills, tools, and techniques. This learning experience guides you through the multi-faceted discipline of portfolio management by focusing on the related technical, leadership, and business skills required to navigate it in the real world. The journey zooms in and out between governance context and specific operational activities. The ultimate goal is practical application, with the bonus of certification along the way. What You Will Learn By the end of this program, you will be able to: Align and manage the portfolio, strategically, to satisfy organizational objectives and priorities, through benefit realization Articulate and emulate the role of a portfolio manager Apply the principles and skills of a portfolio manager to your real-world environment Study and prepare for the PfMP® Examination Apply for the certification, per the PMI PfMP Handbook and pass the initial panel review on your application Getting Started Course Overview Details of the PfMP® Certification process Foundation Concepts Projects, program, and portfolios A portfolio management process Strategy and value The role of the portfolio manager The role of key stakeholders Life cycle management The Portfolio Life Cycle Overview of Life Cycle Portfolio Management Information System (PMIS) Governance within the Portfolio Life Cycle Strategic Management Strategy concepts Supporting documentation and the strategic plan Planning and optimization Organizational risk appetite Managing strategic change Governance Management Overview and Guiding Principles The Concept of Governance Effective Design Factors Governance Roles Capacity and Capability Management Overview and Guiding Principles Capacity Management and Planning Supply and Demand (Management and Optimization) Organization Capabilities (Assessment and Development) Performance Management (Reporting, Analytics, and Balance) Stakeholder Engagement The Importance of Stakeholders Overview and Guiding Principles Definition and Identification Analysis and Planning Communications Approaches and Management Value Management Overview (Guiding Principles, Definition, and Components) Negotiating Expected Value Maximizing Value Assuring Value Realizing Value Measuring and Reporting Value A Look at Tools Risk Management Overview and Guiding Principles Portfolio Risk Planning Portfolio Risk Identification Portfolio Risk Assessment Portfolio Risk Response Examination Content Outline (ECO) Overview Structure Strategic Tasks Mapping Governance Tasks Mapping Performance Tasks Mapping Risk Tasks Mapping Communication Tasks Mapping List of Knowledge and Skills Exam Prep and Practice Overview Documenting experience Submitting the application Preparing to sit for the exam

Microsoft Project Orange Belt® 2016: In-House Training This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop gives participants a full insight into creating effective schedules using Microsoft® Project 2016, allowing you to estimate, coordinate, budget, staff, and control projects and support other users. This workshop provides the eBook Dynamic Scheduling with Microsoft® Project 2013, and is kept up to date with the framework of knowledge outlined by the Project Management Institute's PMBOK® Guide and the Practice Standard for Scheduling. What you Will Learn You'll learn how to: Understand what's new in Project 2016 Explain where Project 2016 fits in the Microsoft® EPM solution Initialize Project 2016 to start project planning Create a well-formed project schedule Understand task types and the schedule formula Assign resources and costs to tasks Analyze resource utilization and optimize the schedule Set a baseline and track progress Create and manage project reports Customize views and fields Apply Earned Value Management Understand the basics of managing multiple projects Getting Started Introductions Course structure Course goals and objectives Concepts of Project Management Getting Started with Project 2016 Project 2016: What's New and General Overview Setting Up a New Project Schedule (templates, options, save, etc.) Setting the Project Calendar Entering Tasks The planning processes Importing tasks (Word, Excel, SharePoint) Synchronizing with SharePoint Tasks List Creating and managing the WBS (include tasks, manually scheduled tasks, summary tasks, milestones, and custom WBS coding) Entering Estimates Tendencies in estimating The rolling wave approach Entering duration and work estimates Types of tasks Entering Dependencies The principle of dynamic scheduling Choosing the right Type of dependency Entering dependencies in Project 2016 Different applications of dependencies Entering Deadlines, Constraints, and Task Calendars Use of deadlines and constraints Entering deadlines and constraints in Project 2016 Entering Resources and Costs Types of resources Entering resources in Project 2016 Calendars and resources Entering costs in Project 2016 Entering Assignments Assignments in a schedule Assignments and task types Entering assignments in Project 2016 Assignments, budgets, and costs Optimizing the Schedule The critical path method (CPM) and the resource critical path (RCP) Resource leveling Optimizing time, cost, and resources in Project 2016 Updating the Schedule The baseline Updating strategies and situations Prepare the status and forecast report in Project 2016 Reporting Using reports Using Visual Reports Formatting and printing in Project 2016 Customizing fields in Project 2016 Earned Value Management (EVM) Overview of EVM Applying EVM with Project 2016 Evaluating the Project Evaluating the project performance Project benefits and results Templates for future projects Summary and Next steps Tools and checklist Best practices checklist Certification options

Change Management™ Practitioner - Going Beyond the Basics and Practitioner Exam Preparation: On-Demand This course will further develop some of the knowledge of Change Management learned during the Foundation certification. You will consider what learning is required and how best to design and deliver it. Then the course will provide an understanding of how Change Management fits into the project management environment. A major challenge with change is making it stick. The course will show how to sustain change by understanding the levers for change, models of adoption, and reinforcing systems. This course also prepares you for the APMG Change Management Practitioner exam. Given that a primary course goal is to achieve the Practitioner Certification, daily homework assignments and practice exams will be provided. The Practitioner-level exam is taken at the end of the second day of the Traditional Classroom course. Virtual Classroom and On-Demand participants must make separate arrangements to schedule their exam following course completion (See "Important Note for Virtual and On-Demand Participants"). What You Will Learn You'll learn how to: Understand the key principles in defining what is to be learned by all involved in a change initiative Describe the project environment in which change is governed and delivered Understand the organizational "levers", adoption approaches, and reinforcing systems typically used to sustain change Improve your ability to pass the APMG Change Management Practitioner Certification exam Getting Started Introductions Course structure Course goals and objectives Learning and Change Defining and managing the required learning to enable change The Project Management Environment Understanding the project environment Identifying key roles Developing a change delivery plan Sustaining Change How levers enable the adoption of change Types of levers (Environmental levers, Leadership levers, and Organizational Development levers) Models of adoption and reinforcing systems APMG Change Management Practitioner Exam Preparation Review of and practice with APMG sample questions and test papers APMG Change Management Practitioner Exam Traditional Classroom: The exam is taken and submitted to APMG for marking Virtual Classroom and On-Demand: The exam is scheduled by the Participant and taken subsequent to the course

Certified Business Relationship Manager (CBRM®): Virtual In-House Training The CBRM® Practitioner Qualification is intended for the intermediate-to-advanced Business Relationship Manager, as it focuses on advancing to the role of Strategic Business Relationship Manager. As such, the primary focus is on strategic business relationship management, leveraged to optimize business value to the enterprise. The purpose of the Practitioner qualification is to confirm whether the candidate has achieved sufficient understanding and competence to perform the role of Strategic Business Relationship Manager. To pursue the CBRM® certification, a candidate must be a certified Business Relationship Management Professional (BRMP®). What You Will Learn The successful candidate will demonstrate deep understanding and ability to perform the Strategic BRM role. Specifically, the candidate will: Effectively communicate the purpose and objectives of the Strategic BRM role and how to optimally position that role for maximum effectiveness within the enterprise Understand how to use their personal power and influence to build business relationships and foster a culture that excels at business value results Apply the Strategic Relationship Management processes and techniques to build and sustain trust relationships spanning Business Partner and Provider networks Be able to assess Business Demand Maturity and Business Relationship Maturity and how these might evolve over time Be able to assess Provider Capability Maturity and BRM Competencies and identify key areas needing improvement Be able to apply cross-organization communication techniques to clearly articulate real Provider / business value delivered to the organization Be able to influence executive leaders in their use of Provider Capabilities and Assets based upon potential business value and convergence with business strategy Promote and catalyze business innovation in the Provider's sphere of influence Be able to use the Business Value Management process, techniques, and metrics to define, realize, and optimize the value of Provider capabilities and assets Apply Business Partner Experience Management so as to foster a positive Business Partner perception of Provider capabilities as an essential element of building and sustaining trust relationships Shape strategic agendas for optimum business value, with due consideration of external compliance requirements and potential risks to the business Understand the implications of Lean / Agile methods for the BRM role and capability Influence the development and deployment of available Provider capabilities based upon business need and potential to enable or create business value. Apply Business Capability Management to determine and acquire enabling capabilities pursuant to strategic outcomes Apply Business Capability Management to determine and acquire enabling capabilities pursuant to strategic outcomes Contribute to Business Transition Management in order to foster organizational understanding, support, adoption, and business value results of investments in new business capabilities Course Introduction Explain the House of BRM, recalling the BRM Core Disciplines, competencies required for the BRM role, and necessary conditions for protecting the integrity of the role Recall the key BRM concepts, processes, and techniques Understand the Business Relationship Maturity Model and the Five Relationship Maturity Levels Understanding Business Relationship Maturity and Value The Strategic BRM Role and Capability BRM Impact on Business Value Introduction to the ACME Leisurewear Case Scenario that is used through the course Assessing BRM Context Clarifying Issues Conducting a Business Demand Maturity Assessment Conducting a Business Relationship Maturity Assessment Conducting a Provider Capability Maturity Assessment Shaping the Business Partner's experience with the Provider The BRM role in Service Management Developing Strategic Relationships How to assess Strategic Relationships and plan for their improvement How to achieve business impact through influence and persuasion How to plan and execute BRM formal communications Organizational considerations for BRM deployment How to determine appropriate BRM performance measurement Optimizing Business Value Formulating and Clarifying Business Strategy Catalyzing Business Innovation Business Capability Management Value Management Planning Portfolio Management Business Transition Planning Business Value Optimization Summary and CBRM Exam Preparation Course Summary CBRM Syllabus Review Format and structure of the CBRM® Practitioner Exam Exam hints and tips Sample Exam

The main subject areas of the course are: Controlling the health risks of asbestos. Sample handling and waste disposal. Identification of asbestos by PLM. Gravimetric quantification of asbestos-containing materials. Discrimination and quantification of free fibres by dispersion and PCM. Analysis of soils - practical application.

Description Speech and Language Therapy Diploma  The practice of assisting people who have disorders in language and speech or trouble with swallowing is known as Speech and Language Therapy. The role played by speech therapists, phonetics, the anatomical structure and physiologic-related functions of hearing and speech, speech-related disorders, and the growth of language, its structure, and the career paths offered by this field will be covered by the course. This Speech and Language Therapy diploma offers an outline of the basics as an introduction to the subject. It also covers a speech therapist's role, the communication fields, and the conditions they pay attention to. An outline of various speech disorders and the remedial applications that are widely used in treating them are provided. A detailed list of pathological expressions that professionals in the field use amongst themselves will also be provided. An in-depth awareness of the various anatomical systems and the physiologic-related duties of all speech organs is required. The Speech and Language Therapy Diploma Course is tailor-made to understand the laryngeal, articulatory and respiratory systems, all of which play a part in speech. It is thrilling to learn how speech is developed and the numerous stages that we undergo to discern and analyse language. You can also understand the various phases present in the linguistic development of children with bilingual and monolingual abilities. This Speech and Language Therapy diploma course also delves into language structure with the help of syntax, morphology, and semantics. Additionally, you will learn how the principles that dictate language and speech are applied by children, the usual mistakes that they may commit, and the errors commonly committed by people suffering from disorders in communication and speech. This Speech and Language Therapy diploma course offers a deep insight into the numerous elements that can affect the growth of language and speech. Drug abuse, vocal abuse, neurological disorders, apraxia, brain injury, intellectual disabilities, autism, and physical impairments are covered in this course. The use of PECS or Picture Exchange Communication System as a tool for treating children with autism who experience issues in speech impairment is also covered in this course.Please note that this online training itself does not entitle you to practise as a registered therapist in UK. Please contact the HCPC for information about licensing requirements for practicing in the UK. What you will learn  1: Attention and Listening 2: Understanding Bilingualism  3: Early Communication 4: Expressive Language 5: Social Communication  6: Speech Sounds  Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

FREE Certification:QLS Endorsed + CPD Accredited | Instant Access | Round-the-Clock Tutor Support | All-Inclusive Cost

Disciplined Agile Senior Scrum Master (DASSM): In-House Training Do you want to take Disciplined Agile® to a new level? Are you looking for tools to solve complex problems and enhance your organization's agility? Do you want to learn how to lead your team to excellence? Expand your knowledge and build practical skills around Disciplined Agile®, business agility, leadership, and team development. Disciplined Agile Senior Scrum Master is a nine-lesson, instructor-led course that shows you how to use the Disciplined Agile tool kit to solve a variety of advanced problems, work with allies within your organization, and optimize how teams work. You will gain knowledge in planning, reporting and metrics, and coordinating activities, as well as how to meet challenges in these areas. And you'll develop the skills you need to foster emotional intelligence, resolve conflicts, and lead high-performance teams at any stage of development. Filled with activities, supplemental reading, and more, this course will prepare you to take the Disciplined Agile Senior Scrum Master (DASSM) exam and, equally important, start using Disciplined Agile immediately within your leadership role. What You Will Learn After the completion of this course, you will be able to: Accelerate your ability to lead high-profile initiatives that are critical to enterprise success Take a deep dive into the Disciplined Agile® tool kit to develop a comprehensive understanding of the hundreds of practices and strategies it contains and the trade-offs of applying them Apply the Disciplined Agile tool kit in hands-on exercises to guide your team in choosing and evolving your best way of working (WoW) in real-life situations Use the tool kit to solve complex challenges commonly encountered in development and operational teams, the value stream, and at the enterprise level Learn how to design and implement metrics that measure your improvements in areas where your teams are struggling Understand how to nurture emotional intelligence Feel confident empowering others on your team(s) Learn how to lead your teams in any situation to improve value delivery for your customers Apply the Disciplined Agile tool kit to guide your team in choosing and evolving the best way of working (WoW) in the situation you face Be prepared to take the Disciplined Agile® Senior Scrum Master (DASSM) exam and earn a valuable, credible certification Roles and responsibilities of DASSM Tuckman Team Development Model Emotional intelligence and why it is essential to team performance Business agility Tactical scaling factors in more complex situations Disciplined DevOps layer 'Test-first' method as it relates to the quality of requirements Scope and purpose of the value stream layer Coordinate activities process goal and why it is important Value creation structure of teams DA™ tool kit to optimize the flow of work and solve challenges related to coordinating and collaborating across teams, or within a larger team of teams Thomas-Kilmann Conflict Resolution Planning Five levels of scope Metrics

Sessions Note that this will be a three-day course run on consecutive days and the date of day one is shown in the booking system schedule. Online event This online course will be delivered using CISCO Webex. You will need to have a good internet connection, a suitable device with a camera and microphone such as a laptop, and headphones. Level of study This Level 5 programme is the equivalent standard of a unit of a foundation degree or a unit of a first year of an honours degree. Details Students will gain a comprehensive knowledge and understanding of: The principles and objectives of Risk & Resilience management The legal and regulatory requirements and the role of the regulators in respect of Risk & Resilience, including the emergence of Cyber threat The interconnected impacts that changes in Risk & Resilience make The effect of climate change on Risk & Resilience strategy The objective and purposes of a Company’s risk and resilience strategy and management structure Where Risk & Resilience management sits in the company organisational structure The decision-making process in terms of Risk & Resilience management The role and nature of risk financing and the variables that influence the process The importance of building resilience in the context of Cyber threat The principles of Risk & Resilience and its relationship to contingency planning The use and merits of quantitative and qualitative techniques in risk and resilience management How to reduce risks to personnel and the business via the emergency and business continuity planning process How to understand individuals’ risk perception behaviours The factors that influence group attitudes to risk-taking The practical meaning of business resilience and its role in disaster recovery The range of technologies and the techniques for gathering data available to assist the management of Risk & Resilience The use of probability theory and the use of normal and binomial distribution numerical methods in Risk & Resilience management The principles of scenario planning in relation to Risk & Resilience The principles of Risk, Resilience and contingency planning in commissioning assets The principles of supply chain management in relation to risk and resilience The role of logistics in relation to Risk & Resilience How to prepare the business for pre and post-emergency situations Instructions This online course will be delivered using CISCO Webex. You will need to have a suitable device with a camera and microphone such as a laptop. If you have any questions about what is required please contact us on enquiries@learninganddevelopment.associates. Qualification All learners taking the qualification will need to produce identification to enable ProQual registration. This can take the form of a: Passport Driving Licence Construction Skills Certification Scheme Card (CSCS Card) Construction Plant Competence Scheme Card (CPCS Card) If none of the above are available to the learner, a photograph with a statement confirming their identity, dated and signed, along with a utility bill, would be acceptable.