68 CBD courses

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.

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

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. DESCRIPTION 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® Framework * MSP Principles * MSP Themes * MSP 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.

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

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

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. OBJECTIVES By the end of the course you will be able to: * Use a range of Text functions to manage text data * Create and use different types of date and time functions * Work with rounding functions * Use logical statements * Build nested formula * Use SUMIF, COUNTIF and AVERAGEIF * Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions * Use IS functions and IFERROR to test cell values CONTENT WORKING WITH TEXT  * Splitting text into multiple cells * Merging data into one cell * Extracting data using text functions * Tidying data WORKING WITH DATES AND TIMES   * Formatting dates and times * Date and time functions * Calculating date and time differences USING FUNCTIONS TO ROUND NUMBERS UP AND DOWN  * ROUND * ROUNDUP * ROUNDDOWN * CEILING * FLOOR USE LOOKUP FUNCTIONS  * Lookup functions * Creating a lookup table * Range naming * Using VLOOKUP * Using HLOOKUP * Using INDEX and MATCH WORKING WITH LOGICAL STATEMENTS  * Creating an IF statement * Using the AND plus OR functions * Nesting functions CALCULATING VALUES BASED ON GIVEN CRITERIA * SUMIF(S) * COUNTIF(S) * AVERAGEIF(S) USING IS AND IFERROR AND TEST CELL VALUES * ISBLANK * ISNUMBER * ISTEXT * ISERROR * IFERROR

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