92 SAP ABAP courses delivered Online

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.

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. 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 practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. ADVANCED QUERY TECHNIQUES * Join inner outer (Left, Right, Full) * Subqueries * Simple * Correlated * Using the Exists Operator * Tips for Developing Complex Queries * Performing Set Operations * Aggregating Results Using Group by * Creating Temporary Tables MANIPULATING TABLE DATA USING SQL'S DATA MANIPULATION LANGUAGE (DML) * Inserting Data into Tables * Updating Existing Data * Deleting Records * Truncating Tables * Implementing Data Integrity with Transactions * Beginning Explicit Transactions * Committing Transactions * Rolling Back Transactions USER-DEFINED FUNCTIONS * Definition and Benefits of Use * CREATE FUNCTION * Syntax * RETURN Clause and the RETURNS Statement * Scalar vs. Table Functions * Comparison with Stored Procedures * Returning Scalar Values and Tables ALTER and DROP FUNCTION STORED PROCEDURES * Definition and Benefits of Use * CREATE PROCEDURE * Syntax * Variables and Parameters * Control of Program Flow * ALTER and DROP PROCEDURE * Implementation Differences TRIGGERS * Definition and Benefits of Use * Alternatives (e.g., Constraints) * CREATE TRIGGER * Syntax * Trigger Types * 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables * Event Handling and Trigger Execution * ALTER and DROP TRIGGER ADDITIONAL COURSE DETAILS: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, and Business Process Owners/Team Leads/Power Users. Overview This course will prepare you to:Describe tasks performed by a typical SAP Access Control userDiscuss Harmonization topics as they relate to SAP Access ControlExplain how SAP GRC helps you to address business challengesIdentify authorization risks in typical business processesDescribe the Segregation of Duties Risk Management ProcessDescribe and configure functionality and features for SAP Access Control 10.1Use the SAP Access Control 10.1 application to analyze and manage risk, design and manage roles, and provision and manage usersDescribe the SAP Access Control 10.1 architecture and landscape, SAP Access Control Repository, and Object Level SecurityDescribe the Periodic Access Review processPlan for and manage emergency accessDiscuss the reporting frameworkConfigure workflows, including multi-stage multi-path (MSMP) workflows and BRF+Describe how the different applications of the SAP GRC Solution integrate with each otherDiscuss key steps in the SAP Access Control implementation process In this course, students gain hands-on configuration and implementation experience of SAP Access Control 10.1, as well as important concepts they will need to know in order to prepare for implementation and ongoing access risk prevention. INTRODUCTION TO SAP ACCESS CONTROL * Discussing Business Challenges and Solutions * Using SAP Access Control ARCHITECTURE, SECURITY, AND AUTHORIZATIONS * Describing the System Architecture * Describing Security and Authorizations SHARED CONFIGURATION SETTINGS * Configuring Shared GRC Settings * Configuring Shared SAP Access Control Settings AUTHORIZATION RISKS AND THE SEGREGATION OF DUTIES (SOD) MANAGEMENT PROCESS * Identifying Authorization Risks * Managing Risk by Segregating Duties SAP ACCESS CONTROL REPOSITORY * Synchronizing Objects into the Repository * Scheduling and Viewing Background Jobs RISK ANALYSIS * Maintaining Shared Master Data * Configuring and Maintaining the Rule Set * Configuring and Using Audit Trail Tracking * Using the Risk Analysis Framework * Remediating Risks * Mitigating Risks * Mitigating Multiple Risks at One Time BUSINESS RULE FRAMEWORK * Creating Rules in the Business Rule Framework (BRF) * Defining Business Rules MULTI-STAGE, MULTI-PATH (MSMP) WORKFLOW * Describing Multi-Stage, Multi-Path (MSMP) Workflow * Maintaining MSMP Workflow * Building MSMP Workflow USER PROVISIONING * Configuring User Provisioning Settings * Configuring Access Request Forms * Requesting Access * Preparing Roles and Owner Data for MSMP Workflow * Creating Simplified Access Requests * Reviewing Search Request Results SAP FIORI USER EXPERIENCE (UX) FOR GRC * Describing SAP Fiori UX ROLE DESIGN AND MANAGEMENT * Configuring Role Management * Configuring Role Methodology * Configuring Role Search Attributes * Planning for Technical Role Definition * Planning for Business Role Definition * Consolidating Roles Through Role Mining * Performing Role Mass Maintenance Operations EMERGENCY ACCESS MANAGEMENT * Describing Emergency Access Management * Planning for Emergency Access * Monitoring Emergency Access PERIODIC ACCESS REVIEW PROCESS * Planning Periodic Review * Monitoring Periodic Review REPORTS AND CUSTOM FIELDS * Use the Reporting Framework SAP ACCESS CONTROL IMPLEMENTATION * Using the SAP Access Control Implementation Process * Designing the SAP Access Control Solution * Planning Upgrade and Migration * Configuring SAP Access Control * Implementing the SAP Access Control solution * Optimizing the SAP Access Control Suite ADDITIONAL COURSE DETAILS: Nexus Humans GRC300 SAP Access Control Implementation and Configuration 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 GRC300 SAP Access Control Implementation and Configuration 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.

