319 Courses in Cardiff delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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 Developers who have some familiarity with serverless and experience with development in the AWS Cloud Overview In this course, you will learn to: Apply event-driven best practices to a serverless application design using appropriate AWS services Identify the challenges and trade-offs of transitioning to serverless development, and make recommendations that suit your development organization and environment Build serverless applications using patterns that connect AWS managed services together, and account for service characteristics, including service quotas, available integrations, invocation model, error handling, and event source payload Compare and contrast available options for writing infrastructure as code, including AWS CloudFormation, AWS Amplify, AWS Serverless Application Model (AWS SAM), and AWS Cloud Development Kit (AWS CDK) Apply best practices to writing Lambda functions inclusive of error handling, logging, environment re-use, using layers, statelessness, idempotency, and configuring concurrency and memory Apply best practices for building observability and monitoring into your serverless application Apply security best practices to serverless applications Identify key scaling considerations in a serverless application, and match each consideration to the methods, tools, or best practices to manage it Use AWS SAM, AWS CDK, and AWS developer tools to configure a CI/CD workflow, and automate deployment of a serverless application Create and actively maintain a list of serverless resources that will assist in your ongoing serverless development and engagement with the serverless community This course gives developers exposure to and practice with best practices for building serverless applications using AWS Lambda and other services in the AWS serverless platform. You will use AWS frameworks to deploy a serverless application in hands-on labs that progress from simpler to more complex topics. You will use AWS documentation throughout the course to develop authentic methods for learning and problem-solving beyond the classroom. Introduction Introduction to the application you will build Access to course resources (Student Guide, Lab Guide, and Online Course Supplement) Thinking Serverless Best practices for building modern serverless applications Event-driven design AWS services that support event-driven serverless applications API-Driven Development and Synchronous Event Sources Characteristics of standard request/response API-based web applications How Amazon API Gateway fits into serverless applications Try-it-out exercise: Set up an HTTP API endpoint integrated with a Lambda function High-level comparison of API types (REST/HTTP, WebSocket, GraphQL) Introduction to Authentication, Authorization, and Access Control Authentication vs. Authorization Options for authenticating to APIs using API Gateway Amazon Cognito in serverless applications Amazon Cognito user pools vs. federated identities Serverless Deployment Frameworks Overview of imperative vs. declarative programming for infrastructure as code Comparison of CloudFormation, AWS CDK, Amplify, and AWS SAM frameworks Features of AWS SAM and the AWS SAM CLI for local emulation and testing Using Amazon EventBridge and Amazon SNS to Decouple Components Development considerations when using asynchronous event sources Features and use cases of Amazon EventBridge Try-it-out exercise: Build a custom EventBridge bus and rule Comparison of use cases for Amazon Simple Notification Service (Amazon SNS) vs. EventBridge Try-it-out exercise: Configure an Amazon SNS topic with filtering Event-Driven Development Using Queues and Streams Development considerations when using polling event sources to trigger Lambda functions Distinctions between queues and streams as event sources for Lambda Selecting appropriate configurations when using Amazon Simple Queue Service (Amazon SQS) or Amazon Kinesis Data Streams as an event source for Lambda Try-it-out exercise: Configure an Amazon SQS queue with a dead-letter queue as a Lambda event source Writing Good Lambda Functions How the Lambda lifecycle influences your function code Best practices for your Lambda functions Configuring a function Function code, versions and aliases Try-it-out exercise: Configure and test a Lambda function Lambda error handling Handling partial failures with queues and streams Step Functions for Orchestration AWS Step Functions in serverless architectures Try-it-out exercise: Step Functions states The callback pattern Standard vs. Express Workflows Step Functions direct integrations Try-it-out exercise: Troubleshooting a Standard Step Functions workflow Observability and Monitoring The three pillars of observability Amazon CloudWatch Logs and Logs Insights Writing effective log files Try-it-out exercise: Interpreting logs Using AWS X-Ray for observability Try-it-out exercise: Enable X-Ray and interpret X-Ray traces CloudWatch metrics and embedded metrics format Try-it-out exercise: Metrics and alarms Try-it-out exercise: ServiceLens Serverless Application Security Security best practices for serverless applications Applying security at all layers API Gateway and application security Lambda and application security Protecting data in your serverless data stores Auditing and traceability Handling Scale in Serverless Applications Scaling considerations for serverless applications Using API Gateway to manage scale Lambda concurrency scaling How different event sources scale with Lambda Automating the Deployment Pipeline The importance of CI/CD in serverless applications Tools in a serverless pipeline AWS SAM features for serverless deployments Best practices for automation Course wrap-up Additional course details: Nexus Humans AWS Developing Serverless Solutions on AWS 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 AWS Developing Serverless Solutions on AWS 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.

