• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5099 Courses delivered Online

Special Executive Master's Programme in Personal Development Studies

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Personal Development Studies - Education Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. The SEMP Personal Development Studies - Education deals with approaches involved in the learning process, which are useful for tackling the process of organizing and taking in new information for development purposes. Online Students who enroll in this Programme will examine a section of development studies that focuses on personal development, soft skills improvement, and project management. In the modules, participants will also study research and development, business writing, and general communication skills. Study skills are skills that can be learned in a short time and can be applied to all fields or career path. The course provides a solid ground for enhancing your reading and writing skills demonstratable in a professional environment. Apart from inculcating team leadership and project management skills, the course will ensure the learner creates the best business presentations and write academic grade reports and essays. The course also provides a detailed explanation of key tools and concepts for researching and avoiding plagiarism. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Development Studies the right Programme for me? As a professional, manager, or consultant, if you want to develop your individual skills in the following areas, then SEMP Personal Development Studies - Education is the right option for you:  Communication Problem Solving Critical Thinking and Conceptual Skill Creativity Multidisciplinary Approach Research Self- Reflector Why SEMP Development Studies? This non-credit-bearing course examines the various skills needed for the development of professionals across the education field, and how these improved skills can be harnessed together to produce a leading professional. To study comparative development effectively, one must draw upon many disciplines and construct a balanced understanding of historical and contemporary processes. Thus, studying development as a means for social transformation requires a blend of knowledge and perspectives ranging from communication, creative thinking, time management, and self-reflection. Who should enrol in this online Certificate Program? The SEMP Personal development Studies - Education Programme is designed for entry-level managers, up to mid-level managers, senior managers or directors, consultants who are in a general management role or fast approaching such a position and want an opportunity to develop their personal skills. Here is a list of people who can enrol in the Programme. Non-Governmental OrganizationMembers(NGOs) International literacy Professionals Journalists Educators Archivist Consultants Economic Development Advisor Government Relations Advisor Intelligence Officer Policy Analyst Public Administrations Professionals Public Policy Advisor Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa Requirements for this Course as it's an Online Course.

Special Executive Master's Programme in Personal Development Studies
Delivered Online On Demand
£2,500

ITIL 4 Specialist: Create, Deliver and Support: In-House Training

By IIL Europe Ltd

ITIL® 4 Specialist: Create, Deliver and Support: In-House Training The ITIL® 4 Specialist: Create, Deliver, and Support module is part of the Managing Professional stream for ITIL® 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: Create, Deliver, and Support exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. What You Will Learn The learning objectives of the course are based on the following learning outcomes of the ITIL® 4 Specialist: Create, Deliver, and Support exam specification: Understand how to plan and build a service value stream to create, deliver, and support services Know how relevant ITIL® practices contribute to the creation, delivery, and support across the SVS and value streams Know how to create, deliver, and support services Organization and Culture Organizational Structures Team Culture Continuous Improvement Collaborative Culture Customer-Oriented Mindset Positive Communication Effective Teams Capabilities, Roles, and Competencies Workforce Planning Employee Satisfaction Management Results-Based Measuring and Reporting Information Technology to Create, Deliver, and Support Service Integration and Data Sharing Reporting and Advanced Analytics Collaboration and Workflow Robotic Process Automation Artificial Intelligence and Machine Learning CI / CD Information Model Value Stream Anatomy of a Value Stream Designing a Value Stream Value Stream Mapping Value Stream to Create, Deliver, and Support Services Value Stream for Creation of a New Service Value Stream for User Support Value Stream Model for Restoration of a Live Service Prioritize and Manage Work Managing Queues and Backlogs Shift-Left Approach Prioritizing Work Commercial and Sourcing Considerations Build or Buy Sourcing Models Service Integration and Management

ITIL 4 Specialist: Create, Deliver and Support: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£2,295

