CBD courses in Sheffield

Master Oracle Multitenant architecture in this course. Learn about database architecture, PDB creation, user management, backup and recovery, resource management, data pump utility, application containers, CDB fleet, PDB snapshots, and DBCA PDB cloning. This course is designed for intermediate-level participants.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for Data Warehouse Administrator, Database Administrator, Database Designer, Support Engineer, and Technical Administrator. Overview Upon successful completion of this course, students will be able to Install Oracle Grid Infrastructure for a Standalone Server, Configure ASMLIB and create ASM disk groups, Apply the latest patch set updates to the Grid Infrastructure software, Install Oracle Database software, Use Oracle Restart to manage components, Prepare the Linux operating system for Oracle software installation, Upgrade Oracle Database, Create a container database, Install Oracle Grid Infrastructure for an Independent Server, Create an Oracle Database using DBCA, and Install the latest patch set updates to the Oracle database software. This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. In this course, you will be introduced to Oracle Database Cloud Service. Oracle Database Overview Oracle Database Introduction Oracle Database Architecture Overview Oracle Database Instance Configurations Oracle Database Memory Structures Process Structures Database Storage Architecture Logical and Physical Database Structures Container and Pluggable Database Overview Installing Oracle Grid Infrastructure for a Standalone Server Overview of Oracle Grid Infrastructure for a Standalone Server System Requirements for Oracle Grid Infrastructure Configuring Storage for Oracle Automatic Storage Management (ASM) Installing Oracle Grid Infrastructure for a Standalone Server Upgrading Oracle Grid Infrastructure for a Standalone Server Installing Oracle Database Software Planning Your Installation System Requirements for Oracle Database Preparing the Operating System Using 4 KB Sector Disks Setting Environment Variables Checking the System Requirements Using the Oracle Universal Installer (OUI) Performing a Silent Mode Installation Creating an Oracle Database by Using DBCA Planning the Database Storage Structure Choosing non-CDB or CDB Types of Databases (based on workload) Choosing the Appropriate Character Set Understanding How Character Sets are Used Setting the NLS_LANG Initialization Parameter Using the Database Configuration Assistant (DBCA) Using Oracle Restart Oracle Restart Overview Oracle Restart Process startup Controlling Oracle Restart Choosing the Correct SRVCTL Utility Oracle Restart Configuration Using the SRVCTL Utility Obtaining Help for the SRVCTL Utility Starting Components by Using the SRVCTL Utility Introduction to Upgrading to Oracle Database Upgrade Methods Data Migration Methods Supported Releases for Direct Upgrade Overview of Upgrade Process Performing a Rolling Upgrade Upgrading a CBD Preparing to Upgrade to Oracle Database Developing a Test Plan Performance Testing Requirements for Databases Using Oracle Label Security or Oracle Database Vault Requirement for Databases Using Oracle Warehouse Builder Using the Pre-Upgrade Information Tool Backing Up the Database Installing the Oracle Database Software Preparing the New Oracle Home Upgrading to Oracle Database Upgrading by Using the Database Upgrade Assistant (DBUA) Manually Upgrading to Oracle Database Migrating a non-CDB to a CDB Performing Post-Upgrade Tasks Migrating to Unified Auditing Performing Post-Upgrade Tasks Following a Manual Upgrade Migrating Data by Using Oracle Data Pump Data Pump Overview Migrating by Using Data Pump Importing by Using a Network Link

