4288 Courses in Cardiff delivered Online

Embarking on a journey into the digital realm? Dive deep into the vast ocean of web development with our course: 'Start Your Career as Web Developer - Complete Training'. This comprehensive programme unfolds the mysteries of HTML, revealing its foundational to advanced layers. As you delve further, JavaScript beckons, introducing you to its core elements, from basic operations to error handling. But that's not all. PHP emerges on the horizon, offering an exploration from rudimentary concepts to intricate object-oriented programming and real-world applications. Equip yourself with the essence of web development and illuminate the pathways of the digital world. Learning Outcomes Grasp the foundational to advanced principles of HTML. Understand and apply JavaScript concepts from introductory to advanced error handling techniques. Master PHP from its fundamental aspects to advanced object-oriented programming and database integration. Develop and implement web applications integrating PHP with MySQL. Implement client-side and server-side validations using JavaScript and PHP. Why choose this Start Your Career as Web Developer - Complete Training? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Start Your Career as Web Developer - Complete Training Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Start Your Career as Web Developer - Complete Training for? Aspiring web developers seeking a structured pathway into the field. Current web designers looking to expand their skills into development. IT students aiming to bolster their academic understanding with applied knowledge. Entrepreneurs aiming to manage or understand their website's backend. Tech enthusiasts with a curiosity about the workings of web development. Career path Web Developer: £28,000 - £50,000 Front-End Developer: £30,000 - £50,000 Back-End Developer: £35,000 - £55,000 Full Stack Developer: £40,000 - £60,000 PHP Developer: £30,000 - £52,000 JavaScript Developer: £35,000 - £57,000 Prerequisites This Start Your Career as Web Developer - Complete Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Start Your Career as Web Developer - Complete Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Introduction 00:03:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask Great Questions 00:01:00 FAQ's 00:01:00 HTML Introduction HTML 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Structure of a Full HTML Webpage 00:07:00 First Hello World! Webpage 00:09:00 HTML Basic Heading tags 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 IDs 00:06:00 Comments 00:04:00 HTML Intermediate Images 00:12:00 Forms 00:05:00 Marquee 00:06:00 Text area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div tag 00:06:00 Google Maps 00:07:00 HTML Advanced HTML Audio 00:07:00 HTML Video 00:05:00 Canvas 00:06:00 Iframes 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 Registration Form 00:04:00 Contact Us Form 00:10:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:02:00 JavaScript Introduction What is JavaScript 00:09:00 Hello World Program 00:14:00 Getting Output 00:11:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 JavaScript Basics Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Strings 00:07:00 String Formatting 00:05:00 JavaScript Operators Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 JavaScript Conditional Statements If-else statement 00:05:00 If-else-if statemen 00:04:00 JavaScript Control Flow Statements While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Coding Exercise 00:02:00 Solution for Coding Exercise 00:02:00 JavaScript Functions Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 JavaScript Error Handling Try-catch 00:05:00 Try-catch-finally 00:17:00 JavaScript Client-Side Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 PHP Introduction What is PHP 00:08:00 Installing XAMPP for PHP, MySQL and Apache 00:12:00 Installing Code Editor(Visual Studio Code) 00:07:00 Creating PHP Project on XAMPP 00:03:00 Hello World Program 00:06:00 PHP Basic Variables 00:16:00 Echo and Print 00:08:00 Data Types 00:11:00 Numbers 00:06:00 Boolean 00:04:00 Arrays 00:06:00 Multi-Dimensional Array 00:07:00 Sorting Arrays 00:04:00 Constants 00:05:00 PHP Strings Strings 00:04:00 String Formatting 00:05:00 String Methods 00:08:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 PHP Operators Arithmetic operators 00:03:00 Assignment operators 00:02:00 Comparison operators 00:05:00 Increment - decrement operators 00:03:00 Logical operators 00:06:00 Ternary operator 00:03:00 PHP Decision-making System If statement 00:05:00 If-else statement 00:02:00 If-else-if-else statement 00:03:00 Switch-case statement 00:05:00 PHP Control flow statements Flow Chart 00:06:00 While loop 00:09:00 Do-while loop 00:04:00 For loop 00:15:00 Foreach loop 00:04:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 PHP Functions Creating a Function 00:08:00 Function with Arguments 00:08:00 Default Argument 00:03:00 Function return values 00:06:00 Call-by-value 00:02:00 Call-by-reference 00:03:00 PHP Super globals $_POST Method 00:06:00 $_GET Method 00:02:00 PHP Advanced Form Handling 00:08:00 Date and Time 00:08:00 Include 00:06:00 Require 00:02:00 Sessions 00:08:00 File Reading 00:02:00 File Upload 00:06:00 PHP Object-oriented programming[OOPs] What is OOP 00:03:00 Class and Objects 00:11:00 Constructor 00:04:00 Destructor 00:03:00 Access Modifiers 00:10:00 Inheritance 00:12:00 Method overriding 00:06:00 Abstract Class 00:03:00 Interface 00:08:00 PHP - MySQL Application [CRUD] MySQL Basic PhpMyAdmin 00:04:00 Creating Database and Table 00:07:00 Database Connection 00:05:00 PHP Form Create records 00:16:00 PHP Form Reading records 00:11:00 PHP Form Update Data 00:15:00 PHP Form Delete record 00:04:00 PHP Real-world code forms Registration Form 00:04:00 MD5 Algorithm for Encrypting 00:03:00 Sha Algorithm 00:02:00 Login Form 00:12:00 PHP Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Login Form Validation 00:05:00 Form Server-side all Data Validation 00:06:00 Form Server-side Validation 00:06:00 PHP Error handling Try-throw-catch 00:06:00 Try-throw-catch-finally 00:02:00

