366 Courses in Cardiff delivered Live Online

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

Unconscious biases are social stereotypes about certain groups of people that individuals form outside their own conscious awareness. Course Category Relationships Racial bias Description Unconscious biases are social stereotypes about certain groups of people that individuals form outside their own conscious awareness. Everyone holds unconscious beliefs about various social and identity groups and these biases stem from one’s tendency to organise social worlds by categorising. So join us on a reflective, engaging day where we tackle real life issues in depth and create action plans for future practice. Learning Objectives Increased confidence and understanding regarding Unconscious Bias Action planning New skills and processes to strengthen the inclusion of diverse groups Opportunity to reflect and understand more deeply on what might be happening due to unconscious bias’ Who Is It For? Any professional, carer or parent Course Content We will explore what is known about:Restorative JusticeDiversityAttitudes and ValuesProfessional dutiesReflective practice

This course will let you develop the skillsets needed to guide the delivery of value in a Lean enterprise—and learn about the activities, tools, and mechanics used to manage backlogs and programs. Attending the class prepares you to take the exam and become a certified SAFe® 6 Product Owner/Product Manager (POPM). SAFe Product Owner/Product Manager 6 training course is provided under Scaled Agile, Inc. Partner Program Agreement.

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on the core values of customer service.

Our masterclass series goes behind the studio door and explores the processes of globally respected people, studios and businesses.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Data Consultants/Managers, Developers, Program/Project Managers, and System Administrators. Overview This course is designed to give you the comprehensive skills needed to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes.In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools. This five-day course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool. Basic SAP BusinessObjects Universe Design Describing Universes Defining the Components of a Universe Data Connections Defining connections Data Foundations Creating Data Foundations Using Joins Business Layers Accessing Data through the Business Layer Integrating the Business Layer Components Validating Objects Creating Measure Objects Creating Shortcut Joins Loops in a Data Foundation Resolving Loops with Joined Tables Resolving Loops Using Aliases Resolving Loops Using Contexts Detecting Contexts Editing Contexts Testing Contexts Resolving Recursive Loops Data Restrictions Defining Data Restrictions Applying Mandatory Data Restrictions Applying Optional Data Restrictions Lists of Values (LOV) Providing a List of Values Parameters Illustrating Runtime Parameters Object @functions Using Object @functions in Queries Applying the Aggregate Awareness Optimization Method Using Other @ Functions Navigation Paths Defining Drill Down Navigation Paths Derived Tables Creating Derived Tables Key Awareness Defining Numeric Keys Universe Management with Data Foundation and Business Layer Views Managing a Universe using the Data Foundation View Managing a Universe using the Business Layer View Universe Optimization Optimizing Universes Using Parameters Universe Deployment and Security Deploying a Universe Securing a Published Universe Creating Data Security Profiles Creating Business Security Profiles Assigning Security Profiles to Users Identifying the Priority of Security Settings Updating a Published Universe SQL Clause Processing Problems Determining How the Order of SQL Clauses Affects Data Returned Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Identifying Fan Traps Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Outer Join Problem Resolution Resolving an Ambiguous Outer Join Using @AggregateAware Universe Creation from Different Data Sources Identifying the Different Data Sources Creating an OLAP Universe Creating a Multi-source Universe Shared Projects Using Shared Projects Manipulating Other Designers' Resources Universe Conversion Converting Existing .unv Universes Translation Deploying Universes in Different Languages

ACCA Course The ACCA Qualification is designed to provide the accounting knowledge, skills and professional values which will deliver finance professionals who are capable of building successful careers across all sectors. Whether they are working in the public or private sectors, practising in accounting firms, or pursuing a career in business. The ACCA Qualification is your route to professional status. Therefore, making a decision to study ACCA courses at Osborne Training will be one of the biggest decision you would make for your career. Professional or Industry specific qualification

Course Overview Teaching the theory and practise of suicide intervention skills that can be applied in any professional or personal setting, captured in a one-day event accredited by City and Guilds of London. We use only the most experienced suicide prevention trainers to deliver this unique learning experience: for anyone who seeks greater understanding and confidence to intervene with people at risk of suicide. The Suicide First Aid through Understanding Suicide Intervention (SFAUSI) course gives learners the knowledge and tools to understand that suicide is one of the most preventable deaths and some basic skills can help someone with thoughts of suicide stay safe from their thoughts and stay alive.  Course Content SFAUSI is comprised of 4 parts, each 90 minutes duration. The programme teaches and practices the skills and knowledge needed to identify someone who may be thinking about suicide and competently intervene to help create suicide- safety as a first aid approach.  Part 1  Introduction to: the day; programme; ourselves and suicide prevention Stigma, Survivors of bereavement by suicide and the Hidden Toll Suicide thoughts and suicide behaviour Intention of behaviour Versus Outcome of behaviour Possible Causes of Suicidal thoughts Part 2 Suicide – the Ripple Effect Population-based approach to suicide prevention Partnership working Working with attitudes and values “I’m so glad you told me” - Audio visual Part 3 Meeting the needs of a person who is thinking about suicide Suicide-Safety Guide Step 1 – Recognising suicide and asking about suicide Step 2 – Understanding options Part 4 Step 3 – Safeguarding suicide Suicide-safety and self-care The risk assessment approach Suicide and suicide gestures Future learning Format Taught over 6 hours using tutor facilitated Socratic learning, tutor-led practice session, mini lectures, group work and audio-visual presentations. This is a highly interactive and emotionally engaging learning experience.  Pre-training requirement No previous experience or training is necessary. Participants will be asked to self-reflect and empathise with a person having thoughts of suicide. There is no expectation on participants to share personal experiences.  Who should attend?  Multi-sector managers and practitioners including health, housing, social care, education, criminal justice, call centre operators, private, voluntary and public sector workers and community groups or members.  Accreditation Participants can choose to register for the City and Guilds accredited unit of learning for an additional fee of £85 per person. This involves completion of a written assignment.

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.

