45122 Courses

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.

Course Introduction Covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms Please note: this course is for health care professionals and nurses only. About this event Course Introduction This course concentrates on B12 deficiency, symptoms, treatments and management. The course covers B12 deficiency, pernicious anaemia, diagnosis, treatment and management. It also covers signs and symptoms of pernicious anaemia. This course is interactive and we include case studies and discuss issues regarding diagnostic testing.  We review inclusion and exclusion criteria and identification of appropriate clients. Delegates will get the opportunity to review practice with hands on practical demonstrations of how to give injections correctly. We will cover administration techniques, where to give the injections and record keeping / documentation. We will discuss role and responsibilities and contraindications and precautions. The delegates will leave this course with an example of an individual protocol of Patient Specific Direction (PSD) and a competence based framework document to be used in practice. This course is very interactive. AIMS AND OBJECTIVES Understand the need for accountability and responsibility in relation to role development Demonstrate an understanding of safe practice Describe the signs and symptoms of pernicious anaemia Describe pernicious anaemia and its impact on patients Fully understand the principles, and practice B12 deficiency and B12 injections Understand the importance of safety issues related to giving injections Understand the law relating to role and function of the HCA and prescribing. Describe why patients require B12 injectionsBe able to correctly identify anatomical sites for injections Demonstrate correct administration techniquesDemonstrate how to correctly dispose of waste Demonstrate correct infection control procedures and use of PPE Describe when patients require referral and understand the importance of referral using correct clinical pathways Demonstrate an understanding of anaphylaxis and emergency procedures Understand the need for correct prescribing procedures Be able to document consultations following your organisations procedures     COURSE CONTENTS Role and responsibilities Accountability guidelines and requirements Pernicious anaemia Blood- function B12 Deficiency Risk factors/groups Causes of B12 deficiency Diagnosis and reference ranges, testing Protocols and guidelines Factors affecting B12 diagnosis and treatment Factors affecting absorption B12 injections and common side effects Could it be B12 Deficiency Supplements Side effects and management including ADR’s Anaphylaxis Contraindications and Precautions Correct Administration and techniques including practical session Injection sites Legal Issues including consent Prescribing and Patient Specific Directions What to record Storage Disposal of injections/waste Infection control Needle stick injuries Competence and supervised practice Policies and procedures Facts and Figures Setting up and running a clinic Insurance/indemnity Research/evidence base and resources WHO SHOULD ATTEND? HCAs Nurses Doctors Pharmacists Anyone interested in Vitamin B12 deficiency and pernicious anaemia and those working with clients with B12 deficiency AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.

Description Here at iStudy, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses. Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this How to Earn from Home Training. The certification that you will receive upon completing this How to Earn from Home Training will help to boost your resume and will help you stand out among your peers in the competitive job market. Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from iStudy. Enrol now! Why You Should Choose How to Earn from Home Training Lifetime access to the course No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? How to Earn from Home Training is CPD Qualification Standards and CiQ accredited, and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our How to Earn from Home Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Earning Money from Home Course Promo 00:03:00 Lesson 1 - Introduction: Making Money From Home 00:03:00 Lesson 2 - Latest Ways to Earn Money Online 00:08:00 Lesson 3 - Work from home jobs for beginners 00:07:00 Lesson 4 - Best Selling Niches for making money online 00:10:00 Lesson 5 - How to make money from an awesome blog 00:08:00 Lesson 6 - How to make money selling online courses 00:09:00 Lesson 7 - How to sell your photos online for more cash 00:06:00 Lesson 8 - How to make money as a freelance writer 00:07:00 Lesson 9 - How to make money from customer service jobs from home 00:06:00 Lesson 10 - How to be a Virtual Assistant and start making income 00:07:00 Lesson 11 - How to make money with a podcast 00:05:00 Lesson 12 - How to make money on Amazon 00:09:00 Lesson 13 - How to make money with transcription jobs 00:05:00 Lesson 14 - How to make money as an online proofreader 00:06:00 Lesson 15 - Making money with membership sites 00:07:00

