4494 Courses

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to SQL Programming Basics (TTSQL002) 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.

Risk Management for IT Projects: Virtual In-House Training IT projects may have direct bottom-line impact on the organization, cost millions of dollars, cause organizational change and change the way the organization is perceived by clients. Many IT projects are notoriously hard to predict and are filled with risk. IT Risk Management takes a comprehensive look at IT project risk management using PMI's PMBOK® Guide Risk Management Model in the context of IT Project Life Cycle phases. The goal of this course is to arm the practitioner with a rigorous, common-sense approach to addressing uncertainty in projects. This approach includes the ability to influence project outcomes, avoid many potential project risks, and be ready to calmly and efficiently respond to unavoidable challenges. What you will Learn You'll learn how to: Describe the risk management process, using the PMBOK® Guide's standard models and terminology Discuss the potential barriers to managing risk effectively in IT project organizations Develop an effective risk management plan for IT projects Identify project risks using IT-specific, practical tools Analyze individual risk events and overall project risk using IT-specific, practical approaches Plan effective responses to IT-specific risk based on the results of risk analysis and integrate risk responses into project schedules and cost estimates Manage and control risk throughout the IT project life cycle Implement selected elements of IT project risk management on your next project Foundation Concepts Basic concepts and purpose Risk and project constraints Risk and corporate cultures Risk management and IT PLC standards Plan Risk Management for IT Projects Plan Risk management process Plan Risk management activities Design a standard template Assess the project-specific needs Tailor the template Produce a project-specific risk management plan Gain consensus and submit as part of overall project plan A risk management plan of IT projects Identify Risks for IT Projects Identify risk process overview Risk categories and examples Risk identification tools Risk events by project life-cycle phases Perform Risk Analysis for IT Projects Perform qualitative risk analysis overview Core qualitative tools for IT projects Auxiliary qualitative tools for cost and schedule estimates When to use quantitative analysis for IT projects Plan Risk Response for IT Projects Plan risk response overview Active risk response strategies for IT projects (Threat and Opportunity) Acceptance and contingency reserves Contingency planning for IT projects Plan risk responses for IT projects Implement Risk Response for IT Projects Implement Risk Responses Executing Risk Response Plans Techniques and Tools Used Continuous Risk Management Monitor Risks for IT Projects Monitor risks overview Monitor risks tips for IT projects Technical performance measurement systems Risk management implementation for IT projects

Introduction to Project Management (Virtual) This course provides practical insights into what is project management and how it is performed in a structured manner.You will learn how projects are selected, initiated, planned, executed, monitored and control, as well as closed, which could serve you ubiquitously. The goal of this course is to provide a minimally essential orientation to practical project management concepts, tools, and techniques. You will be provided with enough of these that can be applied from both a project manager and a key stakeholder perspective. Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Key terms and concepts Organizational framework Leadership framework Originating and Initiating Originating projects Initiating projects Planning Planning overview Scope and quality planning Resources and risk planning Schedule and cost planning Project baselining Executing and Controlling Executing Monitoring and Controlling Closing Project closing overview Closing administratively Closing financially