Tableau is an intuitive and simple tool to learn. This Tableau training course is a jumpstart to getting report writers and analysts who are self-taught or have no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in three days. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment. At the end of this course, you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. Our Tableau Desktop Fast Track course combines all of our Foundation (Fundamentals) and Analyst (Intermediate) content into a 3 day live online course with added access to online bonus content of 3 additional modules. Gathering Requirements, Bring Your Own Data and Engaging Users. What do you get? This course is delivered live virtually and has all material provided through our online portal, together with email support and live coaching sessions. The full program includes all of the following elements: 3 days of live and interactive instructor-led sessions delivered by an expert Tableau Trainer 6 weeks access to our live coaching program delivered by expert Tableau coaches 50+ practical exercises to practice what you learn 12 months access to video’s that walk you through the theory and exercise solutions Practical advice, tools and resources for using Tableau in the real world The three additional online modules provide:Clarity on the approach to gathering dashboard requirements in a way that can be translated into dashboard designs.An agile and iterative development process that delivers products that meet user needs more quickly and effectively.An understanding of how end users will interact with dashboards to ensure that designers deliver actionable results. THE SYLLABUS PHASE 1: DESIGN MODULE 1: UNDERSTAND TABLEAU What is possible How does Tableau deal with data Know your way around Review of Type Conversions How do we format charts Dashboard basics – My first Dashboard MODULE 2: TRANSFORM DATA Connecting to and setting up data in Tableau Modifying data attributes How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates How do I create calculated fields and why? – Creating Calculated Fields, Types of calculated fields, Row Level v Aggregations, Aggregating dimensions in calculations, Changing the Level of Detail (LOD) of calculations – What, Why, How MODULE 3: GATHER REQUIREMENTS(ONLINE CONTENT ONLY) Brainstorm and assess possible priorities Pitfalls to avoid Gather requirements PHASE 2: DEVELOP MODULE 4: CREATE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing progress over time Creating Tables – Creating Tables, Highlight Tables, Heat Maps Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps Making things dynamic with parameters MODULE 5: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 6: ANALYSE INFORMATION Table Calculations Sets, Reference Lines, Trends and Forecasting Answering spatial questions – Mapping, Creating a choropleth (filled) map, Using your own images for spatial analysis, Mapping with spatial files Advanced charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Viz in Tooltips PHASE 3: DESIGN MODULE 7: BUILD DASHBOARDS Using the Dashboard Interface Device layouts Dashboard Actions – Set actions, Parameter actions Viz in Tooltips for Dashboards Dashboard containers – Horizontal & Vertical containers, Hidden containers Navigate between dashboards Telling data driven stories MODULE 8: BRING YOUR OWN DATA Design Best Practices & Resources Wireframe templates Questions Process Start building and testing MODULE 9: EMPOWER STAKEHOLDERS What is Tableau Server Publishing & permissions How can your users engage with content The Tableau ecosystem Review your progress Your next steps HOW MUCH OF YOUR TIME WILL THIS TAKE? Delegates are also provided 6 weeks access to our Tableau Coaching. We run Live Q&A sessions from 4pm-5pm on a Monday (Connecting to Data and Calculated Fields), 2pm-3pm Friday (Creating Charts) & 4pm-5pm Friday (Dashboard Design). The coaching helps delegates to transition from the theory of using Tableau to its practical use. We’d be expecting them to apply the exercises you’ll be doing during the course, onto your own data after the course. In our experience, this is the best way to increase both understanding and long term memory retention. The live coaching also acts as a troubleshooting platform for any practical issues that delegates need to overcome in the real world. Delegates also have 12 months access to all of the training material covered in the course in the form of an online portal (this includes theory videos, exercise solution videos, exercise materials and even quizzes). We have a growing LinkedIn community that delegates are encouraged to join and participate in. We regularly post useful blog posts and additional training that will enhance the Tableau journey and understanding. We help teams using Tableau to transform in the following ways : From a disjointed understanding of Tableau – To being familiar with Tableau terminology and capability From ad-hoc data uploads and error prone calculations – To reusable data connections and robust metrics From disjointed stakeholder questions – To clear and concise requirements that lead to decision making From being unsure how difficult Tableau will be to learn – To being able to develop standard charts and tables in Tableau with dynamic reporting capabilities From manually combining data for each analytical task – To dynamically combining data from multiple tables for analysis From being unsure how to answer analytical questions and what options there are – To being equipped with multiple actionable, dynamic, analytical use cases From not knowing Why, When and How to create Dashboards or Story’s – To being able to combine analysis to answer complex questions and tell data driven stories From using demo data theory – To Delivering value [Answering questions] on their own data From spending lots of time answering colleagues ad-hoc (data) questions – To empowering stakeholders in answering ad-hoc queries and reducing the time to analyse and steer the business