2020 Courses

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.

Do empathy, compassion, and hard work appeal to you as qualities in a career partner? If yes, you might be a perfect fit for the Level 5 Diploma in Health and Social Care. This enriching journey unlocks a world of opportunities within the dynamic realm of Health and Social Care. Delve into the intricacies of Health and Social Care, mastering essential concepts and principles that underpin this dynamic field. Throughout this comprehensive course, you'll gain a deep understanding of the responsibilities, rights, and ethical considerations inherent in Health and Social Care roles. Explore key modules such as Communication and its Relevance, Safeguarding Vulnerable Individuals, and Risk Management in Health and Social Care, empowering yourself with the knowledge and skills necessary to excel in this vital sector. Join us on this transformative journey as you embark on a path towards making a meaningful difference in the lives of others. Whether you're a seasoned professional seeking to enhance your expertise or a newcomer eager to break into the field, our course provides the perfect foundation for success in Health and Social Care. Level 5 Diploma in Health and Social Care Course Learning Outcomes: Comprehend the core principles and values of Health and Social Care. Effectively communicate with diverse groups, fostering trust and understanding. Uphold the rights, dignity, and well-being of individuals served. Navigate the legal and ethical frameworks governing healthcare practices. Implement effective safeguarding measures to protect vulnerable individuals. Contribute to a diverse and inclusive environment, promoting equality and respect. Level 5 Diploma in Health and Social Care Module 01: Introduction to Health and Social Care Module 02: Communication and its Relevance Module 03: Rights and Responsibilities as a Health and Social Care Worker Module 04: Role as A Caregiver and Healthcare Professional Module 05: Working in Health and Social Care; Promoting Equality, Diversity and Rights Module 06: Important Principles and Policies in Health and Social Care Work Module 07: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 Module 08: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 Module 09: Safeguarding Vulnerable Individuals Module 10: Health and Safety Responsibilities Module 11: Risk Management in Health and Social Care Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for Free to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Who is this course for? Level 5 Diploma in Health and Social Care The Level 5 Diploma in Health and Social Care is designed for individuals seeking to enhance their skills and knowledge in the dynamic field of Health and Social Care, like - Health Care Assistant Social Care Worker Support Worker Community Care Assistant Mental Health Worker Learning Disability Support Worker Requirements Level 5 Diploma in Health and Social Care To enrol in this Level 5 Diploma in Health and Social Care course, all you need is a basic understanding of the English Language and an internet connection. Career path Level 5 Diploma in Health and Social Care Senior Healthcare Assistant: £20,000 to £27,000 per year Social Worker: £28,000 to £40,000 per year Care Home Manager: £25,000 to £35,000 per year Community Support Worker: £18,000 to £25,000 per year Health and Social Care Assessor: £22,000 to £30,000 per year Mental Health Support Worker: £19,000 to £28,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included QLS Endorsed Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Boost Your Career By Enrolling In This Library and Information Science Bundle To Overcome Your Challenges! Get a Free 1 QLS Endorsed Certificate Course with 10 Additional CPD QS Accredited Bundle Courses In A Single Payment. If you wish to gain a solid and compact knowledge of Library and Information Science and boost your career, then take a step in the right direction with this industry-standard, comprehensive Library and Information Science bundle of courses, which are well organised. This Library and Information Science bundle package includes 1 Premium, The Quality Licence Scheme-endorsed course, 10 additional CPD QS Accredited Certificate courses, with expert assistance, and a FREE courses assessment included. Learn a range of in-demand technical skills to help you progress in your career with 12 months of unlimited access to this bundle of courses. If you enrol in this package, you will not be charged any extra fees. This Library and Information Science Bundle Package includes: Course 01: Diploma in Library and Information Science at QLS Level 4 10 Additional CPD Accredited Premium Courses - Course 01: Data Entry Administrator Diploma Course 02: Content Management Strategy Course 03: GDPR Training Course 04: Document Control Course 05: Material Management Course 06: Touch Typing Masterclass Course 07: Facilities Management - Course Course 08: Microsoft Excel - Beginner, Intermediate & Advanced Course 09: Critical Thinking Course 10: Online Time Management Training Success becomes a lot simpler with this Library and Information Science bundle package, which allows you to monetise your skills. This bundle is appropriate for both part-time and full-time students, and it can be completed at your own pace. This premium Library and Information Science bundle of courses helps your professional development by receiving an endorsement from the Quality Licence Scheme and CPD QS Accredited Certificate. You'll be able to practice in your own time and speed. The course materials for Library and Information Science are designed by experts, and you can access them. easily from any of your smartphones, laptops, PCs, tablets, etc. Master the skills. You need to arm yourself with the necessary qualities and explore your career opportunities in relevant sectors. Why Prefer This Bundle? You will receive a completely free certificate from the Quality Licence Scheme. Option to receive 10 additional certificates accredited by CPD QS Get a free student ID card! (£10 postal charges will be applicable for international delivery) Engaging voiceover and visual elements for your convenience. Complete the bundle at your own pace. Free assessments and immediate results. 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum: *** >> Diploma in Library and Information Science at QLS Level 4 Module 01: Organisation Systems Module 02: Ethics and Values Module 03: Library Networking Module 04: Library as Infrastructure Module 05: Finance and Budgeting Module 06: Digital and Virtual Libraries Module 07: Library Legislation Assessment Process After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. Show off Your New Skills with a Certification of Completion After successfully completing the Diploma in Library and Information Science at QLS Level 4 , you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, completely free of charge. To Additional the Quality Licence Scheme Endorsed Certificate, you have to pay the price based on the level of these courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 Certificate Accredited by CPD QS Upon finishing the bundle, you will need to order to receive a certificate accredited by CPD QS that is recognised all over the UK and also internationally. The pricing schemes are - Printed Hardcopy Certificate £29 inside the UK. £39 outside the UK (International Delivery). CPD 225 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The bundle aims to help you get the job or even the long-awaited promotion of your dreams.

