3417 Office Skills & Productivity courses in Bushey delivered Online

Duration 3 Days 18 CPD hours This course is intended for Technology Consultant System Administrator Application Consultant Overview This course will prepare you to: Set up SLT configurations, replicate data into different targets (such as SAP HANA, SAP BW or Central Finance) and monitor the data replication. In this course, you will learn how to use the trigger based real time data replication technology of the SAP LT Replication Server (SLT). SAP Landscape Replication Server Overview Explaining Positioning and Key Concepts Identifying Use Cases Understanding SLT as Part of the DMIS Product Family SAP Landscape Transformation Server Introduction Understanding the Architectural Concept Explaining the Landscape Strategy and Sizing Aspects Outlining the SLT Installation Procedure Replication to SAP HANA Setting Up Data Replication Executing Data Replication Understanding Advanced Replication Settings Outlining Operations and Monitoring Describing SLT Handling in Special Cases Replication to SAP BW Providing a Scenario Overview Explaining Open Data Provisioning (ODP) Describing Table-Based Replication Comparing Table-Based Replication and ODP Replication to SAP Data Services Explaining SAP Data Services and Architecture Describing the Setup of Replication to SAP Data Services Replication to ABAP Systems Describing the Architecture for Replication into an ABAP System Outlining the Setup for Replication into an ABAP System Replication to Non-SAP Databases Describing the Architecture for Replication to Non-SAP Databases Understanding the Setup of ABAP to Non-ABAP Replication Replication to Central Finance Describing the Architecture for Replication to Central Finance Understanding the Setup and Configuration of Replication to Central Finance SAP Landscape Transformation Replication Server Summary Providing a Summary of the SAP Landscape Transformation Replication Server SAP Landscape Transformation Replication Server 3.0 and Recent Updates Outlining SAP Landscape Transformation Replication Server 3 Updates Additional course details: Nexus Humans SAP Real-time Replication with SAP LT Replication Server (SLT100) 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 Real-time Replication with SAP LT Replication Server (SLT100) 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 consultants, Business Analysts, Executives, Technology Consultants, Users Overview By the end of this course, students will be able to:Explain SAP LumiraCreate documents and acquire dataPrepare datasetsVisualize dataShare stories In this course, students will learn how to create stunning and interactive visualizations by choosing a rich library of visualization types, ranging from scatter plots, heat and geo maps to tag clouds, box plots and network charts. Course Outline Positioning and Overview of SAP Lumira Discovery Navigating the BI Launchpad Acquiring Data Enrich the Dataset Create Visualizations Create a Story Sharing Options Using the Lumira Discovery Formula Editor Additional Data Sources Data Mashups