Project Risk Management: Virtual In-House Training Have you been surprised by unplanned events during your projects? Are you and your project team frequently fighting fires? Well, you are not alone. Uncertainty exists in any project environment. While it's impossible to predict project outcomes with 100% certainty, you can influence the outcome, avoid potential risks, and be ready to respond to challenges that arise. In this course, you'll gain the proper knowledge needed to identify, assess, plan for, and monitor risk in your projects. You'll learn how to set up and implement risk management processes, helping you to minimize uncertainty and achieve more consistent, predictable outcomes as a result. What You Will Learn You'll learn how to: Demonstrate to others how the risk management processes in A Guide to the Project Management Body of Knowledge (PMBOK® Guide) apply to your project's environment, especially for high-risk projects Adapt these processes for a particular high-risk project team's operating principles Explain the importance of using risk management best practices at single and enterprise project levels Lead an initiative to implement risk management best practices in your project environment Foundation Concepts Risk-related definitions The risk management process High-risk projects and project failures Classical failures in implementing risk management Plan Risk Management Project risk management and governance Risk management planning for high-risk projects High-risk variations on a risk management plan Identify Risk Adapting the risk identification process for high-risk projects Recognizing risks spontaneously Confirming and structuring risk events for treatment Wrapping up risk identification for high-risk projects Perform Qualitative Risk Analysis Adapting qualitative risk analysis for high-risk projects Accelerating risk analysis Clearing risk action Wrapping up qualitative risk analysis for the next level Perform Quantitative Risk Analysis Adapting quantitative risk analysis for high-risk projects Ensuring effective risk analyses with data quality assessments Building a foundation for quantitative risk analysis Using discrete quantitative tools Using continuous quantitative tools Wrapping up quantitative risk analysis for high-risk projects Plan Risk Responses Adapting risk response planning for high-risk projects Optimizing active risk response strategies Leveraging contingencies for high project performance Wrapping up risk response planning for high-risk projects Implement Risk Responses Implementing Risk Responses Process Executing Risk Response Plans Tools and Techniques Best Practices Continuous Risk Management Monitor Risks Adapting risk monitoring for high-risk projects Optimizing risk plan maintenance Weaving risk reassessment into the project's progress Maintaining a continuous 'vigil' in high-risk project environments

Overview 2 day applied course with comprehensive case studies covering both Standardised Approach (SA) and Internal Models Approach (IMA). This course is for anyone interested in understanding practical examples of how the sensitivities-based method is applied and how internal models for SES and DRC are built. Who the course is for Traders and heads of trading desks Market risk management and quant staff Regulators Capital management staff within ALM function Internal audit and finance staff Bank investors – shareholders and creditors Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

In an increasingly complex and interconnected world, intelligence analysis plays a crucial role in protecting national security. The demand for skilled intelligence analysts is growing, and there is a need for individuals with critical thinking skills and an understanding of the intelligence cycle. According to a report by the UK Government, the security and intelligence sector is expected to grow by 3.2% per year, creating around 42,000 jobs by 2020. By taking this course, individuals can equip themselves with the skills and knowledge necessary to contribute to national security efforts in the UK. Learning Outcomes: Understand the definition and purpose of intelligence analysis Develop an understanding of the intelligence cycle and best practices in analysis processes Learn the importance of critical thinking and how to structure analytical assessments Gain an understanding of legal issues and ethics in intelligence analysis Understand the roles, responsibilities, and functions of an intelligence analyst Be able to contribute to national security efforts through effective intelligence analysis Course Curriculum: Module 01: Defining Intelligence Analysis - In this module, you will learn the definition and purpose of intelligence analysis, including the types of intelligence and the role of the intelligence analyst. Module 02: Development of Intelligence Analysis - This module will cover the historical development of intelligence analysis, including the evolution of intelligence gathering and analysis techniques. Module 03: The Intelligence Cycle - In this module, you will learn about the intelligence cycle, including its stages and the role of the analyst in each stage. Module 04: Critical Thinking and Structuring - This module will cover critical thinking, including its importance in intelligence analysis and how to structure analytical assessments. Module 05: Analysis Process and Best Practice - In this module, you will learn best practices in the analysis process, including the use of analytical tools and techniques. Module 06: Intelligence and National Security - This module will cover the role of intelligence in national security, including its contribution to policy-making and the prevention of threats. Module 07: Legal Issues and Ethics - In this module, you will learn about legal issues and ethics in intelligence analysis, including privacy and human rights concerns. Module 08: Your Role, Responsibilities, and Functions as an Analyst - This module will cover the roles, responsibilities, and functions of an intelligence analyst, including effective communication, teamwork, and report writing. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in pursuing a career in intelligence analysis Current intelligence analysts seeking to enhance their skills and knowledge Career path Intelligence Analyst: £25,000-£50,000 per year Senior Intelligence Analyst: £40,000-£80,000 per year Intelligence Officer: £30,000-£60,000 per year Security Analyst: £35,000-£70,000 per year

