8086 Courses in Cardiff delivered Online

Duration 5 Days 30 CPD hours This course is intended for This course is intended for an IT person wanting to learn about administrating SharePoint 2016. Overview After completing this course, you will be able to: The Installation and configure a SharePoint 2016 Farm How to manage a SharePoint 2016 Farm through the GUI and PowerShell How to create site collections via GUI and PowerShell How to create and configure the all the required service applications for SharePoint 2016 How to backup and restore in SharePoint 2016 This SharePoint 2016 Administrator course is design for Administrators who are new to SharePoint Server Administration or who are upgrading from previous versions of SharePoint.This course covers content that was in retired Microsoft Course 20339-1. Module 1: Hardware, Installation and Patching How to build a Min Role Farm How to View ULS Logs How to document and check IIS Settings for SharePoint 2016 Module 2: Farm Management How to manage the SharePoint Farm Administors group How to configure Outgoing Email How to configure Incoming Email How to Configure Diagnostic and Usage Log Options Module 3: Web Applications How to define a new Managed Account How to add new IP Addresses to a SharePoint Server How to create a claims based web application in SharePoint Central Administration How to create a claims based web application in PowerShell How to create a hosting web application in PowerShell Module 4: Site Collections How to create a managed path How to create a site collection using SharePoint Central Administration How to create a site collection using PowerShell How to create a site collection in its own database using SharePoint Central Administration How to create a site collection in its own database using PowerShell How to create a host named site collection using PowerShell Module 5: Service Applications How to create a State Service Application How to create a Search Service Application How to create the Managed Metadate Service Module 6: Application Management How to add a new IP and Certificate to a SharePoint Web Application How to configure DNS for SharePoint Web Application How to Create a Subscription Settings Service Application How to create the Application Management Application Service How to configure the application URLs How to create the App Catalog Site Colleciton How to Add Apps to the catalog Module 7: Managing the User Profile Service How to create the My Site Web Application How to create the User Profile Service Application How to Configure the User Profile Synchronization Permissions How to create the Active Directory Import Connection How to assign permissions for the AD Group to create a My Site How to create a My Site Module 8: Search How to view the currenty Search Topology How to create an Enterprise Search Centre How to configure a new search schema property How to create a site collection-level result source How to create a new content source Module 9: Office Online Server How to install the pre-requisites for Office Online Server How to install the Office Online Server Binaries How to create the Office Online Server SSL Certifcate How to create the Office Online Server Farm How to connect to the farm from SharePoint How to test the connectivity Module 10: Enterprise Content Management How to create and Apply a site policy How to create discovery sets How to configure In Place records management How to configure the records centre How to configure DLP Module 11: Web Content Management How to configure cross-site publication How to configure content deployment Module 12: Workflow Server How to install Workflow Manger server and Client Binaires How to configure the workflow farm How to patch the workflow farm manager and clients How to register the workflow service in SharePoint How to test Workflow creation Module 13: Business Connectity Services and Secure Store How to configure the secure store service How to create the BCS service Application How to setup the products database How to import the BCS Definition How to use the BDC file in a list web part Module 14: Hybrid SharePoint Shown and Demonstrated the Hybrid features of SharePoint 2016 Module 15: Backup and Restore How to backup SharePoint 2016 Content How to delete SharePoint 2016 Content How to restore SharePoint 2016 Content via PowerShell How to recover a unattached content database Module 16: Upgrade How to restore and attach a SharePoint 2013 Database How to upgrade a SharePoint 2013 MMS Service Application Additional course details: Nexus Humans 55355 SharePoint 2016 Administration 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 55355 SharePoint 2016 Administration 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.