Special Executive Master's Programme in Financial Management

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Financial Management The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. The SEMP in Financial Management is targeted at finance professionals and other professionals who want to develop a career in finance, and who require a wide-ranging understanding of financial techniques and their application – but do not require a high-level mathematical understanding of finance theories. The SEMP in Financial Management offers specialist studies in the areas of corporate finance, investments, and risk management. It will give online participants a relevant practical knowledge of finance that can be put into use straight away. Careers in finance depend upon a strong understanding of the foundations of finance, investment behaviour, and the dynamic nature of finance, and the SEMP FM will provide a strong preparation for a career in a wide variety of positions within the finance profession. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Financial Management Programme right for me? Understanding non-profit financial reports and improving the ability of an organization to manage solvency issues is key to a sustainable and successful organization. Our online SEMP Financial Management Programme will help Board members, Senior Management, and other team members of your organization understand the ‘money story’, so they can make better decisions about the future of the organization. If you do not have a strong financial background, this three months online course will improve your ability to manage solvency and risk issues and also effectively increase your knowledge of the use of financial information.   Why SEMP Financial Management? SEMP Financial Management helps participants to develop the skills to analyze company financial data accurately and strategically. It focuses on improving executive decision making. This online Programme gives you tools and techniques that provide a comprehensive view of your company, competitors, and potential acquisitions which can help to monitor and forecast performance, measure profitability, assess competitiveness, and analyze restructuring opportunities. Other Benefits include: Financial management plays an involved role in the health of the overall economy, which impacts everyone, regardless of whether or not they have studied finance. Like companies, individuals are faced with investment and financing decisions. Having a firm grasp of finance will help individuals make those decisions. All business functions deal with finance because they need to be able to make the financial argument for the funding of their projects and to manage their budgets. Who should enrol in this online Certificate Program? Advisors working with private equity, including investment bankers, consultants, corporate lawyers or accountants Finance professionals and senior executives who want to understand the implications of private equity for their business, or who want to work in the industry Investors, from pension fund managers to wealth managers seeking to deepen their knowledge of private equity to inform decisions Entrepreneurs or senior executives from large companies seeking private equity funding Private equity professionals wishing to benefit from the latest research and practice Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa Requirements for this Course as its an Online Course.

Special Executive Master's Programme in Financial Management
Delivered Online On Demand
£2,500

Safeguarding Children Level 3

5.0(1)

By Course Gate

Those who are responsible for caring for children on a professional or personal level must be able to demonstrate an awareness of child safeguarding principles, practices and policies. In the Safeguarding Children Level 3 course, you will receive practical training on how to protect the welfare of children and ensure a safe, secure environment for all. This course is ideal for those who work with children such as teachers, social workers and pediatric nurses. On completion, you will be able to show competence in protecting the welfare of children under your care and build solid relationships that encourage trust and personal disclosure. Learning Objective: Understand the fundamental principles, policies & practices of safeguarding children Demonstrate an understanding of your legal responsibilities when safeguarding children under your care and supervision Learn how to recognise the signs of child abuse and how to report your safeguarding concerns Familiarise with the different forms of child abuse: emotional, physical, neglect and sexual abuse Receive practical training on how to conduct a thorough risk assessment Know how to respond to disclosure and when to make a referral to child services Be able to identify the 5ps in child protection and understand the aim of the child protection plan Be able to create a safe and inclusive environment for all where children feel secure Recognise when a child is high-risk and how to take the right precautions Who is This Course for? This safeguarding children training course is ideal for professionals who work with children or are responsible for the care of children. Our online courses are specially designed for distance learning, offering flexible virtual classroom modules that you can study at your own convenience. There are no specific entry requirements for this course, which can be studied part-time or full-time. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Certificate of Completion from Course Gate At the successful completion of the course, the learners may order the Certificate of Completion from Course Gate (soft copy) by paying only £2. For the Printed hard copy of the certificate, the learners have to pay £9. There is an additional £10 delivery charge for international students. Career Path: The Safeguarding Children Level 3 is designed to train those who work with children to become competent professionals, working in compliance with child safeguarding laws and policies. This certificate can be used as proof of your professionalism in the following fields: Teaching Childminding Social care Paediatric care Course Curriculum Safeguarding Children Level 1 Module 1: Introduction to Safeguarding Module 01 : Introduction to Safeguarding 00:21:00 Assessment Module 1 Module 01 Final Quiz Exam - Safeguarding Children Level 3 00:10:00 Module 2: Laws and Guidance Module 02 : Laws and Guidance 00:42:00 Assessment Module 2 Module 02 Final Quiz Exam - Safeguarding Children Level 3 00:10:00 Safeguarding Children Level 2 Module 3: Child Abuse Module 03 : Child Abuse 00:48:00 Assessment Module 3 Module 03 Final Quiz Exam - Safeguarding Children Level 3 00:10:00 Module 4: Sexual Abuse Module 04 : Child Sexual Exploitation 00:39:00 Assessment Module 4 Module 04 Final Quiz Exam - Safeguarding Children Level 3 00:10:00 Module 5: Risks and Risk Assessment Module 05 : Risks and Risk Assessment 00:16:00 Assessment Module 5 Module 05 Final Quiz Exam - Safeguarding Children Level 3 00:10:00 Safeguarding Children Level 3 Module 6: Responding to Disclosure and Reporting Module 06 : Responding to Disclosure and Reporting 00:32:00 Assessment Module 6 Module 06 Final Quiz Exam - Safeguarding Children Level 3 00:10:00 Module 7: Things to Do after Referral Module 07 : Things To Do After Referral 00:22:00 Assessment Module 7 Module 07 Final Quiz Exam - Safeguarding Children Level 3 00:10:00 Module 8: Record Keeping Module 08 : Record Keeping 00:17:00 Assessment Module 8 Module 08 Final Quiz Exam - Safeguarding Children Level 3 00:10:00 Order Your Certificate

