Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 Concepts Identify DB2 family products Explain DB2 workstation component functions Identify DB2 objects Identify the key differences between static SQL and other application alternatives for accessing DB2 data Program Structure I Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs Effectively communicate with DB2 when processing NULL values and determining success of statement execution Demonstrate use of DB2 coding aids Code CONNECT statements within an application program Identify connection types and impacts on a unit of work Program for the Call Attach Facility (CAF) Program Preparation Identify the additional steps necessary to prepare a program that contains embedded SQL for execution Describe the functions of the DB2 PRECOMPILE and BIND processes Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements Program Structure II Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs Issue positioned UPDATE and DELETE statements Identify how scrollable cursors can be used Recovery and Locking Concepts Define a unit of recovery Identify the basic locking strategies used by DB2 Dynamic SQL Introduction Describe the difference between static and dynamic SQL List the types of dynamic statements Code dynamic SQL in a program Managing Test Data Identify methods to insert data into a table Use the LOAD or IMPORT utility Identify the purpose of the RUNSTATS utility Identify the purpose of the REORG utility Performance Considerations Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts Identify the access paths available to DB2 List common causes of deadlocks and avoid such causes when possible Use the EXPLAIN tools as aids to develop applications that emphasize performance Additional course details: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CV722 IBM DB2 11 for z/OS Application Programming Workshop course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
The Company Overview section of your business plan must excite investors. From the founders’ bios and company history to your business location and business model, it must be clear that you’re poised to succeed. This learning stream helps you navigate the five essential sections to include in your plan: company profile, team, staffing, business model, and current status—all with examples, as well as solid business mindset tips and how to talk to investors. The workshop provides a walk-through of the tactical aspects of the learning stream will be walked-through in the workshop step-by-step.
Management of Value (MoV®) Practitioner This interactive MoV® Practitioner course provides a modular and case-study-driven approach to learning Management of Value (MoV). The core knowledge is structured and comprehensive; and well-rounded modules cover the methodology and various techniques. A case study is used to help appreciate the relevance of MoV in its practical application. What you will Learn The MoV Practitioner Course prepares you for the MoV Practitioner exam. Individuals certified at the MoV Practitioner level will be able to: Apply Management of Value (MoV) principles, processes and techniques, and advocate the benefits of this application appropriately to the senior Management. Develop a plan of MoV activities for the whole lifecycle of small and large projects and programs. Plan an MoV study, tailoring it to particular projects or programs and developing practical study or workshop handbooks as required. Understand and articulate value in relation to organizational objectives. Prioritize value drivers using function analysis and use these to demonstrate how value might be improved. Quantify monetary and non-monetary value using the Value Index, Value Metrics and the Value for Money ratio. Describe and comment on the application of various techniques relevant to MoV. Monitor improvements in value realized throughout a project lifecycle and capture learning which can be transferred to future projects. Offer suggestions and guidance about embedding MoV into an organization, including policy issues, undertake a health check, assess maturity and competence, and provide guidance on typical roles and responsibilities. Understand and articulate the use of MoV within other Best Management Practice methods and its contributions to them Benefits of Taking This Course Upon successful completion of this course, you will be able to: Organise and contribute constructively to a Management of Value (MoV) Study Demonstrate a knowledge of MoV principles, processes, approach, and environment Analyse a company, programme or project to establish its organisational value includes identification and weighting of Value Drivers Pass the AXELOS Practitioner Examination Function Analysis Customer FAST Diagram Value Tree Development Weighting Attributes Paired Comparisons Developing a Value Profile Developing a Value Index Value for Money Ratio Stimulating Innovation Value Engineering Option Evaluation and Selection Evaluation Matrix Value and Value for Money Timing and Planning Teams and Stakeholders MoV in the Organization Integrating with Best Management Practice Relationship between Process and Approach
Building High-Performance Teams: Virtual 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
Your Curriculum - Getting it Right! A whole day, whole school practical workshop to tackle Ofsted's "Quality of Education", "Curriculum Intent, Implementation & Impact". Exclusively for independent schools that are inspected by Ofsted.
Want a chill day with family and friends? Enjoy the workshop, paint and drinks! No stress. Join to design your own tote bag. About the workshop You are invited to design your own pattern or monogram on the Muji Tote Bag. Letters and geometry stencils are provided. It’s an interesting journey to create your own Tote bag with the unique patterns! You will have your “Unique Muji Tote Bag” after the workshop. -Each session is 1.5 (within 2 hours) at Plus X Brighton @GetFun Garden Ltd. -Private group sessions are available by reservation (8-10 people). Please feel free to contact us by email for a 20% discount. -Soft drinks, Coffee and tea are provided. -No experience is needed. All the materials are provided such as paint brushes and acrylic paints. www.getfungarden.com *View the past workshops: https://www.instagram.com/stories/highlights/17971768625498102/
Data Data Everywhere – For what purpose? Which data is crucial to driving your organisation? How do we Analyse data to drive improvements? Course Overview Organisations generally collect enormous amounts of data. However, what data or information is really needed? How do we present the data that we have collected so that it is openly available and can be understood and used to drive the business? Is the data collected driving change? Structure of the Course This one-day workshop will enable participants to gain the necessary skills to collect, analyse and present data in an understanding and meaningful way and assist the decision-making process. It looks at how to translate data into useful and meaningful information that can contribute towards real problem solving, effective performance indicators, leading to the development of effective KPI’s, among others. Alternatively, if an organisation is in the process of selecting data collection methods and appropriate analysis, then this workshop will also help. Data analysis skills are essential to providing honest and accurate analysis, determining statistical significance, reliability, and validity on which to base their decisions, whether it is to improve quality, profitability, efficiency, or competitiveness. Improper statistical analyses distort findings and can mislead or negatively influence decision-making and the perception of the data collected. The correct analysis of data is a process of systematically applying statistical and / or logical techniques to describe and illustrate, condense, and recap, and evaluate data so that it can be used effectively. This workshop provides essential learning for staff at all levels of the organisation. Course content: 1. Data Types Discrete data Continuous data 2. Data Collection Sheet design Testing, prior to full-scale data collection 3. Data Input into Spreadsheet 4. Determination of Basic Descriptive Statistics Mean Median Mode Minimum and maximum values Range Standard deviation 5. Graphical Analysis Bar charts Line graphs Pie charts Scatter diagrams 6. Determination of Relationships between Factors Relationship between discrete factors Relationship between continuous factors 7. Use of Data in Decision Making 8. Establishment of Key Performance Indicators 9. Determination of Data Reliability 10. Summary Who would benefit from this Approach? Anyone who collects, manages, analyses and uses data to drive business performance. Delivery The course is delivered through virtual, tutor-led classes as structured above. The platform used is Adobe Connect which utilizes e-work rooms, video and streamed trainers. Cost £200 + VAT If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.
Duration 5 Days 30 CPD hours This course is intended for Microsoft Dynamics 365 Finance and Operations Apps Developers Overview By the end of this course, you will learn to develop fully realized solutions by using standardized application coding patterns. In this course, you will learn the tasks needed to fulfill the role of developer in Dynamics 365 Finance and Operations Apps. The Dynamics 365 for Finance and Operations (FO) developer is a key technical resource that implements and extends the application to meet the requirements of the business. Module 1: Overview & Architecturen Explore the ecosystem and main components Explore the technical architecture Explore design and deployment considerations Module 2: Developer Tools Manage implementations by using Lifecycle Services Manage source code by using version control Customize by using Visual Studio Module 3: Solution Design Implement application lifecycle management Module 4: AOT Elements Build extended data types and enumerations Build tables Build forms and optimize form performance Create classes Create other user interface elements Module 5: Code Development & Testing Explore the test framework and use tools Get started with development using X++ Develop object-oriented code Use RSAT tool Module 6: Data Migration Prepare data for migration Module 7: Frameworks Introduction Explore extensions and the extension framework Extend elements SysOperationSandbox framework Summary Module 8: Integration Identify data integration patterns and scenarios Implement data integration concepts and solutions Implement the data management package API Data integrations Integrate with Microsoft Azure Connecting to Power Platform services Consume business events Integrate Finance and Operations apps with Microsoft Dataverse Module 9: Reporting Explore the reporting tools Build reports Build workspaces Manage data sources with external data stores Module 10: Security & Performance Work with performance and monitoring tools Implement role-based security Apply basic performance optimization techniques Additional course details: Nexus Humans MB-500T00 Dynamics 365 - Finance and Operations Apps Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the MB-500T00 Dynamics 365 - Finance and Operations Apps Developer course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
This is our lead workshop/training day on behaviour and relationship work in Primary and Secondary schools and Academies, as well as Early Years, FE and adult settings and is both a values primer and a practical guide to successful innovative strategies for improving behaviour and strengthening relationships for challenging children and people of all ages. Course Category Behaviour and Relationships Meeting emotional needs Early Years Inclusion Description This is our lead workshop/training day on behaviour and relationship work in schools and other settings and is both a values primer and a practical guide to successful innovative strategies for improving behaviour and strengthening relationships for challenging children and young people of all ages. Not just another day on ‘Behaviour Management’ – our ‘Fresh Approaches to Behaviour and Relationships’ day goes well beyond a rewards and sanctions approach to ‘behaviour’. We will be focused on those young people for whom rewards and punishments do not always work and who confuse the adults who work with them. We aim to take a relationships based approach and to give those attending an opportunity to think more deeply about why young people do the things they do and what our part as adults is in creating, sustaining and changing these behaviours. The day gives those present opportunities to reflect on their attitudes and practice in relation to children’s behaviour and relationship building. If your usual approaches to managing behaviour aren’t working with particular individuals then take a tour through this range of cutting edge strategies for bringing about positive behaviour change, and for meeting challenging emotional needs. Testimonials ‘Thank you so much for the excellent training day you delivered last week. I found the whole experience quite uplifting and inspirational.’ ‘Thought provoking and empowering. Probably the best training day we’ve had in school’ ‘There was already evidence on the first day of school for pupils that staff were adopting a different approach. Thank you so much for helping us to make a difference.’ ‘Today has to have been one of the very best INSET days I have personally been to – full of practical tips and techniques to use in the classroom; and also proof that this approach does work in practice. It really was inspirational and an excellent start to the term.’ ‘Very motivating and exciting course.’ ‘Another fantastic Colin and Derek training session’ ‘Enjoyed this course very much. Derek and Colin worked very hard and I understood it. Thank you.’ Learning Objectives Reinforce and affirm good practice Re-energise, stimulate and challenge thinking about inclusion of challenging young people and children Increased understanding about behaviour and emotions Increased confidence in managing challenging pupils in childcare settings mainstream schools Access to a wider range of practical strategies to impact on behaviour problems Opportunity to reflect on professional attitudes and behaviour towards families and children and young people Learn new skills and processes to make inclusion successful Who Is It For ? Primary and secondary staff teams All Childcare Providers – Out of School club staff/Childminders/Youth Workers Early years and school based practitioners Heads and deputies SENCOs Advanced skills teachers Primary and secondary teachers Year Managers Parents Local authority support services Course Content The course answers the questions: Are there any new ways to include our most challenging young people? Should we focus on behaviour or relationships? How do we go about including high profile children or young people? Can we find an alternative to exclusion? What would a relationship policy look like? The following are some of the key themes and tools we are likely to explore during the day Getting the welcome right for the most challenging Encouraging – getting the best from the most challenging- Circle of Courage – belonging-achievement-generosity – independence Active listening – Listening to the person underneath the behaviour Compass of Shame – which directions do children and young people head when they feel shame? And what helps children work through these feelings in more healthy ways? Involving other children and young people in solutions and interventions – Circles of friends: peer support, counselling and mediation Team Problem Solving – Solution Circles: a 30 minute group problem solving process to get Teams ‘unstuck’ and to generate positive first action steps Circle of Adults: a process that ‘listens deeper’ to generate reflective problem solving creating lasting behaviour change and effective behaviour intervention plans. A particularly valuable process for those looking to enhance their leadership and facilitation skills Restorative justice and restitution: principles and practice of this approach to repairing harm and restoring relationships without reliance on punishment Understanding the effects of Separation, Loss, Trauma and Neglect on children’s learning and relationships in school and what adults can do to reach and support these children