Course Overview This advanced-level Project Management Level 7 course offers comprehensive training designed to develop strategic thinking, leadership acumen, and organisational proficiency. Covering the essential principles of professional project delivery, the course aligns with international frameworks such as PMBOK and PMI standards, giving learners a solid foundation in high-level project management methodologies. From global project execution to risk and quality management, participants will gain the skills to oversee complex initiatives, manage cross-functional teams, and navigate dynamic business environments. Emphasis is placed on critical areas such as change management, performance evaluation, and crisis response. By the end of the course, learners will be prepared to assume leadership roles in project-driven environments across diverse industries, demonstrating competency in managing time, resources, stakeholders, and strategic outcomes with confidence and clarity. Course Description This Level 7 course delves into advanced project management theories and practices, equipping learners with essential knowledge across the entire project lifecycle. Starting with foundational concepts and extending to global project frameworks, the curriculum includes modules on time, resource, and quality management, along with strategic planning, communication, and procurement. Learners will explore techniques for managing stress, conflict, and team performance, while also developing crisis response strategies and resilience planning. A strong focus is placed on leadership and stakeholder engagement, enabling participants to drive results through effective coordination and planning. Each module is structured to build critical thinking and decision-making capabilities suited for high-level responsibilities. By engaging with industry-relevant case studies and strategic planning exercises, learners will graduate with the insight required to lead organisational change, oversee multifaceted projects, and ensure long-term success within both public and private sectors. Course Modules: Module 01: Introduction to Project Management Module 02: PMBOK and PMI Module 03: Global Project Management Module 04: Project Life Cycle Module 05: Time Management Module 06: Quality Management Module 07: Effective Planning & Scheduling Module 08: Human Resource Management Module 09: Performance Management Module 10: Talent Management Module 11: Organising Meeting and Conferences Module 12: Managing Resources Module 13: Change Management Module 14: Business Resilience and Crisis Management Module 15: Conflict Management Module 16: Stress Management Module 17: Communication Skills Module 18: Procurement & Purchasing Management Module 19: Risk Management (See full curriculum) Who is this course for? Individuals seeking to progress into senior-level project roles. Professionals aiming to formalise their project management expertise. Beginners with an interest in leadership and organisational management. Team leaders or coordinators aspiring to manage large-scale projects. Career Path Project Manager Programme Director Business Change Manager Risk and Compliance Officer Operations Manager Strategic Planning Consultant Procurement and Contracts Manager Portfolio Manager Crisis and Resilience Coordinator

