6193 Courses

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students looking to establish a foundational understanding of Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. Overview In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports. Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft© Access© can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access. Microsoft© Access© for Office 365?: Part 1 (this course): Focuses on the design and construction of an Access database?viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. Microsoft© Access© for Office 365?: Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports. Microsoft© Access© for Office 365?: Part 3 : Focuses on managing the database and supporting complex database designs, including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database. This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. Lesson 1: Working with an Access Database Topic A: Launch Access and Open a Database Topic B: Use Tables to Store Data Topic C: Use Queries to Combine, Find, Filter, and Sort Data Topic D: Use Forms to View, Add, and Update Data Topic E: Use Reports to Present Data Topic F: Get Help and Configure Options in Access Lesson 2: Creating Tables Topic A: Plan an Access Database Topic B: Start a New Access Database Topic C: Create a New Table Topic D: Establish Table Relationships Lesson 3: Creating Queries Topic A: Create Basic Queries Topic B: Add Calculated Columns in a Query Topic C: Sort and Filter Data in a Query Lesson 4: Creating Forms Topic A: Start a New Form Topic B: Enhance a Form Lesson 5: Creating Reports Topic A: Start a New Report Topic B: Enhance Report Layout Additional course details: Nexus Humans Microsoft Access for Office 365: Part 1 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 Microsoft Access for Office 365: Part 1 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 This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES

Duration 3 Days 18 CPD hours This course is intended for Application Consultant Business Analyst Business Process Architect Business Process Owner / Team Lead / Power User Overview Describe and execute business processes in SAP S/4HANA aATP Through instructor lectures and demonstrations balanced with extensive system exercises you will gain a thorough understanding of how aATP can support your logistics processes. This course provides fundamental training regarding availability check in SAP S/4HANA. The availability check in S/4HANA Fundamentals of ATP-check during sales order processing Checking Methods in Detail (Planning Strategies and Requirement Classes, ATP-Check and Scheduling) Backorder Processing in S/4HANA Advanced Available-to-Promise (aATP) in S/4HANA Overview of the basic aATP process in S/4HANA Advanced Available-to-Promise aATP and Allocation: Single and multiple allocation checks, using manage Characteristic catalog Introducing Release for Delivery Fundamentals of Alternative-based-Confirmation Backorder Processing with aATP in S/4HANA Additional course details: Nexus Humans S4270 Advanced Available-to-Promise in SAP S/4HANA 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 S4270 Advanced Available-to-Promise in SAP S/4HANA 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 Project Team Members IT Support Team Members Advanced Business Analysts System Administrators Application Consultants Business Process Owners / Team Leads / Power Users Program / Project Managers Trainers Overview Learn how to design, configure, consolidate, and report with BPC Standard In this course, students learn all of the key steps to set up Consolidation based on the SAP Business Planning and Consolidation, version for SAP NetWeaver. SAP Business Planning and Consolidation Overview Describing SAP Business Planning and Consolidation Running Consolidation Tasks Implementing BPC Standard Consolidation Modeling Consolidation Structures and Reporting Configuring Environments and Dimensions Creating Models for Consolidation Creating Reports and Formats in the EPM Add-In Report on BPC Standard Data in Analysis for Office Data Collection and Preparation Collecting Transforming Data for Consolidation Scenarios Creating Consolidation Logic Configuring Reclassifications Configuring Balance Carryforward Managing Journals Consolidations and Eliminations Translating Local Currency Configuring Intercompany Matching and Booking Using the Ownership Manager Configuring Integration Rules Eliminating Intercompany Transactions Configuring Intercompany US Elimination Designing Management, Matrix, and Multiple Accounting Standard Solutions Describing Consolidation and Elimination Principles Consolidating Investments Describing Stage Consolidation Configuring Scope Variation Configuring Equity Pickup Consolidation Process Monitoring Configuring Work Status Using the Controls Monitor to Validate Data Configuring Consolidation Business Process Flows

