5 Peta courses delivered Live Online

Join Dr Andrew Morrice for a deep dive into what the latest mind-body research tells us about the impact of sleep, the microbiome, nutrition, culinary practices and more on our mental and physical health, and recovery … Accredited CPD: 6 hours Length: 1 day (9.15am - 4.00pm GMT) Excellent content and practical applications for treating OCDPETA DUNN, GP Live training delivered online – Join Miriam Chachamu on Tuesday 13th February 2024 for this live online OCD course workshop via Zoom. The content covered is the same as our original attended workshop, with some modifications to the exercises – you will have plenty of opportunities to ask Miriam questions. We will send details of how to join the Zoom workshop by email the day before the event. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Why take this course Obsessive compulsive disorder (OCD) is not only distressing for sufferers but for their family members and friends too. Contrary to the popular view of OCD being harmless over-cleanliness or simply checking things over and over again, people living with OCD experience a high level of anxiety – and the condition can damage their relationships, social and work lives, and physical health. Many sufferers are ashamed of their problem and hide it. Sometimes therapists fail to recognise the rarer forms of OCD and therefore fail to offer effective treatment. And many people with milder forms of OCD do not realise that they can be helped, and do not seek help until their condition becomes much more severe. This accredited live online course offers an in-depth look at OCD in all its guises and focuses on practical and effective methods of treatment – OCD recovery is possible in most cases. The day is interactive and includes demonstration videos of therapy sessions, short video clips, in-depth discussions and case studies. The films of the therapy sessions and the video of dealing with intrusive thoughts were particularly usefulSCHOOL NURSE What will you learn New information that will enable you to help OCD sufferers more effectively A better understanding of OCD, what it is and how it develops The ability to recognise the less familiar types of OCD – these are often missed by both client and therapist An effective 4-step method for treating OCD New ways to help people overcome their compulsive tendencies Illuminating video clips of OCD sufferers describing their experience Helpful ways parents and educators can prevent signs of OCD in children and teenagers from developing further The important role of guided imagery in treatment and why it improves success rates How to separate the person from their OCD ‘Pure O’ – we look at ‘purely obsessional’ OCD, where people experience distressing intrusive thoughts without any external signs of compulsions The chance to observe effective therapy for OCD and discuss case studies How obsessive compulsive disorder fits with other psychological conditions – and with autism What to do when OCD symptoms are firmly entrenched The opportunity to discuss some of your own cases with a highly knowledgeable tutor How to handle challenging cases successfully and more… Course Programme The ‘Obsessive Compulsive Disorder – understanding OCD and how best to treat it’ online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding OCD 11.00am Comfort break and discussion 11.30am How to treat OCD successfully and quickly 1.00pm Lunch break 1.45pm OCD treatment – what to do when symptoms persist 2.45pm Comfort break and discussion 3.00pm Dealing with unusual or challenging cases 4.00pm Day ends Who is this online course suitable for? Anyone who works with, lives with, teaches or treats people suffering from OCD, or who thinks they may have OCD but isn’t sure Psychotherapists, counsellors, health and social care professionals, mental health and wellbeing professionals, educators, school counsellors, individuals working in a variety of capacities in any number of organisations who are looking for OCD training for professionals Anyone who has family members or friends who suffer from OCD would also benefit from this live online course – it contains essential, practical information about how to help OCD sufferers The day is also valuable for anyone struggling to deal with their own obsessive thoughts or actions Please Note: This course is not a substitute for individual therapy This course looks at a range of OCD behaviours, including: Compulsive checkingContamination / Mental ContaminationSymmetry and orderingRuminations / Intrusive thoughts (Pure O)HOCD – Homosexual OCDPOCD – Paedophile OCD / Prenatal and postpartum OCDand more This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Learn the art of silk shading from home

​Learn how to make your very own candles with essential oils, fragrances & colour dyes, using 100% pure eco-soywax. You will learn about the different types of wax, oils, wicks and the methods to making beautiful candles.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature

Duration 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. Introduction to Data on the Google Cloud Platform Highlight Analytics Challenges Faced by Data Analysts Compare Big Data On-Premises vs on the Cloud Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud Navigate Google Cloud Platform Project Basics Lab: Getting started with Google Cloud Platform Big Data Tools Overview Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools Demo: Analyze 10 Billion Records with Google BigQuery Explore 9 Fundamental Google BigQuery Features Compare GCP Tools for Analysts, Data Scientists, and Data Engineers Lab: Exploring Datasets with Google BigQuery Exploring your Data with SQL Compare Common Data Exploration Techniques Learn How to Code High Quality Standard SQL Explore Google BigQuery Public Datasets Visualization Preview: Google Data Studio Lab: Troubleshoot Common SQL Errors Google BigQuery Pricing Walkthrough of a BigQuery Job Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs Optimize Queries for Cost Lab: Calculate Google BigQuery Pricing Cleaning and Transforming your Data Examine the 5 Principles of Dataset Integrity Characterize Dataset Shape and Skew Clean and Transform Data using SQL Clean and Transform Data using a new UI: Introducing Cloud Dataprep Lab: Explore and Shape Data with Cloud Dataprep Storing and Exporting Data Compare Permanent vs Temporary Tables Save and Export Query Results Performance Preview: Query Cache Lab: Creating new Permanent Tables Ingesting New Datasets into Google BigQuery Query from External Data Sources Avoid Data Ingesting Pitfalls Ingest New Data into Permanent Tables Discuss Streaming Inserts Lab: Ingesting and Querying New Datasets Data Visualization Overview of Data Visualization Principles Exploratory vs Explanatory Analysis Approaches Demo: Google Data Studio UI Connect Google Data Studio to Google BigQuery Lab: Exploring a Dataset in Google Data Studio Joining and Merging Datasets Merge Historical Data Tables with UNION Introduce Table Wildcards for Easy Merges Review Data Schemas: Linking Data Across Multiple Tables Walkthrough JOIN Examples and Pitfalls Lab: Join and Union Data from Multiple Tables Advanced Functions and Clauses Review SQL Case Statements Introduce Analytical Window Functions Safeguard Data with One-Way Field Encryption Discuss Effective Sub-query and CTE design Compare SQL and Javascript UDFs Lab: Deriving Insights with Advanced SQL Functions Schema Design and Nested Data Structures Compare Google BigQuery vs Traditional RDBMS Data Architecture Normalization vs Denormalization: Performance Tradeoffs Schema Review: The Good, The Bad, and The Ugly Arrays and Nested Data in Google BigQuery Lab: Querying Nested and Repeated Data More Visualization with Google Data Studio Create Case Statements and Calculated Fields Avoid Performance Pitfalls with Cache considerations Share Dashboards and Discuss Data Access considerations Optimizing for Performance Avoid Google BigQuery Performance Pitfalls Prevent Hotspots in your Data Diagnose Performance Issues with the Query Explanation map Lab: Optimizing and Troubleshooting Query Performance Advanced Insights Introducing Cloud Datalab Cloud Datalab Notebooks and Cells Benefits of Cloud Datalab Data Access Compare IAM and BigQuery Dataset Roles Avoid Access Pitfalls Review Members, Roles, Organizations, Account Administration, and Service Accounts