WOUND CARE AND MANAGEMENT. INTRODUCTION FOR HEALTH CARE ASSISTANTS AND NURSES

Master Yourself in Talking with Strangers Course Overview This course, Master Yourself in Talking with Strangers, is designed to empower learners with essential communication skills to confidently initiate and sustain conversations with unfamiliar people. It explores effective techniques to overcome social anxiety, build rapport quickly, and engage meaningfully in diverse social settings. Through structured guidance, learners will develop greater self-awareness and adaptability in interactions, enhancing their personal and professional relationships. By the end of the course, participants will be equipped with the tools to initiate conversations naturally, listen actively, and respond with confidence, making social interactions more rewarding and less daunting. Course Description Master Yourself in Talking with Strangers offers an in-depth exploration of the skills necessary to communicate effectively with new acquaintances. Topics include understanding body language, mastering conversation openers, managing nervousness, and cultivating empathy. Learners will engage with practical strategies for navigating different social contexts and recognising cues that facilitate connection. This course provides a supportive learning environment aimed at increasing social confidence and emotional intelligence. By completing this programme, participants will enhance their interpersonal skills, enabling smoother introductions, more engaging dialogues, and the ability to foster new relationships in both personal and professional spheres. Master Yourself in Talking with Strangers Curriculum Module 01: Course Overview Module 02: The Formula Module 03: Summary Module 04: End (See full curriculum) Who Is This Course For? Individuals seeking to improve their confidence in social interactions. Professionals aiming to enhance networking and communication skills. Beginners with an interest in developing interpersonal abilities. Anyone looking to overcome social anxiety and connect more easily with others. Career Path Customer Service Representative Sales and Marketing Executive Networking and Business Development Specialist Public Relations Officer Community Engagement Coordinator

Course Overview: The "Oral Health Care" course is designed to provide a comprehensive understanding of the essential concepts and practices in maintaining optimal oral health. Learners will explore a wide range of topics, from the basics of oral hygiene to the management of common oral health issues and preventive strategies. The course equips learners with the knowledge necessary to support dental care practices effectively. By the end of the course, participants will have developed a solid understanding of oral health, preventive care, and the importance of ongoing maintenance. This course offers valuable insights for those looking to advance their knowledge in dental care or enhance their qualifications in the health sector. Course Description: This course covers a range of topics designed to enhance learners' understanding of oral health care. Modules will guide participants through the fundamentals of oral health, common issues like tooth decay and gum disease, and preventive dentistry techniques. Emphasis is placed on promoting oral health, particularly in children and special populations. Learners will gain insights into the relationship between diet and oral health, as well as the importance of ongoing maintenance to prevent future complications. By completing this course, learners will be prepared to contribute to effective oral health care strategies and will acquire valuable knowledge to apply in various healthcare and dental settings. Course Modules: Module 01: Introduction to Oral Health Care Module 02: Fundamentals of Oral Health Module 03: Common Oral Health Issues Module 04: Preventive Dentistry Module 05: Oral Health Promotion in Children Module 06: Oral Health Care for Special Populations Module 07: Dental Care Procedures Module 08: Oral Health and Nutrition Module 09: Oral Health Maintenance and Beyond (See full curriculum) Who is this course for? Individuals seeking to improve their knowledge of oral health care. Professionals aiming to enhance their understanding of dental health. Beginners with an interest in pursuing a career in health and dental care. Anyone looking to gain a deeper understanding of oral health issues and prevention. Career Path Dental Care Assistant Oral Health Educator Community Health Worker Public Health Specialist Dental Practice Manager

