12087 Courses in Cardiff delivered Online

The Level 4 Certificate for Higher Level Teaching Assistants (HLTA) is a UK OFQUAL accredited, 100% online, competency-based Teaching Assistant (TA) qualification.

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.

Discover Ethereum blockchain development with our comprehensive course. From the fundamentals of Solidity to advanced topics such as NFTs and Truffle, we will gain practical skills through hands-on projects. Whether a beginner or an experienced developer, this course equips us with the tools and knowledge to excel in Ethereum blockchain development.

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner Advanced™ training (PSPO Advanced) to master the role of a Product Owner. Learn how to advance your training of Product Ownership and apply it to deliver even more value. Course Description Agile techniques and the Scrum framework revolutionise project and product delivery, enabling teams to work faster and align closely with business needs. A product owner's role within this delivery is critical. Unlike traditional team managers, Product Owners focus on maximising product value rather than individual elements of project delivery. To excel in this role, product owners must combine business strategy with product vision and delivery roadmaps. The ability to operate within complex environments highlights the need for specific training and qualifications. Product Owner Advanced training is specifically designed to empower experienced Product Owners to deliver greater value. An exceptional Product Owner requires skillsets beyond core Agility and Scrum. These include clear decision-making, vision, communication, and influence. Practical experience is highly valued, and the PSPO 2 course emphasises interactive workshops, discussions, and exercises to provide a comprehensive understanding of the multifaceted Product Owner role. This course elevates existing Product Owners' capabilities, providing a clear path for your professional growth and delivering increased value to product stakeholders. Through collaborative and exploratory training, Product Owners' knowledge and experience will reach new heights, improving various aspects of your role. Key areas covered include: Deepening understanding of the Product Owner role, including product understanding, customer identification, and effective communication of product vision and strategy. Leveraging product vision and strategy to gain a competitive edge. Embracing diverse roles and stances essential for Product Owners. Enhancing stakeholder communication and management skills with a focus on different stakeholder groups. Navigating Agile governance, budgeting, and contracting within the Scrum framework. Scaling the Product Owner role for larger projects and products. By the end of this product owner advanced training, participants will be equipped to excel as Product Owners, driving success and value across their product journey. Why Train With Us? Develop advanced product owner skillsets that build on your existing knowledge of the Scrum framework and product owner accountabilities with our immersive two-day online PSPO Advanced course. Led by experienced industry professionals and support Professional Scrum Trainers & Product Owners, the course values team-based exercises and a hands-on learning experience. We help you grow within your Product Owner role through this advanced training, enabling you to better communicate product vision and strategy to teams, ultimately delivering higher value through projects and products with larger scopes. Who Should Attend This Course? The Professional Product Owner – Advanced course is designed for: Experienced Product Owners, ideally with at least one year of experience in the role Scrum Masters and stakeholders collaborating with Product Owners Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Our one-day sleep workshop aims to provide healthcare professionals with evidence based knowledge to develop their theoretical and practical understanding of how to assess and manage sleep difficulties in pre-school children. It is an opportunity for you to enhance your sleep knowledge, add skills to your current professional tool box and feel confident in supporting young families with sleep. We have developed the workshop content and delivery to be highly engaging, interactive and relevant to all community staff working with families with young children experiencing sleep issues. Child focused, gentle, responsive and firmly grounded in research and evidence-based practice our training follows the Baby Friendly Initiative. The content will focus on practical evidence based issues relating to sleep assessment and identify interventions to guide and support parents and carers. This one-day workshop is accredited for 6 CPD Hours by The CPD Certification Service; “This is a good course delivering clear learning value.” Workshop Aims To provide community staff with up-to-date evidence based knowledge to develop their theoretical and practical understanding of sleep needs; sleep patterns; sleep cycles and common difficulties. To support community staff to enhance their confidence, skills and knowledge base in providing guidance to parents regarding sleep difficulties in pre school children. To provide an overview of evidence based gentle and responsive interventions used to help sleep difficulties in young children. Workshop Outcomes With the use of assessment tools – by the end of the day delegates will be able to: Understand typical sleep regulations, sleep needs and sleep cycles. Understand common sleep difficulties. Provide education to families on establishing good sleep hygiene, and provide anticipatory advice in the prevention of sleep difficulties. Understand how to undertake a sleep assessment for an infant and child, incorporating a sleep history and the use of a sleep diary. Gain an understanding of common sleep interventions used to help behavioural sleep difficulties in pre school children.

