4724 Courses delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. Relational Database Basics Brief History of SQL Relational Databases Popular Databases SQL Statements Simple SELECTs Introduction to the Northwind Database Some Basics SELECTing All Columns in All Rows Exploring the Tables SELECTing Specific Columns Sorting Records The WHERE Clause and Operator Symbols Using the WHERE clause to check for equality or inequality Using the WHERE clause to check for greater or less than Checking for NULL Using WHERE and ORDER BY Together The WHERE Clause and Operator Words More SELECTs with WHERE Checking Multiple Conditions Writing SELECTs with Multiple Conditions Advanced SELECTs Calculated Fields Calculating Fields Aggregate Functions and Grouping Working with Aggregate Functions Built-in Data Manipulation Functions Data Manipulation Functions Subqueries, Joins and Unions Subqueries Joins Using Joins Outer Joins Unions Working with Unions If time allows, one or more of the following may be covered: Conditional Processing with CASE INSERT, UPDATE, DELETE Student Challenges - Design your own reports

Duration 3 Days 18 CPD hours This course is intended for This class is designed for experienced administrators and platform developers as well as solution, enterprise, and technical architects responsible for designing or building integration solutions on the Salesforce Platform. It's also designed for project or program managers looking to understand the big picture of integration in order to better manage their projects and programs. Ideally, you hold the Salesforce Administrator, Salesforce App Builder, or Salesforce Platform Developer I credential and/or are knowledgeable about standard and custom objects; how to work with flows and Process Builder; how to navigate Salesforce, Lightning Components, and Schema Builder; and Apex basics such as creating a Class and Anonymous Blocks. This class is recommended for anyone looking to earn their Salesforce Certified Integration Designer credential. Overview When you complete this course, you will be able to: Identify integration requirements by asking relevant integration questions to business stakeholders. Recommend appropriate integration patterns (Remote Process Invocation - Request and Reply, Remote Process Invocation - Fire and Forget, Batch Data Synchronization, Remote Call-In, and UI Update Based on Data Changes, Data Virtualization) to design integration solutions. Recommend appropriate integration capabilities (SOAP, REST, bulk, streaming, Outbound Messaging, Callouts, and Salesforce Connect) to build integration solutions. Explore architectural concepts and the big picture thinking of how to integrate on the Salesforce Platform. In this 3-day class, our Salesforce integration experts will demonstrate how to build solutions that provide a single view of your customers. You?ll learn about integration capabilities and the considerations that should be made when architecting an integration solution. Through a combination of demos, discussions, and hands-on exercises, you?ll design and build secure, scalable, and high-performing integration solutions that seamlessly surface the information that matters most Integration Overview Understand the Importance of Integration Explore Integration Architecture Explore the Meaning of Single View of the Customer Explore the Meaning of System Landscape Understand the Role of Enterprise Service Bus (ESB) and Extract Transform Load (ETL) in System Landscape Integration Capabilities Introduction to Salesforce APIs Create External Applications Using SOAP API Build Mobile Applications Using REST API Work with Large Data Volumes Using BULK API Build Event-Driven Applications Using Streaming API Build Event-Driven Applications Using Platform Events Build Event-Driven Applications Using Change Data Capture Send Data from Salesforce to External Applications Using Outbound Message Call External APIs Programmatically Using Callouts Integrate Data from an External Data Source Using Salesforce Connect Synchronize Data with Heroku Connect Call External APIs Declaratively Using External Services Integration Patterns Understand Use Cases for a Request and Reply Pattern Understand Use Cases for a Fire and Forget Pattern Understand Use Cases for a Batch Data Synchronization Pattern Understand Use Cases for a Remote Call-In Pattern Understand Use Cases for a UI Update Based on Data Changes Pattern Understand Use Cases for a Data Virtualization Pattern Integration Security Explore Two-Way Transport Layer Security (TLS) Understand When to Use Remote Site Settings Understand the Benefits of Using Named Credentials Understand Certificates Encrypt Your Data at Rest Using Salesforce Shield Platform Encryption Advanced Integration Discussions Design Solutions for Performance Design Solutions for Scale Review Integration Regulatory Requirements Review Integration Best Practices Case Study Draw a System Landscape Diagram Evaluate Business Needs Translate Needs to Integration Requirements Design an Integration Solution Build an Integration Solution Maintain an Integration Solution Additional course details: Nexus Humans Salesforce Design and Build Integration Solutions (ARC101) 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 Design and Build Integration Solutions (ARC101) 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.