Duration 2 Days 12 CPD hours This course is intended for Application Consultant Business Process Architect Business Process Owner / Team Lead / Power User Developer Development Consultant Enterprise Architect Solution Architect System Architect Technology Consultant Overview This course will prepare you to: Get an overview about the workflow functions and functionality in SAP S/4HANA, S/4HANA Cloud and SAP Cloud Platform Explain the possible extensions of workflows in these technologies You want to learn about the workflow functionality in S/4HANA, S/4HANA Cloud and SAP Cloud Platform? This course provides a business overview of processes, which are working 'right out-of-the box'. It explains possible extensions and comes with several exercises to deepen the theoretical lessons. INTRODUCTION * Explain workflow @SAP and in SAP S/4HANA * Use SAP Fiori MY INBOX APP, SETUP AND CONFIGURATION * Explain the installation and set up of the My Inbox app * Access the My Inbox app * Add a BWF system as a task provider * Add a SAP BPM system as a task provider * Use roles for SAP Fiori * Define the gateway scenario and catalogs * Use the task gateway service * Perform further settings * Implement BADIs * Create dynamic columns for SWF_USER_ATTR * Create push notifications for the SAP Fiori Launchpad FLEXIBLE WORKFLOW * Explain Flexible Workflow * Use a Workflow Scenario * Explain SAP S/4HANA Cloud workflow * Responsibility Management SAP CLOUD PLATFORM WORKFLOW SERVICE * Use SAP Cloud Platform Workflow for workflow application development STRATEGY RECOMMENDATIONS AND MIGRATION OPTIONS * Discuss strategy recommendations for enterprise workflow with SAP * Discuss migration options for existing workflows ADDITIONAL COURSE DETAILS: Nexus Humans BIT602 SAP Workflow with SAP Fiori 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 BIT602 SAP Workflow with SAP Fiori 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.

Duration 5 Days 30 CPD hours This course is intended for Database Administrator Help Desk/CoE Support System Administrator Technology Consultant Overview This course will prepare you to: Install and update an SAP HANA 2.0 SPS04 database Installation and configuration of SAP HANA cockpit 2.0 SP10 Perform the SAP HANA system administration tasks using SAP HANA cockpit 2.0 SP10 in a multitenant database environment Start and stop, change the configuration, backup and troubleshoot an SAP HANA 2.0 SPS04 database Backup and recover a multitenant SAP HANA 2.0 SPS04 database This course covers in detail all key capabilities of SAP HANA database system administration. Through the lectures and exercises you will learn how to install, update and operate an SAP HANA 2.0 SPS04 database using SAP HANA Cockpit 2.0 SP10. The course covers the most important database administration tasks of an SAP HANA system administrator. During the course, you will learn details about starting and stopping, changing the configuration parameters, monitoring the database, backup and recovery and troubleshoot of a multitenant SAP HANA 2.0 SPS04 database system. COURSE OUTLINE * This course is the best starting point to learn about SAP HANA installation, update, configuration and system administration * The course is independent from the SAP NetWeaver administration world, as it teaches how to perform system administration on the SAP HANA platform. The system administration tools used are native to the SAP HANA platform * At the end, you will be able to perform all the required daily system administration tasks on the SAP HANA database platform THROUGHOUT THE COURSE, YOU WILL LEARN ABOUT THE FOLLOWING SAP HANA TOOLS FOR INSTALLATION, UPDATE, CONFIGURATION AND SYSTEM ADMINISTRATION * SAP HANA database lifecycle manager (HDBLCM) * SAP HANA cockpit 2.0 SP10 * SAP HANA HDBSQL command line CONTENTS * SAP HANA introduction * Installation sizing and OS preparations * SAP HANA installation and upgrade of a multitenant database * SAP HANA architecture and deployment options * SAP HANA cockpit 2.0 installation and configuration * SAP HANA Administration tools * Post installation steps * Database administration tasks using SAP HANA cockpit 2.0 * Backup and recovery using SAP HANA cockpit 2.0 * SAP HANA Security * User and authorizations

Duration 2 Days 12 CPD hours This course is intended for Database Administrator Help Desk/CoE Support System Administrator Technology Consultant Overview This course will prepare you to: Use the SAP HANA cockpit to perform emergency trouble shooting, the SAP HANA traces to investigate for costly statements and to setup SAP HANA Workload Management and SAP HANA Capture and Replay tools. In this course, students will learn how to describe the methods and the tools needed for analyzing performance issues in SAP HANA. EMERGENCY ANALYSIS AND TROUBLESHOOTING USING SAP HANA COCKPIT 2.0 SP10 * Handling System Offline Situations * Handling System Hanging but Reachable Situations * Analyzing a Suddenly Slow System STRUCTURAL SYSTEM PERFORMANCE ROOT CAUSE ANALYSIS * Analyzing Memory Issues * Analyzing CPU Issues * Analyzing Expensive Statements Issues * Analyzing Disk and I/O Issues PROACTIVE MONITORING AND PERFORMANCE SAFEGUARDING * Configuring SAP HANA Alerting Framework * Setting up SAP HANA Workload Management * Using SAP HANA Capture and Replay ADDITIONAL COURSE DETAILS: Nexus Humans SAP HANA 2.0 SPS04 - Using Monitoring and Performance Tools 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 SAP HANA 2.0 SPS04 - Using Monitoring and Performance Tools 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.

