1357 BA courses in Sheffield

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

SDH training course description Our SDH training course is designed for those with a basic knowledge of the principles of telecommunication digital transmission techniques. An overview of the existing transmission hierarchies and their limitations is provided with an introduction to the Synchronous Digital Hierarchy (SDH). The advantages of SDH are explained fully. What will you learn Identify the major limitations of the PDH network. Outline the advantages of using the SDH. Illustrate the various SDH equipment and network topologies. Describe the principles of the SDH multiplexing structure. SDH training course details Who will benefit: Anyone working with SDH. Prerequisites: It should be noted that this course will assume some basic telecommunication transmission knowledge from the delegates attending. This may be accomplished by attending the Introduction to Telecommunications course. Duration 2 days SDH training course contents Introduction to SDH Timing and synchronisation of digital signals, the plesiochronous digital hierarchy (PDH), the synchronous digital hierarchy (SDH), service protection with SDH SDH Multiplexing Techniques The multiplexing principles of SDH, mapping and aligning a 2Mbit/s tributary into a TU-12, aligning the VC-12 in a TU-12, multiplexing TU-12's into a TUG-2, multiplexing TUG-2's into a TUG-3, multiplexing TUG-3's into a VC-4, the VC-4 path overhead, the STM-1 frame, the AU-4 pointer, the STM-1 section overheads, multiplexer section protection, transmission at rates higher than STM-1, concatenation line transmission functions in SDH SONET Multiplexing Techniques Mapping a DS1 tributary into a virtual tributary, aligning the VT-SPE into a VT frame, mapping the VTGs into a STS-1 SPE, the STS-1 synchronous payload envelope, the STS-1 frame SONET network sections and lines transmissions at higher rates than STS-1 SDH Functions and Facilities SDH network topologies, structure of SDH equipment, synchronisation of SDH networks, protection switching in SDH networks, SDH alarm structure, SDH performance monitoring, testing of SDH, equipment and systems, network management and SDH, asynchronous transfer mode (ATM), future services and technologies OSI Telecommunications Network Management Definition of network management, managing telecom equipment, the managed object library, the management information base, the telecommunications management network (TMN), the Q3 protocol.

Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!

Management of Portfolios (MoP®) Foundation: In-House Training In this MoP® Foundation course, participants will acquire the sufficient knowledge and understanding of the principles, cycles, practices, techniques, roles, responsibilities, documents, and organizational context within which portfolio management operates. MoP helps organizations ensure if the investments are done in the right change initiatives and implementing them correctly. This is achieved by: Prioritizing the programs and projects in terms of their contribution to the organization's strategic objectives and overall level of risk Managing the programs and projects consistently to ensure efficient and effective delivery Maximizing the benefit by providing the greatest return from the investment made What You Will Learn Individuals certified at the MoP Foundation level will be able to: Define the scope and objectives of portfolio management and how it differs from program and project management List the benefits of applying portfolio management Explain the context it operates in List the principles upon which successful portfolio management is based on List the different approaches to implement MoP List the factors required to maintain the progress and assess the success of portfolio management State the purpose and key content of the major portfolio documents Define the scope of key portfolio management roles Introduction: MoP Scenario Background of the Methodology The MoP Principles Senior Management Commitment Governance Alignment Strategy Alignment Portfolio Office Energized Change Culture The MoP Definition Cycle Roles and Responsibilities The MoP Delivery Cycle Management control Benefits management Financial management Risk management Stakeholder engagement Organizational governance Resource management The MoP Framework Recap

