1103 Courses in Cardiff delivered 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.

Mental Health First Aid (MHFAider) is an internationally recognised training course that teaches people how to spot the signs and symptoms of mental ill health and provide help on a first aid basis. We don't teach people to be therapists, but we do teach people how to respond in a crisis, and how to reach out before a crisis happens. The training gives people tools to support themselves and each other, so everyone can talk about mental health and seek help when needed. As an MHFAider you will be able to: Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other support Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the role in depth, including boundaries and confidentiality Practise self-care This course is ideal for those who would like to become an MHFAider to: Gain the knowledge and skills to spot signs of people experiencing poor mental health Be confident starting a conversation and signpost a person to appropriate support Alongside the best evidence-based Mental Health First Aid (MHFA) training, MHFAiders are also provided with three-year access to ongoing learning and support through the MHFAider Support App 1 Introduction to MHFAider (3 hours 30 mins) MHFA and the MHFAider role Introduction to the MHFAider Action Plan 'ALGEE' What is Mental Health? Helpful and unhelpful language Undersign our Frame of Reference, understanding how we make sense of the world Understanding stress & the Stress Container 2 Understanding Mental Health (4 hours) What influences mental health? The Mental Health Continuum What is anxiety? What is a traumatic event? Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? MHFA conversation practice 3 MHFAider in practice (4 hours) Applying ALGEE What is depression? What is suicide? What is psychosis? MHFA conversation practice 4 Next steps (3 hours) Recovery and lived experience Applying ALGEE Boundaries in the MHFAider role MHFA conversation practice Moving forward in the MHFAider role and your MHFA action plan Self-care

This highly practical one-day workshop has been designed specifically to help maximise sales where customers make contact by telephone. When customers contact us direct they have clearly already considered the possibility that they might buy from us, but we're still only half-way to making a sale. Unless we fully understand their needs and make it easy for them to buy, we may not secure the business. This workshop concentrates on the telephone skills and techniques needed to achieve the most positive outcome in any inbound customer call. A combination of excellent customer service skills and savvy sales awareness techniques will increase our chances of a successful outcome for both parties. The programme features the unique INBOUND model, to help remember the key principles for effective inbound telephone sales: Initial impressions Needs of the customer Bring them with you Open up the conversation Understand the triggers Narrow down the solutions Decision time! The programme also covers how to deal with difficult calls and challenging people - after all, every complaint is a sales opportunity! This programme will help participants: Create the perfect interaction with any customer making contact by telephone Make every call count Build rapport quickly in any situation Handle difficult calls and challenging people Create sustainable and profitable relationships Increase your sales conversions 1 The inbound sales process Each customer who contacts us will be at a different stage of the sales process. Some might be making general enquiries whilst others will be ready to commit, having made most of their decisions already. Sales and customer service people need to be ready to find out the stage the customer has reached before helping them to make the right decision for them 2 Engaging with the customer Having clarified where the customer is on their journey to making a purchasing decision, our next responsibility is to create and build a trusting relationship on both sides. This involves establishing rapport quickly to ease the communication process, thus enabling smooth transactions, both now and in the future 3 Questioning and listening skills for gathering information Developing these skills requires practice so that the communication becomes natural for the customer. This helps the customer to feel comfortable with us and work with us towards an effective solution. We discuss different types of question and how to use high-gain questions to uncover key information. Active listening will ensure that we can really help customers get what they need 4 Overcoming objections and excuses If we have followed the process properly and really understood the customer, then there should no further objections or barriers to completing the transaction. The reality is that there will still be the occasional issue that needs clarifying, so we need to prepare for possible objections and questions that customers might have. This includes probing objections so that we fully understand the customer's perspective before constructing suitable responses or solutions 5 Gaining commitment and ending the call Customers want to gain a solution to the issue they are facing and the sooner we can help them achieve that the better. Guiding the customer and helping them to believe in their own decision is part of our role. This section is dedicated to getting commitment all the way along the process, not just at the close 6 Dealing with difficult and challenging situations The realisation that everybody is different, with different personality types, different ways of looking at the world and different goals, is key to understanding sales. With this is mind we discuss these differences and how we adapt our approach to ease communication and maintain trust and understanding 7 Action plans Course summary and presentation of action plans