This is a masterclass in managing emotions at work, leveraging the power of self-understanding along with effective conflict management strategies to achieve successful outcomes

This workshop gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue,namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system. Course Category Meeting emotional needs Description This workshop gives an opportunity to focus on the emotional needs of boys and how to meet these. We lift the lid on an emerging urgent inclusion issue,namely meeting the emotional needs of boys. Everyone knows a boy. They may be pupil, son, brother, parent or partner. Boys when they become adults are over represented in the prison, and mental health system. In one recent year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. Three men for every one woman kill themselves every year (Guardian, June 2006). 1 in 4 women experience domestic violence and 2 women a week are killed by a current or ex partner. Boys and men are a major concern. We need to find ways to allow them to unclench their hearts and learn to experience, process, communicate and manage their own emotional lives for their own and for the good of the wider community. Testimonials ‘Thanks for a super day, lots of good ideas for our citizens of the future. We need to offer them the best and what we would offer our own children’?? ‘Enjoyed the day very much. Brilliant ideas and lots of food for thought. Will use the solution circle. A great tool!’ ‘went well and the ethos/participation was commendably facilititated. well done’. ‘Wonderful day!’ ‘Still getting lots of positive messages this end.’ Learning Objectives Increased understanding of boys’ emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion of boys Opportunity to reflect on professional attitudes and behaviour towards boys and their emotional challenges New skills and processes to make boys’ inclusion and achievement more successful Who Is It For ? Early years and school based practitioners Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content The course explores the questions : Is there a problem with boys? What can we do to meet the emotional needs of boys? What helps? What should our priority be with boys? This workshop will explore: Cultural and historical expectations of boys in our society Shared experiences of teaching and parenting boys Circle of Courage as away of understanding emotional needs Fathers, mothers and sons Drinking and drugs: filling the emotional void Depression and suicide Anger and violence Solution Circle Problem Solving around boys needs What boys really need

This fast track Diploma in Continuing Professional Development (CPD) for Leadership (Accredited by Qualifi, UK) qualification has been created to develop CPD (continuing professional development) in Leadership, for those who want to draw from their personal experience and develop their leadership understanding and skills, professionally academically and practically for their personal and professional development. The focus of this qualification is the exploration and practical research into leadership as a subject in order to apply this knowledge into a new environment. The fast track Level 7 Diploma in Continuing Professional Development (CPD) in Leadership qualification will require Learners to critically evaluate, challenge and synthesise a wide range of current leadership roles, tools, techniques and models. The emphasis placed on current Leadership concepts and models is on those that are relevant to the 21st century business environment and context and goes beyond the normal examination of Anglo-American management models. Program Overview: Diploma in CPD (Continuing Professional Development) for Leadership - Level 7 (Fast Track) Key Highlights of fast track Diploma in CPD (Continuing Professional Development) for Leadership - Level 7 qualification are: Program Duration: 3 Months (Regular Mode Available) Program Credits: 60 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Masters Degree programme. Alumni Status No Cost EMI Option Career Progression after completion of your Diploma in Continuing Professional Development for Leadership qualification: Learners completing the fast track Diploma in Continuing Professional Development for Leadership - Level 7 can progress to: A University partner to complete a Dissertation to then receive a full master's degree, subject to approval or Directly into employment in an associated profession University Exemptions QUALIFI has exemptions for learners to progress to a number of universities to complete a Master's Degree after completing their Diploma in Continuing Professional Development for Leadership - Level 7 in fast track mode. The pathways are an indication of a learner's progress towards a university degree and are based on the university's review of QUALIFI's learning programmes and outcomes. As our Qualifi accredited qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation) and Qualifications Wales, learners are also eligible to progress to a Top-Up Degree, Master's programme, or MBA at many universities in UK and Overseas with advanced standing.