Duration 1 Days 6 CPD hours This course is intended for Experienced universe designers upgrading from a previous version of SAP BusinessObjects Designer to SAP BusinessObjects Information Design Tool 4.1. NOTE: This workshop is not designed for users new to the tool. In this course, participants will gain an understanding of the Delta between Universe Design and the Information Design Tool. Course Outline New File extension Universe components -Projects -Connections -Data foundation -Business Layer Universe Testing Lists of Values Parameters @Execute function Calculated Columns Multisource universe Federated Tables Additional course details: Nexus Humans WNAI41 SAP Information Design Tool Delta 4.1 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 WNAI41 SAP Information Design Tool Delta 4.1 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 Application Consultant Business Analyst Business Process Architect Business Process Owner / Team Lead / Power User Data Consultant / Manager Help Desk / COE Support Program / Project Manager Solution Architect System Architect Technology Consultant Trainer Overview Please refer to overview This course will provide you with a deep understanding of the production planning process, how to configure it, and how to apply the concepts of demand management and material requirements planning in SAP S4/HANA. SAP S/4HANA Production Planning Overview Outlining Production Planning in SAP S/4HANA Considering Prerequisites for Production Planning in SAP S/4HANA Master Data for SAP S/4HANA Production Planning Outlining Master Data for SAP S/4HANA Production Planning Prerequisites and Tools for Advanced Planning in SAP S/4HANA Outlining Advanced Planning: PP/DS in SAP S/4HANA Reviewing Master Data for Advanced Planning Activating Advanced Planning Evaluating Alerts with the Alert Monitor Planning Production with the Product View Demand Management in SAP S/4HANA with Planning Strategies Applying Planning Strategies for Make-to-Order Production Applying Planning Strategies for Make-to-Stock Production Advanced Production Planning in SAP S/4HANA Exploring Steps in PP/DS Material Requirements Planning Exploring Heuristics and Functions in PP/DS Applying the PP/DS Planning Run Detailed Scheduling in SAP S/4HANA Exploring Concepts and Principles for Detailed Scheduling Applying transactional Tools for Detailed Scheduling Applying Apps for Detailed Scheduling Using Detailed Scheduling in the Planning Run Using the PP/DS Optimizer Additional course details: Nexus Humans S4220 SAP Production Planning in SAP S/4HANA 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 S4220 SAP Production Planning in SAP S/4HANA 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.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that poor communication costs UK businesses an estimated £40 billion a year? Struggling to get your point across or misread body language can lead to misunderstandings, missed deadlines, and frustrated colleagues. Effective communication is the key to a successful career - are you ready to unlock your potential? This comprehensive bundle equips you with the skills you need to become a powerful communicator in any workplace setting. You'll learn effective communication strategies for different situations, from giving clear presentations to delivering constructive feedback. Discover the secrets of nonverbal communication, understand how to build rapport with colleagues, and gain the confidence to lead and manage teams effectively. Our Bundle contains 5 of our premium courses for one discounted price: Course 01: Workplace Communication Management Course 02: Communication Skills Course 03: Business Communication Course 04: The Secrets of Body Language Course 05: Leadership & Management Invest in your future and gain a competitive edge by mastering productive communication strategies, building stronger professional relationships, and contributing to a more collaborative and successful work environment. Enrol Today! Learning Outcomes of Productive Communication Develop strategies for effective workplace communication management. Enhance verbal, non-verbal, and written communication skills. Apply business communication best practices in professional settings. Interpret and utilize body language effectively in communication. Implement leadership and management principles for clear communication. Foster a productive and collaborative work environment through communication. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Productive Communication Get a free student ID card with Productive Communication Training program (£10 postal charge will be applicable for international delivery) The Productive Communication is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Productive Communication course materials The Productive Communication comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Workplace Communication Management Module 01: Information And Communication For Stakeholders Module 02: Communication & Barriers Module 03: Culture And Communication In The Workplace Module 04: Language And Effective Communication Module 05: Business Communication & Interpersonal Relationships Module 06: Communication Improvement At Workplace Course 02: Communication Skills Module 01: Effective Communication Module 02: How to Talk to Anyone Module 03: Power of Storytelling Module 04: Becoming an Influencer Module 05: Importance of Body Language Module 06: Communication Skills for Job Interviews Module 07: Public Speaking Course 03: Business Communication Business Communication Verbal And Non-Verbal Communication Written Communication Electronic Communication Communicating With Graphics Effectively Working For Your Boss =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Managers and team leaders. Business professionals and executives. Human resources and training professionals. Aspiring leaders and communicators. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Communication Manager Corporate Trainer Public Speaker Leadership Coach Business Consultant HR Professional Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

SAP Training: Overview What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Business Cases/ Live Project Our SAP training courses are designed in a way which gives the students maximum exposure of real-life scenario through no of business cases and guidance on implementation by professional SAP Consultants. You receive a certificate once you finish the course from Osborne Training. SAP Certification During the training, you get access to Sap sandbox which continues even after training finishes until the completion of the Internship. You can also do an external exam to receive certification from SAP (Optional), for details on exam booking you may visit the SAP website. SAP Training Modules Available Financial & Controlling (FICO) High-Performance Analytic Appliance (HANA) Supply Relationship Management (SRM) Customer Relationship Management (CRM)

SAP Training London: Overview What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Business Cases/ Live Project Our SAP training courses are designed in a way which gives the students maximum exposure of real-life scenario through no of business cases and guidance on implementation by professional SAP Consultants. Free SAP Access Free SAP Sandbox Access provided for 6 months so that you can practice even after your SAP training course. Certificate of Attendance- You receive a certificate once you finish the course from Osborne Training,  You can also do an external exam to receive certification from SAP (Optional), for details on exam booking you may visit the SAP website. SAP Training Modules Available Financial & Controlling (FICO) High-Performance Analytic Appliance (HANA) Supply Relationship Management (SRM) Customer Relationship Management (CRM)

SAP CRM Training Online SAP CRM (Customer Relationship Management) module empowers you to manage all of your customer-related data and contacts. In SAP CRM training course you will learn how to leverage functionality for the full spectrum of CRM processes including sales, service, marketing, and operations. Powered with an understanding and knowledge of the comprehensive functionality in SAP CRM, you can easily manage the entire customer life cycle efficiently and intelligently. SAP CRM is one of the significant part of SAP Business Suite to manage customer relationship. It supports all customer-focused business areas such as marketing, sales and service. A component of SAP CRM, CRM Analytics, enables organizations to gather all relevant information about various key factors such as a customer and analyse the knowledge base to incorporate insights into operational processes and helps in strategic decision-making. SAP CRM Basic Functions and Master Data SAP CRM Sales, Marketing, Services and Middleware SAP CRM WORKSHOP/Project orientation Training