40140 Courses

3 free fun games for you to play with you dog or puppy, that when added to your walk will help with loose lead walking.

Overview Learn about Occupational Therapy from industry experts and boost your professional skill. This Occupational Therapy course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of Occupational Therapy. You'll also gain the skills of Occupational Therapy to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of Occupational Therapy professionals and gain first-hand experience of Occupational Therapy problem-solving. The Occupational Therapy  is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the Occupational Therapy, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This Occupational Therapy will provide you with the latest information and updates of Occupational Therapy. It will keep you one step ahead of others and increase your chances of growth. Please note that completing this online program does not qualify you to work as a licensed Occupational Therapist. Please contact with the HCPC or the RCOT if you are looking for a course that meets the guideline of HCPC. Why buy this Occupational Therapy? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Occupational Therapy you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Occupational Therapy does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Occupational Therapy was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Occupational Therapy is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction to Occupational Therapy About the Course & Instructor 00:06:00 What is Occupational Therapy? 00:06:00 Knowledge & Skills for Occupational Therapy 00:09:00 Working with Adults 00:07:00 Working with Children 00:06:00 (Basic) Anatomy & Physiology The Structure & the Functions 00:08:00 The Blood & the Immune System 00:07:00 What is 'Brain Injury'? 00:07:00 Developmental Disorders & Conditions 00:07:00 Physical Disabilities 00:07:00 Creative & Management Skills The Use of Creative Activities 00:08:00 Management & Leadership Skills 00:06:00 Building Confidence & Self-Esteem 00:05:00 Dealing with Depression 00:08:00 Career Growth in Occupational Therapy Professional Development 00:05:00 Personal & Academic Development 00:05:00 Alternative Career Options 00:09:00 Individual (Client's) Development A Theory of Human Need for Occupation 00:07:00 Occupations for Health & Wellbeing 00:04:00 Coping Strategies (stress) 00:10:00 Maslow's Hierarchy of Needs 00:05:00 Thank You & Good Bye! 00:04:00 Mock Exam Mock Exam - Occupational Therapy 00:20:00 Final Exam Final Exam - Occupational Therapy 00:20:00

Join us for a transformative examination of nurturing compassion inside with our 'MBCT based Self-Compassion Development' course, and set off on a soul-enriching journey. In a mere whisper, our course begins with the gentle embrace of 'Common Humanity' in Section 01. Navigate through the introspective labyrinth of self-treatment, forgiveness, and the Sedona Method. Unveil the profound wisdom of 'I am OK, You're OK' and the art of releasing resistance, with each lesson gently urging you to be patient and tender with yourself. Section 01 culminates in the profound understanding of suffering and the essence of taking care of your inner being. As you gracefully transition into Section 02 on mindfulness, immerse yourself in practices like Cognitive Defusion, Self as Context, Anapana Meditation, and Metta Bhavana Meditation. This course isn't just a guide; it's a poetic odyssey towards self-compassion and mindfulness, inviting you to discover the beauty of your own existence. Learning Outcomes Embrace the concept of 'Common Humanity' and its transformative impact on self-compassion. Cultivate forgiveness and explore the liberating power of the Sedona Method. Internalize the philosophy of 'I am OK, You're OK' for enhanced emotional well-being. Develop resilience by letting go of resistance and practicing patience with oneself. Master mindfulness through techniques like Cognitive Defusion, Self as Context, Anapana Meditation, and Metta Bhavana Meditation. Why choose this MBCT based Self-Compassion Development course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this MBCT based Self-Compassion Development course for? Individuals seeking a profound journey towards self-compassion and mindfulness. Anyone interested in overcoming self-critical thoughts and fostering a positive self-view. Mental health enthusiasts eager to integrate mindfulness practices into their daily lives. Individuals navigating life changes and seeking resilience through self-love. Those on a personal growth journey, open to exploring the transformative power of compassion. Career path Mindfulness Coach: £25,000 - £40,000 Wellness Consultant: £30,000 - £45,000 Holistic Therapist: £28,000 - £50,000 Life Coach: £30,000 - £60,000 Mental Health Educator: £25,000 - £45,000 Personal Development Speaker: £35,000 - £60,000 Prerequisites This MBCT based Self Compassion Development does not require you to have any prior qualifications or experience. You can just enrol and start learning.This MBCT based Self Compassion Development was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Common Humanity Introduction 00:04:00 Overview 00:03:00 How you treat yourself 00:08:00 Mistakes, Forgiveness & Sedona Method 00:11:00 I am OK, You're OK 00:13:00 Letting go of resistance 00:16:00 Be patient with yourself 00:15:00 Taking care of yourself 00:03:00 Understanding Suffering 00:11:00 Section 02: Mindfulness Section Introduction 00:01:00 Cognitive Defusion 00:11:00 Self as Context 00:14:00 Anapana Meditation of Mindfulness 00:05:00 Metta Bhavana Meditation 00:04:00 Conclusion 00:01:00