Management of Risk (M_o_R®) Foundation: In-House Training This M_o_R® Foundation course prepares learners to demonstrate knowledge and comprehension of the four elements of the M_o_R framework: Principles, Approach, Processes, Embedding and Reviewing and how these elements support corporate governance. The M_o_R Foundation Course is also a prerequisite for the M_o_R Practitioner qualification. What you will Learn At the end of the M_o_R Foundation course, participants will gain competencies in and be able to: Describe the key characteristics of risk and the benefits of risk management List the eight M_o_R Principles List and describe the use of the key M_o_R Approach documents Create Probability and Impact scales Define and distinguish between risks and issues Create a Risk Register Create a Stakeholder map Identify the key roles in risk management Use the key techniques and describe specialisms in risk management Undertake the M_o_R Foundation examination Introduction Introduction to the M_o_R course What is a risk? What is risk management? Why is risk management so important? Basic risk definitions The development of knowledge about risk management Corporate governance and internal control Where and when should risk management be applied? M_o_R Principles The purpose of M_o_R principles Aligns with objectives Fits the context Engages stakeholders Provides clear guidance Informs decision-making Facilitates continual improvement Creates a supportive culture Achieves measurable value Risk management maturity models M_o_R Approach Relationship between the documents Risk management policy Risk management process guide Risk management strategy Risk register Issue register Risk response plan Risk improvement plan Risk communications plan M_o_R Process Common process barriers Identify contexts Identify the risks Assess estimate Assess evaluate Plan Implement Communication throughout the process M_o_R Perspectives Strategic perspective Program perspective Project perspective Operational perspective Risk Specialisms Business continuity management Incident and crisis management Health and Safety management Financial risk management Environmental risk management Reputational risk management Contract risk management

PRINCE2 Agile® Foundation: In-House Training PRINCE2 Agile® provides structure, governance, and control when working with agile concepts, methods, and techniques. It is a solution combining the flexibility and responsiveness of Agile with the clearly defined framework of PRINCE2. PRINCE2 Agile® framework covers a wide range of agile concepts, including SCRUM, Kanban, and Lean Startup. The PRINCE2 Agile® Foundation certificate is designed to help professionals deliver agile projects by tailoring PRINCE2® management controls with a broad toolset of agile delivery techniques and frameworks. PRINCE2 Agile® is an extension module tailored for forward-thinking organizations and individuals already benefiting from PRINCE2®. It provides further guidance on how to apply agile methods to the world's most recognized project management method. The purpose of the Practitioner qualification is to demonstrate that you can apply and tailor PRINCE2 Agile® in a scenario situation. What you will Learn Understand the key aspects of PRINCE2® Understand basic concepts behind common agile ways of working Demonstrate the purpose of combining PRINCE2® with agile Be able to fix and flex the aspects of a project in an agile context Apply the PRINCE2® principles and tailor the themes, processes, and management products to a project in an agile context Incorporate the areas that can support a PRINCE2 Agile® implementation To prepare Participants for the PRINCE2 Agile® Foundation exam Benefits Agile methods allow organizations to realize the benefits of products and potentially an earlier return on investment while products are being developed and improved. Improved communication through the use of common terminology across PRINCE2® and agile disciplines. Develop a clear definition of how agile can govern a project's delivery, while PRINCE2® governs projects as a whole. Seamless integration: PRINCE2 Agile® will complementPMBOK® GuideandAPM Body of Knowledge®just as PRINCE2® does currently. It will also be of interest for Program Managers with MSP® who need to understand how projects relate to the delivery mechanism. The most up-to-date and relevant view of Agile project management methodologies, PRINCE2 Agile® references the 'flow-based' working featured in Kanban in addition to other agile concepts not covered in other qualifications. Introduction - Getting Started Part 1 An overview of PRINCE2 Agile Overview Blending PRINCE2 and Agile What to fix and what to flex Part 2 Agile behaviors ad the PRINCE2 Principles Agile and the PRINCE2 Themes Part 3 Focus areas Agile and the PRINCE2 Processes Examination preparation Examination. Summary - What did we learn, and how can we implement this in our work environment?

Change Management Foundation: In-House Training: In-House Training This course provides practical knowledge on Change Management techniques and the Foundation certification. You will examine various Change Management techniques and explore which could be effectively implemented in your organization. The structured approach helps you understand how you deal with change as an individual, as a member of a team or organization, and as a leader. The program design explores the impact that change has on these four major areas: Change and the Individual Change and the Organization Communications and Stakeholder Engagement Change Management Practice This course also prepares you for the APMG Change Management Foundation exam. Given that a primary course goal is to achieve the Foundation Certification, the course text will be provided in advance of the workshop so the participant may begin studying. In addition, daily homework assignments and practice exams will be provided. The Foundation-level exam is taken at the end of the third day of the Traditional Classroom course. Virtual Classroom participants must make separate arrangements to schedule their exam following course completion (See 'Important Note for Virtual Course Participants'). What You Will Learn You'll learn how to: Explain how individuals learn and why many may resist change Illustrate how to build an effective change team Describe the stakeholder engagement process and relate this to appropriate communication Differentiate various approaches to plan, implement, and sustain organizational change Demonstrate how to assess change impact and readiness, and deal with resistance Improve your ability to pass the APMG Change Management Foundation Certification exam Getting Started Introductions Course structure Course goals and objectives Change and the Individual How people learn Personality and change - introduction to MBTI Models of individual change - the Change Curve and Bridges' Transition Motivating individuals during change Change and the Organization Understanding organizational metaphors Organizational culture and change 3 models of change - Lewin, Kotter, and Senge Key roles in change Stakeholder Engagement Identifying and analyzing stakeholders Personas and empathy maps Influencing strategies Communication Feedback and communication approaches Communicating change - planning, factors, and barriers Communication biases and channels Change Impact Identifying and assessing change impact Stakeholder impact assessment Change severity assessment Change Readiness Building change agent networks and the change team How to make the organization ready for change Creating a change management plan Dealing with resistance to change APMG Change Management Foundation Exam Preparation Review of and practice with APMG sample questions and test papers APMG Change Management Foundation Exam Traditional Classroom: Paper-based exams will be taken on the last day of class Virtual Classroom: The exam is scheduled by the Participant and taken subsequent to the course