Get ready for an exceptional online learning experience with the Phlebotomy Training bundle! This carefully curated collection of 30 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Phlebotomy Training is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Phlebotomy Training package has something for everyone. As part of the Phlebotomy Training package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Phlebotomy Training bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Phlebotomy Training CPD Accredited Courses: Course 01: Phlebotomist Training Course 02: Infection Prevention Training Course 03: Sterile Compounding Preparations Online Training Course 04: Medical Transcription Course 05: Medical Terminology Training Course 06: Medical Law Course 07: Nurse Prescribing Diploma Course 08: Practice Nurse Course 09: IsiXhosa for Healthcare: The Nurse Course 10: Introduction to Vaccination Course 11: Diploma in Medical Secretary Course 12: Clinical Coding Course 13: Level 3 Diploma in Anatomy and Physiology of Human Body Course 14: Dermatology & Skin Anatomy Course 15: First Aid at Work Course 16: Paediatric First Aid Training Course 17: Mental Health First Aid Course 18: Diabetes Awareness (Type 1 & 2) Course 19: Public Health and Safety Course 20: Epidemiology Course 21: Consent Training in Healthcare Course Course 22: Community Practice Nurse Course 23: Personal Hygiene Course 24: Health and Social Care Management Course 25: Safe Handling of Medicines Course 26: Career Development Plan Fundamentals Course 27: CV Writing and Job Searching Course 28: Learn to Level Up Your Leadership Course 29: Networking Skills for Personal Success Course 30: Motivation - Motivating Yourself & Others What will make you stand out? Upon completion of this online Phlebotomy Training bundle, you will gain the following: CPD QS Accredited Proficiency with this Phlebotomy Training bundle After successfully completing the Phlebotomy Training bundle, you will receive a FREE CPD PDF Certificates as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Phlebotomy Training bundle The online test with immediate results You can study and complete the Phlebotomy Training bundle at your own pace. Study for the Phlebotomy Training bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Phlebotomy Training bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Phlebotomy Training, a rich anthology of 30 diverse courses. Each course in the Phlebotomy Training bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisPhlebotomy Training bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Phlebotomy Training bundle offers you the flexibility and convenience to learn at your own pace. Make the Phlebotomy Training package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Phlebotomy Training bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements You are cordially invited to enroll in this Phlebotomy Training bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Unleash your potential with the Phlebotomy Training bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Phlebotomy Trainingbundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Quality Standard Certificates - Free

Introduction to Project Management: Virtual In-House Training This course provides practical insights into what is project management and how it is performed in a structured manner. 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. What you Will Learn You will learn how to: Articulate on the basics of the project management profession Explain project management terms and concepts in practice Speak on how projects originate in mature organizations Employ a disciplined approach to initiating, planning, and managing projects to closure Identify and describe the roles and responsibilities of key project stakeholders Consider standard project processes to implement based upon the PMBOK® Guide 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 Summary and Next Steps Review of goals, objectives, key concepts, and expectations Evaluations

This course covers road-tow equipment - from legal checks, tyres, lighting through to brake checks, adjustment and repairs. Ideal for tool hire, plant hire. CPA Members HAE Members and IPAF Members for their Fitters, mechanics, technicians, Check and Test, Test and Run, PDI Techs, not forgetting Charities or other organisations who run maintain or sell trailer mounted items nd those that sell, deal in or refurbish equipment.

Premium Bundle of all Time | Ofqual Regulation + NCFE Awards + CPD Accreditation | Assessment & Tutor Support Included

Critical Thinking and Creative Problem Solving: In-House Training Two critical skillsets for the future of work are critical thinking and creative problem solving. These modes of working and thinking intersect and overlap; both are necessary and both can be taught. Having the ability to exercise creativity while at the same time applying structure and discipline to the thinking process is a key competency in the twenty-first century workplace. This course explores the interplay between critical and creative thinking, and the necessity of each to effective problem solving and decision making. Participants will learn a variety of techniques to apply critical thinking to real-life scenarios. They will experiment with different problem-solving approaches and will learn about cognitive influences on our decisions and choices. The course delves into the business value of creativity and involves participants in actively integrating criticality, creativity, and problem solving. What you will Learn At the end of this program, you will be able to: Explain basic concepts of problem solving Infer types of cognitive biases that impact decision making Utilize types of root cause analysis Differentiate among obstacles to sound decision making Apply a variety of problem-solving approaches / processes to existing challenges Evaluate alternative solution methods using various techniques Analyze real world problem scenarios to determine the lateral thinking type needed to address them Foundation Concepts Definitions Thinking modes and cognitive bias Basic problem-solving framework Problem Definition and Solution Generation Root cause analysis Basic problem-solving obstacles Generating alternative solutions Evaluating Alternatives Critical thinking guidelines Obstacles to sound decision making Tools for evaluating alternatives Exploring Lateral Thinking Problem-solving challenge Workplace application