Duration 3 Days 18 CPD hours This course is intended for Security administrators, developers, developer consultants, system administrators, and technology consultants. Overview This training course will focus on the authorization, security, and integrated scenario. In this course, students will focus on the authorization, security, and integrated scenarios for SAP HANA. MODULE 1 * Creation of authorizations and authorization roles MODULE 2 * User management MODULE 3 * Access control for HANA native models MODULE 4 * Authorization trace MODULE 5 * Auditing MODULE 6 * Authentication and single sign-on options MODULE 7 * Encryption options MODULE 8 * Security considerations for Multitenant Database Containers MODULE 9 * SAP GRC Integration for Governance Risk and Compliance MODULE 10 * HANA use case scenarios and security requirements MODULE 11 * SAP Netweaver Identity Management integration MODULE 12 * Reusing of BW authorizations for SAP HANA applications MODULE 13 * HANA Cloud Platform (HCP) security MODULE 14 * HANA Enterprise Cloud security

Duration 3 Days 18 CPD hours This course is intended for All persons interested in getting an overview of SAP?s Business Suite solutions. Overview Identify SAP Applications and ComponentsExplain basic functionality of SAP SolutionsAttend more detailed SAP courses and have the required baseline knowledge In this course, students identify SAP applications and components, as well as learn how to explain basic functionality of SAP Solutions. SAP - A CLOUD COMPANY * Identifying SAP Applications and Components * Outline the Functionality of SAP Cloud-Enabling Applications OUTLINING NEW SAP FUNCTIONALITY * Outline the usage and functionality of SAP HANA * Outline the usage and functionality of Cloud for Customer * Describe the various aspects of SAP User Experience SAP SYSTEM NAVIGATION * Accessing the SAP System * Personalizing the User Interface SYSTEM-WIDE CONCEPTS * Identifying SAP Organizational and Master Data Elements LOGISTICS * Creating a Purchase Order for Materials * Using Supplier Relationship Management (SRM) for Procurement and Sourcing Processes * Integrating Ariba Functionality with Procurement in SAP Enterprise Resource Planning (ERP) * Creating a Planned Order * Processing Production Orders * Using Supply Chain Management (SCM) to Manage Supply and Demand * Creating Sales Orders * Creating a Delivery and Posting a Goods Issue * Creating Sales Order Billing Documents * Using Customer Relationship Management (CRM) * Using Product Lifecycle Management (PLM) FINANCIALS * Identifying Financial Accounting Processes * Using Financial Add-Ons for SAP Business Suite * Creating a Journal Entry in the General Ledger * Outlining the Outbound Payments Process in Accounts Payable * Generating Financial Statements * Outlining the Inbound Process in Accounts Receivable * Outlining the Business Processes in Fixed Assets Accounting * Analyzing Internal Costs in Management Accounting * Monitoring Manufacturing Costs * Analyzing Profitability HUMAN CAPITAL MANAGEMENT (HCM) * Identifying the Components of SAP Enterprise Resource Planning (ERP) HCM * Outlining the HR Renewal Functionality * Integrating SuccessFactors in the Cloud ANALYTICS AND STRATEGIC PLANNING * Executing Analytics and Strategic Planning Reports SAP SERVICES * Accessing SAP Services

Duration 3 Days 18 CPD hours This course is intended for Project team members and Key-Users responsible for the maintenance of Execution Steps for process orders and production orders to generate interactive PI Sheets and work instructions for operators and workers in the production plant and to realize the data exchange with the automation and process control world. In this course, students will attain the ability to maintain Execution Steps for process orders and production orders to generate interactive PI sheets and work instructions. COURSE OUTLINE * Process management / process integration * Control recipes / control instructions * XSteps * Process messages * Customizing

Duration 4 Days 24 CPD hours This course is intended for This course is for consultants, project team members, and administrators who want to learn how to implement data provisioning and data transformation for their SAP HANA project. In this course, students will learn the essential techniques and tools of data provisioning and data transformation for SAP HANA. This course will help students identify the most effective data provisioning solutions for their SAP HANA project. COURSE OUTLINE * Trigger-based replication with SAP Landscape Transformation * ETL based data provisioning using SAP Data Services * Connecting SAP HANA to data sources using SAP HANA Smart Data Access * Real-time data loading using Smart Data Streaming * ETL based loading using Smart Data Integration and Smart Data Quality * SAP HANA Direct Extractor Connection * Fundamentals of SAP Replication Server ADDITIONAL COURSE DETAILS: Nexus Humans HA350 SAP HANA - Data Management 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 HA350 SAP HANA - Data Management 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.