Level 2 Certificate in Understanding Domestic Abuse Course Do you want domestic abuse to end? You will get a comprehensive grasp of domestic violence, abuse, and the obstacles and particular difficulties that some victims of abuse have by completing this Level 2 Certificate in Understanding Domestic Abuse Course. This Level 2 Certificate in Understanding Domestic Abuse Course covers the long-term effects and the methods used by financial abusers to keep their victims under control. The Level 2 Certificate in Understanding Domestic Abuse Course also discusses the financial and societal effects that domestic violence may have on society. This Level 2 Certificate in Understanding Domestic Abuse Course will teach you about the different kinds of abuse that may happen to children. With the Level 2 Certificate in Understanding Domestic Abuse Course completion, you will know how to spot the warning signs, and how abuse affects children's physical and emotional health throughout time at different developmental stages. Enrol in the Level 2 Certificate in Understanding Domestic Abuse Course to learn about the psychological, emotional, and physical effects that victims of domestic abuse and violence endure. Learning Outcomes of Level 2 Certificate in Understanding Domestic Abuse Course After completing this Level 2 Certificate in Understanding Domestic Abuse Course, the learner will be able to: Understand what domestic violence & abuse is and who is at risk. The Level 2 Certificate in Understanding Domestic Abuse Course helps to understand the dynamics of domestic violence. Gain a solid understanding of the impact of domestic violence on victims through Level 2 Certificate in Understanding Domestic Abuse Course The Level 2 Certificate in Understanding Domestic Abuse Course teaches how to assess the risks of domestic violence and abuse of children. Know how to help children recover from domestic abuse, support the victim and report incidents throughout the Level 2 Certificate in Understanding Domestic Abuse Course. After completing the Level 2 Certificate in Understanding Domestic Abuse Course, you can work with victims of domestic abuse. Main Course: Domestic Violence and Abuse Awareness Diploma Course Free Courses are including with this Level 2 Certificate in Understanding Domestic Abuse Course Course 01: Family support worker Course 02: Child Protection and Risk Assessment Special Offers of this Level 2 Certificate in Understanding Domestic Abuse Course This Level 2 Certificate in Understanding Domestic Abuse Course includes a FREE PDF Certificate. Lifetime access to this Level 2 Certificate in Understanding Domestic Abuse Course Instant access to this Level 2 Certificate in Understanding Domestic Abuse Course Get FREE Tutor Support to this Level 2 Certificate in Understanding Domestic Abuse Course Level 2 Certificate in Understanding Domestic Abuse Course Online The goal of this domestic abuse course is to raise students' awareness. Additionally, the types of domestic abuse and their effects are covered in the Level 2 Certificate in Understanding Domestic Abuse course. In addition, the Domestic Abuse: Domestic Abuse Course describes the warning signs, potential dangers, and how to report crimes. Understanding domestic abuse policy and intervention will be made easier with the help of this Level 2 Certificate in Understanding Domestic Abuse course. Who is this course for? Level 2 Certificate in Understanding Domestic Abuse Course Online Anyone who works with or wants to work with vulnerable persons should get this Level 2 Certificate in Understanding Domestic Abuse Course. Special Note: Our Level 2 Certificate in Understanding Domestic Abuse Course is not a regulated course. If you prefer to get qualified, you can look at the following options: NCFE CACHE Level 2 Certificate in Understanding Domestic Abuse Requirements Level 2 Certificate in Understanding Domestic Abuse Course Online To enrol in this Domestic Abuse Course, students must fulfil the following requirements. To join in our Domestic Abuse Course, you must have a strong command of the English language. To successfully complete our Level 2 Certificate in Understanding Domestic Abuse Course, you must be vivacious and self driven. To complete our Level 2 Certificate in Understanding Domestic Abuse Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Level 2 Certificate in Understanding Domestic Abuse Course Career path Level 2 Certificate in Understanding Domestic Abuse Course Online Taking this Level 2 Certificate in Understanding Domestic Abuse Cours can help you land a career in the UK as a psychologist, counsellor, lecturer, or in many other roles.