Emergency Care Assistant - (First Aid) Course Overview: This Emergency Care Assistant - (First Aid) course provides essential knowledge and skills for those interested in responding to emergency situations. Focusing on first aid techniques, learners will be equipped to assess, manage, and treat injuries and illnesses until professional help arrives. Covering critical aspects such as CPR, secondary injuries, and illnesses, this course ensures that participants are confident and prepared to act effectively. By completing this course, learners will gain the competence to provide emergency assistance in a variety of settings, helping to save lives and mitigate harm in urgent situations. Course Description: The Emergency Care Assistant - (First Aid) course covers vital topics including the principles of first aid, how to conduct a secondary survey, and the management of common injuries and medical conditions. Learners will explore the correct methods for performing CPR, identify secondary illnesses, and understand how to address a variety of emergency medical situations. The course is designed to offer a structured and comprehensive learning experience, incorporating theoretical and practical elements to ensure learners develop the necessary skills to provide emergency care. By the end of this course, participants will be fully equipped to assess, manage, and treat injuries and illnesses effectively, contributing to improved emergency response capabilities in any situation. Emergency Care Assistant - (First Aid) Curriculum Module 01: The Aim of First Aid Module 02: The Secondary Survey Module 03: Treating Secondary Injuries Module 04: Resuscitation (CPR) Module 05: Secondary Illnesses and Conditions Module 06: Additional Secondary Illnesses and Conditions (See full curriculum) Who is this course for? Individuals seeking to gain first aid knowledge and response skills. Professionals aiming to enhance their emergency response capabilities. Beginners with an interest in healthcare or emergency services. Anyone wanting to contribute to safety and well-being in their community. Career Path: Emergency Care Assistant First Aid Trainer Healthcare Support Worker Paramedic Assistant Fire and Rescue Support Staff

Course Overview: The Diploma in Social Work Studies Level 5 provides learners with an in-depth understanding of social work, covering key theories, methods, and practices within the field. Designed to enhance knowledge of both theoretical and practical aspects, this course equips students with the skills to navigate the complexities of social care. Learners will gain a broad understanding of working with vulnerable populations, professional conduct, and various intervention models. Upon completion, students will be well-prepared to contribute to the social work sector, providing essential support to individuals and communities. Course Description: This course explores a range of core topics within social work, including the foundational theories, casework processes, and the diverse contexts in which social work practice occurs. Students will delve into the different models of intervention and the role of social workers within multidisciplinary teams. The programme offers insight into working with adults, understanding the principles of conduct, and the professional responsibilities of a social care worker. Throughout the course, learners will develop critical skills in managing casework and applying relevant theories to real-world situations. The course is structured to provide learners with a comprehensive understanding of social work principles, preparing them for future careers in this essential field. Course Modules: Module 01: An Overview of Social Work Module 02: Social Work Basics Module 03: Theories of Social Work and Sociology Module 04: Casework Process and Teamwork Module 05: Dimensions of Social Work / Models of Intervention Module 06: Practice Contexts and Application Module 07: Working with Adults Module 08: Principles of Conduct and Role as Social Care Worker (See full curriculum) Who is this course for? Individuals seeking to pursue a career in social work Professionals aiming to advance in the social care sector Beginners with an interest in social work and sociology Anyone wanting to understand the role of social workers in society Career Path Social Worker Social Care Practitioner Adult Social Care Worker Community Support Worker Social Care Team Leader

Online Fire Safety Course Course Overview This Online Fire Safety Course provides comprehensive knowledge essential for understanding fire hazards, prevention, and emergency response. Designed to equip learners with the skills to identify fire risks and implement effective safety measures, the course covers current UK fire safety legislation, prevention strategies, and evacuation procedures. Learners will gain confidence in recognising potential fire dangers and understanding their responsibilities to maintain a safe environment. Suitable for individuals across various sectors, the course ensures participants can contribute effectively to fire safety awareness and compliance within their workplace or community. Upon completion, learners will be well-prepared to support fire safety initiatives and promote safer environments. Course Description This course delves into the fundamental aspects of fire safety, starting with an introduction to fire risks and causes. It explores key UK fire safety laws and regulations, ensuring learners understand legal responsibilities. The course covers preventive measures, including fire detection systems and risk assessments, and provides detailed guidance on emergency evacuation procedures. Throughout the course, learners will develop critical skills to assess hazards, plan safety measures, and respond appropriately during fire incidents. The structured content is delivered through clear explanations and informative materials, enabling learners to apply knowledge confidently within their roles. This course is ideal for those wishing to expand their understanding of fire safety principles and regulatory compliance in a professional context. Online Fire Safety Course Curriculum Module 01: Introduction to Fire Safety Module 02: Fire Safety Legislation Module 03: Measures of Fire Safety Module 04: Fire Emergency Evacuation Procedures (See full curriculum) Who Is This Course For? Individuals seeking to enhance their knowledge of fire safety principles. Professionals aiming to develop their competence in workplace safety compliance. Beginners with an interest in fire prevention and emergency planning. Managers responsible for health and safety within their organisation. Career Path Fire Safety Officer Health and Safety Coordinator Facilities Manager Compliance Advisor Emergency Planning Officer