This coursework will work as a toolkit for you to set your goals right and be able to keep working on them afterward. Be it your health, finance, relationships, or even casual events - Goal Setting and Life Planning course helps you as a planning Guru at your every step. From this coursework, you will discover what really is important for you, and learn how to strive towards it. This course is essentially a capstone for grasping all the techniques to determine your real goals, practice to stay focused, and finally, work it out. It gives out practical instructions that really work!  Highlights of the course  Determine your goals and dreams Learn to stay motivated and focused Explore the methods to work your plans out Discover the secrets to a successful life Establish a positive mindset Map out an effective goal plan What you'll learn Create your PERSONAL COPY of the Life Compass tool Gain control over your life and ensure you take action where it really matters Gain clarity and visibility across all areas of your life Review your critical goals on a monthly basis Celebrate your successes as you go along Who this course is for: Anyone looking to gain more productivity Anyone who lacks of a sense of purpose in his/her life Anyone who feels overwhelmed or having too much to do Anyone who finds it difficult to stay focused on the goals he/she sets for him/herself Anyone who is looking for a turnkey solution for life planning and goal setting Principles and Guidance Welcome FREE 00:01:00 World Class tips for Goal Setting 00:05:00 Mission statement and Values 00:02:00 Long term goals 00:02:00 Monthly Scorecard 00:03:00 Month specific activities 00:06:00 Conclusion 00:04:00 DOWNLOAD YOUR LIFE COMPASS HERE LIFE COMPASS LINK 00:05:00 DEMO videos: HOW TO USE THE LIFE COMPASS DEMO 1 - Mission statement 00:05:00 DEMO 2 - Long term goals 00:06:00 DEMO 3 - Monthly scorecard 00:05:00 DEMO 4 - Energy audit 00:03:00 DEMO 5 - Month specific activities 00:04:00 DEMO 6 - Greg personal Life Compass 00:03:00