Do you just need a quick chat to move things forward? Do you have some pressing questions and need feedback that relates directly to you and your book? Did you want to do Taking Your Book To School but are not quite ready yet? I have three half-hour brainstorm sessions available to you on Saturday 18th March at a discounted rate of £20.00 per session. Would you like one? First come first served!

Teachers will become familiar with the software, aiding each learner access to their college dashboard as a designer, so they can complete a heat loss report and other heating design elements. Furthermore each learner will have access to send surveys from the heat engineer app (Apple or Android) which once sent will be received within the college dashboard. Where teachers can assess the survey.

Transform your life with Coach Faisal, London's expert in personal and career development. Experience unique coaching with Stretchology Class, blending fitness, mindfulness, and life coaching. Trusted by top brands like WeWork and BBC, Coach Faisal tailors guidance for your success. Start your journey

Parental Mental Health & Child Protection Course Overview: This course on Parental Mental Health & Child Protection provides an in-depth understanding of the complex intersection between parental mental health issues and their impact on child welfare. Learners will explore a range of mental health disorders, focusing on how these conditions affect family dynamics and child development. The course covers crucial safeguarding practices, enabling professionals to assess and address the needs of families in distress. Upon completion, learners will have the skills to identify early signs of mental health struggles in parents, understand the risks to children, and apply appropriate interventions to ensure child protection. The practical value of this course lies in its ability to equip professionals with the knowledge to support vulnerable families and promote the wellbeing of children. Course Description: The Parental Mental Health & Child Protection course offers a thorough exploration of various mental health issues that parents may face, such as stress, anxiety, personality disorders, and mood disorders, and their implications for children. Learners will delve into the impacts of these disorders on family relationships and child protection. The course includes a detailed analysis of safeguarding procedures and strategies for assessing needs and providing help to families in crisis. By examining real-world case studies, participants will gain insights into identifying early warning signs of child harm, understanding the role of mental health in child protection, and implementing effective solutions. Upon completing this course, learners will be equipped with the skills to support at-risk families and contribute to effective child safeguarding. Parental Mental Health & Child Protection Curriculum Module 01: Introduction to Mental Health Module 02: Stress and Anxiety Disorders Module 03: Schizophrenia Module 04: Personality Disorders Module 05: Mood Disorders Module 06: Eating & Sleeping Disorders Module 07: Self-Harm and Suicide Module 08: Solving Family Issues – Part 1 Module 09: Solving Family Issues – Part 2 Module 10: Safeguarding – Assessing Need and Providing Help (Part 1) Module 11: Safeguarding – Assessing Need and Providing Help (Part 2) Module 12: Building Relationships (See full curriculum) Who is this course for? Individuals seeking to understand the connection between mental health and child protection. Professionals aiming to develop skills in safeguarding and family support. Beginners with an interest in mental health, child welfare, or social work. Any other relevant group interested in family dynamics and child protection. Career Path: Social Workers Child Protection Officers Family Support Workers Mental Health Counsellors Youth Workers Family Therapists

Duration 1 Days 6 CPD hours This course is intended for This course is for solution architects, solution designers, administrators, product managers, or anyone who needs to learn the essentials of IBM Case Manager. Overview Describe the users of IBM Case Manager Identify components of IBM Case Manager Create and process a case Search for a case Review a case Add annotations and comments to a case Split a case Explore and identify the structure of a solution Add a custom task Add a quick task Identify IBM Case Manager integration options This course is an introduction to IBM Case Manager, concepts, functions, and architecture. Participants use an IBM Case Manager system to practice the skills that are required by case workers to process cases and create runtime tasks. Introduction to IBM Case Manager Describe the uses of IBM Case Manager Identify components of IBM Case Manager Create and process a case Identify a case List the components of a case type Describe the IBM Case Manager Client Add a case and process a work item Review a case Search for a case Review a case Add annotations and comments to a case Split a case Structure of a solution Describe IBM Case Manager solutions and their assets Identify IBM Case Manager environments Explore the IBM Case Manager Builder Step Designer Add runtime tasks Add a custom task Add a quick task IBM Case Manager integration options Identify IBM Case Manager integration options