The Equality & Diversity in the Workplace Level 3 course provides a deep dive into the principles and practices that ensure fairness and respect for everyone in a professional environment. This course is designed to help learners understand the importance of equality and diversity, offering insights into how these principles can be applied to create a balanced and productive workplace. With a focus on building an inclusive culture, the course tackles various aspects such as legal requirements, the value of diversity, and strategies for promoting equality within teams. By completing this course, you will be equipped to identify potential issues related to discrimination, tackle bias, and contribute to a positive, respectful work atmosphere. Learners will explore topics ranging from managing diverse teams to understanding the benefits of equality and inclusion for both individuals and organisations. Whether you're looking to improve your workplace environment or seeking career advancement, this course provides the essential knowledge to make informed, impactful decisions. It’s a flexible learning option, ideal for anyone who wishes to better understand and contribute to an equitable and respectful workplace. This course will enable you to: Understand the UK laws governing equality and diversity. Discover how to include human rights and inclusivity in the workplace policy. Understand how to do an equity study on a work environment or infrastructure. Learn about the origins and triggers of disruptive prejudice. Learn how to instal positive affirmations that promote equity for all. Key Features: Instant e-certificate Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life Coaching Course *** (Offer Ends Soon) *** Course Curriculum Module One: Understanding Diversity Understanding Diversity Module Two: Understanding Stereotypes Understanding Stereotypes Module Three: Breaking Down the Barriers Breaking Down the Barriers Module Four: Verbal Communication Skills Verbal Communication Skills Module Five: Non-Verbal Communication Skills Non-Verbal Communication Skills Module Six: Being Proactive Being Proactive Module Seven: Coping with Discrimination Coping with Discrimination Module Eight: Dealing with Diversity Complaints as a Person Dealing with Diversity Complaints as a Person Module Nine: Dealing with Diversity Complaints as a Manager Dealing with Diversity Complaints as a Manager Module Ten: Dealing with Diversity Complaints as an Organization Dealing with Diversity Complaints as an Organization Certification Once you've successfully completed your Equality & Diversity in Workplace Level 3 course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is suitable for anyone who wants to improve their knowledge and skills in Equality and Diversity in the workplace, including managers, human resource professionals, employees, and anyone who wants to impact their workplace positively. Human resources executives Training officers Interns Law Students Teacher Requirements Learners do not require any prior qualifications to enrol on this course. Career path Following the career opportunities below, you can pursue them after successfully completing the course: Equalities officer (£22,000 to £45,000 per year) Education welfare officer (£19,000 to £30,000 per year) Heritage officer (£18,500 to £48,000 per year) Public relations officer (£18,000 to £50,000 per year) Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Learn all about Mpox (Monkeypox) symptoms, diagnosis, and treatment in our CPD-certified course. Gain essential skills for workplace safety and public health awareness. Enroll now!

Enhance your plumbing skills with Professional Plumbing Level 2. Master essential techniques, from basic components to UK standards compliance, ensuring proficiency in advanced plumbing practices.

Become certified in Animal Care & Pet Sitting with our comprehensive online course. Gain expertise in animal behaviour, safety, nutrition, and business management, and embark on a rewarding career in the pet care industry. Ideal for pet owners, aspiring professionals, and animal enthusiasts. Sign up today!

Understanding financial accounting is no longer just for number crunchers in grey suits—it’s a core skill that brings clarity to the often-confusing world of business finances. This course introduces you to the bedrock principles of financial accounting, designed in a logical flow that even your sleep-deprived inner auditor would approve of. From double-entry bookkeeping to balance sheets and income statements, you’ll gain insight into how businesses track, report, and evaluate financial performance with purpose and precision. Whether you’re trying to make sense of your business's financial reports or just tired of nodding blankly during budget meetings, this course offers you the language of numbers in a way that makes sense. With a structured, theory-based format, you'll explore the essential components of accounting with clarity and relevance. Perfect for professionals, entrepreneurs, or those with a healthy distrust of spreadsheets, this is your chance to understand the financial ropes—minus the accounting jargon headache. Learning Outcomes: Understand the basics of financial accounting Learn the balance sheet equation and how to prepare financial statements Acquire knowledge of the recording process in financial accounting Gain an understanding of adjusting entries and their impact on financial statements Be able to complete the accounting cycle The Learn the Fundamentals of Financial Accounting course is designed to provide students with a comprehensive understanding of the basics of financial accounting. The course covers the balance sheet equation, financial statements, the recording process, adjusting entries, and completing the accounting cycle. Students will gain a deep understanding of the concepts and principles behind financial accounting and how they are applied in real-world scenarios. This course is perfect for anyone who wants to gain a solid understanding of financial accounting, whether they are new to the field or have some prior knowledge. It is also ideal for small business owners who want to manage their finances more effectively and make informed decisions based on financial data. ⊱⊱ Learn the Fundamentals of Financial Accounting Course Curriculum Module 01: Introduction to Business Module 02: Balance Sheet Equation Module 03: Financial Statements Module 04: Recording Process Module 05: Adjusting Entries Module 06: Completing the Account How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is designed for individuals who are interested in learning the fundamentals of financial accounting. It is suitable for: Students who want to pursue a career in accounting or finance Business owners who want to manage their finances effectively Professionals who want to enhance their accounting skills for career advancement Individuals who want to improve their personal finance management skills Anyone who is interested in learning about financial accounting Career path Accounting Clerk: £16,000 - £25,000 per year Bookkeeper: £18,000 - £30,000 per year Accounts Payable/Receivable Clerk: £18,000 - £30,000 per year Financial Analyst: £30,000 - £50,000 per year Certified Public Accountant (CPA): £40,000 - £90,000 per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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 comprehensive bundle course is designed to provide our learners with a more in-depth understanding of the financial aspects of business management. By combining these relevant CPD courses, they will be fully equipped with the essential skills to manage business accounts effectively and with confidence. Develop a broad understanding of business organisations and all areas of business operations with this beginner's Business Management course. This comprehensive training course is designed to help learners familiarise with the stages of the business process life cycle, the critical practices of business process management. It covers relationship, meeting and change management, helping learners to develop their skills in problem-solving and critical thinking. This course is ideal for aspiring business managers, account executives and business analysts. Discover everything you need to know about recording financial transactions and business accounting with our beginner's guide to Bookkeeping Course. Throughout this course, learners will develop their knowledge of fundamental bookkeeping practices and principles, with an in-depth look at computerised and manual bookkeeping systems. Key topics include ledgers and the different types of ledgers, preparing a trial balance, coding, balance sheets and PNL accounting. This course includes practical training for a wide range of bookkeeping roles. Learning Outcomes of The Business Management & Bookkeeping Training: Learn the fundamental principles and practices of business process management Gain a solid understanding of each stage within the business process life cycle Equip yourself with the essential skills required for successful project management Understand the importance of critical thinking for problem-solving in business Get step-by-step guidance on how to manage business meetings efficiently Familiarise with the benefits and processes of manual & computerised bookkeeping Learn how to prepare, trial balances, balance sheets and financial reports Fast track your career in bookkeeping with an internationally-recognised certificate Understand the basics of profit and loss (PNL) accounting and taxation Develop your understanding of cost coding and the different coding systems Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? This 2-in-1 bundle course is ideal for aspiring business managers and those who are not yet in a bookkeeping role and wish to develop their practical skills and knowledge to improve their career prospects in this sector. It is suitable for a wide range of bookkeeping roles and entry-level roles within the financial sector. Career Path On successful completion, learners will have a fundamental knowledge of bookkeeping for better business management, which will open doors for them in roles such as: Business Manager Bookkeeper Junior Accountant Financial Analyst Internal Auditor