Special Needs: Special Needs Training This Special Needs: Special Needs Training is designed for those interested in or who are currently in a SENCO role in the early years setting. This Special Needs: Special Needs Training qualification provides learners with a thorough understanding of the roles and responsibilities of the Special Educational Needs Coordinator in early years setting. Learn about the strategies and techniques for assisting children and their families and gain in-depth knowledge of SEN codes of practice. The purpose of this Special Needs: Special Needs Training course is to help learners progress to further and higher education and develop new practical skills in health and social care. Special Offers of this Special Needs: Special Needs Training Course This Special Needs: Special Needs Training Course includes a FREE PDF Certificate. Lifetime access to this Special Needs: Special Needs Training Course Instant access to this Special Needs: Special Needs Training Course Get FREE Tutor Support from Monday to Friday in this Special Needs: Special Needs Training Course ***Courses are included in this Special Needs: Special Needs Training*** Course 01: SENCO: Special Educational Needs Coordination Course 02: Level 3 Certificate in Understanding Autism Course 03: Level 4 Childcare and Development Course [ Note: Free PDF certificate as soon as completing the Special Needs: Special Needs Training course] Special Needs: Special Needs Training Course curriculum of Special Needs: Special Needs Training Industry Experts Designed this Special Needs: Special Needs Training course into 02 detailed modules. Module 01: Roles and Responsibilities of the Special Educational Needs Coordinator in the Early Years Module 02:Strategies and Techniques for Supporting Children and Families Assessment Method of Special Needs Training After completing each module of the Special Needs Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Special Needs Training After completing the MCQ/Assignment assessment for this Special Needs Training course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Special Needs: Special Needs Training This Special Needs: Special Needs Training is ideal for those already working in a SENCO role as part of their Early Years Practitioner role or interested in doing so. This Special Needs: Special Needs Training is also suitable for childminders. Requirements Special Needs: Special Needs Training Students who intend to enrol in this Special Needs: Special Needs course must meet the following requirements: Special Needs: Good command of the English language Special Needs: Must be vivacious and self-driven Special Needs: Basic computer knowledge Special Needs: A minimum of 16 years of age is required Career path Special Needs: Special Needs Training Certificates Certificate of completion Digital certificate - Included

The Call Centre & Customer Service Training Course is designed to help call center professionals expertly handle customer calls and ensure that every caller receives the best possible service. You will get provide with the skill building in every aspect of handling calls from customers such as the use of probing techniques, voice control, what to say when, rapport building and much more. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? Call Centre & Customer Service Training Course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject. Course Content Call Centre & Customer Service Training Course - Updated Version Introduction to Customer Service 00:25:00 What's Different about Good Customer Service? 00:14:00 Customer Relationship Management 00:44:00 Customer Service Communication Strategies 00:26:00 Aspects of Phone Etiquette 00:33:00 Building Rapport Over the Phone 00:26:00 Inbound and Outbound Calls 00:18:00 Active Listening and Managing Tough Callers 00:30:00 Managing Interoffice Calls and Voicemail 00:12:00 Problem Solving over the Phone 01:06:00 Intra Organisation Dealings 00:37:00 Measuring Customer Service 00:14:00 Call Centre & Customer Service Training Course - Old Version Call Centre & Customer Service Training Course Module One - Getting Started 00:15:00 Module Two - The Basics (I) 00:30:00 Module Three - The Basics (II) 00:30:00 Module Four - Phone Etiquette 01:00:00 Module Five - Tools 01:00:00 Module Six - Speaking Like a Star 00:30:00 Module Seven - Types of Questions 00:15:00 Module Eight - Bench marking 00:20:00 Module Nine - Goal Setting 00:30:00 Module Ten - Key Steps 00:20:00 Module Eleven - Closing 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Call Centre & Customer Service Training Course- Activities 00:00:00 Mock Exam Mock Exam- Call Centre & Customer Service Training Course 00:20:00 Final Exam Final Exam- Call Centre & Customer Service Training Course 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.