3681 Courses delivered Live Online

Understand and mitigate your own personal drivers of conflict

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.

Learn The Art of Smudging Learn everything you need to know to confidently begin incorporating this powerful Smudging Ceremony into your life today! Smudging is a practice of connecting with the Spirit of specific plants and herbs to help cleanse, uplift, protect, and unite the physical and spiritual planes. Ancient traditions all around the world have incorporated the practice of smudging into their ceremonies. Now is your time to connect with “that which is greater than us”.

STGO Abnormal Loads

Safer recruitment training became mandatory for the recruitment of school staff from 1 January 2010. This means a recruitment panel must have at least one member who has completed the training, or where an individual is in charge of recruitment, that individual must have completed the training. It is the responsibility of schools to comply. It is recommended that anyone recruiting into the wider children’s workforce be trained.

leadership management training course

leadership management training course

Take a look at this new Mental Health First Aid course at Knight Training. Watching over your mental health is very important, having this knowledge can be of use at any environment, and is suitable for anyone. Come get train with us at https://knight.training/products/mental-health-online-mh-first-aid?variant=43369922199787

Essential CPD to deepen your understanding and develop your skills as a therapist CPD Certificate: 3 hours Length: 9.45am – 1.00pm (GMT) LIMITED PLACES – Feb date now full Join Ros Townsend live online on Tuesday 8th October 2024 for this important CPD course, designed specifically for mental health professionals interested in the human givens approach. BONUS – you will get a recording for 2 weeks afterwards to maximise your learning. There are many occasions when a client presents with an excessive emotional response and it is not immediately apparent why this is happening. Perhaps they know that they are ‘over-reacting’ in some way – getting very angry, very fearful – or are experiencing a driven urge to take a particular action – such as eating or having sex. This live online course will help you gain confidence in working safely and ethically with affect bridges to discover if an unhelpful pattern, in the form of a molar memory or sub-threshold trauma is at the root of their experience, allowing you to then determine collaboratively with your client the best ways of addressing that. During the course, there will be plenty of opportunity to ask questions of the tutor, and to engage in exercises and discussions with your peers and colleagues. Why take this course Whether you are a new HG therapist wanting to develop a clear understanding of how to utilise an affect bridge to determine if a molar memory or sub-threshold trauma is present, and to better understand the protocols for working with these, or whether you are an experienced HG practitioner looking to refresh your knowledge and delve deeper into understanding this valuable skillset, this course will help you gain the skills and understanding you need to do so safely and effectively. In an early article regarding molar memories, Joe Griffin termed them ‘an ancient mechanism that is ruining lives’; and the impact of such driven urges on the lives of our clients cannot be underestimated. Molar memories can, on first encountering the theory, seem complicated and unfathomable, but this course will set them – and sub-threshold traumas and the use of the affect bridge to access both – within a clear framework of understanding, linking back to the way in which our brain perceives things (referencing the APET model) and to RIGAAR (how we structure a good therapy session). During the course, numerous case studies will be shared and used as the basis for exercises, and there will be ample opportunity to link the learning to your own experiences in the therapy room. You will gain a clear understanding of: how to follow the treatment protocols for working with molar memories and sub-threshold traumas – adapting these, of course, to each client’s unique model of reality; how to safely and ethically utilise an affect bridge; and how to avoid the danger of creating any false memories. Ros is a brilliant teacher and presenter. She made the whole course interesting, engaging and informative as well as very supportive. She was also very patient with all our questions!GEMMA ROGERS, COUNSELLOR/COACH What the training covers: How APET and RIGAAR relate to one another Why an understanding of APET is essential when working with affect bridge What an affect bridge is How to use affect bridge safely and ethically within your therapy sessions How to avoid the risk of creating false memories Why we must proceed with caution when undertaking affect bridges when working online The difference (in this context) between ‘positive’ and ‘negative’ The tell-tale patterns of a sub-threshold trauma and a molar memory being present A framework to understand the presentations of both sub-threshold traumas and molar memories How to identify a sub-threshold trauma An understanding of the treatment protocol for sub-threshold traumas How to identify a molar memory An understanding of the treatment protocol for molar memories Why molar memories sometimes present differently in complex trauma How to use the understanding of APET and help clients to utilise affect bridge as a positive tool within their lives Who is this course suitable for? This course is designed for both trainee and fully-qualified HG therapists It is also suitable for any mental health professionals interested in the human givens approach It is recommended to all HG practitioners by the Human Givens Institute (HGI) Timings 9.45 am – Join Zoom 10.00 am – Course session starts 1.00 pm – Course ends In any online training it’s important to build in regular breaks and ensure that every 20 minutes there is a shift in focus of attention to pull the eyes away from the screen. There will be two 10–15 minute comfort breaks during the training and regular opportunities for discussion and exercises in break-out rooms. Meet your tutor Rosalind Townsend Ros Townsend is an experienced psychotherapist and supervisor with busy practices in SW England, where she combines private therapy work with referrals from Occupational Health and the NHS. Read more

This course provides the delegate with the theoretical and practical skills to undertake non-licensed works with ACM's. Persons requiring this type of training would include trade operatives undertaking tasks with ACM's as defined in HSG210 and in accordance with CAR 2012 Reg 3(2). In addition to the Asbestos Awareness, those employees whose work will knowingly disturb ACMs, and which is defined as non-licensable work or NNLW, should receive additional task-specific information, instruction and training.