Duration 5 Days 30 CPD hours This course is intended for This course is recommended for application or system support personnel or anyone who needs an overview of the capabilities of HP UD 10.1x. Overview Upon successful completion of this course, you should be able to: Identify the evolution of the Configuration Management System (CMS) from the Configuration Management Database (CMDB), the need for CMS, and working of CMS Define the concept of Universal Discovery (UD) and be able to identify its applications and types Identify the architecture and deployment process of UD, and the installation and setup of the data flow probe and its log files Define the concepts of discovery adapters, discovery jobs, discovery scripts, and other discovery resources Use the Universal Discovery module to perform application dependency mapping discovery and inventory discovery Use zone-based discover method and discovery activities Design and build agentless and agent-based discoveries, and use inventory scanners Work with the Software Library Viewer and various inventory tools Use the application recognition process, and discovery rules HP This course is designed to provide an understanding of the fundamental concepts and applications of the HP Universal Discovery (UD) solution. This course is designed to provide an understanding of the fundamental concepts and applications of the HP Universal Discovery (UD) solution.

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course are Technology Consultants, System Administrators, System Architects, Database Administrators, Help Desk/COE Support, and Program/Project Managers. Overview Presentation in detail of the architecture of SAP NetWeaver Application Server (SAP NetWeaver AS).Learn effective techniques for navigating.Receive an overview of the development process in an SAP system landscape In this course, students gain knowledge about the fundamentals of SAP NetWeaver Application Server. SAP Systems Explaining the Key Capabilities of SAP NetWeaver Explaining the Architecture of an SAP System, Application Server (AS) ABAP and Application Server (AS) Java Navigation Basics Navigating with SAP Graphical User Interface (GUI) for Windows in AS ABAP Systems Navigating with a Browser in AS Java Systems System Core Explaining AS ABAP and AS Java System Architecture Identifying the Processes of an AS ABAP System Processing User Requests in AS ABAP Using Additional Processes of an AS ABAP System Explaining the Processes of an AS Java System Software Development in SAP Systems Outlining the Data Structure of an AS ABAP System Managing Transports in the ABAP Environment Explaining ABAP Workbench Tools Developing and Transporting an ABAP Repository Object Developing Applications in AS Java Developing Applications in Eclipse for ABAP Communication and Integration Technologies Describing Communication with Remote Function Call-Based (RFC) Technology Describing the Basics of Web Services Describing OData in SAP Gateway Application Lifecycle Management (ALM) Explaining Application Lifecycle Management (ALM) Describing the Installation of an SAP System Describing the Maintenance of an SAP System SAP Portfolio Overview Identifying the Platform, Database, and User Experience in the SAP Technology Portfolio Outlining Additional Components of the SAP Technology Portfolio Identifying the Components of the SAP Applications Portfolio SAP User Interfaces Accessing AS ABAP Systems with SAP GUI Accessing SAP Systems Using Other User Interfaces Additional Information Sources Accessing the SAP Service Marketplace (SMP) Accessing the SAP Community Network (SCN)

Duration 5 Days 30 CPD hours This course is intended for Implementer Overview Enrolling in this course will help you better understand and leverage PeopleSoft Payroll for North America (USA) payroll requirements and processes. This knowledge will help you create, adjust and troubleshoot your organization's employee payroll. Learn Off-Cycle Payroll Events In addition to typical on-cycle payroll processing, Payroll for North America provides functionality for a variety of off-cycle payroll events and other payroll requirements. This course will illustrate how to reverse a paycheck, record a manual check, produce online checks and final checks and create a gross up check. In addition, you'll also learn the necessary steps to set up and process mid-period job changes and multiple jobs. Finally, you'll set up and processes benefit deductions and garnishments. This PeopleSoft Payroll - US Rel 9.2 training teaches you how to set up and maintain employee tax data, additional pay, general deductions and direct deposits. Expert Oracle University instructors will show you how to use this solution to calculate payroll, review calculation results, identify and correct errors, confirm payroll and more. Setting Up PeopleSoft HRMS Tables for Payroll Processing Identifying HRMS Tables That Impact Payroll Processing Describing Installation Table Setup for PeopleSoft Enterprise Payroll for North America Describing the Role of SetID, Location, and Department in Payroll Processing Describing Company Table Setup Desc Setting Up Payroll Tables Identifying Payroll Setup Tables Setting Up Source Bank Accounts Creating Special Accumulators Setting Up Earnings Codes Setting Up Earnings Programs Describing Shift Pay Setup Creating a Pay Group Creating a Rate Code Setting Up U.S. Payroll Tax Tables Identifying Tax Table Maintenance Responsibility Describing PeopleSoft-Maintained Tax Tables Setting Up Customer-Maintained Tax Tables Setting Up Employee Data Identifying Sources of Employee Data Setting Up an Employee Instance Entering and Viewing Employee Job Data Identifying Employee Pay Data Updating Employee Tax Data Assigning Additional Pay to Employees Assigning General Deductions to Employees Updating P Creating and Updating Paysheets Describing Paysheets in Payroll for North America Describing Balance ID Creation Creating Pay Calendars Setting Up Pay Run IDs Creating Paysheets Viewing and Updating Paysheets and Paylines Describing the Payroll Unsheet Process Calculating Payroll Describing Payroll Calculation Running Preliminary Payroll Calculation Running Final Payroll Calculation Confirming Payroll and Producing Checks and Reports Confirming a Payroll Viewing Confirmed Payroll Results Online Printing Checks and Advices Describing Check Reprinting Describing Direct Deposit Transmittals and Reports Describing Payroll and Tax Reports Identifying Methods of Reversing Payroll Confirmati Processing Off-Cycle Payrolls Identifying Off-Cycle Payroll Processing Reversing a Paycheck Describing Reversal/Adjustment Processing Recording a Manual Check Producing an Online Check Describing Retroactive Processing Setting Up and Processing Additional Payroll Functionality Setting Up a Holiday Schedule Setting Up Advanced Earnings Options Setting Up Multiple Jobs Processing Setting Up and Processing Mid-period Job Changes Processing Gross Ups Setting Up and Processing Benefit Deductions in Payroll Setting Up Deductions and Earnings for Benefits Calculations Updating a Benefit Program and Enrolling Employees Analyzing Benefits-Related Payroll Reports Setting Up and Processing Garnishments Identifying Garnishment Setup Steps Describing PeopleSoft-Maintained Garnishment Tables Setting Up Company-Level Tables for Garnishment Processing Assigning an Employee Garnishment Deduction Setting Up Employee Garnishment Specification Data Reviewing Emp Describing PeopleSoft Enterprise ePay Identifying HRMS Tables That Impact Payroll Processing Describing Installation Table Setup for PeopleSoft Enterprise Payroll for North America Describing the Role of SetID, Location, and Department in Payroll Processing Describing Company Table Setup Desc