PMI-RMP® Exam Prep: In-House Training This course is aimed at preparing the participant to pass the PMI-RMP® (Risk Management Professional) exam. The course will also provide practical tips and tools that can be used in any organization's project management risk practices. In this expanded session, you will also have time to practice your exam taking skills with coaching from a credentialed instructor. The course includes the tool RMP-IQ, with sample exam questions to practice for the exam and allow participants to see their knowledge level in the various domains. What You Will Learn At the end of this course, participants will be able to: Explain the value and benefits of the PMI-RMP® credential Perform a self-assessment of your knowledge and skills Prepare a study plan that will allow you to pass the exam Foundation Concepts The Risk Management Professional (PMI-RMP®) Exam PMI's Standard for Risk Management Portfolios, Programs and Projects Key risk definitions Risk management life cycle Levels of Risk Management Enterprise Risk Management Portfolio Risk Management Program Risk Management Project Risk Management Risk Strategy and Planning: Part 1 Task 1: Perform a preliminary document analysis Task 2: Assess project environment for threats and opportunities Task 3: Confirm risk thresholds based on risk appetites Risk Strategy and Planning: Part 2 Task 4: Establish risk management strategy Task 5: Document the risk management plan Task 6: Plan and lead risk management activities with stakeholders Agile, programs, and portfolio aspects of risk strategy and planning Risk Identification: Part 1 Objectivity and bias Task 1: Conduct risk identification exercises Risk Identification: Part 2 Task 2: Examine assumption and constraint analysis Task 3: Document risk triggers and thresholds based on context / environment Task 4: Develop risk register Agile, programs, and portfolio aspects of risk identification Risk Analysis: Part 1 Task 1: Perform qualitative analysis Risk analysis in an agile environment Risk Analysis: Part 2 Task 2: Perform quantitative analysis Task 3: Identify threats and opportunities Program and portfolio aspects of risk analysis Risk Response Task 1: Plan risk responses Agile, programs, and portfolio aspects of risk response planning Task 2: Implement risk responses Monitor and Close Risks: Part 1 Task 1: Gather and analyze performance data Monitor and Close Risks: Part 2 Task 2: Monitor residual and secondary risks Task 4: Monitor project risk levels Task 3: Provide information required to update relevant project documents Agile, programs, and portfolio aspects of monitoring and closing risks

