2012 Courses in Cardiff delivered Live Online

Duration 4.375 Days 26.25 CPD hours This course is intended for The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are: Application designers and database developers Database administrators Web server administrators Overview This eTextbook begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.

Course Overview The Portuguese Language Course for Beginners is designed to introduce learners to the essentials of the Portuguese language, equipping them with the ability to communicate confidently in everyday situations. This course covers key aspects such as greetings, basic vocabulary, sentence structure, and conversational skills. Whether you are preparing for travel, work, or personal enrichment, this course provides a strong foundation for further language development. By the end of the course, learners will have gained the competence to understand and use common Portuguese expressions, engage in simple conversations, and appreciate the cultural nuances of Portuguese-speaking countries. With its clear structure and engaging approach, this course offers practical value by enhancing communication skills, boosting cultural understanding, and opening up new personal and professional opportunities. Course Description The Portuguese Language Course for Beginners offers a structured introduction to the language through a series of focused lessons. Learners will explore essential topics including basic grammar, vocabulary building, pronunciation techniques, and conversational etiquette. Each section of the course is designed to enhance comprehension and speaking abilities, fostering a gradual progression towards language confidence. Learners will also gain insights into Portuguese culture, helping them to apply their language skills in real-world contexts with sensitivity and awareness. The course combines interactive exercises, audio support, and accessible content to ensure an enriching learning experience. Upon completion, learners will have developed the linguistic tools necessary to engage in everyday Portuguese conversations, navigate simple social and professional interactions, and lay the groundwork for further language study. The course is ideal for those seeking a reliable and well-rounded entry point into Portuguese language acquisition. Course Modules Module 01: Lesson 1 Module 02: Lesson 2 Module 03: Lesson 3 Module 04: Lesson 4 (See full curriculum) Who is this course for? Individuals seeking to communicate effectively in Portuguese during travel or relocation. Professionals aiming to expand career opportunities in Portuguese-speaking markets. Beginners with an interest in learning a new language for cultural enrichment. Students or enthusiasts looking to build foundational language skills for academic or personal growth. Career Path Translator or Interpreter (Entry-Level) Customer Service Representative in multilingual environments Travel and Tourism Assistant International Sales or Business Support Officer Language Tutor (Beginner Level) Cultural Exchange Programme Coordinator

Course Overview The "Handyperson/Handyman (From Basic Tools to Plumbing, Painting and Decorating)" course is designed to provide learners with a comprehensive understanding of a wide range of essential skills. This course covers everything from basic tool usage to more advanced tasks such as plumbing, painting, decorating, and general maintenance. Learners will gain the confidence to undertake various home improvement projects, enhance their professional toolkit, and apply their new skills in everyday situations. By the end of the course, learners will have developed a strong foundation in essential handyperson tasks and be well-equipped to handle minor repairs and maintenance work across different environments. Course Description In this course, learners will explore an extensive range of handyperson skills, beginning with the fundamentals of basic tools and equipment. They will progress to more complex topics such as electrical work, plumbing, and general carpentry. The course covers crucial areas such as appliance repair, wall and floor maintenance, as well as painting and decorating techniques. Learners will gain valuable knowledge of health and safety practices, ensuring they work efficiently and safely. This course is designed to provide learners with a solid skill set that can be applied across a wide range of tasks, from minor repairs to larger construction projects. Throughout the course, learners will be guided on how to establish their own handyperson business, providing them with essential entrepreneurial knowledge to further their career. Course Modules Module 01: Introduction to Handyperson Module 02: Basic Tools and Equipment Module 03: Electrical Work Module 04: Plumbing Skills Module 05: Appliances Module 06: General Carpentry Module 07: Basic Maintenance Skills Module 08: Walls and Floors Module 09: Painting and Decorating Module 10: Drilling, Tiling and Welding Module 11: Construction Projects Module 12: Health and Safety at Work Module 13: Starting Own Business for Handyperson (See full curriculum) Who is this course for? Individuals seeking to develop diverse handyperson skills Professionals aiming to expand their knowledge in home improvement and maintenance Beginners with an interest in the construction or maintenance industry Anyone looking to start their own handyperson business or freelance career Career Path Handyperson Maintenance Technician Property Manager Independent Handyman/Handyperson DIY Consultant Home Improvement Specialist Construction Worker Small Business Owner (Handyperson Services)

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