This 3 day Tableau Desktop Advanced Training course is designed for professionals who have been working with Tableau for some time and are looking to dive deeper and learn analytical use cases that utilise Tableaus advanced features. It is also a perfect refresher course if you want to upgrade your skills to the latest features. Public Course Options EXTEND YOUR KNOWLEDGE OF TABLEAU IN THIS HANDS-ON COURSE TRAINING £1,200 per person + VAT 3 Day live virtual course 12 Months access to online course This 3 day Tableau Desktop Advanced Training course is designed for the professional who has been working with Tableau for some time and is looking to dive deeper. You will review all calculation types and apply Table Calculations and Level of Detail Expressions in multiple use cases. You will also learn advanced techniques for analysing time series data, cohorts and survey data. You will learn advanced mapping and dashboard techniques to help improve the insights gained for your target audience. You will be introduced to the latest features together with practical use cases for getting the most benefit from them. Attendees should have a deep understanding of the fundamental concepts of building Tableau worksheets and dashboards and be comfortable with the techniques learnt in the Foundation and Analyst courses. At the end of this course you will be able to apply and combine some of the more complex capabilities and techniques that Tableau has to offer. In addition to our regular 2 day syllabus we have added an additional day so that we can add learning for many new features introduced into Tableau over the last couple of years. Live Coaching and Q&A Access In addition to the 3 day live and interactive course, delegates also receive 6 weeks live access to our Coaching and Q&A calls that take place 3 times each week. Delegates have found these to be highly beneficial to enhance their learning experience as well as assisting with applying the learning from the course to practical working deliverables on their own data. The course includes the following topics: RECAP: CALCULATIONS Review of Number Functions Review of String Functions Review of Date Functions Review of Type Conversions Review of Logical Functions Review of Aggregate Functions Alternatives to Calculations 2 Hands-on exercises GETTING THE MOST FROM TABLE CALCULATIONS What are and when to use Table Calculations What Table Calculation Types are there? Defining the Scope and Direction of calculations Using Table Calculations in Calculated Fields How do Filters work with Table Calculations? 7 Hands-on exercises LODS - LEVEL OF DETAIL EXPRESSIONS Overview FIXED LOD How do Filters work with LODs? INCLUDE LOD EXCLUDE LOD Nesting LODs Comparing the various Calculation Types 5 Hands-on exercises ADVANCED TECHNIQUES FOR ANALYSING TIME-BASED DATA Creating Sparklines Creating Slope Charts Creating Control Charts Creating Bump Charts 4 Hands-on exercises ANALYSING BEHAVIOURS IN DATA Creating Cohort Analysis Analysing Survey Data 2 Hands-on exercises ADVANCED TECHNIQUES FOR MAPPING Mapping Distance from a point Normalising map areas with Hexbins Combining Spatial & Data Files 3 Hands-on exercises ADVANCED CONSIDERATIONS FOR DASHBOARDS Identifying your Audience Using Containers and Layout Considerations for Dashboard Elements Sheet swapping Adding Dashboard Actions to Context 2 Hands-on exercises In addition to the regular syllabus we will also cover the following New Features : Viz in Tooltips Set Actions Parameter Actions Show/Hide Containers Animations Dashboard Navigation Button Replace Worksheet in a Dashboard (DB) Show/Hide Sort Controls Vector Maps Customisable reference line tooltips Automatic dashboard phone layouts Export to PowerPoint Transparent worksheet backgrounds Density Mark Type (New Heatmap) Dashboard Extensions Step and Jump Lines Dashboard Grids Nested sorting improvements Ask Data Explain Data Spatial Calculations Negative values on log axis Additional clustering functionality Enhanced cross-database join control This training course includes over 35 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. A comprehensive training manual is provided together with all the data, starter and solution Tableau Workbooks required for the training.  Students must use their own laptop with an active version of Tableau Desktop 2020.1 (or later) pre-installed. What People Are Saying About This Course "Course was fantastic and completely relevant to the work I am doing with Tableau. I particularly liked Steve's method of teaching and how he applied the course material to 'real-life' use-cases."Richard W., Dashboard Consulting Ltd "This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work."Lauren M., Baillie Gifford "I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I've learned into practice."Aron F., Grove & Dean "Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work."John B., Mporium

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Welcome to the Advanced Health & Social Care course! With a growing population and increasing demand for health and social care services, the need for highly skilled professionals in this field is higher than ever. According to recent statistics, the health & social care sector is one of the largest employers in the UK, providing jobs to over 3 million people and contributing £38.5 billion to the economy. This Health & Social Care in the UK course is designed to equip you with the essential knowledge and skills needed to succeed in this dynamic and rewarding industry. This Advanced Certificate in Health & Social Care in the UK at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Throughout the Health & Social Care in the UK course, you will learn about the UK health system, including its policies and legislation, and gain an understanding of the fundamental aspects of providing quality health and social care. By the end of the Health & Social Care in the UK programme, you will have developed a range of advanced skills, such as critical thinking, communication, and leadership, which are highly valued by employers in the sector. At the end of this Health & Social Care in the UK course, you will: Demonstrate an understanding of the UK health system and its policies Understand the essential principles, policies and legislations in health & social care work Analyse the fundamental aspects of providing quality health and social care Evaluate the impact of health and social care on individuals, communities, and society as a whole Develop advanced skills in critical thinking, communication, and leadership Demonstrate a commitment to professional ethics and values in health & social care work This Health & Social Care in the UK training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Health & Social Care in the UK at QLS Level 3 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Module 01: Introduction to Advanced Health and Social Care Module 02: Introduction to the UK Health System Module 03: Essential Principles, Policies and Legislations in Health and Social Care Work Module 04: Fundamental Aspects of Providing Quality Health Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Advanced Certificate in Health & Social Care in the UK at QLS Level 3 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Health & Social Care in the UK course is ideal for: Individuals looking to start a career in health & social care Professionals who wish to enhance their knowledge and skills in the field Anyone who wants to make a positive impact on the lives of others Requirements Health & Social Care at QLS Level 3 No prior background or expertise is required. Career path Healthcare Assistant - £19,000 Support Worker - £20,000 per annum Social Worker - £31,000 per annum Occupational Therapist - £32,000 per annum Registered Nurse - £33,000 per annum Health Service Manager - £42,000 per annum Enroll now and take the first step towards a fulfilling career in health & social care in the UK. Certificates Advanced Certificate in Health & Social Care in the UK at QLS Level 3 Hard copy certificate - Included After successfully completing the Advanced Certificate in Health & Social Care in the UK at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost. CPDQS Accredited Certificate Digital certificate - Included