Course Overview: "Financial Ratio Analysis for Business Decisions" equips learners with essential tools to analyse financial statements effectively, enabling better business decision-making. The course introduces key financial ratios such as profitability, return, liquidity, and operational ratios, providing valuable insights into a company's financial health. By understanding these ratios, learners can evaluate business performance, assess risks, and make informed decisions in various business contexts. The course is designed to enhance the financial acumen of professionals across sectors, equipping them with the analytical skills needed to drive strategic decisions and improve financial outcomes. Learners will gain a comprehensive understanding of how financial ratios influence corporate strategy, with an emphasis on real-world application in business operations and decision-making. Course Description: This course covers a range of financial ratios essential for making informed business decisions. Learners will explore profitability ratios, return ratios, liquidity ratios, and operational analysis, learning how to interpret and use these metrics to evaluate a company's performance. The curriculum also delves into identifying potential financial manipulations and understanding how these impact decision-making. By completing the course, learners will gain a solid understanding of financial ratio analysis and its role in assessing the strengths and weaknesses of an organisation's financial health. The course is designed for professionals across industries looking to enhance their financial literacy and analytical skills, preparing them to make confident, data-driven decisions. Learners will benefit from structured content, expert-led discussions, and industry-specific case studies that help contextualise theoretical concepts. Course Modules: Module 01: Introduction Overview of Financial Ratios Importance of Ratio Analysis in Decision-Making Key Terminology and Definitions Module 02: Profitability Understanding Profit Margin Ratios Gross Profit Margin Net Profit Margin Return on Assets (ROA) and Return on Equity (ROE) Module 03: Return Ratio Definition and Importance of Return Ratios Return on Investment (ROI) Economic Value Added (EVA) Evaluating Business Performance Module 04: Liquidity Ratio Importance of Liquidity Ratios in Business Current Ratio Quick Ratio Cash Flow Analysis Module 05: Operational Analysis Efficiency Ratios Asset Turnover Inventory and Receivables Management Module 06: Detecting Manipulations And Making Other Operational Decisions Identifying Financial Statement Manipulations Fraud Detection Techniques Making Operational Decisions Based on Financial Data (See full curriculum) Who is this course for? Individuals seeking to improve their financial decision-making skills. Professionals aiming to enhance their understanding of financial performance metrics. Beginners with an interest in business finance and financial analysis. Business analysts and managers looking to gain deeper insights into financial health. Career Path: Financial Analyst Business Analyst Investment Analyst Finance Manager Management Consultant Risk Manager Corporate Strategy Analyst