Course Overview This comprehensive course in Supply Chain Management, Purchasing & Procurement provides learners with the strategic knowledge and operational understanding needed to navigate today’s dynamic supply environments. It explores the core components of supply chain systems, procurement cycles, and purchasing strategies, offering insight into effective logistics planning, supplier relations, and risk mitigation. Learners will gain the tools to streamline processes, optimise procurement decisions, and align purchasing objectives with broader business goals. Designed to support both career development and organisational efficiency, the course equips participants with a strong foundation in modern supply chain functions—contributing to smarter decision-making and improved supply performance. Course Description This course delves into the critical areas of supply chain operations, from foundational concepts to advanced procurement practices. Participants will study logistic management frameworks, category and inventory management, transport coordination, and supplier relationship strategies. Special focus is given to procurement tools, bid management, and cost reduction techniques that can enhance purchasing functions. Through each module, learners are introduced to effective methods for improving supply accuracy, managing quality, and applying risk assessment across sourcing channels. The course supports learners in understanding the interconnected nature of global supply networks, helping them contribute more effectively to procurement, planning, and supplier engagement in diverse business settings. Course Modules Module 01: Supply Chain Basics Module 02: Supply Chain Drivers Module 03: Introduction to Logistic Management Module 04: Planning Framework for Logistics Module 05: Transport Management Module 06: Role of Procurement in an Organisation Module 07: The Purchasing Cycle Module 08: Purchasing Toolkits Module 09: Managing Competitive Bids Module 10: Quality Management Module 11: Supplier Relationship Management Module 12: Analysing and Reducing Risk in the Supply Chain Module 13: Improving Efficiency and Accuracy Module 14: Category Management Module 15: Inventory Management Module 16: E-Procurement (See full curriculum) Who is this course for? Individuals seeking to build a career in procurement or logistics. Professionals aiming to upskill in supply chain operations. Beginners with an interest in purchasing and supply management. Business owners or team leaders looking to optimise procurement processes. Career Path Supply Chain Analyst Procurement Officer Purchasing Manager Inventory Control Specialist Logistics Coordinator Category Manager Supplier Relationship Manager Operations Executive in manufacturing, retail, or distribution sectors