Duration 3 Days 18 CPD hours This course is intended for Database Administrator Enterprise Architect System Administrator System Architect Technology Consultant Overview This course will prepare you to: Understand the concepts of SAP BTP Understand the tasks of an SAP BTP administrator Administrate accounts, services, and users in SAP BTP Manage connections, databases, and monitoring in SAP BTP This course will prepare you to:Understand the concepts of SAP BTPUnderstand the tasks of an SAP BTP administratorAdministrate accounts, services, and users in SAP BTPManage connections, databases, and monitoring in SAP BTP SAP Strategy RISE with SAP and Intelligent, Sustainable Enterprise SAP BTP Use Cases Architectures Account Model and Services ABAP, Cloud Foundry, and Kyma Runtime Environments Cloud Development Concept Configuration Discovery Center and Boosters Command Line Interface Connectivity Destinations Cloud Connector User Management Account User Management SAP Cloud Identity Services Database Offerings SAP HANA Cloud Application Lifecycle Management Product Portfolio Monitoring SAP Application Logging Service SAP Cloud ALM Interface Channel SAP Cloud Transport Management Service SAP Cloud Transport Management Service Additional course details: Nexus Humans Introduction to SAP Business Technology Platform (BTP) Administration 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 SAP Business Technology Platform (BTP) Administration 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 System Security Administrator Security Architect Technology Consultant Overview This course will prepare you to Understand SAP Security fundamentals Get an overview of the main SAP concepts for security Be prepared to learn more in detail about each SAP concept for security This course will prepare you to Understand SAP Security fundamentals. Get an overview of the main SAP concepts for security. Be prepared to learn more in detail about each SAP concept for security. SAP Access Governance and Control Overview of Security Fundamentals Introduction to SAP Access Governance SAP NetWeaver Application Security Overview Describe SAP User Experience Explain Basic User Administration for AS ABAP Explain Basic Role Administration for AS ABAP Describe SAP Fiori Catalog and Group Administration Concept Describe AS JAVA Security Discuss Custom Development and Security SAP Access Governance and Compliance Describe SAP Access Governance Explain SAP GRC Access Control Describe SAP Identity Management Describe SAP Cloud Identity Access Governance Infrastructure Security Explaining Network Topology Enabling Secure Network Communication (SNC) Enabling Secure Sockets Layer (SSL) Implementing Single Sign-On (SSO) in SAP Systems Security Monitoring with SAP Solution Manager Monitoring Security with SAP Solution Manager SAP Data Privacy Governance and Cybersecurity Introduce EU General Data Privacy Regulation (GDPR) Discuss SAP Support for GDPR Compliance Additional course details: Nexus Humans SAP System Security Fundamentals 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 System Security Fundamentals 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 and system administrators Overview Manage physical data replacement and storageCreate, backup and restore databasesCreate and manage multiple temporary databases In this course, students learn how to manage physical data replacement and storage, create, backup and restore databases, and create and manage multiple temporary databases. SAP Adaptive Server Enterprise (ASE) Explaining SAP ASE Describing the Database Architecture Using Query Editors Installation Installing Servers Identifying Installation Parameters Starting and Stopping SAP ASE Connecting Clients to the Server Database Server Configuration Explaining the Server Configuration File Modifying the Server Configuration File Explaining Memory Mechanisms Configuring Memory Configuring the Size of Caches Space Management Creating Devices Managing Devices Mirroring Devices Creating Databases Managing Databases Managing Disk Resources Managing Temporary Databases Security Managing Roles Creating Logins Managing Logins Managing Database Users Managing Creation Permissions Managing Object Permissions Creating Groups Creating Roles Maintenance Using SAP ASE Extraction Utilities Using the Bulk Copy Utility Explaining Automatic Recovery Ensuring Database Consistency Setting Up the High Speed Consistency Checker Backup Planning for Backups Executing Database Backups Restoring Database Backups Performing Transaction Log Backups Using Advanced Backup Techniques Monitoring Using SAP DB Control Center Monitoring SAP ASE Additional course details: Nexus Humans EDB358 SAP System and Database Administration - Adaptive Server Enterprise 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 EDB358 SAP System and Database Administration - Adaptive Server Enterprise 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.