Develop your skills in agile project management and learn the agile approach using the DSDM® framework. Gain confidence to sit the AgilePM® Foundation and Practitioner qualifications on this accredited programme. Duration: 4 days (26 hours) This accredited course is designed for Project Managers, who require an understanding of the agile approach and/or who are intending to run projects using the DSDM® framework. It is also designed to equip practising Project Managers with the confidence to sit the AgilePM® Foundation and Practitioner qualifications, and each delegate will receive a copy of the Agile Project Management V2 Handbook, published by the Agile Business Consortium, formally known as the DSDM Consortium. Objectives  By the end of the course you will be able to: Demonstrate a detailed, practical knowledge of Agile Project Management, based upon the DSDM framework and be equipped with the ability to apply the agile approach in the workplace Describe how the agile way of working can sit alongside more traditional project management frameworks, such as PRINCE2® Plan, organise and control Agile projects Sit the AgilePM Foundation examination, held on the third day and for the Practitioner examination, held on the afternoon of the fourth day Content Agile fundamentals What is Agile? Choosing an appropriate Agile approach Philosophy, Principles and Project Variables Preparing for Success Roles and responsibilities Roles and Responsibilities and the Project Manager view People, Teams and Interactions The DSDM process and products Looking at the DSDM Process and Project Management through the Lifecycle, as well as the DSDM Products and their Effective Use Practices and control Delivering on Time – combining MoSCoW Prioritisation and Timeboxing Requirements and User Stories Estimating Planning Quality Risk Examination and results Foundation Examination and results Practitioner Workshop and Examination AgilePM® Foundation Exam The AgilePM® Foundation Exam is of 40 minutes duration and consists of 50 multiple choice questions. A Pass is 25 correct answers. The exams are marked by the trainer immediately following the exam and the results are available within an hour. The AgilePM® Practitioner Exam A written paper of 2.5 hours duration. There are 8 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. Each question is worth 10 marks and the candidate must score 40/80 to be successful. Please note that examinations are the responsibility of the examination board, APMG. Presented in association with aims4change, an APMG Accredited Training Organisation. AgilePM®is a Registered Trade Mark of the Agile Business Consortium Limited.

Learn the basic principles of good programme management using the MSP® approach and prepare for the Foundation and Practitioner examinations on this accredited programme. Duration: 5 days (32.5 hours) Our MSP® Foundation and Practitioner course is designed to teach the basic principles of good programme management in line with the Principles, Themes and Processes described in the MSP® approach. It also prepares delegates for the Foundation and Practitioner examinations. This course is designed for anyone who needs to understand programme management and the practical application of MSP® and to gain the MSP® Foundation and Practitioner qualifications. Delegates should have an understanding of and preferably experience in the issues surrounding business change The MSP® Foundation and Practitioner Course is based upon the “Managing Successful Programmes – 5th Edition” which describes “best practice” guidance for handling all types of transformational change programmes. These are intensive modules and require delegates to undertake some evening work in their own time. Objectives  By the end of the course you will be able to: Describe the differences between programmes and projects Describe the Principles, Themes and Processes as described in the MSP® - 5th Edition Practice the application of MSP® Prepare for both the MSP® Foundation and Practitioner Exam Please note that examinations are the responsibility of the examination board, PEOPLECERT and must be organised separately by each person attending. Content Introduction Introduction – what is, and why use, Programme Management The Three Lenses of the MSP® FrameworkMSP PrinciplesMSP ThemesMSP Processes The Themes Overview – introduction to the seven Themes Organization – roles, accountabilities, responsibilities Design – Vision, Benefits, Risk, Target Operating Model Justification – Business case and financial planning Structure – Delivery approaches, Planning and control Knowledge – Knowledge and Information management Assurance – Assurance at multiple levels approach and planning Decisions – Decision-making, Issue and Risk resolution approaches, Data-gathering and options analysis The Processes Overview – the seven processes Identify the Programme – initial justification Design the Outcomes - establishing solid foundations Plan Progressive Delivery – build on the programme design Deliver the Capabilities– oversee programme delivery Embed the Outcomes – adopting new ways of working and realize the benefits Evaluate new information – collecting, evaluating, analysing and presenting new information Close the Programme – final assessment and release resources Practitioner Workshop and Examination MSP® Practitioner Examination Objectives and Guidance MSP® Review MSP® Practitioner Examination Workshops MSP® Practitioner Examination MSP® Foundation and Practitioner Examinations The MSP® Foundation Exam is of 1 hour duration and consists of 60 multiple choice questions. A Pass is 36 correct answers, 60%.   The MSP® Practitioner Exam is a written paper of 2.5 hours duration. There are 70 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. The candidate must score 42/70, 60%, to be successful. Presented in association with aims4change, a PEOPLECERT Accredited Training Organisation. MPS® is a Registered Trade Mark of AXELOS Limited.