Safeguarding Children Level 3
Delivered Online On Demand5 hours 17 minutes
£11.99

Communicating complexity

By Fire Plus Algebra

Successful communications are all about making the message as simple as possible – but this can be difficult when the subjects we're talking about are inherently complicated.  Academic institutions, tech companies, health organisations, charities and many others have complex ideas, processes and systems at the heart of what they do.  This course is for anybody who needs to distill information down into key messages for important stakeholders, funders and investors, decision makers and members of the public.  You’ll learn proven techniques for grabbing attention and changing minds through presentations and public speaking, infographics and data visualisations, and written reports and online posts.  We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve. Sample learning content Session 1: Understanding your audience Matching your objectives to your audience's motivations. Identifying the right tone and language. Understanding how, where and when your audience wants to be spoken to. Session 2: Refining your objectives  Breaking down strategic aims into tactical steps Metrics and milestones: defining and measuring progress and success. Rapidly building a brief for your communications. Session 3: Telling the story  Using metaphors, visuals, comparisons to frame your narrative. From slide decks to online campaigns - choosing the right formats for delivering your message. Selecting communications channels to maximise reach and impact. Session 4: Keeping it going  Processes and systems for launching and maintaining communications campaigns. Building social proof – creating and curating content. Troubleshooting and preparing for common challenges. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “We’ve now worked with Alan for almost 3 years, and during that time he has continued to deliver the highest quality training for our clients and delegates. Alan’s passionate delivery style has continued to deliver innovative training solutions to over 1500 delegates across the public, private and voluntary sector. Each of our courses with him has always delivered exceptional feedback and satisfaction levels.” Joe Barlow | Head of Programme, Understanding ModernGov

Communicating complexity
Delivered OnlineFlexible Dates
£2,405.97

Total NetFlow for engineers

5.0(3)

By Systems & Network Training