Level 2 Certificate in Understanding Domestic Abuse Course Do you want domestic abuse to end? You will get a comprehensive grasp of domestic violence, abuse, and the obstacles and particular difficulties that some victims of abuse have by completing this Level 2 Certificate in Understanding Domestic Abuse Course. This Level 2 Certificate in Understanding Domestic Abuse Course covers the long-term effects and the methods used by financial abusers to keep their victims under control. The Level 2 Certificate in Understanding Domestic Abuse Course also discusses the financial and societal effects that domestic violence may have on society. This Level 2 Certificate in Understanding Domestic Abuse Course will teach you about the different kinds of abuse that may happen to children. With the Level 2 Certificate in Understanding Domestic Abuse Course completion, you will know how to spot the warning signs, and how abuse affects children's physical and emotional health throughout time at different developmental stages. Enrol in the Level 2 Certificate in Understanding Domestic Abuse Course to learn about the psychological, emotional, and physical effects that victims of domestic abuse and violence endure. Learning Outcomes of Level 2 Certificate in Understanding Domestic Abuse Course After completing this Level 2 Certificate in Understanding Domestic Abuse Course, the learner will be able to: Understand what domestic violence & abuse is and who is at risk. The Level 2 Certificate in Understanding Domestic Abuse Course helps to understand the dynamics of domestic violence. Gain a solid understanding of the impact of domestic violence on victims through Level 2 Certificate in Understanding Domestic Abuse Course The Level 2 Certificate in Understanding Domestic Abuse Course teaches how to assess the risks of domestic violence and abuse of children. Know how to help children recover from domestic abuse, support the victim and report incidents throughout the Level 2 Certificate in Understanding Domestic Abuse Course. After completing the Level 2 Certificate in Understanding Domestic Abuse Course, you can work with victims of domestic abuse. Main Course: Domestic Violence and Abuse Awareness Diploma Course Special Offers of this Level 2 Certificate in Understanding Domestic Abuse Course This Level 2 Certificate in Understanding Domestic Abuse Course includes a FREE PDF Certificate. Lifetime access to this Level 2 Certificate in Understanding Domestic Abuse Course Instant access to this Level 2 Certificate in Understanding Domestic Abuse Course Get FREE Tutor Support to this Level 2 Certificate in Understanding Domestic Abuse Course Level 2 Certificate in Understanding Domestic Abuse Course Online The goal of this domestic abuse course is to raise students' awareness. Additionally, the types of domestic abuse and their effects are covered in the Level 2 Certificate in Understanding Domestic Abuse course. In addition, the Domestic Abuse: Domestic Abuse Course describes the warning signs, potential dangers, and how to report crimes. Understanding domestic abuse policy and intervention will be made easier with the help of this Level 2 Certificate in Understanding Domestic Abuse course. Who is this course for? Level 2 Certificate in Understanding Domestic Abuse Course Online Anyone who works with or wants to work with vulnerable persons should get this Level 2 Certificate in Understanding Domestic Abuse Course. Special Note: Our Level 2 Certificate in Understanding Domestic Abuse Course is not a regulated course. If you prefer to get qualified, you can look at the following options: NCFE CACHE Level 2 Certificate in Understanding Domestic Abuse Requirements Level 2 Certificate in Understanding Domestic Abuse Course Online To enrol in this Domestic Abuse Course, students must fulfil the following requirements. To join in our Domestic Abuse Course, you must have a strong command of the English language. To successfully complete our Level 2 Certificate in Understanding Domestic Abuse Course, you must be vivacious and self driven. To complete our Level 2 Certificate in Understanding Domestic Abuse Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Level 2 Certificate in Understanding Domestic Abuse Course Career path Level 2 Certificate in Understanding Domestic Abuse Course Online Taking this Level 2 Certificate in Understanding Domestic Abuse Cours can help you land a career in the UK as a psychologist, counsellor, lecturer, or in many other roles.

Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Know Your Customer (KYC) will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Know Your Customer (KYC) will help you keep ahead of the pack. The Know Your Customer (KYC) incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this coursewill add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Know Your Customer (KYC), you can equip yourself with the essentials to keep you afloat into the competition. Along with this Know Your Customer (KYC) course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Know Your Customer (KYC)? Course 01: Know Your Customer (KYC) Course 02: Sales: Psychology of Customers Course 03: Customer Relationship Management Course 04: Phone-Based Customer Service Course 05: Retail Management - Level 5 Course 06: GCSE English Course 07: Public Speaking and Presentation Skill Course Course 08: The Formula to Talk with Strangers Course 09: Level 2 Microsoft Office Essentials Course 10: Time Management Course 11: Stress Management Training So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Know Your Customer (KYC): One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable and in-demand skills without leaving your home. How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum of Know Your Customer (KYC) Bundle Course 01: Know Your Customer (KYC) Module 01: Introduction to KYC Module 02: Customer Due Diligence Module 03: AML (Anti-Money Laundering) Module 04: KYC, AML, and Data Privacy Regulations for Businesses Operations in the United Kingdom Module 05: Regulations to be Complied by Industries Module 06: Methods for carrying out KYC and AML and the Future of KYC Compliance Course 02: Sales: Psychology of Customers Introduction Introducing A.S.K - concentrating on 'A' for ATTRACT. Section 3 The 'S' of A.S.K. - SERVING Section 4 The K of A.S.K Section 5 ...And lastly... Course 03: Customer Relationship Management Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Course 04: Phone-Based Customer Service Module 1: Introduction to Customer Service Module 2: What's Different about Good Customer Service? Module 3: Customer Relationship Management Module 4: Customer Service Communication Strategies Module 5: Aspects of Phone Etiquette Module 6: Building Rapport Over the Phone Module 7: Inbound and Outbound Calls Module 8: Active Listening and Managing Tough Callers Module 9: Managing Interoffice Calls and Voicemail Module 10: Problem Solving over the Phone Module 11: Intra Organisation Dealings Module 12: Measuring Customer Service Course 05: Retail Customer Service Training Module 01: Who We Are and What We Do Module 02: The Sales Process and Dealing with Customers at the Checkout Module 03: Importance of Consumer Behaviour Module 04: Taking Trends and Targeting Customers Effectively Module 05: The Importance of Communicating with Customers Module 06: Identifying and Addressing Customer Needs Module 07: Generating Return Business Module 08: In-Person Customer Service Module 09: Giving Customer Service over the Phone Module 10: Providing Electronic Customer Service Module 11: Recovering Difficult Customers Module 12: Understanding When to Escalate Course 06: GCSE English Module 01: Introduction to GCSE English Module 02: Edexcel English Section A Part 01 Module 03: Edexcel English Section A Part 02 Module 04: Edexcel English Section B Module 05: Edexcel English Section C and many more... Course 07: Public Speaking and Presentation Skill Course Introduction QUICK UNLEARNING Before Starting this "SKILL" IS THIS HAPPENED WITH YOU???? Impressive Methods of Hooking Audience, even before your Speech or Presentation 6 Highly Impressive Methods of Starting any Speech or Presentation!! Body Language: 6 Methods for Impressive Body Language for Speech or Presentation Vocal Variety: 3 Methods (VST) for POWERFUL Vocal Variety Effective Methods of Ending Any Speech or Presentation Bonus Course 08: The Formula to Talk with Strangers Section 01: Course Overview Section 02: The Formula Section 03: Summary Section 04: End Course 09: Level 2 Microsoft Office Essentials ***Excel 2016*** Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks ***Word 2016*** Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Workbooks - Microsoft Word 2016 (Beginner) ***PowerPoint 2016*** PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentatin ***Access 2016*** Introduction to Access Modify Data Working with Queries Access Forms Working with Reports Course 10: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan Course 11: Stress Management Training Beginning Concepts Specific Stress Management Techniques MORE Stress Reduction Strategies Still MORE Stress Reduction Techniques - Part 1 Still MORE Stress Reduction Techniques - Part 2 Still MORE Stress Reduction Techniques - Part 3 BONUS Video & Wrap Up! Special LIVE Bonus Video! CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Know Your Customer (KYC) bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Know Your Customer (KYC) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included