Learn the processes, practices and principles of project management described in the PRINCE2® approach and prepare for the Foundation and Practitioner examinations on this accredited programme. Duration: 5 days (32.5 hours) Our PRINCE2® Foundation and Practitioner Qualification course is designed to teach the processes, practices and principles of project management described in the PRINCE2® approach and to prepare delegates for the Foundation and Practitioner examinations, held as part of the course. This course is designed for existing and potential Project and Team Managers who would like to gain a comprehensive understanding of the PRINCE2® method of managing projects and will provide those responsible for planning and managing projects with a structure that will help, without imposing inflexible processes or stifling creative thinking. The PRINCE2® Foundation and Practitioner Course is based on the “Managing Successful Projects with PRINCE2® 7th Edition”, which describes the structured project management method. These are intensive modules and require delegates to undertake some evening work in their own time. Objectives  By the end of the course you will be able to be: Describe the background, principles, structure and terminology used in the PRINCE2® 7th Edition project management method Prepare for and take both the PRINCE2® Foundation and Practitioner Exams Please note that examinations are the responsibility of the examination board, PEOPLECERT and must be organised separately by each person attending. Content Introduction Introduction to projects and project management Structure Of PRINCE2® 7th Edition The seven Principles –the basis of what defines a PRINCE2 project People – leading successful change, teams and communication The seven Practices – to be addressed throughout the project The seven Processes - the activities to direct, manage and deliver a project successfully Practices Business case – establishing mechanisms to decide whether project is desirable, viable and achievable Organizing – establishing accountabilities and responsibilities Quality – defining mechanisms to ensure that products are fit for purpose Plans – the product based approach to planning Risk – identifying, assessing and controlling uncertainty Issues – identifying, assessing and controlling changes to the baseline and other issues Progress – monitoring actual achievements against estimate and controlling deviations Processes Starting up a Project - is there a viable and worthwhile project Directing a Project – enabling key decision making by the Project Board Initiating a Project – establishing solid foundations Controlling a Stage –assigning and monitoring work and keeping within stage tolerance Managing Product Delivery – controlling the link between the Project Manager and Team Manager(s) Managing a Stage Boundary – current stage review and next stage planning Closing a Project – confirmation of acceptance and project review Tailoring PRINCE2® - to the project environment Foundation Examination and results Practitioner Workshop and Examination PRINCE2® Practitioner Examination Objectives and Guidance PRINCE2® Review PRINCE2® Practitioner Examination Workshops PRINCE2® Practitioner Examination PRINCE2® Foundation and Practitioner Examinations The PRINCE2® Foundation Exam is of 1 hour duration and consists of 60 multiple choice questions. A Pass is 36 correct answers, 60%. The PRINCE2® Practitioner Exam is a written paper of 2.5 hours duration. There are 70 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. The candidate must score 42/70 to be successful, 60%.   Presented in association with aims4change, a PEOPLECERT Accredited Training Organisation. PRINCE2® is a Registered Trade Mark of AXELOS Limited.

Get to grips with Docker, containers versus images, and more by learning through a hands-on approach

With this hands-on video course, you'll gain a solid understanding of AWS, DevOps, and deployments at scale using ECS with the help of examples and activities. Throughout the course, you'll get to grips with a wide variety of AWS services.

Learn how to manage internal and/or external stakeholders’ expectations within a project environment. Course overview Duration: 1 day (6.5 hours) This course is suitable for anyone who has to manage internal and/or external stakeholders’ expectations within a project environment. The course will provide tools and techniques to manage stakeholder’s expectations and needs. It will help participants to map all stakeholders who impact the capability to deliver the desired results. Participants will work with a fictitious project to bring all the analysis and tools to life.  Objectives  By the end of the course you will be able to: Identify both primary and secondary stakeholders Use tools and processes to manage stakeholder expectations Use techniques to help win support for your projects Put together a stakeholder communication plan Determine the best communication methods Build relationships between you and key stakeholders Use influencing skills to influence stakeholders before they influence you Effectively handle conflict that occurs throughout the project lifecycle Determine the fundamental rules of negotiation and how to achieve a satisfactory outcome Content Identification and stakeholder analysis Using a mind map to determine stakeholders and stakeholder groups Analysis of stakeholder interest and power Using different tools to help determine stakeholder needs and expectations Categorising your stakeholders into primary, secondary and key Interviewing stakeholders to determine needs, expectations and politics Influencing strategies Using a planning tool to determine how different stakeholders can be influenced Interviewing stakeholders to determine what will motivate/de-motivate them Looking at communication methods and choosing the most appropriate in order to influence and manage expectations Production the communication strategy Using a case study and project Gantt to produce a detailed communication plan Using a communication plan structure Conflict Management Identifying common causes of conflict in the project lifecycle Finding the most appropriate response to resolve conflicts effectively Determining your default position and understanding why it might not always be right Negotiation The different types of negotiation used in the project environment Determining a simple negotiation process Understanding the principles of effective negotiation – the do’s and don’ts

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items