For individuals who are not accounting specialists, the budgeting process can be a mysterious and frightening experience. This course seeks to dispel the myths and misunderstandings around budgeting by describing the process and its significance in simple terms.

With this hands-on video course, you'll gain a solid understanding of AWS, DevOps, and deployments at scale using ECS with the help of examples and activities. Throughout the course, you'll get to grips with a wide variety of AWS services.

This course covers the essential topics necessary for working with Microsoft SQL Server. You will understand the various scenarios and techniques to write queries and build and administer databases, along with delving into advanced SQL topics that are in great demand in the industry.

Course Overview Discover new levels of self-awareness and show conviction in your beliefs and values when you take this training to Become the Best Version of Yourself. It's all too easy to let life and events change our characteristics or for us to put up a façade that hides our true feelings. Move away from that behaviour by taking this inspiring course that empowers you to feel your best, live your life as you want to, and be a better person. This Personal Improvement tutorial specifically looks at the way that we perceive ourselves and how we can do this in a more positive way. You will be taught how to be 'authentic', perform activities that you want to do without feeling judged or uncomfortable, live the lifestyle that you have chosen, interact with other individuals in a natural way, and so much more. This is an eye-opening journey into the truth of oneself and how being honest about your feelings leads to new kinds of personal freedom. Enrol now and start living the life you deserve. This best selling Become the Best Version of Yourself has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Become the Best Version of Yourself is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Become the Best Version of Yourself is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Become the Best Version of Yourself is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Become the Best Version of Yourself, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Become the Best Version of Yourself will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Become the Best Version of Yourself to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.