Taking minutes is a much under-rated skill. It can be challenging at the best of times. So how do you do it for virtual meetings? This trainer-led session will help. It's a very practical programme which explores the issues specific to minuting on-line meetings and gives solutions to some of the trickier problems. Full of useful tips, the session will enable participants to: Identify how to adapt their current minute-taking skills to on-line meetings Plan and prepare for a meeting Follow a line of discussion Work in partnership with a remote Chair Deal confidently with minute-taking challenges. 1 Welcome Programme objectives Personal introductions 2 Adapting minute-taking to virtual meetings How is it different? What changes in approach are needed? 3 Preparation Preparing for the meeting Technology and equipment Dress and personal presentation Liaising with the Chair Practical preparation tips 4 Minuting tips Managing the 'techie' elements, eg. poor sound/visual quality Knowing who is speaking Following a line of discussion What if I don't hear or understand? Tips for producing a set of minutes 5 Session review Summary, key learning points, feedback and close

Excel Data Analysis Course Overview The Excel Data Analysis course is designed to equip learners with the essential skills needed to analyse and interpret data using Microsoft Excel. This course covers a range of tools and techniques that are vital for processing, summarising, and visualising data. Learners will explore functions, pivot tables, charts, and data manipulation strategies that will enable them to work efficiently with data sets. By the end of the course, learners will be able to transform raw data into meaningful insights, making it an invaluable skill for professionals across various industries. Whether you're looking to improve your data skills or progress in your career, this course offers the foundational knowledge required for data analysis in Excel. Course Description This course delves into the core aspects of Excel Data Analysis, starting with basic functions and advancing to complex data manipulation techniques. Learners will explore how to create and manage pivot tables, perform data filtering, and apply functions such as VLOOKUP and INDEX MATCH. Visualisation tools like charts and graphs will be covered, enabling learners to present their findings in a clear and impactful way. Additionally, learners will be introduced to data modelling, conditional formatting, and advanced formula techniques that will enhance their data analysis capabilities. The course is structured to provide a comprehensive understanding of Excel’s data analysis features, building competency for a wide range of practical applications in both personal and professional settings. Excel Data Analysis Curriculum Module 01: Introduction to Excel for Data Analysis Module 02: Using Excel Functions for Data Manipulation Module 03: Working with Pivot Tables and Pivot Charts Module 04: Data Visualisation: Creating Charts and Graphs Module 05: Advanced Excel Functions for Complex Data Analysis Module 06: Data Filtering and Sorting Techniques Module 07: Conditional Formatting for Data Insights Module 08: Introduction to Data Modelling and Forecasting Module 09: Data Analysis Best Practices and Case Studies (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to advance in data-centric roles. Beginners with an interest in data analysis and Excel. Anyone looking to improve their Excel knowledge for career development. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Administrative Assistant Project Manager Research and Development Analyst

ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! Course Overview The ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! course is designed to guide learners from basic understanding to advanced proficiency in using ChatGPT. This course covers a wide range of topics, from the fundamentals of ChatGPT to its integration for business scaling and its applications in specific industries like Excel professionals and students. By the end of the course, learners will have a comprehensive understanding of ChatGPT’s capabilities, how to leverage its potential for various tasks, and how to improve productivity and creativity using this powerful tool. Whether you are looking to enhance your business, excel in academic pursuits, or integrate AI into your work, this course provides the knowledge and skills necessary to succeed. Course Description This course offers an in-depth exploration of ChatGPT, covering its fundamental features and uses across different sectors. Learners will be introduced to ChatGPT’s functionalities, followed by more specialised modules, including its applications for developers, students, and professionals working with Excel. Participants will gain valuable insights into how ChatGPT can be used to automate tasks, enhance business operations, and create innovative content. They will also explore the integration of Dall-E 2 for generating graphic art and the best tools and extensions to improve ChatGPT's functionality. The course is structured to ensure learners gain a clear understanding of how to effectively use ChatGPT for various personal and professional goals. ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! Curriculum Module 01: Getting Started Module 02: ChatGPT – Basic Module 03: ChatGPT for Developers Module 04: Build, and Scale your Business Using ChatGPT Module 05: ChatGPT for Students Module 06: The Power of ChatGPT Module 07: ChatGPT for Excel professionals Module 08: Generate Incredible Graphic Art with Dall-E 2 Module 09: The Best Tools and Extensions using ChatGPT (See full curriculum) Who is this course for? Individuals seeking to improve productivity through AI. Professionals aiming to leverage ChatGPT for business growth. Beginners with an interest in learning AI technologies. Developers looking to integrate ChatGPT into applications. Students seeking to optimise learning and research tasks. Career Path AI Integration Specialist Business Automation Expert Developer specialising in AI tools Digital Content Creator Data Analyst using AI tools Academic Support Professional Graphic Designer using AI for art generation