Join us in building bridges of understanding and inclusion through our CP Awareness and Advocacy course. Learn about the causes, symptoms, diagnosis, treatment, and rehabilitation of Cerebral Palsy, and how to work collaboratively as a team to provide better care planning for children with CP and their families. Learning outcomes: Understand the different types of Cerebral Palsy and their symptoms Identify the causes of Cerebral Palsy Analyse the epidemiology of Cerebral Palsy Understand the principles of treatment and rehabilitation for CP Develop care planning strategies for children with Cerebral Palsy and their families Learn how to work collaboratively as a team with the child, family, and therapists Cerebral Palsy is a neurological condition that affects movement and coordination. This course aims to raise awareness and promote advocacy for individuals with Cerebral Palsy. You will learn about the different types of CP and their symptoms, as well as the causes and epidemiology of the condition. You will also gain an understanding of the diagnosis process and the principles of treatment and rehabilitation for CP, including occupational and physical therapy. Through this course, you will develop skills in care planning and learn how to work collaboratively as a team with the child, family, and therapists. This course is suitable for anyone who wants to learn more about Cerebral Palsy and improve their understanding of the condition. Join us and become a better advocate for individuals with Cerebral Palsy. 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? Healthcare professionals Parents and family members of children with Cerebral Palsy Students pursuing a career in healthcare or therapy fields Advocates and volunteers for disability rights organizations Career path Pediatric Neurologist: £41,000 - £102,000 Occupational Therapist: £24,000 - £40,000 Physical Therapist: £22,000 - £38,000 Speech and Language Therapist: £25,000 - £45,000 Special Education Teacher: £25,000 - £42,000 Disability Rights Advocate: £21,000 - £37,000

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! The Only Level 5 QLS Endorsed Transport Manager Diploma Program in The Market! Everything you need to know about the UK's travel infrastructure in under 4 hours - road, rail, water and air. If you want to become a transport manager, you must know about all the major travel infrastructures in the UK. And in this course, you will learn about all of them. Alongside the infrastructure. Furthermore, you will master how to ensure health and safety as a Transport Manager and How to use the SAP Transportation Management system & Transport Manager. This Diploma in Transport Manager at QLS Level 5 course is: Endorsed by The Quality Licence Scheme Accredited by CPDQS (with 250 CPD points) This course is packed with step-by-step lessons on: Transport Manager Systems (TMS) Transportation Management Strategy Road Freight Transport Laws and Permits Rail and Transport Management for Transport Manager Transport Manager Ports and Inland Waters Transport Manager for Airlines Trends, Challenges and Best Practices in Transport Manager Transport Manager and Health and Safety Each lesson is structured, and the Transport Manager course is made in a way that answers all of your related questions. So you will get everything you need all in one place. Why Choose Our Course: Opportunity to earn a certificate endorsed by the Quality Licence Scheme Get instant access to this course. Learn from anywhere in the world This course is affordable and simple to understand This is an entirely online, interactive lesson with voiceover audio Lifetime access to the Transport Manager course materials Transport Manager comes with 24/7 tutor support *** Course Curriculum of Transport Manager Course *** Module 01: Introduction to Transport Management Overview of transport management principles, key concepts, and the role of transport managers in ensuring efficient logistics and supply chain operations. Module 02: Transport Management Systems (TMS) Introduction to TMS, highlighting automation, route optimisation, real-time tracking, and how it enhances efficiency and customer satisfaction. Module 03: Transportation Management Strategy Covers effective strategies for planning, execution, and performance evaluation in transportation management to achieve business goals and continuous improvement. Module 04: Road Freight Transport Laws and Permits Explains the legal framework, regulations, and permit requirements for road freight transport, emphasising compliance and the impact on operations. Module 05: Rail and Transport Management Discusses the management of rail transport operations, efficiency, safety, and the role of rail in the transportation ecosystem. Module 06: Transport Management for Ports and Inland Waters Focuses on managing transport operations for ports and inland waters, logistics, regulatory compliance, and safety measures. Module 07: Transport Management for Airlines Explores airline transport management, covering scheduling, fleet management, regulatory compliance, and strategies to enhance efficiency and customer experience. Module 08: Trends, Challenges, and Best Practices in Transport Management Analyses current trends, challenges, and best practices, including technological advancements and sustainability in transport management. Module 09: Transport Management and Health and Safety Highlights the importance of health and safety in transport management, covering risk assessment, safety protocols, and regulatory compliance. Assessment Process After completing an online Transport Manager course module, you will be given an MCQ test & The passing score for each test will be set at 60%. After passing the Diploma in Transport Manager at QLS Level 5 exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. CPD 150 CPD hours / points Accredited by CPD Quality Standards Module 01: Introduction 27:59 1: Introduction Video Preview 00:53 2: An Introduction to Successful Transport Management Preview 27:06 Module 02: The UK's Travel Infrastructure - Road and Rail 18:03 3: The UK's Travel Infrastructure - Road and Rail Preview 18:03 Module 03: Road Freight 43:56 4: Road Freight and Transport Management 43:56 Module 04: Passenger Road Transport Management 41:13 5: Passenger Road Transport and its Management 41:13 Module 05: Rail Freight Management 20:50 6: Rail and Transport Management 20:50 Module 06: Ports and Inland Waters Ways Management 19:26 7: Transport Management for Ports and Inland Waters 19:26 Module 07: Airlines Transport Management 12:47 8: Transport Management for Airlines 12:47 Module 08: Trends and Challenges 09:48 9: Trends, Challenges and Best Practice in Transport Management 09:48 Module 09: Health and Safety Management 15:43 10: Transport Management and Health and Safety 15:43 Assessment (Optional) 02:00 11: Assignment On - Diploma in Transport Manager at QLS Level 5 02:00 Order Your Certificate 02:00 12: Order Your CPD Certificate 01:00 13: Order Your QLS Endorsed Certificate 01:00 Who is this course for? This Transport Manager course is for people who want to quickly and easily learn about Transport Management. Aspiring Transport Managers Logistics Enthusiasts Supply Chain Specialists Business Graduates Career Changers Requirements You will not need any prior background or expertise to enrol in this course. Career path UK Annual Salary: Transport Manager (£30,000 - £60,000) Logistics Coordinator (£25,000 - £40,000) Supply Chain Manager (£35,000 - £70,000) Fleet Manager (£30,000 - £50,000) Warehouse Manager (£25,000 - £45,000) Transportation Analyst (£25,000 - £45,000) Certificates Certificate Accredited by CPD Digital certificate - Included