Recent studies show a surge in interest in Agricultural Science, Horticulture, and Gardening, with a notable increase of 35% in enrollment in related courses worldwide. This trend underscores the growing recognition of the importance of sustainable agriculture and green spaces in addressing global challenges such as food security and environmental conservation. In response to this demand, our comprehensive Agricultural Science, Horticulture and Gardening QLS Endorsed Diploma bundle offers a holistic approach to education, blending theoretical knowledge with practical applications. With a focus on QLS-endorsed diplomas and CPD QS-accredited courses, participants can expect a rigorous yet rewarding learning experience that equips them with the necessary skills and knowledge to excel in this dynamic field. Delve into the intricate world of Agricultural Science, Horticulture, and Gardening with our Agricultural Science, Horticulture, and Gardening bundle designed to nurture personal and professional growth. Explore the complexities of botany, forestry, and arboriculture while gaining insights into reproduction in flowering plants and the fundamentals of hydroponics gardening. Enhance your understanding of land and environment management, paving the way for sustainable practices and innovative solutions. Moreover, sharpen your career development, CV writing, networking, and presentation skills to carve a successful path in this thriving industry. Bundle Include includes: QLS Endorsed Courses: Course 01: Diploma in Gardening at QLS Level 5 Course 02: Diploma in Horticulture Training at QLS Level 5 Course 03: Diploma in Agricultural Science at QLS Level 5 CPD QS Accredited Courses: Course 04: Botany Course 05: Forestry Course 06: Arboriculture Course 07: Reproduction in Flowering Plants Course 08: Hydroponics Gardening Online Course Course 09: The Basics of Reproduction Course 10: Land Management Course 11: Environment Management Take your career to the next level with our bundle that includes technical courses and five guided courses focused on personal development and career growth. Course 12: Career Development Plan Fundamentals Course 13: CV Writing and Job Searching Course 14: Networking Skills for Personal Success Course 15: Ace Your Presentations: Public Speaking Masterclass Course 16: Decision-Making and Critical Thinking Seize this opportunity to elevate your career with our comprehensive Agricultural Science, Horticulture and Gardening bundle, endorsed by the prestigious QLS and accredited by CPD. Agricultural Science, Horticulture and Gardening QLS Endorsed Diploma. Learning Outcomes: Gain a comprehensive understanding of Agricultural Science, Horticulture, and Gardening. Master essential concepts in botany, forestry, and arboriculture. Develop proficiency in reproduction techniques for flowering plants. Acquire practical skills in hydroponics, gardening and land management. Learn strategies for effective environmental management and conservation. Enhance career development, networking, and presentation abilities for professional success. Embark on a multifaceted exploration of Agricultural Science, Horticulture, and Gardening with our comprehensive Agricultural Science, Horticulture, and Gardening bundle course. Delve into the foundational principles of plant biology, understanding the intricate mechanisms behind growth, development, and reproduction. Through in-depth modules on botany, forestry, and arboriculture, participants will unravel the complexities of plant life from the molecular level to ecosystem dynamics. Gain practical insights into plant propagation techniques and cultivation practices, empowering you to nurture diverse plant species confidently and precisely. Navigate the evolving landscape of sustainable agriculture and environmental stewardship as you delve into hydroponics gardening, land management, and environmental conservation. Discover innovative resource utilisation and ecosystem management approaches, equipping you with the tools to address pressing global challenges such as climate change and biodiversity loss. With a blend of theoretical knowledge and practical applications, this Agricultural Science, Horticulture, and Gardening course offers a transformative learning experience, empowering individuals to become catalysts for positive change in Agricultural Science, Horticulture, and Gardening. CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Agricultural Science, Horticulture, and Gardening course is ideal for: Aspiring horticulturists seeking to expand their knowledge and skills. Professionals in the agriculture sector aiming to enhance their expertise. Individuals passionate about sustainable gardening and environmental conservation. Career changers interested in pursuing opportunities in the green industry. Students eager to explore the fascinating world of botany and plant sciences. Entrepreneurs looking to establish or expand their presence in the gardening market. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon completion of the Agricultural Science, Horticulture, and Gardening courses, you will be able to: Horticulturist Agricultural Scientist Environmental Consultant Botanist Landscape Designer Nursery Manager Greenhouse Technician Certificates 13 CPD Quality Standard Certificates Digital certificate - Included 3 QLS Endorsed Certificates Hard copy certificate - Included