3466 Office Skills & Productivity courses in Godalming delivered Online

From business to research, having a solid grasp of Excel Data analysis can open doors of opportunity in various industries. Learn this valuable skill set from the comfort of your home with the Data Analysis In Excel course. This course will introduce you to the ins and outs of Excel data analysis. This Data Analysis In Excel course will help you establish a solid foundation in Excel data analysis. This course will help you pick up the skills to visualise data with charts in Excel. Here, you will also learn about Pivot Tables and Charts. Furthermore, the course will teach you how to work with multiple Workbooks. In addition, you will learn about Lookup factions and how to use them. By the end of this course, you will know the essentials of automating Workbook functionality. This course will assist you in securing effective data analysis skills. In addition, you will receive a QLS-endorsed certificate of achievement. This certificate will enhance your employability in the relevant job market. Join now!  Learning Outcomes Understand the basic principles of data analysis with Excel Learn how to visualise data with Excel charts Build your expertise in using Pivot Tables and Charts Grasp the techniques of working with multiple Worksheets and Workbooks Know the process of automating Workbook functionality Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £99. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Research Assistant Researcher Business Analyst

Are you looking to enhance your Data Analysis with Excel skills? If yes, then you have come to the right place. Our comprehensive course on Data Analysis with Excel will assist you in producing the best possible outcome by mastering the Data Analysis with Excel skills. The Data Analysis with Excel is for those who want to be successful. In the Data Analysis with Excel, you will learn the essential knowledge needed to become well versed in Data Analysis with Excel. Our Data Analysis with Excel starts with the basics of Data Analysis with Excel and gradually progresses towards advanced topics. Therefore, each lesson of this Data Analysis with Excel is intuitive and easy to understand. Why would you choose the Data Analysis with Excel from Compliance Central: Lifetime access to Data Analysis with Excel materials Full tutor support is available from Monday to Friday with the Data Analysis with Excel Learn Data Analysis with Excel skills at your own pace from the comfort of your home Gain a complete understanding of Data Analysis with Excel Accessible, informative Data Analysis with Excel learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Data Analysis with Excel bundle Study Data Analysis with Excel in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Data Analysis with Excel Improve your chance of gaining in demand skills and better earning potential by completing the Data Analysis with Excel Data Analysis with Excel Curriculum Breakdown of the Data Analysis with Excel Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Data Analysis with Excel helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Data Analysis with Excel. It is also great for professionals who are already working in Data Analysis with Excel and want to get promoted at work. Requirements To enrol in this Data Analysis with Excel, all you need is a basic understanding of the English Language and an internet connection. Career path The Data Analysis with Excel will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Data Analysis with Excel. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