Duration 2 Days 12 CPD hours This course is intended for The primary audiences for the course are as follows: Cisco technical customers (IT, telephony members, etc.) Cisco technology partners Cisco employees Overview Upon completing this course, the learner will be able to meet these overall objectives: Describe the CUIC High-Level Architecture and Deployment considerations Understanding Cisco Unified Intelligence Center Security, License Types and User Security Describe the installation and function of both the Controller Node Member Nodes. CUIC Configurations as well as how to upgrade the product is discussed. Managing Cisco Unified Intelligence Center Components Understanding Cisco Unified Intelligence Center Administration Describe what a Value List is and its function in CUIC Describe how Value Lists are created Describe what a Collection is and when you would use it when running reports Describe what are Report Definitions Describe the creation of Report Definitions and how to build a new Report using the new Report Definition The Cisco Unified Intelligence Center 11.6 for Advanced Users v1.1 (CUIC11.6AU v1.1) course is a 2-day instructor-led training (ILT) course. Cisco Unified Intelligence Center is a comprehensive, end-to-end reporting solution, designed to simplify the task of creating and modifying reports. It also can manage disparate data sources and, at the same time, to present a consistent user interface and a common tool to access varied data across multiple Cisco product families. Cisco Unified Intelligence Center Overview for the Advanced User Understanding Cisco Unified Intelligence Center Deployment Considerations Understanding Cisco Unified Intelligence Center Security, License Types and User Security Installing Cisco Unified Intelligence Managing Cisco Unified Intelligence Center Components Understanding Cisco Unified Intelligence Center Administration Using CUIC Value Lists and Collections as well as Report Definitions Using Value Lists and Collections Using Report Definitions