Course Overview The Fashion and Lifestyle Blogging course is designed to equip aspiring bloggers with the essential knowledge, strategies, and inspiration to succeed in the vibrant digital landscape. From setting up a blog to curating compelling content and engaging audiences across social platforms, learners will explore the full blogging journey. This course emphasises brand building, collaboration opportunities, and monetisation strategies, offering real-world insights into navigating the blogging industry. Upon completion, learners will be able to create, manage, and promote a professional blog with a confident understanding of personal branding, photography, networking, and industry partnerships. Whether aiming to establish an independent blog or to enhance a professional portfolio, learners will gain skills that are transferable across the broader fields of media, marketing, and communications. Course Description This comprehensive course in Fashion and Lifestyle Blogging provides an in-depth exploration of the key elements required to build a successful blog. Learners will be guided through the foundations of blogging, content creation techniques, photography essentials, and social media engagement strategies. Special attention is given to networking, brand collaboration, and monetisation opportunities, empowering learners to transform their passion into a sustainable presence. The course also covers branding principles and offers pathways for continued growth within the blogging sphere. Through structured modules, participants will acquire a thorough understanding of the digital environment and sharpen their skills in storytelling, image curation, and community building. By the end of the programme, learners will possess the confidence to carve out a distinctive online identity and explore diverse opportunities within the dynamic worlds of fashion, lifestyle, and digital media. Course Modules Module 01: Blogging 101 Module 02: Starting Out and Setting Up Module 03: Content Creation Module 04: Photography and Imagery Module 05: Staying Social Module 06: Networking and Events Module 07: Working with Brands Module 08: Monetising Your Blog Module 09: Building a Brand Module 10: Growing as a Blogger Module 11: The Fashion and Lifestyle Blogger Roundup (See full curriculum) Who is this course for? Individuals seeking to build a professional presence in blogging. Professionals aiming to expand into the digital media and influencer sectors. Beginners with an interest in fashion, lifestyle, and online content creation. Creatives and entrepreneurs looking to establish or enhance their personal brand. Social media users wishing to transition into content creation careers. Career Path Fashion Blogger Lifestyle Content Creator Digital Marketing Assistant Brand Collaboration Coordinator Influencer Marketing Specialist Social Media Manager Creative Content Consultant PR and Communications Officer

Instagram Marketing Masterclass Course Overview: This Instagram Marketing Masterclass provides a comprehensive guide to mastering Instagram for business growth. Learners will explore strategies for building a strong brand presence, engaging with followers, and utilising Instagram's various features to drive traffic and sales. The course covers content creation, advertising, analytics, and influencer marketing. By the end, learners will be equipped with the knowledge to enhance their social media marketing skills, enabling them to optimise campaigns, increase visibility, and measure success effectively. Course Description: In this in-depth course, learners will delve into the essential elements of Instagram marketing, covering everything from setting up an effective profile to advanced advertising techniques. Key topics include developing a content strategy, understanding Instagram's algorithm, creating visually appealing posts, and leveraging Instagram Stories and Reels. Learners will also gain insights into performance analytics, helping them to assess campaign success and adjust strategies accordingly. By the end of the course, participants will have a thorough understanding of how to drive engagement and build a loyal following on Instagram, allowing them to make informed decisions that align with their business goals. Instagram Marketing Masterclass Curriculum: Module 01: Introduction to Instagram Marketing Module 02: Creating Engaging Content for Instagram Module 03: Understanding Instagram's Algorithm Module 04: Instagram Advertising and Promotions Module 05: Using Instagram Stories and Reels for Growth Module 06: Analytics and Measuring Instagram Performance Module 07: Building Your Brand and Growing Your Following Module 08: Collaborating with Influencers on Instagram Module 09: Advanced Instagram Marketing Strategies (See full curriculum) Who is this course for? Individuals seeking to enhance their social media marketing skills. Professionals aiming to elevate their brand presence online. Beginners with an interest in social media marketing. Small business owners or marketers looking to leverage Instagram. Digital marketing enthusiasts eager to understand Instagram's full potential. Career Path: Social Media Manager Digital Marketing Specialist Brand Manager Content Creator Influencer Marketing Strategist Online Marketing Consultant Community Manager