Course Overview This comprehensive course on "Data Analysis and Forecasting in Excel" provides learners with essential skills to manage, analyse, and visualise data effectively using Excel. Whether you are analysing historical data or forecasting future trends, this course covers key tools such as PivotTables, charts, and lookup functions to make your data work for you. Learners will also gain proficiency in automating tasks and creating dynamic reports, which are invaluable for decision-making processes in various professional settings. By the end of the course, you will have the capability to work with complex data sets, produce insightful reports, and apply forecasting techniques to guide future strategies. Course Description In this course, learners will delve into the full spectrum of data analysis capabilities offered by Excel. Topics include modifying worksheets, working with lists, and using advanced tools such as PivotTables, PivotCharts, and lookup functions. Learners will explore the process of visualising data through charts and sparklines, allowing them to convey complex information in an accessible manner. The course also covers automating workbook functionality and creating mapping data for better analysis. Additionally, learners will gain expertise in forecasting data trends to support strategic planning. By the end of the course, participants will have developed a comprehensive understanding of Excel’s analytical tools, enabling them to manage data with efficiency and precision in various business contexts. Course Modules Module 01: Modifying a Worksheet Module 02: Working with Lists Module 03: Analyzing Data Module 04: Visualizing Data with Charts Module 05: Using PivotTables and PivotCharts Module 06: Working with Multiple Worksheets and Workbooks Module 07: Using Lookup Functions and Formula Auditing Module 08: Automating Workbook Functionality Module 09: Creating Sparklines and Mapping Data Module 10: Forecasting Data (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel data analysis skills. Professionals aiming to improve their forecasting and reporting capabilities. Beginners with an interest in data management and analysis. Those seeking to enhance their proficiency in Excel for career advancement. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Project Manager Excel Specialist in various industries such as finance, marketing, and logistics

Course Overview The Criminal Psychology and Profiling course offers an insightful exploration into the psychological underpinnings of criminal behaviour and the art of criminal profiling. Learners will develop a strong foundation in understanding the minds of offenders, the impact of mental health disorders, and the various methods used to classify and investigate crime. Through studying forensic science, behavioural analysis, and victimology, participants will be equipped with the theoretical knowledge and analytical techniques needed to interpret criminal behaviour. Upon completion, learners will possess a deeper appreciation of how criminal psychology informs investigative strategies, legal processes, and crime prevention efforts, positioning them for further study or professional growth in this fascinating field. Course Description This course delves into the intricate relationship between psychology and criminal behaviour, offering a comprehensive study of mental disorders, forensic science applications, and profiling methodologies. Learners will examine the classification of crime, the phases of offender profiling, and the importance of victimology within investigations. The course also provides an overview of the criminal justice system in England and Wales, ensuring a contextual understanding of the legal framework surrounding criminal cases. Designed to strengthen analytical and critical thinking abilities, this programme encourages learners to apply logical reasoning and metacognitive strategies to criminal profiling. By the end of the course, participants will have cultivated a well-rounded skill set valuable for careers in criminal psychology, forensic science, and investigative fields. Course Modules Module 01: Understanding Criminal Psychology Module 02: Influence of Mental Disorders Module 03: Classification of Crime Module 04: Forensic Science Module 05: Criminal Profiling: Science, Logic and Metacognition Module 06: Phases of Profiling Module 07: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice Module 08: Victimology Module 09: The Criminal Justice System in England and Wales (See full curriculum) Who is this course for? Individuals seeking to understand criminal behaviour and profiling methods. Professionals aiming to enhance their expertise in psychology, criminology, or investigative roles. Beginners with an interest in forensic psychology, crime analysis, or criminal justice. Anyone aspiring to explore a career pathway in criminal psychology, forensic science, or legal support services. Career Path Criminal Psychologist Forensic Psychologist Behavioural Analyst Crime Analyst Offender Profiler Criminal Investigator Legal Assistant within criminal law practices Victim Support Worker

Course Overview "JavaScript for Everyone" offers a comprehensive introduction to one of the most essential programming languages used in web development. This course covers the fundamental concepts of JavaScript, allowing learners to build dynamic, interactive websites. Students will gain a solid understanding of core JavaScript principles such as variables, loops, functions, and objects, as well as more advanced topics like cookies, page redirection, and error handling. By the end of the course, learners will be equipped with the skills to implement JavaScript in real-world projects, enhancing the interactivity and functionality of websites. Course Description This course provides an in-depth exploration of JavaScript, focusing on both basic and advanced topics. It begins with an introduction to key programming concepts before diving into areas such as conditional statements, functions, and events. Learners will discover how to work with JavaScript objects, arrays, and built-in objects like Number, Boolean, and String. Additionally, the course covers important aspects like page redirection, pop-up boxes, and validation techniques. By the end, students will be proficient in JavaScript debugging, error handling, and using regular expressions, with a clear understanding of how to apply JavaScript in web development projects. Course Modules Module 01: Introduction Module 02: Basic Concepts on JavaScript Module 03: Conditional and Switch Statements Module 04: JS Functions Module 05: JS Events Module 06: JS Cookies Module 07: JS Page Redirection Module 08: JS Popup Boxes Module 09: JS Void Module 10: JS Print Module 11: JS Objects Module 12: JS Number Object Module 13: JS Boolean Object Module 14: JS String Object Module 15: JS Arrays Module 16: JS Dates Module 17: JS Math and Reg Exp Module 18: JS Browsers and Summary Module 19: JS Debugging Module 20: JS Errors Module 21: JS Validations (See full curriculum) Who is this course for? Individuals seeking to develop web development skills. Professionals aiming to enhance their programming knowledge. Beginners with an interest in web development or JavaScript. Anyone looking to gain a foundational understanding of programming languages. Career Path Web Developer Front-End Developer JavaScript Developer Software Engineer Full-Stack Developer Web Application Developer

Learn the skills and mindset to become a business partner, align your expertise with the organisational goals, drive growth, and shape the future of your company. Course overview Duration: 1 day (6.5 hours) This is a highly interactive and practical course which will help you to understand the role of Business Partnering and the key skills needed to be successful in the role. The course is designed specifically to give you an opportunity to explore the role and test a range of techniques to improve your strategic working as well as your influencing and relationship building skills. This course is aimed at individuals who work cross-functionally and with other people to achieve business results and is particularly helpful for those who engage frequently with senior managers and executives. Objectives  By the end of the course you will be able to: Describe the role of Business Partner and the benefit to the business Develop stronger engagement with all internal and external stakeholders Influence without authority Build positive relationships Handle robust conversations Be forward thinking, not reactive Act as a change agent Communicate with confidence and credibility Content Understanding the role of the Business Partner What is Business Partnering from an individual, departmental and business view Using a psychometric test to look at where your strengths are and how you can use them effectively in the role Developing Relationships Creating a powerful first impression. Communication skills Understanding different communication styles Being more proactive in developing key relationships Stakeholder engagement Presenting ideas in a confident and articulate way Understanding and developing trust Connecting with people Networking Influencing and Negotiating Influencing and persuading others Dealing with conflict and difficult conversations Becoming a trusted advisor/Business Partner Advanced questioning skills and techniques to get to the root of a problem Strategic Thinking Develop the mind-set and strategic capability to play a more proactive leading role in the business

This workshop-based bite-size will provide space to explore some practical tools and ideas on how to be more resilient when faced with challenging and tough situations. There is an opportunity to do a self assessment and bring it to the day as a means to identify areas to work on and begin to master skills that will enhance resilient thinking. There will be time to explore what resilience is and understand the range of practical tools and techniques available that can be used beyond the workshop itself. By the end of the workshop participants will be able to: Discuss and evaluate their personal strengths and areas for development in being more resilient at work Understand what resilience involves and how to identify and challenge their own beliefs that undermine resilience Understand the four aspects of resilience - confidence, adaptability, building support and maintaining a clear perspective Understand how to use resiliency tools to help to cope better with the challenge of change Review and evaluate their learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions and objectives Breaking the ice 2 Identifying current challenges in relation to work How we handle these challenges 3 Defining resilience and how and why it helps our personal effectiveness and thinking 4 Resilience skills and how to develop them 5 Learning a resilience tool that promotes new ways of thinking / working 6 Review and evaluation of learning Action planning