***Want to Unlock the Secrets of Data? Become a Database Mastermind!*** The world runs on data, and Database Administrators (DBAs) are the heroes behind the scenes ensuring its smooth operation. Database administrators in the UK are in high demand, with an average salary of £41,501 per year. The job market is expected to grow by 9% in the next few years, so now is a great time to start a career as a database administrator. As a database administrator, you will be responsible for the design, implementation, and maintenance of databases. You will also be responsible for ensuring the security and integrity of the data. If you are interested in a challenging and rewarding career in technology, then database administration is a great option for you. Our Database Administrator course starts with the basics of Database Administrator and gradually progresses towards advanced topics. Therefore, each lesson of this Database Administrator course is intuitive and easy to understand. Learning Outcomes By the end of this Database Administrator course, you'll be able to: Install and configure MySQL Server and MySQL Workbench. Create, manage, and manipulate databases and tables using SQL. Insert, update, and delete data efficiently. Design and implement database relationships to ensure data integrity. Utilize aggregate functions to summarize and analyze data. Reverse engineer existing databases and forward engineer data models. Why would you choose the Database Administrator course from Compliance Central: Lifetime access to Database Administrator course materials Full tutor support is available from Monday to Friday with the Database Administrator course Learn Database Administrator skills at your own pace from the comfort of your home Gain a complete understanding of Database Administrator course Accessible, informative Database Administrator learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Database Administrator Study Database Administrator in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Database Administrator Course Database Administrator Curriculum Breakdown of the Database Administrator Course Unit 01: Introduction Gain foundational knowledge of MySQL Server and databases, including installation and initial setup. Module 01: Introduction to MySQL Server and Databases Module 02: Download and Install MySQL Server and MySQL Workbench Unit 02: Manipulating Tables and Data - CRUD Operations Learn to manage databases through creating, reading, updating, and deleting (CRUD) data in SQL and MySQL Workbench. Module 01: Connect and Create a Database Module 02: Drop or Remove Database Module 03: Create an SQL Database Table Module 04: Insert Data into the Table with SQL Script Module 05: Insert Data into the Table with Workbench Module 06: Select Data from the Table with SQL Script Module 07: Select Data with Filters Module 08: Update Data in the Table Module 09: Delete Data from the Table Module 10: Reverse Engineer Database into Model Module 11: Forward Engineer Data Model into Database Unit 03: Relationships and Foreign Keys Understand and implement relationships, foreign keys, and normalization in databases, enhancing data integrity and querying capabilities.ys Module 01: What are Relationships, Foreign Keys and Normalization? Module 02: Create Relationships with Data Modeling Module 03: Create Relationships with Workbench Table Design Tool Module 04: Insert Records in Related Tables Module 05: Run Queries on Related Tables (Inner Joins) Module 06: Left, Right and Cross-Joins Unit 04: Aggregate Functions Explore aggregate functions to perform calculations on data sets, including grouping, averaging, counting, and summing data. Module 01: Grouping Data using SQL GROUP BY Clause Module 02: SQL AVG Aggregate Function Module 03: SQL COUNT Aggregate Function Module 04: SQL MIN & MAX Aggregate Functions Module 05: SQL SUM Aggregate Function Module 06: Splitting Groups using HAVING Clause CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Database Administrator course is ideal for: Individuals with an interest in data management and database systems. IT professionals seeking to expand their skillset and transition into a Database Administrator role. Business analysts who want to gain a deeper understanding of data structures and manipulation techniques. Anyone passionate about building and maintaining robust and efficient databases. Those looking to enhance their career prospects in the ever-growing field of data. Requirements To enrol in this Database Administrator course, all you need is a basic understanding of the English Language and an internet connection. Career path A successful career as a Database Administrator can open doors to exciting opportunities. Here are some potential career paths to consider: Database Administrator Database Analyst Database Architect Data Warehouse Specialist Business Intelligence Analyst Data Scientist (with further specialization) Database Security Specialist Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Numbers tell stories—but only if you know how to read them. This course is designed to guide learners through the fine art of building HR dashboards using Excel, helping you turn columns and cells into clear, strategic insights. Whether you're navigating headcount data, analysing attrition, or tracking recruitment pipelines, you’ll gain the structured knowledge to bring clarity to the chaos of workforce figures. No fluffy jargon or corporate riddles—just solid Excel techniques that speak directly to HR needs. Through well-organised lessons, you'll explore how to compile, format, and visualise essential HR data in a way that even senior leadership won’t scroll past. From pivot tables to conditional formatting and dynamic charts, this course will help you create dashboards that don’t just look good, but actually mean something. If you're in HR and Excel is your daily battleground, this course will teach you how to build dashboards that do the talking for you—neatly, clearly, and without needing a 50-slide presentation. Learning Outcomes: Develop an understanding of the principles and practices of HR dashboard analysis using Excel Learn effective strategies for index and tab designing, MOM headcount, and employee compensation front face Develop analytical skills for departmental and location analysis, tenure wise analysis, and job rating analysis Understand how to utilize Excel to gain insights on complex HR data sets Be able to make informed decisions and navigate the complex and dynamic world of HR analytics using Excel The "Build HR Dashboard using Excel" course is designed to provide a comprehensive understanding of the principles and practices that underpin successful HR dashboard analysis using Excel. Through engaging modules and real-world case studies, learners will gain insights into effective strategies for index and tab designing, MOM headcount, employee compensation frontface, departmental and location analysis, tenure wise analysis, and job rating analysis. By the end of the course, learners will be equipped with the knowledge and skills to make informed decisions and navigate the complex and dynamic world of HR analytics using Excel. Whether you're an HR professional looking to enhance your skills or a beginner looking to enter the world of HR analytics, this course is a must-have for anyone interested in building a comprehensive HR dashboard using Excel. Build HR Dashboard using Excel Course Curriculum Section 01: Introduction Section 02: Data Introduction Section 03: Index Design and Tab Designing Section 04: Employee Frontface Section 05: Pivot Data List Section 06: MOM Headcount Section 07: Departmental and Location Analysis Section 08: Tenure wise Analysis Section 09: Age wise Analysis Section 10: Emp Demo and Quality Circles Section 11: Time Sheet Late Marks Analysis Section 12: Full and Final Analysis Section 13: Training Analysis Section 14: Employee Compensation Frontface Section 15: Job Rating Analysis Section 16: HR Update Section 17: Conclusion How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? HR professionals looking to enhance their data analysis skills using Excel Beginners interested in the world of HR dashboard analysis using Excel Business students interested in the field of HR analytics using Excel Entrepreneurs looking to incorporate data analysis into their HR practices using Excel Anyone interested in gaining a comprehensive understanding of HR analytics using Excel Career path HR Analyst: £25,000 - £50,000 per year HR Manager: £35,000 - £70,000 per year HR Business Partner: £35,000 - £90,000 per year HR Director: £70,000 - £150,000 per year Chief Human Resources Officer (CHRO): £100,000 - £250,000+ per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Master cash flow management with Microsoft Excel in our comprehensive course. Learn internal controls, cash receipts and disbursements management, bank reconciliations, petty cash handling, and more. Ideal for professionals seeking to enhance their financial management skills using Excel.

