717 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.

This Adobe Photoshop Course runs over the weekend on either a Saturday or Sunday for beginners. Learn Photoshop from scratch.

Course Overview: This comprehensive course offers learners a thorough understanding of swing trading, combining foundational knowledge with advanced techniques to succeed in the financial markets. It covers the principles of technical analysis, swing trading strategies, and market analysis, providing a complete framework for effective trading. By the end of the course, learners will be equipped to make informed decisions, understand market trends, and implement strategies with confidence. This course is ideal for individuals seeking to develop a solid understanding of swing trading, whether they are new to the field or looking to refine their existing skills. Course Description: In this course, learners will explore key swing trading concepts, including chart reading, market trends, and risk management techniques. Topics such as technical indicators, trading strategies, and timing the market will be covered in depth. Learners will develop a structured approach to market analysis and learn how to make informed decisions. The course is designed to provide a well-rounded understanding of swing trading, from basic theory to advanced strategies, enabling participants to confidently navigate the financial markets and make sound trading decisions. Course Modules: Module 01: Introduction Module 02: Intro to Swing Trading Module 03: Technical Analysis 101 Module 04: Swing Trading Strategy & Analysis (See full curriculum) Who is this course for? Individuals seeking to understand swing trading fundamentals. Professionals aiming to enhance their trading strategies and market analysis skills. Beginners with an interest in financial markets and trading. Anyone wanting to gain a deeper understanding of technical analysis and trading strategies. Career Path Swing Trader Technical Analyst Investment Advisor Market Researcher Financial Analyst

Course Overview The "Adobe Lightroom CC" course offers learners an in-depth understanding of the powerful photo editing and organising tools within Adobe Lightroom CC. This course is designed to help individuals at all levels develop proficiency in managing and editing their images efficiently. It covers both the Lightroom Classic CC and Lightroom CC applications, offering learners insights into non-destructive editing techniques, file management, and advanced photo adjustments. Upon completion, learners will be equipped to enhance their photography workflow, ensuring that they can bring their creative visions to life with ease. Course Description This comprehensive course covers key areas of Adobe Lightroom CC, including the differences between Lightroom Classic CC and Lightroom CC, and their respective strengths. Learners will explore how to organise and edit photos using a variety of features such as editing tools, presets, and colour corrections. Additionally, learners will gain knowledge on how to submit photos efficiently within Lightroom and learn best practices for organising a photo library. Throughout the course, participants will develop the skills necessary to refine their editing abilities, increase productivity, and optimise their overall workflow in a professional photography environment. Course Modules Module 01: Lightroom Classic CC Module 02: Lightroom CC Module 03: Photo Submission (See full curriculum) Who is this course for? Individuals seeking to enhance their photo editing skills. Professionals aiming to streamline their photo management and editing processes. Beginners with an interest in photography and photo editing. Photography enthusiasts wanting to optimise their Lightroom workflow. Career Path Professional Photographer Photo Editor Graphic Designer Digital Imaging Specialist Content Creator Photography Studio Assistant

Are you interested in learning how to make polymer clay jewellery? Join us for a fun and informative workshop that will teach you everything you need to know about conditioning the clay, texturing, cutting, shaping the clay, forming and moulding. You'll create a range of finished jewellery pieces that you can take home with you afterwards. This is a great way to learn some new skills and explore a wide variety of style and techniques that are easy enough for beginners but also have room for more advanced learners!