Dive deep into the intricate realm of construction with the 'Construction Cost Estimation Diploma'. This comprehensive curriculum unfurls the secrets behind effective management in the construction arena, focusing particularly on the nuances of cost estimation. From understanding the foundational concepts of construction management to delving into the pivotal role of cost estimators and the factors that sway cost estimations, this course provides you with an insightful journey into the construction industry's financial landscape. Learning Outcomes Understand foundational principles of construction management. Master the techniques and tools essential for accurate cost estimation. Recognise the pivotal responsibilities and modern approaches adopted by cost estimators. Discern the various elements and influences dictating cost estimation. Gain insight into cost management strategies and effective material management in construction. Why choose this Construction Cost Estimation Diploma? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Construction Cost Estimation Diploma for? Aspiring cost estimators aiming for a comprehensive grasp on their role. Construction managers desiring a deeper understanding of cost dynamics. Professionals in the construction realm eager to advance their financial acumen. Graduates looking to forge a career in construction cost analysis. Individuals intrigued by the financial intricacies of the construction world. Career path Cost Estimator: £35,000 - £45,000 Construction Manager: £40,000 - £60,000 Site Supervisor: £30,000 - £45,000 Quantity Surveyor: £35,000 - £50,000 Project Manager (Construction): £40,000 - £65,000 Materials Manager: £30,000 - £45,000 Prerequisites This Construction Cost Estimation Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Construction Management Introduction to Construction Management 00:07:00 Module 02 : Cost Estimation Cost Estimation 00:16:00 Module 03 : Role of Cost Estimator and New Aspects of Cost Estimation Role of Cost Estimator and New Aspects of Cost Estimation 00:05:00 Module 04 : Elements and Factors influencing Cost Estimation Elements and Factors Influencing Cost Estimation 00:08:00 Module 05 : Cost Estimation in the Construction Industry Cost Estimation in Construction Industry 00:18:00 Module 06 : Cost Management Cost Management 00:09:00 Module 07 : Management of Material for construction Management of Material for construction 00:08:00

This awareness course is suitable for everyone. It provides learners with the knowledge to recognise a suspected mental health condition, the skills to start a conversation, and be able to signpost a person towards professional help.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, and Business Process Owners/Team Leads/Power Users. Overview This course will prepare you to:Describe tasks performed by a typical SAP Access Control userDiscuss Harmonization topics as they relate to SAP Access ControlExplain how SAP GRC helps you to address business challengesIdentify authorization risks in typical business processesDescribe the Segregation of Duties Risk Management ProcessDescribe and configure functionality and features for SAP Access Control 10.1Use the SAP Access Control 10.1 application to analyze and manage risk, design and manage roles, and provision and manage usersDescribe the SAP Access Control 10.1 architecture and landscape, SAP Access Control Repository, and Object Level SecurityDescribe the Periodic Access Review processPlan for and manage emergency accessDiscuss the reporting frameworkConfigure workflows, including multi-stage multi-path (MSMP) workflows and BRF+Describe how the different applications of the SAP GRC Solution integrate with each otherDiscuss key steps in the SAP Access Control implementation process In this course, students gain hands-on configuration and implementation experience of SAP Access Control 10.1, as well as important concepts they will need to know in order to prepare for implementation and ongoing access risk prevention. Introduction to SAP Access Control Discussing Business Challenges and Solutions Using SAP Access Control Architecture, Security, and Authorizations Describing the System Architecture Describing Security and Authorizations Shared Configuration Settings Configuring Shared GRC Settings Configuring Shared SAP Access Control Settings Authorization Risks and the Segregation of Duties (SoD) Management Process Identifying Authorization Risks Managing Risk by Segregating Duties SAP Access Control Repository Synchronizing Objects into the Repository Scheduling and Viewing Background Jobs Risk Analysis Maintaining Shared Master Data Configuring and Maintaining the Rule Set Configuring and Using Audit Trail Tracking Using the Risk Analysis Framework Remediating Risks Mitigating Risks Mitigating Multiple Risks at One Time Business Rule Framework Creating Rules in the Business Rule Framework (BRF) Defining Business Rules Multi-Stage, Multi-Path (MSMP) Workflow Describing Multi-Stage, Multi-Path (MSMP) Workflow Maintaining MSMP Workflow Building MSMP Workflow User Provisioning Configuring User Provisioning Settings Configuring Access Request Forms Requesting Access Preparing Roles and Owner Data for MSMP Workflow Creating Simplified Access Requests Reviewing Search Request Results SAP Fiori User Experience (UX) for GRC Describing SAP Fiori UX Role Design and Management Configuring Role Management Configuring Role Methodology Configuring Role Search Attributes Planning for Technical Role Definition Planning for Business Role Definition Consolidating Roles Through Role Mining Performing Role Mass Maintenance Operations Emergency Access Management Describing Emergency Access Management Planning for Emergency Access Monitoring Emergency Access Periodic Access Review Process Planning Periodic Review Monitoring Periodic Review Reports and Custom Fields Use the Reporting Framework SAP Access Control Implementation Using the SAP Access Control Implementation Process Designing the SAP Access Control Solution Planning Upgrade and Migration Configuring SAP Access Control Implementing the SAP Access Control solution Optimizing the SAP Access Control Suite Additional course details: Nexus Humans GRC300 SAP Access Control Implementation and Configuration 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 GRC300 SAP Access Control Implementation and Configuration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This course is 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 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 three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 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 Module 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 Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 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 Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 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 Additional course details: Nexus Humans 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 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.