Health & Safety and Wellbeing in Care Course Overview This course provides an in-depth understanding of health, safety, and wellbeing within the care sector. It explores key legislation, risk management, and the essential protocols to ensure the safety of both care providers and recipients. By covering topics such as fire safety, stress management, and correct handling techniques, learners will be equipped to create safer care environments. The course delivers valuable knowledge for maintaining compliance with legal frameworks and improving overall wellbeing in care settings. Upon completion, learners will gain confidence in managing health and safety practices, enhancing both personal and organisational care standards. Course Description "Health & Safety and Wellbeing in Care" is designed to provide learners with a comprehensive understanding of the regulations, practices, and tools necessary for ensuring safety and wellbeing in care environments. The course covers essential topics such as health and safety legislation, security protocols, and stress management. Learners will explore fire safety and its related legislation, as well as proper handling and moving techniques. The course also delves into key regulations like LOLER (Lifting Operations and Lifting Equipment Regulations) and RIDDOR (Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations). By the end, learners will have developed skills to assess and manage risks in various care settings, ensuring the safety of individuals and contributing to the improvement of overall care standards. Health & Safety and Wellbeing in Care Curriculum Module 01: Health & Safety Legislation & Policies Module 02: Safety, Security & Stress Management Module 03: Fire Safety Module 04: Fire Safety Legislation Module 05: Handling and Moving Module 06: LOLER & RIDDOR (See full curriculum) Who is this course for? Individuals seeking to enhance their understanding of health and safety in care environments. Professionals aiming to ensure compliance with health and safety regulations in care settings. Beginners with an interest in health and safety practices for the care industry. Care providers who wish to improve their workplace safety standards. Career Path Health and Safety Officer in care settings Risk Manager in healthcare environments Care Home Manager Support Worker Health and Safety Consultant for care organisations

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course Overview "Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!" is designed for learners who want to enhance their Excel skills in a short period. This course covers the essential formulas that are frequently used in both everyday tasks and professional settings. It provides quick, easy-to-follow insights on the most common Excel functions, enabling you to work more efficiently with data, improve productivity, and gain confidence in using Excel’s powerful features. By the end of this course, you will have a comprehensive understanding of 50 key Excel formulas and be able to apply them confidently across various tasks and scenarios. Course Description In this course, learners will be introduced to 50 of the most widely used Microsoft Excel formulas, including basic functions like SUM and AVERAGE, as well as more advanced formulas such as VLOOKUP, IF statements, and pivot table formulas. Each formula is explained with clear examples, offering learners a straightforward approach to improving their Excel proficiency. Whether you are managing data, performing financial analysis, or generating reports, these formulas will significantly enhance your ability to complete tasks faster and more effectively. With a focus on learning key formulas, this course provides an excellent foundation for anyone looking to optimise their Excel skills in a time-efficient way. Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Curriculum Module 01: Introduction to Excel Formulas Module 02: Basic Mathematical Formulas Module 03: Logical Functions and Conditions Module 04: Lookup and Reference Functions Module 05: Text and Date Functions Module 06: Statistical Functions and Analysis Module 07: Advanced Excel Formulas Module 08: Using Formulas for Data Validation and Error Checking Module 09: Formulas for Financial Modelling Module 10: Troubleshooting and Optimising Formulas (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel capabilities. Professionals aiming to improve data management and analysis skills. Beginners with an interest in improving their productivity with Excel. Anyone wanting to quickly learn the key Excel formulas used in daily tasks. Career Path Data Analyst Financial Analyst Project Manager Business Analyst Office Administrator Operations Manager IT Support Specialist

Clinical Observations Skills Course Overview The "Clinical Observation Skills" course is designed to equip learners with the essential skills required for observing and understanding clinical practices in various healthcare settings. This course provides comprehensive insights into the role of clinical observation, focusing on key areas such as legal standards, ethical practice, patient condition monitoring, clinical management, and more. Upon completion, learners will develop a strong foundation in the critical thinking and observation techniques necessary for improving patient care. The course also enhances knowledge of hygiene standards and medical dispensary operations. Learners will be empowered to contribute effectively to healthcare environments, improving both their observational skills and their understanding of clinical processes. Course Description This course delves into the core aspects of clinical observation, offering an in-depth exploration of the various fields within healthcare. Learners will study a broad range of topics, starting with the basics of clinical observation and moving on to legal and professional ethics. Key areas of focus include monitoring a patient's condition, understanding clinical management systems, and observing technical medical methods and dispensaries. In addition, the course addresses important aspects such as health, safety, and hygiene in clinical environments. The learning experience is structured to develop the knowledge needed to contribute confidently to healthcare teams and settings. The skills acquired from this course will prepare learners to assess and understand clinical processes, contributing to a deeper level of patient care and supporting professional development in healthcare roles. Clinical Observations Skills Curriculum Module 01: Introduction to Clinical Observation and Clinical Carer Module 02: Legal Standards and Professional Aspects of Ethical Practice Module 03: Patient’s Condition Observation Module 04: Clinical Management Observation Module 05: Technical Clinical Method Observation Module 06: Medicine and Dispensaries Observation Module 07: Health Safety and Hygiene (See full curriculum) Who is this course for? Individuals seeking to understand clinical observation techniques. Professionals aiming to develop skills in clinical settings. Beginners with an interest in healthcare and medical practices. Anyone looking to improve their knowledge of health, safety, and hygiene standards in clinical environments. Career Path Clinical Observation Specialist Healthcare Assistant Medical Administrator Patient Care Coordinator Clinical Support Worker Medical Office Assistant

Recruitment Consultant Diploma Level 5 Course Overview The Recruitment Consultant Diploma Level 5 provides learners with in-depth knowledge and expertise required to succeed in the recruitment industry. This course covers a broad range of topics, including recruitment legislation, sales strategies, candidate management, and client acquisition. By the end of the course, learners will gain a comprehensive understanding of the recruitment process and how to effectively manage both candidates and clients. The course is designed to equip individuals with the essential skills needed for success in recruitment consultancy, offering valuable insights into industry practices, strategies, and key performance indicators. Course Description This diploma course offers a detailed exploration of the recruitment industry, starting with an introduction to its significance and the various legislative frameworks that impact recruitment practices in the UK. Learners will delve into strategies for candidate attraction, interview processes, and client acquisition. The modules are designed to help individuals develop critical skills in sales, client management, and the recruitment process itself. Learners will understand how to set key performance indicators, effectively manage candidates, and formulate strategies for success in the recruitment sector. This course is structured to provide comprehensive learning, ensuring that students are well-prepared for careers in recruitment consultancy. Recruitment Consultant Diploma Level 5 Curriculum: Module 01: Introduction to Recruitment: Importance and Implications Module 02: An Overview of the Recruitment Industry Module 03: The UK Recruitment Legislation Module 04: Sales and Selling in the Recruitment Industry Module 05: The Recruitment Process Module 06: Key Performance Indicators for the Recruitment Industry Module 07: Candidate Attraction for Recruitment Module 08: Candidate Management Module 09: Candidate Interview Processes Module 10: Client Acquisition Module 11: Client Strategy in the Recruitment Sector Module 12: Client Management Module 13: Steps to Starting and Running a Successful Recruiting Service (See full curriculum) Who is this course for? Individuals seeking to enter the recruitment industry. Professionals aiming to advance their recruitment career. Beginners with an interest in recruitment consultancy. Those looking to develop a deeper understanding of recruitment processes. Career Path Recruitment Consultant Talent Acquisition Specialist Recruitment Agency Manager Client Relationship Manager in Recruitment Recruitment Operations Specialist

Veterinary Assistant Diploma Level 3 Course Overview The Veterinary Assistant Diploma Level 3 provides learners with an in-depth understanding of the veterinary profession, covering a wide range of essential topics necessary for supporting veterinary teams. This course equips students with the knowledge and skills required to assist in the care of animals, provide customer service in veterinary clinics, and contribute to the smooth running of veterinary practices. Learners will explore key areas such as animal anatomy, disease prevention, and medical procedures, alongside important client interaction and administration skills. Upon completion, learners will be prepared to step into a vital role within the veterinary sector, offering strong career prospects and the opportunity to make a positive impact in animal healthcare. Course Description This comprehensive course delves into the fundamentals of veterinary care, focusing on animal biology, care techniques, and industry-specific practices. Topics covered include animal anatomy and physiology, infectious diseases, diagnostic procedures, and medical treatment protocols. Additionally, learners will gain insights into the administrative aspects of a veterinary practice, including patient records, client communication, and essential office procedures. Throughout the course, students will develop a well-rounded skill set that prepares them to effectively support veterinary professionals in a variety of settings. By the end of the course, learners will possess a solid understanding of the veterinary assistant's role, along with the confidence to contribute to the daily operations of a veterinary clinic or hospital. Veterinary Assistant Diploma Level 3 Curriculum Module 01: Introduction to Veterinary Medicine Module 02: Animal Anatomy and Physiology Module 03: Common Animal Diseases and Treatments Module 04: Diagnostic Procedures in Veterinary Care Module 05: Veterinary Practice and Administration Module 06: Veterinary Client Communication and Support Module 07: Animal Welfare and Ethical Considerations Module 08: Legal and Regulatory Requirements in Veterinary Care Module 09: Preventative Care and Health Maintenance Module 10: Career Development in the Veterinary Field (See full curriculum) Who is this course for? Individuals seeking to become a Veterinary Assistant Professionals aiming to advance their career in animal healthcare Beginners with an interest in veterinary medicine and animal care Those wishing to contribute to the welfare and health of animals Career Path Veterinary Assistant Veterinary Receptionist Animal Health Care Technician Animal Welfare Officer Veterinary Practice Administrator

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the PostgreSQL for Database Developers (TTDB7024) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for vSphere administrators, architects, system engineers, and systems integrators who are responsible for the deployment or management of Site Recovery Manager Overview By the end of the course, you should be able to meet the following objectives: Summarize the components of Site Recovery Manager architecture Deploy and configure the Site Recovery Manager appliance Describe the principal disaster recovery topologies that are used with Site Recovery Manager Configure inventory and resource mappings Describe the storage replication options that are used with Site Recovery Manager Configure Site Recovery Manager to leverage array-based replication Describe VMware vSphere Replication™ functionality Describe the vSphere Replication architecture Deploy and configure vSphere Replication for use with Site Recovery Manager Build Site Recovery Manager array-based protection groups, protection groups based on vSphere Replication, and Virtual Volumes protection groups. Build, edit, execute, test, and remove a recovery plan Perform a planned migration This two-day, hands-on training course gives experienced VMware vSphere© administrators the knowledge to install, configure, and manage VMware Site Recovery Manager? 8.6. This course also shows you how to write and test disaster recovery plans that use Site Recovery Manager. Course Introduction Introductions and course logistics Course objectives Site Recovery Manager Architecture Describe Site Recovery Manager architecture Identify disaster recovery options with Site Recovery Manager Evaluate how Site Recovery Manager integrates with VMware products Describe Site Recovery Manager licensing options List the disaster recovery topologies supported by Site Recovery Manager Describe how VMware Site Recovery for VMware Cloud on AWS integrates with Site Recovery Manager Deploying and Configuring Site Recovery Manager Identify the vSphere and vCenter Server requirements for deploying Site Recovery Manager Define Site Recovery Manager virtual appliance system requirements Deploy the Site Recovery Manager appliance Navigate the Site Recovery Manager configuration UI Describe the process for registering Site Recovery Manager with vCenter Server Describe how to start and stop services in Site Recovery Manager Identify ways to perform updates to the Site Recovery Manager appliance Describe the options for accessing the Site Recovery Manager Describe the process for configuring site pairing Describe how to import and export Site Recovery Manager configuration Navigate the Site Recovery Manager configuration UI Describe the process for registering Site Recovery Manager with vCenter Server Describe how to start and stop services in Site Recovery Manager Identify ways to perform updates to the Site Recovery Manager appliance Describe the options for accessing the Site Recovery Manager Describe the process for configuring site pairing Describe how to import and export Site Recovery Manager configuration Configuring Inventory Mappings Explain the importance of inventory mappings Identify configuration options for inventory mappings Describe the importance of placeholder virtual machines and datastores Describe the importance of the vSphere inventory changes for Site Recovery Manager operation Using Array-Based Replication Describe array-based replication Describe Storage Replication Adapters and explain their role for the array-based replication Describe the concept and configuration of array pairs Describe datastore groups and the relationship between devices and datastore groups Describe the role of consistency groups Identify the advantages of array-based replication vSphere Replication Describe Site Recovery Manager with vSphere Replication Architecture Discuss the role of vSphere Replication components Discuss use cases for vSphere Replication Discuss system requirements and operational limits of vSphere Replication Determine how to calculate bandwidth requirements for vSphere Replication Identify the advantages of vSphere Replication Deploy a vSphere Replication appliance Configure a vSphere Replication appliance and register it with vCenter Server Pair vSphere Replication appliances Deploy an additional vSphere Replication server Register a vSphere Replication server with a vSphere Replication management server Replicating VMs Using vSphere Replication Describe the replication process used by vSphere Replication List vSphere Replication replica states Describe vSphere Replication of encrypted virtual machines Describe vSphere native key provider Describe how to configure vSphere Replication Discuss vSphere Replication RPO settings Describe MPIT instances Describe additional vSphere Replication settings Describe how to disable vSphere Replication Protection Groups Define protection group functionality Examine the differences between array-based protection groups, protection groups based on vSphere Replication, and Virtual Volumes protection groups Create a protection group View a placeholder virtual machine in the inventory Configure protection for virtual machines and edit protection groups Recovery Plans Discuss recovery plan concepts Discuss network planning Discuss the organization of storage for recovery plans Describe customization options in recovery planning Describe priority groups and VM dependencies Describe how to implement a recovery plan Configure VM recovery plan properties Describe the customization of recovery plans Configure additional steps in the recovery plan Delete a recovery plan Executing Recovery Plans Discuss use cases for Site Recovery Manager Describe planned migration Identify Site Recovery Manager workflows Examine Site Recovery Manager integration with various vSphere technologies Describe how to conduct a recovery plan test Perform a recovery plan test Identify the effect on the storage layer during the test recovery steps Review the recovery plan test steps Describe how to cancel a recovery plan test and clean up after recovery plan test cancelation Explain a recovery plan execution in planned migration or disaster recovery mode Identify the recovery steps for each execution type Describe a forced recovery Explain the importance of reprotection processes and states Examine failback steps Describe how to reprotect a data center Monitoring and Troubleshooting Identify Site Recovery Manager alarm options Generate Site Recovery Manager recovery plan history reports Configure Site Recovery Manager advanced settings Identify Site Recovery Manager logs Describe the vRealize Operations management pack for Site Recovery Manager