If you want to make better use of the full functional variety of Microsoft office 365 and move beyond its essential functions, then this Microsoft Office 365 course is a must pick for you. Throughout this video training course, you will gain mastery over all the features of Microsoft Office 365 and learn how to use those features for your best advantage.  The Microsoft Office 365 course has four sections that are designed to familiarise you with the various features and usage of the application. This training will also introduce you to the features that are required to know for using Microsoft Office 365.  The Microsoft Office 365 training course is designed to simplify your office work and help you to collaborate easily with your colleagues and customers. Enrol now and increase the rate of success of your organisation through the proper use of Microsoft Office 365. Learning Outcomes of The Microsoft Office 365:  Get a solid understanding of the various features and usage of Microsoft Office 365 Understand how to set up Office 365 and learn how to navigate the user interface. Learn how to configure Skype for Business Experience an in-depth lesson for using SharePoint for expert purposes Learn how to create user resource mailboxes and shared user mailboxes Expand your knowledge of Office 365 Web apps and learn how to use them Learn how to use Skype for business meetings and communicate via Skype for Business Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate.

Our best-selling Nursing Assistant Diploma Course will endow you with the skills and knowledge to provide vital care for patients, ensuring their wellbeing and safety. Nursing Assistants are the critical support service for the UK's Healthcare system, and you can be part of this tradition by training for this meaningful role. The core values and accountabilities that you gain from this tutorial will ensure that patients and staff can expect the highest standards of care when attending your medical facility. Become proficient at all the duties a Nursing Assistant must perform meticulously, whilst learning the ethical practices needed. You will be coached on patient management, critical medical procedures, nutritional requirements, and infection control. Each of these educational modules delivers a masterclass in essential Nursing standards and policies. By taking this Nursing Assistant Diploma Course, opportunities and prospects as a medical professional will reach a new level. This certified training package has been crafted to develop and hone your Healthcare capabilities by using user-friendly study tools and interactive assessments. You will be given every possible advantage to excel in one of the most crucial roles in the Health Industry. Enrol now and ensure the future of the NHS. Please note: This course only gives you the theoretical knowledge that you need to excel in this field. This Nursing Assistant+Nurse Prescribing Diploma doesn't entitle you to practise as a professional in this specific field. Why choose this Nursing Assistant Diploma Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who is this course for? This course is aimed at those individuals attempting to secure a Nursing role in the UK's Healthcare system, and those with aspirations to progress their career to new levels in this area. Career Path The training given by the Nursing Assistant Diploma Course provides significant benefits for those in the Healthcare sector. As such, it will substantially enhance careers or the positions of: Nursing Assistant Trainee Nursing Assistant Care Assistant Hospice Workers Community Care Workers Healthcare Professional