Course Overview The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this Microsoft SQL Server Development course and boost the quality of your software. This Microsoft SQL Server Development course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management. Learning Outcomes Learn how to use Microsoft SQL management studio Familiarize with basic database design Learn how you can use select statements Be able to insert delete or update data into data tables Learn about the best practices for database development Create relationships among multiple tables Learn how you can use foreign keys Be able to create Complex database objects Understand how to backup and restore database Who is this course for? This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your Microsoft SQL server development. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Microsoft SQL Server Development is a useful qualification to possess and would be beneficial for any related profession or industry such as: Software Engineer Web Developers Data Security Officers Database Administrators Database Developers Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Azure is a cloud computing service formerly known as Windows Azure. This cloud computing service is a big part of Microsoft's business, and it competes with similar services from Amazon and Google. With this diploma in Microsoft Azure 2017 course, get a chance to learn about the fundamentals of working in a Microsoft Azure environment to help improve your business. This course will help you get started with Microsoft Azure technologies such as virtual machines, networking, identity, storage and infrastructure. You will get to learn how Microsoft Azure can help you build and manage your business's applications and cloud services and help improve overall business productivity. So why wait? Join this course now! Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Diploma in Microsoft Azure 2017 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Diploma in Microsoft Azure 2017 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Azure 2017 Hello Azure FREE 00:23:00 Subscriptions 00:16:00 Management Portals 00:33:00 App Service 00:22:00 App Settings 00:12:00 Hosting Plans 00:19:00 Deployments 00:22:00 Monitoring 00:15:00 Application Insights 00:25:00 Debugging Part 00:23:00 Function Apps 00:37:00 DevOps 101 00:12:00 Work Backlog 00:19:00 Code 00:12:00 Build 00:10:00 Release 00:12:00 Testing 00:06:00 Mock Exam Mock Exam- Diploma in Microsoft Azure 2017 00:20:00 Final Exam Final Exam- Diploma in Microsoft Azure 2017 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00