Duration 3 Days 18 CPD hours This course is intended for This course is aimed at project team members responsible to implementing cross application business processes in Sales and Distribution and Materials Management. Participants wishing to familiarize themselves with the basic execution of cross-application business processes and implementation in the standard SAP ERP. In this course, participants become familiar with the functions for processing selected cross application business processes in Sales and Distribution and Materials Management, and identify the associated Customizing settings. Course Outline Third-party order processing Cross-company-code sales Stock transfers within a company code Cross-company-code stock transfers Subcontracting Advanced Returns Management (supplier and customer returns)
Join our Women in Insurance Leadership Workshop and gain insights from industry experts on how to succeed in the male-dominated insurance sector. This workshop is designed to empower women by providing valuable tools and resources to enhance leadership skills, build professional networks, and create a more inclusive workplace culture. Don't miss this opportunity to connect with other women in the industry and take your career to the next level. Register today!
Duration 2 Days 12 CPD hours This course is intended for This basic course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of Overview Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses Code inner joins and non-correlated subqueries Use SQL arithmetic operations Use scalar and column functions Use UNION and UNION ALL INSERT, UPDATE and DELETE rows Code simple CREATE TABLE and CREATE VIEW statements This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment. Outline Introduction Simple SQL Queries Retrieving Data from Multiple Tables Scalar Functions and Arithmetic Column Functions and Grouping UNION and UNION ALL Using Subqueries Maintaining data
Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.
Duration 3 Days 18 CPD hours This course is intended for The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Prerequisites Understanding core data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non-relational data in the cloud. Knowledge of data analysis and visualization concepts. DP-900T00 Microsoft Azure Data Fundamentals is recommended 1 - Discover data analysis Overview of data analysis Roles in data Tasks of a data analyst 2 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 3 - Get data in Power BI Get data from files Get data from relational data sources Create dynamic reports with parameters Get data from a NoSQL database Get data from online services Select a storage mode Get data from Azure Analysis Services Fix performance issues Resolve data import errors 4 - Clean, transform, and load data in Power BI Shape the initial data Simplify the data structure Evaluate and change column data types Combine multiple tables into a single table Profile data in Power BI Use Advanced Editor to modify M code 5 - Design a semantic model in Power BI Work with tables Create a date table Work with dimensions Define data granularity Work with relationships and cardinality Resolve modeling challenges 6 - Add measures to Power BI Desktop models Create simple measures Create compound measures Create quick measures Compare calculated columns with measures 7 - Add calculated tables and columns to Power BI Desktop models Create calculated columns Learn about row context Choose a technique to add a column 8 - Use DAX time intelligence functions in Power BI Desktop models Use DAX time intelligence functions Additional time intelligence calculations 9 - Optimize a model for performance in Power BI Review performance of measures, relationships, and visuals Use variables to improve performance and troubleshooting Reduce cardinality Optimize DirectQuery models with table level storage Create and manage aggregations 10 - Design Power BI reports Design the analytical report layout Design visually appealing reports Report objects Select report visuals Select report visuals to suit the report layout Format and configure visualizations Work with key performance indicators 11 - Configure Power BI report filters Apply filters to the report structure Apply filters with slicers Design reports with advanced filtering techniques Consumption-time filtering Select report filter techniques Case study - Configure report filters based on feedback 12 - Enhance Power BI report designs for the user experience Design reports to show details Design reports to highlight values Design reports that behave like apps Work with bookmarks Design reports for navigation Work with visual headers Design reports with built-in assistance Tune report performance Optimize reports for mobile use 13 - Perform analytics in Power BI Explore statistical summary Identify outliers with Power BI visuals Group and bin data for analysis Apply clustering techniques Conduct time series analysis Use the Analyze feature Create what-if parameters Use specialized visuals 14 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 15 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 16 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 17 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method Additional course details: Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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.
PgMP® Exam Prep: In-House Training This course is designed and developed by PgMP® certified consultants and instructors. Its aim is to prepare professionals who are familiar with the principles of program management for the Program Management Professional (PgMP)® Examination. The course is based on PMI's The Standard for Program Management, A Guide to the Project Management Body of Knowledge (PMBOK® Guide), and PMI's Program Management Professional (PgMP)® Examination Content Outline (current versions). Through this learning experience, you will explore: Program management from a PMI standard perspective, including the interdependencies between the five performance domains, the three program phases, and the ten supporting activities in this new and improved program management standard The difference between the five performance domains in the new program management standard and the five practice domains in the examination content outline The role and competencies of the program manager The difference between project managers and program managers - and their relationship in a program environment The difference between program managers and portfolio managers - and their relationship in a program environment How program managers align and manage benefits The best ways to engage and involve program stakeholder groups How to establish governance across the program life cycle What You Will Learn At the end of this course, you will be able to: Differentiate between the practice domains in the PMI PgMP® Examination Content Outline and the performance domains in The Standard for Program Management - Fourth Edition Name and describe the three phases in the program management life-cycle phases Describe the mapping of the life-cycle phases with the supporting program activities Identify the key outputs of the supporting program activities Articulate the interrelationships between the program management supporting processes and the mapping of processes to Knowledge Areas and Process Groups in the PMBOK® Guide - Sixth Edition Apply program management knowledge to answer foundation and scenario-based questions Summarize the process and eligibility criteria for earning the PgMP® credential Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Programs, projects, and portfolio definitions differences, and how they relate The definition of a component and how it relates to a program Representative program management life cycle Role of the program manager and the program office The difference between the program management practice and performance domains Program Register and Knowledge Asset Management Program registers, and how they are used to manage knowledge assets Knowledge asset management, beginning with the data, information, knowledge, and wisdom (DIKW) Model Knowledge assets and relationship to the performance domains The program manager as a knowledge asset manager Types of Programs Perspectives on programs to establish the 'right' perspective Categories of programs based on the program standard Scenario-based questions Program and Organization Strategy Alignment An overview of the Program Strategy Alignment performance domain Exploration of the elements of strategic alignment, i.e., the business case, program charter, and program roadmap Exploration of organization maturity and strategic alignment Scenario-based questions that reference both the Program Strategy Alignment performance domain and the Strategic Program Management practice domain Program Benefits An overview of the Program Benefits Management performance domain Exploration of each benefits management interaction with the representative program management life cycle: Benefits IdentificationBenefits Analysis and PlanningBenefits DeliveryBenefits TransitionBenefits SustainmentScenario-based questions that reference both the Program BenefitsManagement performance domain and the Benefits Management practice domain Program Stakeholder Engagement An overview of the Program Stakeholder Engagement performance domain Exploration of each stakeholder engagement performance domain activity: Program Stakeholder IdentificationProgram Stakeholder AnalysisProgram Stakeholder Engagement PlanningProgram Stakeholder EngagementProgram Stakeholder CommunicationsScenario-based questions that reference both the Program StakeholderEngagement performance domain and the Stakeholder Management practice domain Program Governance An overview of the Program Governance performance domain Exploration of each program governance performance domain activity: Program governance practicesProgram governance roles and responsibilitiesProgram governance design and implementationGovernance relationship within programsScenario-based questions that reference both the Program Governance performance domain and the Governance practice domain Program Life Cycle Management An overview of the Program Life Cycle Management performance domain Exploration of the three phases in the representative program life cycle: Program DefinitionProgram DeliveryProgram ClosureExploration of the interaction between program activities and integration managementScenario-based questions that reference both the Program Life CycleManagement performance domain and the Program Life Cycle practice domain Program Management Supporting Activities - Part 1 An overview of the program management supporting activities Exploration of 5 of 10 supporting activities: Program change managementProgram communications managementProgram financial managementProgram information managementProgram procurement managementScenario-based question(s) presented after each supporting activity Program Management Supporting Activities - Part 2 Exploration of the remaining 6 of 10 supporting activities: Program quality managementProgram resource managementProgram risk managementProgram schedule managementProgram scope managementScenario-based question(s) presented after each supporting activity Program Management Professional (PgMP®) Examination Application process and timeline General and special eligibility criteria International Institute's Online Learning Tool - access to sample examination questions Program Management Professional (PgMP®) Examination breakdown of domains and subdomains Terms and conditions of the exam PgMP® Professional Code of Conduct
Duration 5 Days 30 CPD hours This course is intended for Experienced system administrators and system integrators responsible for using the advanced features of vRealize Automation in enterprise deployments. Overview By the end of the course, you should be able to meet the following objectives Describe and configure the vRealize Automation in a clustered enterprise deployment using VMware vRealize Suite Lifecycle Manager⢠Scale VMware Identity Manager⢠to support High Availability. Configure security certificates in vRealize Automation from external Certificate Authorities. Describe the clustered deployment architecture, including Kubernetes pods and services. Create and configure advanced blueprints with complex YAML and cloudConfig. Use vRealize Automation advanced blueprints to deploy an actual 2-tier DB-Server using MySQL and phpMyAdmin. Practice troubleshooting techniques with advanced YAML blueprints in vRealize Automation. Use advanced VMware NSX-TTM Data Center networking features including NAT, routed networks, load balancers, security groups, and tags. Use VMware Code Stream⢠to integrate vRealize Automation with Kubernetes. Create Code Stream pipelines. Create and use Ansible playbooks that integrate with vRealize Automation. Configure vRealize Automation to integrate with Puppet. Configure and use ABX actions to create day-2 actions and interface with PowerShell scripts. Use vracli commands, log files, and VMware vRealize Log Insight⢠to troubleshoot vRealize Automation and vRealize Automation deployments. This five-day course is a follow-on to the VMware vRealize© Automation? Install, Configure, Manage course. In this course you go deeper into the advanced features of vRealize Automation to deploy user systems and interface vRealize Automation with other platforms and you learn how to deploy an enterprise-level cluster environment using LCM. This course relies heavily on hands-on labs. Course Introduction Introductions and course logistics Course objectives vRealize Automation Clustered Deployment Use LCM in a clustered deployment Configure External Certificates Configure NSX-T Data Center load balancer Install vRealize Automation using Clustered Deployment Scale VMware Identity Manager to support High Availability vRealize Automation Clustered Deployment Architecture List of Kubernetes Pods The vRealize Automation Kubernetes Architecture Relationship of Kubernetes Pods to Services Logs and their locations Blueprint deployment workflow with Kubernetes Service interaction Backup strategies and potential problems Advanced Blueprints Use advanced YAML and cloudConfig to deploy a functioning 2-tier application with a phpMyAdmin front-end server and a MySQL database server Use troubleshooting techniques to debug problems in advanced YAML blueprints List the log files that can aid in troubleshooting blueprint deployment Advanced Networking Use VMware NSX-T Data Center advanced features in blueprints Interfacing to IPAMs Use NSX-T Data Center NAT in blueprints Use NSX-T Data Center routed networks Use NSX-T Data Center load balancers Use NSX-T Data Center security groups Use tags with NSX-T Data Center network profiles Using vRealize Orchestrator Create Day-2 Actions with vRealize Orchestrator workflows Troubleshoot vRealize Orchestrator cluster issues Use vRealize Orchestrator to add computer objects to Active Directory when vRealize Automation deploys blueprints Use a tagging approach to vRealize Orchestrator workflows Use dynamic forms with vRealize Orchestrator Using ABX Actions Determine when to use ABX and when to use vRealize Orchestrator Use ABX to create day-2 Actions Call PowerShell from ABX Kubernetes Integration Create a Kubernetes namespace from vRealize Automation Connect to an existing Kubernetes cluster Automate the deployment of an application to a Kubernetes cluster with Code Stream Use Kubernetes in Extensibility Code Stream Create and use CI/CD pipelines Use the Code Stream user interface Add states and tasks to a Code Stream pipeline Integrate code from Code Stream with Git Using GitLab Integration Configure the GitLab Integration Use Gitlab with blueprints Configuration Management Describe the use case of Ansible and Ansible Tower Connect to Ansible Tower Use Ansible playbooks Use Puppet in configuration management Troubleshooting vracli commands and when to use them Check the status of Kubernetes pods and services Correct the state of pods and services Diagnose and solve vRealize Automation infrastructure problems Diagnose and solve vRealize Automation failures to deploy blueprints and services Use vRealize Log Insight for troubleshooting Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vRealize Automation: Advanced Features and Troubleshooting [v8.x] 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 VMware vRealize Automation: Advanced Features and Troubleshooting [v8.x] 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.
Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!
Duration 5 Days 30 CPD hours This course is intended for Experienced system administrators and system integrators responsible for designing and implementing vRealize Automation Overview By the end of the course, you should be able to meet the following objectives: Describe the vRealize Automation architecture and use cases in cloud environments Manage vRealize Automation entities on VMware and third-party virtual and cloud infrastructures Configure and manage Cloud Accounts, Projects, Flavor Mappings, Image Mappings, Network Profiles, Storage Profiles, Volumes, Tags, and Services Create, modify, manage, and deploy Cloud Templates Connect to a Kubernetes Cluster and manage namespaces Customize services and virtual machines with cloudConfig Configure and manage the Service Broker Configure and manage ABX actions, custom properties, event broker subscriptions, and vRealize Orchestrator workflows Integrate with vRealize Orchestrator Install vRealize Automation with Lifecycle Configuration Manager Describe Cloud Automation Services (Cloud Assembly and Code Stream). Integrate Cloud Assembly with Terraform and SaltStack Use logs and CLI commands to monitor and troubleshoot vRealize Automation During this five-day course, you focus on installing, configuring, and managing VMware vRealize© Automation?. You learn about how vRealize Automation can be used to automate the delivery of virtual machines, applications, and personalized IT services across different data centers and hybrid cloud environments. The course covers how to manage both on-premise systems and cloud services. The course covers how vRealize Automation Service Broker can aggregate content in native formats from multiple clouds and platforms into a common catalog. This course also covers interfacing vRealize Automation with other systems using VMware vRealize© Orchestrator? and how to use vRealize Automation to manage Kubernetes systems and leverage other systems. The course also covers integrating with Terraform and using SaltStack as a configuration management tool. Course Introduction Introductions and course logistics Course objectives vRealize Automation Overview and Architecture Describe the purpose and functionality of vRealize Automation Describe the vRealize Automation architecture Describe the use of VMware Workspace ONE© AccessTM Describe the relationship between Kubernetes clusters, containers, and vRealize Automation services Describe CLI commands for vRealize Automation 8 cluster management Describe Cloud Assembly Describe Service Broker Describe Code Stream Installing vRealize Automation List the different vRealize Automation deployment types Describe the purpose of vRealize easy installer Describe the vRealize Automation installation process Authentication and Authorization Identity the steps involved in integrating Workspace One with Active Directory Describe features of Workspace One Describe the user roles available in vRealize Automation Identify the key tasks performed by each user role Define custom roles Configure branding and multitenancy Basic Initial Configuration Quickly create a basic configuration with a cloud account, cloud zone, project, flavor mapping, and image mapping. VMware Cloud Templates Configure and deploy a basic cloud template Create cloud templates that can run on any cloud Use cloudConfig to run commands, install software, and create users Use YAML for inputs, variables, and conditional deployments Tags and Storage Configuration Configure tags Describe different types of tags Manage tags Configure storage profiles Use tags and storage profiles Integrating NSX-T Data Center List the capabilities and use cases of NSX-T Data Center Describe the NSX-T Data Center architecture and components Integrate NSX-T Data Center with vRealize Automation List the supported network profiles in vRealize Automation Use NSX-T Data Center components to design a multitier application Cloud Template Identify the network and security options available in design canvas Create and manage on-demand networks and security groups Configure NSX-T day 2 actions Integrating with Public Clouds Configure and use VMware Cloud Foundation accounts Configure and use an AWS cloud account Configure and use an Azure cloud account Configure and use a Google Cloud Platform cloud account Using Service Broker for Catalog Management Release a VMware Cloud Template? Define content source and content sharing Define Service Broker policy enforcement Use custom forms for catalog items vRealize Automation Extensibility Describe Extensibility Use event topics Create a subscription Call a vRealize Orchestrator workflow Create ABX actions Using Code Stream Introduction to Code Stream The CI/CD process Integrate GitLab with Code Stream and Cloud Assembly Use Code Stream to install software Using Terraform Integrate Cloud Assembly with Terraform Use Terraform with a VMware Cloud Template Use Terraform with Code Stream Using Kubernetes Clusters Introduction to Kubernetes Connect to an existing Kubernetes Cluster Integrate VMware Tanzu? Grid Integrated Edition Create a Supervisor Namespace as a catalog item Using SaltStack for Configuration Management Introduction SaltStack with vRealize Automation Use SaltStack for software deployment Use SaltStack for configuration management Use SaltStack with event-driven orchestration vRealize Automation Troubleshooting and Integration Location of logs Using Activity Monitoring deployment history Basic troubleshooting CLI commands Collecting logs (VAMI console) Integration with VMware vRealize© Log Insight? Integration with vRealize Operations Migrating vRealize Automation 7.x to 8
Duration 2 Days 12 CPD hours This course is intended for This class assumes some prior experience with Git, plus basic coding or programming knowledge. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert team, students will explore: Getting Started with Collaboration Understanding the GitHub Flow Branching with Git Local Git Configuration Working Locally with Git Collaborating on Your Code Merging Pull Requests Viewing Local Project History Streaming Your Workflow with Aliases Workflow Review Project: GitHub Games Resolving Merge Conflicts Working with Multiple Conflicts Searching for Events in Your Code Reverting Commits Helpful Git Commands Viewing Local Changes Creating a New Local Repository Fixing Commit Mistakes Rewriting History with Git Reset Merge Strategies: Rebase This is a fast-paced hands-on course that provides you with a solid overview of Git and GitHub, the web-based version control repository hosting service. While the examples in this class are related to computer code, GitHub can be used for other content. It offers the complete distributed version control and source code management (SCM) functionality of Git as well as adding its own features. It provides access control and several collaboration features such as bug tracking, feature requests, task management, and wikis for every project. Getting Started with The GitHub Ecosystem What is Git? Exploring a GitHub Repository Using GitHub Issues Activity: Creating A GitHub Issue Using Markdown Understanding the GitHub Flow The Essential GitHub Workflow Branching with Git Branching Defined Activity: Creating a Branch with GitHub Introduction Class Diagram Interaction Diagrams Sequence Diagrams Communication Diagrams State Machine Diagrams Activity Diagram Implementation Diagrams Local Git Configuration Checking your Git version Git Configuration Levels Viewing your configurations Configuring your username and email Configuring autocrif Working Locally with Git Creating a Local copy of the repo Our favorite Git command: git status Using Branches locally Switching branches Activity: Creating a New File The Two Stage Commit Collaborating on Your Code Collaboration Pushing your changes to GitHub Activity: Creating a Pull Request Exploring a Pull Request Activity: Code Review Merging Pull Requests Merge Explained Merging Your Pull Request Updating Your Local Repository Cleaning Up the Unneeded Branches Viewing Local Project History Using Git Log Streaming Your Workflow with Aliases Creating Custom Aliases Workflow Review Project: GitHub Games User Accounts vs. Organization Accounts Introduction to GitHub Pages What is a Fork? Creating a Fork Workflow Review: Updating the README.md Resolving Merge Conflicts Local Merge Conflicts Working with Multiple Conflicts Remote Merge Conflicts Exploring Searching for Events in Your Code What is GitHub? What is Git bisect? Finding the bug in your project Reverting Commits How Commits are made Safe operations Reverting Commits Helpful Git Commands Moving and Renaming Files with Git Staging Hunks of Changes Viewing Local Changes Comparing changes with the Repository Creating a New Local Repository Initializing a new local repository Fixing Commit Mistakes Revising your last commit Rewriting History with Git Reset Understanding reset Reset Modes Reset Soft Reset Mixed Reset Hard Does gone really mean gone? Getting it Back You just want that one commit Oops, I didn?t mean to reset Merge Strategies: Rebase About Git rebase Understanding Git Merge Strategies Creating a Linear History Additional course details: Nexus Humans Introduction to GITHub for Developers (TTDV7551) 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 Introduction to GITHub for Developers (TTDV7551) 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.