PRINCE2 Agile® Practitioner: In-House Training PRINCE2 Agile® Practitioner is a solution combining the flexibility and responsiveness of Agile with the clearly defined framework of PRINCE2®. PRINCE2 Agile® framework covers a wide range of agile concepts, including SCRUM, Kanban, and Lean Startup. The PRINCE2 Agile® Practitioner certification teaches you to blend structure, governance, and control with agile methods, techniques, and approaches. The strength of PRINCE2® lies in the areas of project direction and project management, whereas Agile has a very strong focus on product delivery. When PRINCE2® and agile are combined, project direction, project management, and project delivery are optimized to create a complete project management solution. PRINCE2 Agile® is an extension module tailored for forward-thinking organizations and individuals already benefiting from PRINCE2®. It provides further guidance on how to apply agile methods to the world's most recognized project management method. The purpose of the Practitioner qualification is to demonstrate that you can apply and tailor PRINCE2 Agile® in a scenario situation. What you will Learn Understand the basic concepts of common agile ways of working Understand the purpose and context for combining PRINCE2® and the agile way of working Able to apply and evaluate the focus areas to a project in an agile context Able to fix and flex the aspects of a project in an agile context Apply the PRINCE2® principles and tailor the themes, processes, and management products to a project in an agile context To learn through the use of theory and practical exercises Prepare for the PRINCE2 Agile® Practitioner exam Benefits Agile methods allow organizations to realize the benefits of products and potentially an earlier return on investment while products are being developed and improved Improved communication through the use of common terminology across PRINCE2® and agile disciplines Develop a clear definition of how agile can govern a project's delivery, while PRINCE2® governs projects as a whole Seamless integration: PRINCE2 Agile® will complementPMBOK® GuideandAPM Body of Knowledge® just as PRINCE2® does currently. It will also be of interest for Program Managers with MSP® who need to understand how projects relate to the delivery mechanism. The most up-to-date and relevant view of Agile project management methodologies, PRINCE2 Agile® references the 'flow-based' working featured in Kanban in addition to other agile concepts not covered in other qualifications Agile Overview & Blending PRINCE2 and Agile Agile overview Blending PRINCE2 and Agile Fix and Flex, Agile and PRINCE2 Processes & Starting a Project Fix and Flex Agile and the PRINCE2 Processes; Starting up a project and Initiating a project Business case theme Change and Organization Themes& Principles Change theme Organization theme Agile and PRINCE2 Principles and the Agilometer Managing Product Delivery and Scrum & Plans and Progress Themes Managing product delivery and Scrum Plans Theme and Progress Theme Quality, Controlling & Managing a Stage and Directing Projects and Contracts Quality Theme Controlling a stage and Frequent Releases Managing a stage boundary Directing a project and contracts Closing a project Tailoring PRINCE2 Productsand Other Practices Tailoring PRINCE2 products and other practices

Better Business Cases™ Practitioner: In-House Training: In-House Training Better Business Cases™ is based on the Five Case Model - which is the UK government's best practice approach to structuring spending proposals and making effective business decisions. Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives. The goal of the practitioner course is to develop a candidate's ability to deliver a comprehensive business case, through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this Practitioner course, a candidate will be able to start applying the model to a real business case development project. What You Will Learn At the end of this program, you will be able to: Develop the lifecycle of a business case and to establish the relationships between the five cases Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario Overview of Better Business Cases Alignment with the strategic planning process Importance of the Business Case using the Five Case Model Overview of the Five Case Model Purpose of the key stages in the development of a spending proposal Purpose of a Business Justification Case Business Case Development Process Purpose of project / programme assurance and assurance reviews Responsibility for producing the Business Case Determining the Strategic Context and Undertaking the Strategic Assessment Scoping the Scheme and Preparing the Strategic Outline Case Planning the Scheme and Preparing the Outline Business Case Procuring the Solution and Preparing the Full Business Case Implementation and monitoring Evaluation and feedback Making the Case for Change Agree on the strategic context Determine spending objectives, existing arrangements, and business needs Determine potential business scope and key service requirements Determine benefits, risks, constraint, and dependencies Exploring the Preferred Way Forward Agree on critical success factors Determine long list options and SWOT analysis Recommend a preferred way forward Determining Potential Value for Money Revisit the short list Prepare the economic appraisal for short-listed options Undertake benefits appraisal Undertake risk appraisal Select preferred option and undertake sensitivity analysis Preparing for the Potential Deal Determine the procurement strategy Determine service streams and required outputs Outline potential risk apportionment Outline potential payment mechanisms Ascertain contractual issues and accountancy treatment Ascertaining Affordability and Funding Requirement Prepare the financial model Prepare the financial appraisals Planning for Successful Delivery Plan programme / project management Plan change and contract management Plan benefits realization Plan risk management Plan programme / project assurance and post project evaluation Procuring the Value for Money Solution Revisit the case for change Revisit the OBC options Detail procurement process and evaluation of best and final offers (BAFOs) Contracting for the Deal Set out the negotiated deal and contractual arrangements Set out the financial implications of the deal Ensuring Successful Delivery Finalize project management arrangements and plans Finalize change management arrangements and plans Finalize benefits realization arrangements and plans Finalize risk management arrangements and plans Finalize contract management arrangements and plans Finalize post-project evaluation arrangements and plans