Unlock the power of data analysis with our specialized Data Analysis in Excel Course. Learn essential techniques and tools to analyze data effectively using Microsoft Excel. Whether you're a beginner or looking to enhance your skills, this course provides hands-on training to help you interpret data, create insightful reports, and make informed business decisions. Enroll now to harness the full potential of Excel for data analysis and take your analytical skills to the next level.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for information technology (IT) professionals who need to improve their expertise in Windows Server 2016 in the area of storage and compute functionality. Overview After completing this course, you will be able to: Configure and install Windows Server 2016 Manage Server Core, server upgrade and migration strategy Understand storage options Manage partition table formats Manage basic and dynamic disks, file systems Manage virtual hard disks, and drive hardware Manage disks and volumes Select and manage proper storage solutions for a specific scenario Storage Spaces and Data Deduplication implementation Configure and Manage Microsoft Hyper-V, virtual machines and Hyper-V containers Configure disaster recovery technologies Manage and Configure failover clustering for Hyper-V virtual machines Configure, plan and implement a Network Load Balancing (NLB) Work with deployment images This course is intended for information technology (IT) professionals who have basic knowledge of Windows Server. It is designed for professionals who have primary responsibility of managing storage and computing by using Windows Server 2016. Professionals who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.This course covers content that was in retired Microsoft Course 20740. Module 1: Installing, upgrading, and migrating servers and workloads Introducing Windows Server 2016 Preparing and installing Server Core Preparing for upgrades and migrations Migrating server roles and workloads Windows Server activation models Module 2: Configuring local storage Managing disks in Windows Server Managing volumes in Windows Server Module 3: Implementing enterprise storage solutions Overview of DAS, NAS, and SANs Comparing Fibre Channel, iSCSI, and Fibre Channel over Ethernet Understanding iSNS, DCB, and MPIO Configuring sharing in Windows Server 2016 Module 4: Implementing Storage Spaces and Data Deduplication Implementing Storage Spaces Managing Storage Spaces Implementing Data Deduplication Module 5: Installing and configuring Hyper-V and virtual machines Overview of Hyper-V Installing Hyper-V Configuring storage on Hyper-V host servers Configuring networking on Hyper-V host servers Configuring Hyper-V virtual machines Managing virtual machines Module 6: Deploying and managing Windows and Hyper-V containers Overview of containers in Windows Server 2016 Preparing for containers Installing, configuring, and managing containers by using Docker Module 7: Overview of high availability and disaster recovery Defining levels of availability Planning high availability and disaster recovery solutions with Hyper-V virtual machines Backing up and restoring by using Windows Server Backup High Availability with failover clustering in Windows Server 2016 Module 8: Implementing failover clustering Planning a failover cluster Creating and configuring a new failover cluster Maintaining a failover cluster Troubleshooting a failover cluster Implementing site high availability with stretch clustering Module 9: Implementing failover clustering with Windows Server 2016 Hyper-V Overview of yhe integration of Hyper-V Server 2016 with failover clustering Implementing Hyper-V VMs on failover clusters Key features for VMs in a clustered environment Module 10: Implementing Network Load Balancing Overview of NLB Configuring an NLB cluster Planning an NLB implementation Module 11: Creating and managing deployment images Introduction to deployment images Creating and managing deployment images by using MDT Virtual machine environments for different workloads Module 12: Managing, monitoring, and maintaining virtual machine installations WSUS overview and deployment options Update management process with WSUS Overview of Windows PowerShell DSC Overview of Windows Server 2016 monitoring tools Using Performance Monitor Monitoring event logs Additional course details: Nexus Humans 55324 Installation, Storage and Compute with Windows Server 2016 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 55324 Installation, Storage and Compute with Windows Server 2016 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 Developed for IT Professionals interested in learning how to manage Citrix Endpoint Management on-premises or cloud environments using leading practices. Potential students include Administrators and Implementers. Overview How to manage a Citrix Endpoint Management implementation in a On-premises or cloud environment How to perform common enterprise mobility management tasks and mobile application managementUnderstand the device enrollment processHow to perform monitoring, troubleshooting, and reporting on a Citrix Endpoint Management Enterprise solution Students will explore how to manage Citrix Endpoint Management in this course. Venture into the cloud as students learn to manage devices, apps, and users. Students will learn how the architecture, management, and communication flow function with Citrix Endpoint Management Service and how they can fit their organization?s needs. Students will learn how to administer their Citrix Endpoint Management environment and how to support your end users, as well as working with applications and securing a variety of endpoints. Introduction to Citrix Endpoint Management Citrix Endpoint Management Features Citrix Cloud and Citrix Endpoint Management Citrix Endpoint Management User Experience and Security Citrix Endpoint Management Entitlements Citrix Endpoint Management Architecture Citrix Endpoint Management Prerequisites Citrix Endpoint Management Server Citrix Endpoint Management and Microsoft Intune Apple APNs and Google Firebase Cloud Messaging MDX Architecture and Features Cloud Components Cloud Component Overview Onboarding and Access Cloud Connector and Cloud Resource Locations Cloud Migration Cloud Updates and Features Common Device Management Tasks Administrative Console Overview Delivery Groups Device Policies Device Enrollment Enrollment Methods iOS Device Enrollment Android Device Enrollment Windows 10 Enrollment Other Devices Managing Device Security Security Policies Automated Actions Android for Work ActiveSync Filtering Shared Devices Working with Apps Application Integration Citrix Endpoint Management Productivity Apps Application Security with MDX 3rd Part Applications Integrating Citrix Content Collaboration Citrix Content Collaboration Overview Integrating Citrix Endpoint Management with Content Collaboration Content Collaboration Workflows Maintaining and Troubleshooting Maintaining Citrix Endpoint Management Maintaining Certificates Troubleshooting Citrix Gateway (formerly NetScaler Gateway) Troubleshooting Tools for Citrix Productivity Apps Firewall Issues Monitoring and Reporting Monitoring and Reporting of Devices Monitoring and Reporting of Citrix Content Collaboration Additional course details: Nexus Humans CEM-205 Manage Citrix Endpoint 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 CEM-205 Manage Citrix Endpoint 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.

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 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.