Wanna learn something simple yet so amazing that it's going to blow your mind? Good, because this little workshop's a gem. Join Happy Human Training's Cami Rose as she shares her decades of experience as a counsellor and coach with an introduction to the power of noticing and the crucial role it can play in helping us better manage our day to day stresses, challenges and relationships.
Wanna learn something simple yet so amazing that it's going to blow your mind? Good, because this little workshop's a gem. Join Happy Human Training's Cami Rose as she shares her decades of experience as a counsellor and coach with an introduction to the power of noticing and the crucial role it can play in helping us better manage our day to day stresses, challenges and relationships.
This workshop has been designed to help managers understand their responsibilities and what they need to do to ensure compliance with current workplace legislation - including the fire safety and CDM regulations. The day will cover the legal background - including an appreciation of how safety legislation has evolved and why; the logic behind recent developments and the implications for staff and employers; key areas of current legislation; roles and responsibilities in health and safety management, including monitoring contractors and suppliers effectively; implementing sound health and safety policies and procedures; getting staff on board, and implementing effective systems. Also, recognising potential risks and hazards and developing strategies to minimise their impact in the workplace. This course will give participants an understanding of: The broader context of the key areas of health and safety regulation which apply to your organisation Existing health and safety practice and guide them in how to shape and implement an effective health and safety policy What they should do and the procedures to support it Potential areas of risk in the workplace - and how to take action to minimise the threat to staff safety How sound health and safety processes can contribute to business performance 1 Understanding the workplace legislation Overview of health and safety and workplace legislation Compliance, the role of the facilities manager, and who is accountable? Breakout session to discuss where we are now and to highlight issues of concern Applying required policies and procedures Developing and implementation/review of the safety policy Communicating with users, clients and contractors Health and safety manual 'Selling' health and safety 2 Key legislation - a practical working guide Asbestos Regulations Construction (Design and Management) Regulations 2007 / 2015 Control of Substances Hazardous to Health (COSHH) Regulations Disability Discrimination Act (DDA) Display Screen Equipment (DSE) Regulations 1992 Electricity at Work Regulations 1989 Fire Precautions (Workplace ) Regulations 2006 Health and Safety (Consultation with Employees) Regulations 1996 Health and Safety (First Aid) Regulations 1981 Health and Safety at Work etc. Act 1974 Management of Health and Safety at Work Regulations 1992 Manual Handling Operations Regulations 1992 Portable Appliance Testing (PAT) Provision and Use of Work Equipment Regulations 1992 REACH - Registration, Evaluation, Authorisation and restriction of Chemicals Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations (RIDDOR) 1995 Waste Electrical and Electronic Equipment (WEEE) Regulations 2006 Work Equipment Regulations 3 Controlling contractors Understanding the Regulations Selecting and assessing contractors Understanding and setting accountability Why a method statement? How to apply a permit to work system Safe systems of work Round-table discussion to bring out issues from participants' own experience 4 Risk assessment Understanding your hazards Identifying specialist areas How to undertake these assessments Implementation of sound systems and processes Syndicate exercise identifying where assessments are needed and carrying out assessments 5 Keeping the work environment safe Sick building syndrome and legionella Asbestos Waste management Pest control Provisions for first aid Accident reporting and investigation At-work driver safety Security 6 Fire safety Understanding the Regulatory Reform Fire Safety Order Fire certificates The fire risk assessment Testing fire-fighting equipment? Emergency procedures Workshop to examine the procedures for dealing with different types of emergencies 7 Ergonomics programme Ergonomics - important or irrelevant? Are you complying with HSE regulations? Furniture and equipment Display screen equipment assessments Homeworking - your concern or not? Syndicate exercise to review what to do when relocating or refurbishing an office 8 Inspecting and auditing Role of Health and Safety Executive Inspectors - 'be prepared' FM role Staff/trade union involvement Independent audits Records and reports Communicating the results 9 Action plan Participants to list actions they need to take after the course
Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, and Solution Architects. Overview Become familiar with detailed information about the functions of the global availability check in the SAP SCM solution in the context of sales and distribution. In this course, students learn in detail the different standard & advanced availability check capabilities of the integrated SAP APO Global-Available to Promise component, embedded in corresponding business scenarios & along with the relevant settings. Overview of Global Available-to-Promise (Global ATP) Outlining the Functionality of Global Available-to-Promise (Global ATP) Integration of Global Available-to-Promise (Global ATP) Explaining the Use of Core Interface (CIF) Integration with Global Available-to-Promise (Global ATP) Check Method Selection in Global Available-to-Promise (Global ATP) Explaining Availability Check Methods Product Availability Check in Global Available-to-Promise (Global ATP) Checking Product Availability in Global Available-to-Promise (Global ATP) Checking Scope in Global Available-to-Promise (Global ATP) Setting the Checking Horizon in Global Available-to-Promise (Global ATP) Evaluating Logic in the Available-to-Promise (ATP) Check in Global Available-to-Promise (Global ATP) Product Allocation in Global Available-to-Promise (Global ATP) Setting Up Single Level Product Allocation in Global Available- to-Promise (Global ATP) Setting Up Multilevel Product Allocation in Global Available-to- Promise (Global ATP) Check Against the Forecast in Global Available-to-Promise (Global ATP) Setting Up the Check Against Forecast in Global Available-to- Promise (Global ATP) Rules-Based Availability Check in Global Available-to-Promise (Global ATP) Setting Up Rules-Based Availability Check in Global Available-to- Promise (Global ATP) Configuring Rule Determination Based on the Condition Technique in Global Available-to-Promise (Global ATP) Setting Up a Consolidation Location in Rules-Based Available-to- Promise (ATP) Check Using the Multi-Item Single Delivery Location (MISL) Function in Global Available-to-Promise (Global ATP) Using the Exclusive Rule Strategy in Global Available-to-Promise (Global ATP) Configuring Product Interchangeability Master Data in Global Available-to-Promise (Global ATP) Production Within the ATP Check in Global Available-to-Promise (Global ATP) Configuring the Capable-to-Promise (CTP) Procedure in Global Available-to-Promise (Global ATP) Configuring the Multilevel ATP Check (MATP) Procedure in Global Available-to-Promise (Global ATP) Backorder Processing in Global Available-to-Promise (Global ATP) Executing Backorder Processing in Global Available-to-Promise (Global ATP) Using Enhanced Interactive Backorder Processing in Global Available-to-Promise (Global ATP) Configuring Event-Driven Quantity Assignment in Global Available- to-Promise (Global ATP) Setting Up Reassignment of Order Confirmations in Global Available-to-Promise (Global ATP) Transportation and Shipment Scheduling in Global Available-to- Promise (Global ATP) Scheduling Transportation and Shipment Using Master Data in Global Available-to-Promise (Global ATP) Scheduling Transportation and Shipment Using the Condition Technique in Global Available-to-Promise (Global ATP) Scheduling Transportation and Shipment Using Configuration in Global Available-to-Promise (Global ATP) Scheduling Transportation and Shipment Scheduling using Configuration and Calendars in Global Available-to-Promise (Global ATP) Additional course details: Nexus Humans SCM670 SAP Global Available-to-Promise 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 SCM670 SAP Global Available-to-Promise 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 1 Days 6 CPD hours This course is intended for This course is intended for students who want to use more advanced functionalities in Microsoft Word, including image manipulation, collaboration and revision tracking, cross- referencing and linking, document security, forms, and process automation through macros. Overview In this course, you will explore advanced functionalities in Word. You will: Use images in a document. Create custom graphic elements. Collaborate on documents. Add reference marks and notes. Secure a document. Create and manipulate forms. Create macros to automate tasks. Word for Microsoft 365 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.Being able to manipulate graphics and efficiently create, manage, revise, and distribute long documents and forms can help your organization create important and interesting documents. Implementing time-saving features that enable you to work well in a collaborative mode will benefit both you and your organization. Constructing document elements that ensure your readers have access to pertinent information at the click of a button, while at the same time protecting sensitive information, is another important skill. Mastering these skills and techniques will make you a valued employee in your organization.Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will alsoenable you to access and effectively utilize many web-based resources provided with your Microsoft 365? subscription. Helpful notes throughout the material alert you to caseswhere the online version of the application may function differently from the primary, desktop version.This course may be a useful component in your preparation for theMicrosoft Word (Microsoft 365 Apps and Office 2019): Exam MO-100 and Microsoft Word Expert (Microsoft 365 Apps and Office 2019): Exam MO-101 certification exams. Lesson 1: Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Lesson 2: Using Custom Graphic Elements Topic A: Create Text Boxes and Pull Quotes Topic B: Add WordArt and Other Text Effects Topic C: Draw Shapes Topic D: Create Complex Illustrations with SmartArt Lesson 3: Collaborating on Documents Topic A: Share and Co-Author a Document Topic B: Mark Up a Document Topic C: Review Markups Topic D: Merge Changes from Other Documents Lesson 4: Adding Document References and Links Topic A: Add Captions Topic B: Add Cross-References Topic C: Add Bookmarks Topic D: Add Links Topic E: Insert Footnotes and Endnotes Topic F: Add Citations and a Bibliography Lesson 5: Securing a Document Topic A: Suppress Information Topic B: Set Formatting and Editing Restrictions Topic C: Restrict Document Access Topic D: Add a Digital Signature to a Document Lesson 6: Using Forms to Manage Content Topic A: Create Forms Topic B: Modify Forms Lesson 7: Automating Repetitive Tasks with Macros Topic A: Automate Tasks by Using Macros Topic B: Create a Macro Additional course details: Nexus Humans Microsoft Word for Office 365 (Desktop or Online) (v1.1) Part 3 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 Word for Office 365 (Desktop or Online) (v1.1) Part 3 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 This course is designed for Pardot Marketers and Salesforce Administrators responsible for designing, building, and implementing marketing workflows and reports in the Pardot Lightning App. It's also for Business Users looking to learn more about the Pardot Lightning App. This course is a great foundation builder for anyone looking to take the Salesforce Pardot Specialist Certification Exam. Overview When you complete this course, you will be able to: Enable the Pardot Lightning App. Explain the relationship created between Pardot and Salesforce once the Pardot Lightning App has been enabled. Generate leads with Pardot Lightning App's various lead generation tools including forms, landing pages, and custom redirects. Manage leads with Pardot Lightning App's lead management tools including page actions, automation rules, segmentation rules, dynamic lists, and completion actions. Engage leads with Pardot Lightning App's lead engagement tools including email, personalization, dynamic content, and Engagement Studio. Qualify leads with Pardot Lightning App's scoring and grading functionality. Interpret data generated via Pardot Lightning App's reporting capabilities. Design and execute successful end-to-end marketing workflows using the Pardot Lightning App. Discover how to drive more qualified leads, nurture prospects through the sales cycle, and sell more effectively using the Pardot Lightning App. In this 3-day class, Pardot experts will show you how to design and implement marketing workflows in the Pardot Lightning App to make data-driven decisions and drive your company?s business forward. Learn how to create and automate dynamic emails, generate and qualify leads, and leverage reports and data to boost sales. Course Introduction Review Course Objectives Set Learner Expectations Review Housekeeping Items Review Additional Course Resources Explore Course Case Study Salesforce Integration Understand the Pardot-Salesforce Relationship Sync Data Between Salesforce and Pardot Enable the Pardot Lightning App in Salesforce Create Custom Fields Review Salesforce Campaigns Administration Create a Pardot Dashboard Authenticate Your Email Sending Domains Sync with Third-Party Applications Using Connectors Restore Assets from the Recycle Bin Create and Assign Users and User Groups Understand Usage Governance Visitors and Prospects Understand Pardot Visitors Understand Pardot Prospects List Management Create List Types Organize Prospects Using Static Lists Test Emails Using Test Lists Personalization and Email Marketing Personalize Your Emails with HML and Advanced Dynamic Content Automate Email Marketing Create Email Templates See What Works Best for Your Audience Using AB Testing Track Email Performance Using Email Reports Forms and Landing Pages Capture Leads with Forms Convert Visitors to Leads Using Landing Pages Track Leads with Forms and Landing Page Reports Track Clicks Using Custom Redirects Create Custom Redirect Reports Lead Management Trigger Page Actions Automate Actions from a Marketing Element Using Completion Actions Create a List of Prospects and Apply a Segmentation Action Using Segmentation Rules Create Repeatable, Criteria-Based Automation Rules Create Dynamic Lists Choose an Automation Tool Lead Qualification Understand Prospect Scoring Grade Prospects Based on Profiles Lead Nurturing Build an Engagement Program Create Engagement Program Reports Additional course details: Nexus Humans Salesforce Drive Sales with the Pardot Lightning App (PDX101) 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 Salesforce Drive Sales with the Pardot Lightning App (PDX101) 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 Experienced system administrators and network administrators Customers, cloud architects, systems engineers, data center administrators Network administrators with experience in managed services or managing a Telco Cloud environment Overview By the end of the course, you should be able to meet the following objectives: Deploy VMware Telco Cloud Service Assurance Manage VMware Telco Cloud Service Assurance to satisfy Telco cloud provider needs Discuss configurable options for VMware Telco Cloud Service Assurance Identify and configure different data sources which are used with VMware Telco Cloud Service Assurance Configure different collectors in VMware Telco Cloud Service Assurance Identify the Root Cause Analysis options with VMware Telco Cloud Service Assurance Discuss data collection in VMware Telco Cloud Service Assurance Explain root cause analysis in VMware Telco Cloud Service Assurance Navigate through the logs for troubleshooting This three-day, hands-on training course provides the knowledge, skills, and tools to achieve competency in installing, configuring, and managing the VMware Telco Cloud Service Assurance environment. In this course, you are introduced to the installation methods of VMware Telco Cloud Service Assurance? across various supported platforms and troubleshooting tools that help you install, manage, and troubleshoot your VMware Telco Cloud Service Assurance environment. In addition, you are presented with various types of configuration options, which you will identify, analyze, and navigate through as you explore the UI and configurable options of the product. Course Introduction Introduction and course logistics Course objectives Introduction to VMware Telco Cloud Service Assurance Describe the features of VMware Telco Cloud Service Assurance List the capabilities of VMware Telco Cloud Service Assurance Discuss the use cases of VMware Telco Cloud Service Assurance Describe the role played by VMware Telco Cloud Service Assurance components in delivering service assurance Deploying VMware Telco Cloud Service Assurance Explain different deployment options of VMware Telco Cloud Service Assurance Identify different deployment methods of VMware Telco Cloud Service Assurance Discuss different phases in deploying VMware Telco Cloud Service Assurance Identify different footprints available for HA based and non-HA based installation of VMware Telco Cloud Service Assurance Describe the SMARTs components of VMware Telco Cloud Service Assurance Deploy VMware Telco Cloud Service Assurance User Access Control Describe the features Role-based Access Control (RBAC) Outline the role of Keycloak in implementing RBAC in VMware Telco Cloud Service Assurance Configure user federation in Keycloak Use the VMware Telco Cloud Service Assurance UI to manage RBAC Create policies in VMware Telco Cloud Service Assurance that align with job roles Services and User Interface Configurations Describe the architecture of logical switching Describe the core services on a TCSA cluster Discuss the Global Manager or Service Assurance Manager (SAM), IP Domain Manager, Server Manager (ESM) Discuss VMware Telco Cloud Service Assurance UI Overview Explain Working with Notifications Elaborate Configuring Summary's Describe Accessing Notification Details Explain Viewing and configuring Topologies List Customizing Topologies Describe Topology Explorer Explain Collecting Troubleshooting Information Discuss Custom models Describe how compute resources are provided to VMware Telco Cloud Service Assurance Describe how storage is provided to VMware Telco Cloud Service Assurance Configure and manage VMware Telco Cloud Service Assurance Discuss configurable options for VMware Telco Cloud Service Assurance Day 1 and Day 2 Operations Review the architecture of logical routing and NSX Edge nodes Identify different data sources to be used with VMware Telco Cloud Service Assurance Configure different collectors with VMware Telco Cloud Service Assurance Describe Alarms and Thresholds Demonstrate how to configure alarms with VMware Telco Cloud Service Assurance Explain how to setup thresholds and timelines in VMware Telco Cloud Service Assurance Define Catalog management and sharing catalogs inside and between organizations. Identify the steps to import or upload data into catalogs. Explain the purpose of catalogs and How to Create a catalog organization. Describe the Purpose and Usage of Open Virtualization Format (OVA) and Custom vApp or VM Properties. Discuss vApp Templates Logs and Troubleshooting Review the architecture of the Distributed Firewall Discuss VMware Telco Cloud Service Assurance installations logs List Smarts installation logs Explain backup and restore options of VMware Telco Cloud Service Assurance Identify the approach for troubleshooting containerized services Discuss monitoring services
Duration 2 Days 12 CPD hours This course is intended for Network professionals and who design, build, operate, manage, and troubleshoot software-defined networking and security, and application owners who need visibility across multi-cloud environments Overview By the end of the course, you should be able to meet the following objectives: Explain the features and architecture of VMware Aria Operations for Networks Describe the VMware Aria Operations for Networks installation processes and requirements Navigate the VMware Aria Operations for Networks GUI Recognize major use cases for VMware Aria Operations for Networks and their benefits Deploy VMware Aria Operations for Networks Use VMware Aria Operations for Networks to monitor, operate, analyze, and troubleshoot the infrastructure supporting your applications This two-day, hands-on course gives you the skills to deploy and use VMware Aria Operations? for Networks to ensure an optimized, highly available, and secure infrastructure for your applications. You will learn the features, components, architecture, and benefits of VMware Aria Operations for Networks and how to use it to simplify daily operation and troubleshooting tasks. Course Introduction Introductions and course logistics Course objectives Introduction to VMware Aria Operations for Networks Identify the use cases for VMware Aria Operations for Networks Access the VMware Aria Operations for Networks Home page View VMware Aria Operations for Networks entity data Perform searches for specific entity data Create entity search queries Find and use event data VMware Aria Operations for Networks Architecture and Components Identify the components of VMware Aria Operations for Networks Describe the function of each component and how the components interact Check the health of VMware Aria Operations for Networks components VMware Aria Operations for Networks Installation Deploy VMware Aria Operations for Networks components Configure the pairing relationship between the platform VM and the collector VM Troubleshoot platform VM and collector VM configuration problems Explain how data sources export flow information Add VMware vCenter Server© to VMware Aria Operations for Networks Add a VMware NSX to VMware Aria Operations for Networks Configure IPFIX Distinguish between the mechanisms used to scale VMware Aria Operations for Networks Select the appropriate scaling mechanism for your environment Describe how clusters are expanded Integrate VMware Aria Operations with VMware Aria Operations for Networks Import a VMware Aria Operations for Networks instance into VMware Aria Suite Lifecycle VMware Aria Operations for Networks Use Cases Explain use cases for VMware Aria Operations for Networks Create VMware Aria Operations for Networks applications Perform application discovery Plan and optimize micro-segmentation and security for applications Explain the use of flow analytics Use flow information from physical devices in security planning Generate virtual machine path topologies between entities using flows Extract useful information from path topologies Validate NSX deployments Monitor and troubleshoot NSX events Operations and Troubleshooting Common Issues Perform VMware Aria Operations for Networks operations by using VMware vSphere© tags Use the flow analytics dashboards to perform flow analysis Set and configure Intents to identify aberrations in the behaviour of entities Use VMware Aria Operations for Networks tools to troubleshoot common problems Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Aria Operations for Networks: Install, Configure, Manage [V6.8] training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware Aria Operations for Networks: Install, Configure, Manage [V6.8] 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 This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL. Overview Discuss basic relational database concepts Use some of the OLAP features of DB2, such as GROUPing and RANKing functions Create tables, views and indexes Use referential integrity, check constraints and triggers Use outer joins, and join tables to themselves Use CASE expressions, and the CAST function Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables Use complex subqueries Use a greater number of scalar SQL functions Use advanced SQL constructs, such as recursive SQL and table expressions Define User-Defined Distinct Types and User-Defined Functions Avoid several of the most common causes for poorly-performing SQL This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows. Introduction Identify the purpose of the clauses in the SELECT statement Describe the key differences among the IBM DB2 platforms Describe and use some of the OLAP features of DB2, such as GROUPING functions like CUBE and ROLLUP, and the RANK, DENSE_RANK and ROW_NUMBER functions Create Objects Code statements to: Create tables and views, Alter tables, Create indexes, Implement referential integrity (RI), and Define triggers and check constraints Identify impacts and advantages of referential integrity, including impacts of delete rules Identify considerations when using triggers and check constraints Define and make use of INSTEAD OF triggers Join Retrieve data from more than one table via inner and outer joins Use outer joins (LEFT, RIGHT, FULL) Use ANTI JOINS Join a table to itself Use UNION and UNION ALL Use EXCEPT and INTERCEPT CASE, CAST, Summary Tables, and Materialized Query Tables Identify when CASE expressions can be used Code CASE expressions in SELECT list and in the WHERE clause Identify when CAST specifications can be used Identify the advantages of using Summary (Materialized Query) Tables and Temporary tables Identify the advantages of using Materialized Query Tables (MQTs) Identify when and how to use Temporary tables Using Subqueries Code subqueries using the ALL, ANY/SOME, and EXISTS keywords Code correlated subqueries Choose the proper type of subquery to use in each case Scalar Functions Extend your knowledge of scalar functions which: Manipulate arithmetic data, Manipulate date values, and Manipulate character data Examples of scalar functions that are addressed in this course: SUBSTR POSSTR COALESCE/VALUE DECIMAL ROUND DIGITS CHAR DATE/TIME Table Expressions and Recursive SQL Identify reasons for using table expressions and recursive SQL Use nested and common table expressions Identify the difference between views and table expressions Code recursive SQL Control the depth of recursion when coding recursive SQL UDTs/UDFs and Performance Describe the concepts behind User-Defined Types, User-Defined Functions and Stored Procedures Predict when queries will use indexes to get better performance Identify concepts of predicate processing State introductory concepts about index structure State general best practices advice Additional course details: Nexus Humans CE131 IBM DB2 SQL Workshop for Experienced Users 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 CE131 IBM DB2 SQL Workshop for Experienced Users 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 4 Days 24 CPD hours This course is intended for This course is ideal for email digital marketers responsible for managing the email channel for their organization, Salesforce Admins responsible for supporting users when Marketing Cloud Connect is installed, and customers who will be connecting their Salesforce org to Marketing Cloud using Marketing Cloud Connect. Overview When you complete this course, you will be able to: Explain Marketing Cloud Connect. Connect a Marketing Cloud account to a Salesforce org. Create individualized content blocks to leverage Salesforce CRM data using personalization strings and dynamic content. Create an email in Content Builder. Utilize the various sending methods to send to a Lead, Contact, Report, or Campaign in Marketing Cloud and Sales and Service Clouds. Automate sending emails using a Triggered Email, Automation Studio, and Journey Builder. Configure Synchronized CRM Sources to bring CRM data into Marketing Cloud. Segment data using Reports, Filter Activity, and Query Activity. Create journeys using Salesforce Activities in Journey Builder. Review tracking data in Marketing Cloud and Sales and Service Clouds. Create analytics reports in Marketing Cloud. Create and customize Marketing Cloud reports in Sales and Service Clouds. Create a dashboard based on Marketing Cloud reports. Unify and analyze your data in one place with Marketing Cloud Connect. In this 4-day class, you'll learn how to link your Marketing, Sales, and Service Clouds to seamlessly engage with your customers. Discover how to segment Salesforce data to create personalized, targeted emails. Track and report on those emails to see what resonates most with your customers so you can strengthen your relationships with them. Salesforce Marketing Cloud Overview Review the Customer Success Platform Get to Know Marketing Cloud Marketing Cloud Connect Review Marketing Cloud Connect Review the Various Ways to Connect the Clouds Marketing Cloud Connect Configuration Explore How to Connect the Clouds Review the Prerequisites for Marketing Cloud Connect Review Salesforce Terminology Connect a Marketing Cloud Account to a Salesforce Org Review Prework Personalized Digital Marketing Review What Functionality Can Be Accomplished in Each Cloud Create a Personalized Email Leveraging Salesforce CRM Data Using Content Builder Use Testing Tools Send a Marketing Cloud Email Manually to a Lead, Contact, Report, and Campaign Automate the Sending of an Email via a Triggered Email, Automation Studio, and Journey Builder Understand What Happens When an Email Is Sent Understand Subscriber Statuses Synchronized CRM Data Explain How and Why to Bring Salesforce CRM Data into Marketing Cloud Synchronize Data Sources in Contact Builder Create Segments Using Filters and the Query Activity Create a Salesforce Data Extension for Sending Create a Journey Using Synchronized Data Sources Test a Journey Journey Builder Explain Sales and Service Cloud Activities Create a Journey Using Sales and Service Cloud Activities Tracking and Reporting Understand the Tracking Data Available in Marketing Cloud Create and Automate Tracking Reports in Marketing Cloud Understand the Tracking Data Available in Sales and Service Cloud Create and Customize Marketing Cloud Reports in Sales and Service Cloud Create a Dashboard for Marketing Cloud Tracking Reports Additional course details: Nexus Humans Salesforce Link Your Salesforce Data using Marketing Cloud Connect (MCC201) 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 Salesforce Link Your Salesforce Data using Marketing Cloud Connect (MCC201) 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.