Course Overview This comprehensive "Cookery: Bread Making & Baking" course introduces learners to the art of baking bread, focusing on key techniques and essential knowledge. Participants will explore various methods of bread production, from traditional techniques to modern approaches like sourdough. This course offers practical insights into the baking process, providing a thorough understanding of ingredients, equipment, and timing. By the end of the course, learners will have gained the skills necessary to create a variety of bread, enabling them to experiment with different flavours and textures in their baking endeavours. Course Description In this course, learners will be introduced to the fundamentals of bread making, beginning with an overview of the different types of bread. Key topics include essential baking equipment, ingredients, and the science behind fermentation. Participants will explore techniques such as creating a sourdough starter, using straight dough methods, and crafting an array of bread recipes. The course will also cover methods for adjusting recipes and perfecting the texture and flavour of each loaf. By the end, learners will have mastered the foundational skills needed to bake bread of various styles, enhancing their culinary capabilities and confidence in the kitchen. Course Modules Module 01: Introduction to Bread Making Module 02: Equipment Module 03: Basics of Baking Module 04: Basic Techniques Module 05: Make Your Own Sourdough Module 06: Making Bread Using Straight Dough Module 07: More Recipes (See full curriculum) Who is this course for? Individuals seeking to master bread making. Professionals aiming to enhance their culinary skills. Beginners with an interest in baking and cookery. Aspiring home bakers looking to diversify their skills. Career Path Baker Pastry Chef Cookery Instructor Artisan Bread Producer Food Production Specialist

Course Overview: This Dyslexia Awareness course provides a comprehensive understanding of dyslexia, focusing on its impact, challenges, and effective support strategies. Designed for individuals and professionals alike, this course addresses dyslexia from multiple angles, including educational settings and cognitive theories. By the end of the course, learners will be equipped with essential knowledge to support those with dyslexia, identify potential barriers, and create inclusive learning environments. This course is ideal for anyone seeking to expand their understanding of dyslexia and its implications in various sectors. Course Description: The course covers a broad range of topics, including the definition of dyslexia, its connection with other learning difficulties, and its presence in educational contexts. Learners will explore cognitive theories, such as the phonological processing difficulties that underpin dyslexia, and delve into legal rights and accommodations for dyslexics. The modules guide learners through effective approaches for identifying and supporting individuals with dyslexia in both academic and professional settings. Upon completion, participants will gain valuable insights into enhancing accessibility and inclusion for dyslexic individuals in various environments. Course Modules: Module 01: Introduction to Dyslexia Module 02: Dyslexia and Learning Difficulties Module 03: Dyslexia in the School Module 04: Cognitive Approaches in Dyslexia Module 05: The Legal Rights of Dyslexics (See full curriculum) Who is this course for? Individuals seeking to understand dyslexia and its impact Professionals aiming to enhance their knowledge in supporting dyslexic individuals Beginners with an interest in inclusive education and learning difficulties Anyone working with individuals affected by learning differences Career Path: Special Education Teacher Educational Psychologist Learning Support Assistant Disability Support Coordinator Inclusion Officer Education Consultant

Course Overview This course on Self Confidence & Self Esteem is designed to help individuals understand and enhance their self-belief. It focuses on practical methods and strategies to cultivate confidence and improve self-esteem. Learners will gain a deeper understanding of how confidence impacts personal and professional success, and they will explore tools to boost their confidence levels. By the end of the course, learners will be equipped with the knowledge and mindset needed to build lasting self-esteem and project confidence in various aspects of life. Course Description This course covers the fundamentals of self-confidence and self-esteem, providing a thorough understanding of the psychological aspects that influence these traits. Learners will explore various confidence-building strategies, with an emphasis on developing a positive mindset and maintaining self-belief in challenging situations. The course includes reflective activities to help individuals assess their current levels of confidence and implement effective methods to improve. Key areas of focus include overcoming self-doubt, setting personal goals, and learning how to build self-worth, all of which are integral to fostering lasting self-esteem. By the end of this course, learners will be able to apply their new skills to enhance their personal growth and professional success. Course Modules Module 01: Introduction Module 02: Understanding Confidence Module 03: Developing the Right Mindset to Gain Confidence Module 04: Build Confidence: Strategies That Work Module 05: Quick Activity to Build Your Confidence Module 06: Conclusion (See full curriculum) Who is this course for? Individuals seeking to improve their self-confidence. Professionals aiming to develop stronger self-esteem for career growth. Beginners with an interest in personal development. Anyone wanting to overcome self-doubt and embrace positive self-image. Career Path Personal Development Coach HR Professional Sales Executive Leadership and Management Roles Motivational Speaker