Total NetFlow training course description A comprehensive hands on course covering NetFlow. The course starts with the basics of flows moving swiftly onto configuring NetFlow and studying the information it provides. What will you learn Describe NetFlow. Configure generators and collectors. Recognise how NetFlow can be used. Describe the issues in using NetFlow. Compare NetFlow with SNMP, RMON and sflow. Total NetFlow training course details Who will benefit: Technical staff working with NetFlow. Prerequisites: TCP/IP Foundation Duration 2 days Total NetFlow for engineers What is NetFlow? Flows. Where to monitor traffic. Hands on Wireshark flow analysis. Getting started with NetFlow NetFlow configuration. Hands on Accessing NetFlow data using the CLI. NetFlow architecture Generators and collectors. When flows are exported. NetFlow reporting products. SolarWinds. Hands on Collector software. NetFlow features and benefits Real time segment statistics, real time top talkers, traffic matrices. Hands on Traffic analysis with NetFlow. NetFlow issues NetFlow impact, agent resources, server resources, comparing NetFlow with SNMP, RMON and sflow. Hands on Advanced NetFlow configuration. Export formats Flow aging timers, NetFlow versions, export formats, templates, IPFIX. Hands on NetFlow packet analysis. NetFlow MIBs The NetFlow MIB, configuration, retrieving NetFlow statistics. Hands on Integrating NetFlow with SNMP.

Total NetFlow for engineers
Delivered in Internationally or OnlineFlexible Dates
£1,727

ITIL 4 Strategist: Direct, Plan and Improve: Virtual In-House Training

By IIL Europe Ltd

ITIL® 4 Strategist: Direct, Plan and Improve: Virtual In-House Training The ITIL® 4 Strategist: Direct, Plan, and Improve course is based on the ITIL® 4 Strategist Direct, Plan, and Improve candidate syllabus from AXELOS. This course is based on the ITIL® 4 Strategist: Direct, Plan and Improve IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. This course provides the practical skills necessary to create a 'learning and improving' IT organization, with a strong and effective strategic direction. It was designed to provide practitioners with a practical and strategic method for planning and delivering continual improvement with necessary agility. It covers both practical and strategic elements, making it the universal module that is a key component to both ITIL® 4 Managing Professional and ITIL® 4 Strategic Leader streams. What You Will Learn At the end of this course, participants will be able to: Understand the key concepts of direction, planning, improvement Understand the scope of what is to be directed and/or planned and know how to use key principles and methods of direction and planning in that context Understand the role of GRC and know how to integrate the principles and methods into the service value system Understand and know how to use the key principles and methods of continual improvement for all types of improvements Understand and know how to use the key principles and methods of Communication and Organizational Change Management to direction, planning and improvement Understand and know how to use the key principles and methods of measurement and reporting in direction, planning, and improvement Understand and know how to direct, plan, and improve value streams and practices Course Introduction Let's Get to Know Each Other Course Overview ITIL® 4 Certification Scheme Course Learning Objectives Course Components Course Agenda Exercises Case Study: Axle Car Hire Case Study: HandyPerson on Demand Exam Details Core Concepts of DPI Key Terms Covered in the Module Module Learning Objectives Basics of Direction Basics of Planning Basics of Improvement Other Core Elements DPI through Service Value Chain and Guiding Principles Key Terms Covered in the Module Module Learning Objectives DPI of the SVS DPI of Guiding Principles Role of Direction in Strategy Management Key Terms Covered in the Module Introducing Strategy Management Developing Effective Strategies Implementation of Strategies Key Terms Covered in the Module Module Learning Objectives Managing Risks Making Decisions through Portfolio Management Directing via Governance, Risk, and Compliance (GRC) Introduction to Assessment and Planning Key Terms Covered in the Module Module Learning Objectives Core Concepts of Assessment Conducting Effective Assessments Core Concepts of Planning Assessment and Planning through VSM Key Terms Covered in the Module Module Learning Objectives Introducing VSM Developing Value Stream Maps Knowing More About VSM Measurement, Reporting, and Continual Improvement Key Terms Covered in the Module Module Learning Objectives Measurement and Reporting Alignment of Measurements and Metrics Success Factors and Key Performance Indicators Continual Improvement Measurements and Continual Improvement through Dimensions and SVS Key Terms Covered in the Module Module Learning Objectives Measurements for the Four Dimensions Continual Improvement of the Service Value Chain and Practices OCM Principles and Methods Key Terms Covered in the Module Module Learning Objectives Basics of OCM OCM throughout DPI and Service Value Chain Resistance and Reinforcement Communication Principles and Methods Key Terms Covered in the Module Module Learning Objectives Basics of Effective Communication Communication with Stakeholders SVS Development Using Four Dimensions Key Terms Covered in the Module Module Learning Objectives Organizations and People in the SVS Partners and Suppliers in the SVS Value Streams and Processes in the SVS Information and Technology in the SVS