Learners will be able to demonstrate much improved awareness of pressure sores and understand how they can help positively impact the service users' lives. They will be able to identify the function of the different layers of skin, highlight how and why pressure sores form, understand how they can prevent them and have a better understanding of the dressings, aids, and equipment used.

Company Accounting - tax return, Annual accounts and Annual return Training Course If you want to work in a Finance or Tax department of a business or as an accountant in well-known accountancy firms it is vital that you know how to prepare accounts for the company and submit them to the right places. This UK Tax accounting course will upgrade your skills to higher level. Completing this course will enable you learn more about the procedures involved in submitting Corporate Tax Return. Once you are skilled on this, you can offer this as a service to potential business clients and earn £££. If you are running a business you can process your own Business Tax return and Accounts, instead of paying someone else to do it. It will save a lot of money (£££) every year. You will stay ahead of the competition if you are looking for a job in the Accounting or Tax Industry once you are skilled Business Accounting and Tax procedures. Identifying requirements to set up a UK Company Identifying Statutory Requirements for Companies Introduction to Confirmation Statement processing Identifying Types of Companies based on size Identifying Types and requirements of various Submissions available Identifying minimum requirements in a Balance Sheet and Profit & Loss Account Identifying Tax Return periods and deadlines Identifying Penalties for Late filing Identifying Closing Down Procedures for Companies Introduction to the Filing Company accounts procedure Company house forms and correspondences Understanding of IXBRL requirements Understanding submission procedures using HMRC Online CT600 (Webfiling) Using one Business(SME/Micro Entity) case to understand the procedures on Annual Submission for Company Tax Return and Accounts submission

Understand the Mental Toughness model and look at how to improve your mental toughness with the 4c’s. Course overview Duration: 1 day (6.5 hours) Mental toughness is the ability to resist, manage and overcome doubts, worries, concerns and circumstances that prevent you from succeeding, or excelling at a task or towards an objective or a performance outcome that you set out to achieve. Our one day programme can help you to achieve this by using tools and techniques to help you perform under pressure and ensure your wellbeing. Objectives  By the end of the course you will to: Identify the causes of stress and how to prevent them Assess your mental toughness using the MTQ48 measure Use tools and techniques to develop your mental toughness Content Understanding Stress, Pressure and Challenge The causes of stress How stress can manifest itself Threat response The Stress performance curve Stress, challenge and pressure Positive stress Mental Toughness, Stress Management and Resilience Defining stress management, resilience and mental toughness How they differ and how they affect each other Mental Toughness Understanding mental toughness The importance of mental toughness The benefits of developing your mental toughness The 4 Cs of Mental Toughness How we approach Challenge Control our emotions Develop Confidence Create Commitment MTQ48 Profile Understanding your MTQ48 profile Looking at your mental toughness Areas for development Developing Mental Toughness Managing physical energy to deal with stress Developing healthy habits for managing stress Multitasking and the ability to focus Identifying unhelpful thought patterns Positive and pragmatic thinking approaches Managing your approach to change and challenge Ways of developing mental toughness

A 5 day mindfulness challenge to help you bring mindfulness into your day

A free sampler for the Motorcycle Skills - Improve your Riding in Eight Weeks online e-course from Survival Skills Rider Training

Free Hypnosis Training: Discover Hypnotherapy with SFTA Join us for an exciting online event where you can explore the fascinating world of hypnotherapy. Hosted by the renowned Solution Focused Training Academy Focused, this workshop session is perfect for anyone curious about the power of hypnosis. Whether you're a beginner or have some experience, this event will provide valuable insights and techniques to enhance your understanding. Starting on Tues 3Oth April 2024, at 7.00 pm, our expert trainers will guide you through the fundamentals of hypnotherapy. Discover how hypnosis works its applications in various fields, and learn practical tips to induce hypnotic states. Through interactive sessions and engaging discussions, you'll gain a deeper understanding of the mind and its potential. Don't miss this unique opportunity to delve into the world of hypnotherapy. Reserve your spot today and embark on a journey of self-discovery and personal growth. Register now for this FREE event and unlock the secrets of hypnosis with SFTA! By attending, you'll: Get a hands-on feel for inducing a trance. Embark on a journey through the rich history of hypnosis. Uncover the magic behind the Solution Focused Approach and why it works. Details on our In-person and Distance learning programmes. You'll receive two Self-hypnosis tracks written by Catherine Eland. But wait, there's more! As a token of our appreciation, you will receive a FREE self-hypnosis download to deepen your understanding and help with sleeping, confidence and motivation. So, mark your calendar for Tuesday, April 30th 2024, at 7.00 pm and get ready for a night of enlightenment, intrigue, and a whole lot of fun on Zoom. Are you itching to take your hypnotherapy journey to the next level with our Six-Month Weekend SFTA Hypnotherapy Training course starting in April 2024? Alternatively, you might like a flexible learning experience with our SFTA distance learning course. Visit our website at www.sfta.co.uk. We've got schools across the UK. Or, if you prefer, give our friendly support team a call at 0345 257 0056. Let's make it an unforgettable journey together!