Course Overview The "DIY Home Improvement" course provides an in-depth exploration of various home improvement projects, equipping learners with the knowledge to enhance their homes. Covering a wide range of topics from basic painting and wall repairs to more complex plumbing and electrical tasks, this course offers practical skills that are directly applicable to everyday home maintenance. Learners will gain the confidence to undertake home improvement projects, understand safety protocols, and manage issues such as damp and pest control effectively. The course aims to foster self-sufficiency in home care, empowering individuals to improve their living spaces efficiently. Course Description This course delves into the core aspects of DIY home improvement, beginning with an introduction to essential tools and techniques, followed by detailed lessons on painting, wall repairs, door and window installation, and electrical fixture adjustments. Learners will explore plumbing basics and how to address common issues like damp, rots, and pests. Safety is also emphasised, ensuring that learners understand how to safeguard themselves and their homes during projects. By the end of the course, participants will have developed a comprehensive understanding of home maintenance and improvement, allowing them to tackle a variety of domestic challenges with confidence and competence. Course Modules Module 01: Introduction to Home Improvement Module 02: Paint Job Module 03: Walls Module 04: Doors and Windows Module 05: Electrical Fixtures Module 06: Outdoor Projects Module 07: Plumbing Module 08: Damp, Rots, and Pests Module 09: Home Safety (See full curriculum) Who is this course for? Individuals seeking to improve their homes with cost-effective solutions. Professionals aiming to expand their home maintenance skills. Beginners with an interest in home improvement and maintenance. Homeowners looking to enhance their property value. Career Path Home Improvement Specialist Property Maintenance Manager DIY Consultant Home Renovation Project Manager Estate Agent or Property Manager (specialising in home improvements)

Course Overview: This course provides a comprehensive introduction to cryptocurrencies, blockchain technology, and their broader implications in the financial world. Learners will gain an understanding of how cryptocurrencies work, the underlying technology of blockchain, and the variety of available cryptocurrencies. The course also explores the future potential of cryptocurrencies, including opportunities in decentralised finance (DeFi) and NFTs. Upon completion, learners will be equipped with the knowledge to navigate the rapidly evolving cryptocurrency market, make informed investment decisions, and understand the legal landscape in the UK. Course Description: This course covers a wide range of topics essential to understanding the world of cryptocurrencies. Learners will delve into the fundamentals of cryptocurrencies and blockchain technology, exploring how decentralised systems work. The course introduces various types of cryptocurrencies, their uses, and the role of NFTs in the digital space. Learners will also cover the critical aspects of cryptocurrency wallets, security measures, and how decentralised finance is reshaping financial systems. The course also includes modules on cryptocurrency investment strategies and the evolving legal frameworks in the UK. By the end of the course, learners will have a solid understanding of the cryptocurrency ecosystem and its future trajectory. Course Modules: Module 01: The Fundamentals of Cryptocurrencies Module 02: The Blockchain Module 03: Types of Cryptocurrencies Module 04: NFTs Module 05: Cryptocurrency Wallets Module 06: Cryptocurrency Security Module 07: Decentralised Finance Module 08: Investing in Cryptos Module 09: Opportunities and Future of Cryptocurrencies Module 10: Cryptocurrency Laws in the UK (See full curriculum) Who is this course for? Individuals seeking to understand the basics of cryptocurrencies Professionals aiming to expand their knowledge in blockchain technology Beginners with an interest in digital finance and investment opportunities Anyone looking to stay informed about future trends in cryptocurrency Career Path: Cryptocurrency Analyst Blockchain Developer DeFi Specialist Investment Advisor (Cryptocurrencies) Financial Consultant Legal Advisor for Cryptocurrency Regulations