ITIL 4 Strategist: Direct, Plan and Improve: Virtual In-House Training
Delivered OnlineFlexible Dates
£2,150

55232 Writing Analytical Queries for Business Intelligence

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

55232 Writing Analytical Queries for Business Intelligence
Delivered OnlineFlexible Dates
£1,785

ITIL 4 Specialist: Drive Stakeholder Value: In-House Training

By IIL Europe Ltd

ITIL® 4 Specialist: Drive Stakeholder Value: In-House Training The ITIL® 4 Specialist: Drive Stakeholder Value module is part of the Managing Professional stream for ITIL 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: Drive Stakeholder Value exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. What You Will Learn The learning objectives of the course are based on the following learning outcomes of the ITIL® 4 Specialist: Drive Stakeholder Value exam specification: Understand how customer journeys are designed Know how to target markets and stakeholders Know how to foster stakeholder relationships Know how to shape demand and define service offerings Know how to align expectations and agree on details of services Know how to onboard and offboard customers and users Know how to act together to ensure continual value co-creation (service consumption / provisioning) Know how to realize and validate service value Customer Journey Purpose of the Module Purpose of Mastering the Customer Journey Touchpoints and Service Interactions Module Topics Mapping the Customer Journey Designing the Customer Journey Measuring and Improving the Customer Journey Customer Journey Step 1: Explore Purpose of the Module Purpose of the Explore Step Module Topics Understanding Service Consumers Understanding Service Providers Understanding and Targeting Markets Customer Journey Step 2: Engage Purpose of the Module Purpose of the Engage Step Aspects of Service Value Module Topics Service Relationship Types Building Service Relationships Building and Sustaining Trust and Relationships Analyzing Customer Needs Managing Suppliers and Partners Customer Journey Step 3: Offer Purpose of the Module Purpose of Shaping Demand and Service Offerings Module Topics Managing Demand and Opportunities Specifying and Managing Customer Requirements Designing Service Offerings and User Experience Selling and Obtaining Service Offerings Customer Journey Step 4: Agree Purpose of the Module Purpose of Aligning Expectations and Agreeing on Services Module Topics Agreeing on and Planning Value Co-Creation Negotiating and Agreeing on a Service Customer Journey Step 5: Onboard Purpose of the Module Purpose of Onboarding and Offboarding ITIL® Management Practices Module Topics Planning Onboarding Fostering Relationships with Users Providing User Engagement and Delivery Channels Enabling Users for Service Elevating Mutual Capabilities Offboarding Customer Journey Step 6: Co-create Purpose of the Module Purpose of Service Provision and Consumption Module Topics Service Mindset Ongoing Service Interactions Nurturing User Communities Customer Journey Step 7: Realize Purpose of the Module Measuring Service Value Purpose of Value Capturing and Customer Journey Improvement Realizing Service Value in Different Settings Module Topics Tracking Value Realization Assessing and Reporting Value Realization Evaluating Value Realization and Improving Customer Journeys Realizing Value for the Service Provider

ITIL 4 Specialist: Drive Stakeholder Value: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£2,295

Business and Data Analysis With SQL

4.7(160)

By Janets

Unlock the power of data with our comprehensive course on Business and Data Analysis with SQL. Learn essential SQL skills to extract meaningful insights, make data-driven decisions, and drive business success. Whether you're a beginner or looking to enhance your expertise, our course empowers you with the tools and knowledge needed to excel in the dynamic world of data analysis. Enroll now to master SQL for business intelligence and elevate your analytical skills to new heights.

Business and Data Analysis With SQL
Delivered Online On Demand3 weeks
£9.99