Duration 4 Days 24 CPD hours This course is intended for This course is appropriate for anyone who wants to create applications or modules to automate and simplify common tasks with Perl. Overview Working within in an engaging, hands-on learning environment, guided by our expert web development, PHP practitioner, students will learn to: Create a working script that gets input from the command line, the keyboard, or a file Use arrays to store and process data from files Create formatted reports Use regular expressions Use the appropriate types of variables and data structures Refactor duplicate code into subroutines and modules What is available in the standard library Use shortcuts and defaults, and what they replace Introduction to Perl Programming Essentials is an Introductory-level practical, hands-on Perl scripting training course that guides the students from the basics of writing and running Perl scripts to using more advanced features such as file operations, report writing, the use of regular expressions, working with binary data files, and using the extensive functionality of the standard Perl library. Students will immediately be able to use Perl to complete tasks in the real world. Session: An Overview of Perl What is Perl? Perl is compiled and interpreted Perl Advantages and Disadvantages Downloading and Installing Perl Which version of Perl Getting Help Session: Creating and running Perl Programs Structure of a Perl program Running a Perl script Checking syntax and warnings Execution of scripts under Unix and Windows Session: Basic Data and I/O Numeric and Text literals Math operators and expressions Scalar variables Default values Writing to standard output Command line arguments Reading from the standard input Session: Logic and Loops About flow control The if statement and Boolean values Using unless and elsif Statement modifiers warn() and die() The conditional construct Using while loop and its variants Using the for loop Exiting from loops Session: Lists and Arrays The list data type Accessing array elements Creating arrays List interpolation Arrays and memory Counting elements Iterating through an array List evaluation Slices and ranges Session: Reading and writing text files File I/O Overview Opening a file Reading text files Writing to a text file Arrays and file I/O Using the <> operator Session: List functions Growing and shrinking arrays The split() function Splitting on whitespace Assigning to literal lists The join() function The sort() function Alternate sort keys Reversing an array Session: Formatting output Using sprintf() and printf() Report formatting overview Defining report formats The write() function Advanced filehandle magic Session: Hashes Hash overview Creating hashes Hash attributes Traversing a hash Testing for existence of elements Deleting hash elements Session: References What is a reference? The two ways to create references References to existing data References to anonymous data Dereferencing scalar, array, and ash references Dereferencing elements of arrays and hashes Multidimensional arrays and other data structures Session: Text and Regular Expressions String length The substr() function The index() and rindex() functions String replication Pattern matching and substitution Regular expressions Session: Raw file and data access Opening and closing raw (binary) files Reading raw data Using seek() and tell() Writing raw data Raw data manipulation with pack() and unpack() Session: Subroutines and variable scope Understanding packages Package and Lexical variables Localizing builtin variables Declaring and calling subroutines Calling subroutines Passing parameters and returning values Session: Working with the operating system Determining current OS Environment variables Running external programs User identification Trapping signals File test operators Working with files Time of day Session: Shortcuts and defaults Understanding $_ shift() with no array specified Text file processing Using grep() and Using map() Command-line options for file processing Session: Data wrangling Quoting in Perl Evaluating arrays Understanding qw( ) Getting more out of the <> operator Read ranges of lines Using m//g in scalar context The /o modifier Working with embedded newlines Making REs more readable Perl data conversion Session: Using the Perl Library The Perl library Old-style library files Perl modules Modules bundled with Perl A selection of modules Getting modules from ActiveState Getting modules from CPAN Using Getopt::Long Session: Some Useful Tools Sending and receiving files with Net::FTP Using File::Find to search for files and directories Grabbing a Web page Some good places to find scripts Perl man pages for more information Zipping and unzipping files