• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

7602 Courses

The LMI Foundations of Success workshop introduces the concepts and practical tools used to help countless individuals within thousands of organisations, of all sizes and complexity in both the public and private sector, realise more of their true potential.

Foundations of Success
Delivered OnlineFlexible Dates
£298.8

Cybersecurity: An Introduction to Cybersecurity

5.0(1)

By Enspark

Explore the world of cybersecurity beyond firewalls and antivirus software in this micro-learning course. Discover the critical role employees play in safeguarding your organization's digital assets and learn about the motivations behind cybercrimes. Gain insights into the dynamic landscape of digital threats and the alarming growth of cybercrime. This course will equip you with essential knowledge to protect yourself and your company from security breaches, emphasizing the importance of vigilance and awareness. Learning Objectives Construct a dedicated and productive remote workspace, considering factors such as comfort, organization, and freedom from distractions, to enhance focus and work-life balance.;Develop effective time management skills and routines, including setting clear boundaries, prioritizing tasks, and scheduling breaks, to optimize productivity and prevent burnout in a hybrid work setting.;Enhance your communication and collaboration skills with the steps to accurately engage in virtual meetings, share ideas, and foster effective teamwork, ensuring successful interactions in the hybrid workspace.

Cybersecurity: An Introduction to Cybersecurity
Delivered Online On Demand10 minutes
£4.95

Lean Six Sigma Green Belt - 8 Courses Bundle

By NextGen Learning

In an era marked by hyper-competition and constant flux, mastering the art of Lean Six Sigma offers a compelling edge. With this course, you'll delve into the theoretical intricacies of streamlined operational processes, redefining productivity and quality in your professional landscape. Learn the science of reducing waste and increasing efficiency, making you an indispensable asset in the 21st-century workforce. With a staggering 82% of Fortune 100 companies using Lean Six Sigma, the value of this methodology has never been more apparent. This course invites you to join this elite cadre of efficient problem-solvers, offering an in-depth study of Lean Six Sigma in the theoretical realm. Uncover how to reduce waste, enhance productivity, and elevate quality standards. This course offers a comprehensive bundle, specially designed for your convenience, allowing you to immerse in the theoretical realm of Lean Six Sigma from the comfort of your home. It carefully curates a journey from the foundational knowledge of the White Belt, up to the advanced expertise of the Green Belt. Complemented by a study of operations management and a detailed Six Sigma toolkit, this course paves the way for operational efficiency and quality improvement in any professional setting. So, whether you are looking to scale the corporate ladder, or seeking to launch a start-up with streamlined operations, this course opens the gateway to honing your Lean Six Sigma skills at your own pace and in your own space. The five CPD Accredited courses are: Course 01: Diploma in Lean Process and Six Sigma Course 02: Complete Lean Six Sigma Green Belt Course for Service Industry Course 03: Lean Six Sigma White Belt course Course 04: Operations Management: Process Mapping & Supply Chain Course 05: Process Improvement Course 06: Process Improvement: How to Reduce Waste Course 07: Lean Six Sigma: Toolkit Course 08: Project Management: How to Build a Project Charter Learning Outcomes Understand the principles and methodologies underpinning Lean Six Sigma. Gain insights into the process mapping and supply chain within operations management. Absorb foundational knowledge with the Lean Six Sigma White Belt course. Progress to advanced mastery with the Complete Lean Six Sigma Green Belt course. Familiarise with the Lean Process, and elevate your understanding of Six Sigma. Equip yourself with a comprehensive Lean Six Sigma toolkit, boosting your problem-solving skills. Diploma in Lean Process and Six Sigma: Foundational course covering Lean Process and Six Sigma methodologies. Participants learn to identify and eliminate process inefficiencies, reduce defects, and enhance organisational performance. Lean Six Sigma Green Belt for Service Industry: Tailored for the service sector, focusing on applying Lean Six Sigma to improve service processes. Emphasis on customer satisfaction and operational excellence. Lean Six Sigma White Belt: Introductory course providing a basic understanding of Lean Six Sigma concepts for beginners. Operations Management: Process Mapping & Supply Chain: Explores process mapping and supply chain optimisation in operations management. Participants learn to visualise processes and improve supply chain efficiency. Process Improvement: Covers core principles and strategies for process improvement, including identifying areas for enhancement and measuring impacts. Process Improvement - How to Reduce Waste: Focuses on Lean Six Sigma principles to identify and eliminate waste in processes, contributing to cost savings and improved efficiency. Lean Six Sigma: Toolkit: Equips participants with a toolkit of essential Lean Six Sigma methodologies and tools for practical implementation. Project Management: Building a Project Charter: Guides participants in building a project charter within the Lean Six Sigma framework, ensuring effective initiation and leadership of projects. Embark on your Lean Six Sigma journey, and stay ahead in your professional journey! CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Lean Six Sigma course is suitable for: Aspiring professionals keen to explore operational excellence through Lean Six Sigma. Existing operational managers seeking to enhance their knowledge of Lean Six Sigma. Individuals aiming to embark on a quality control career pathway. Entrepreneurs aiming for streamlined operations in their start-ups. Requirements Without any formal requirements, you can delightfully enrol in this Lean Six Sigma course. Career path This Lean Six Sigma course will help you to pursue different career paths: Lean Six Sigma Consultant - £45K to 65K/year. Operations Manager - £30K to 50K/year. Process Improvement Manager - £35K to 55K/year. Quality Assurance Analyst - £25K to 45K/year. Supply Chain Analyst - £28K to 50K/year. Lean Six Sigma Trainer - £40K to 70K/year. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Lean Six Sigma Green Belt - 8 Courses Bundle
Delivered Online On Demand24 hours
£39

Level 3 HR Management Diploma (with QLS Endorsed Certificate) Course

By Training Express

Unlock the secrets of effective HR management with our Certificate in HR Management at QLS Level 3. Dive deep into the core aspects of human resources, from recruitment to UK employment law. Equip yourself with the tools to foster a thriving workplace, ensuring employee satisfaction and organisational success. Whether you're a budding HR enthusiast or a seasoned professional, this course offers a comprehensive guide to mastering the intricacies of HR. With ten meticulously designed modules, you'll gain the knowledge and skills to navigate the dynamic world of human resources with confidence. Learning Outcomes Understand the fundamentals of human resource management. Master the recruitment and selection process. Learn effective employee training and development strategies. Grasp the essentials of performance appraisal management. Navigate complex employee relations. Promote health and safety in the workplace. Familiarise with key UK employment laws. Key Features FREE QLS-endorsed certificate 4 Free CPD Accredited Courses with Free e-Certificates CPD Accredited Hard Copy Certificates Fully online, interactive courses Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Free Courses Human Resource Change Management Conflict Resolution in the Workplace Safer Recruitment Training GDPR for Business Course What Will You Learn from This Course? Embark on a transformative journey into the realm of HR management. This course offers a comprehensive overview, ensuring you are well-equipped to handle the challenges and opportunities in the HR sector. Module 01: Introduction to Human Resource Delve into the basics of HR. Understand its significance in organisations. Module 02: Employee Recruitment and Selection Procedure Discover the art of hiring. Learn to select the right candidate. Module 03: Employee Training and Development Process Explore strategies to nurture talent. Enhance employee growth and productivity. Module 04: Performance Appraisal Management Grasp the methods of evaluation. Understand how to provide constructive feedback. Module 05: Employee Relations Dive into the dynamics of workplace relationships. Learn to foster a harmonious environment. Module 06: Motivation and Counselling Understand the keys to employee motivation. Learn counselling techniques for staff well-being. Module 07: Ensuring Health and safety at the Workplace Prioritise workplace safety. Learn to create a hazard-free environment. Module 08: Employee Termination Navigate the sensitive process of letting go. Ensure a respectful and lawful termination. Module 09: Employer Record and Statistics Master the art of record-keeping. Understand the importance of accurate data. Module 10: Essential UK Employment Law Familiarise with UK's legal landscape. Ensure compliance and protect employee rights. Certificate Once you've successfully completed your course, you will immediately be sent a CPD Accredited PDF certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). After successfully completing the assignment, learners will be able to order a FREE QLS-endorsed certificate. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring HR managers and executives. Small business owners managing their teams. Team leaders aiming for HR roles. Graduates seeking a career in HR. Office managers overseeing staff. Entrepreneurs wanting to understand HR. Line managers keen on employee development. Administrative staff transitioning to HR roles. Requirements There are no formal requirements for this bundle courses to be enrolled. Career path HR Manager Recruitment Consultant Training and Development Officer Employee Relations Specialist Health and Safety Advisor Employment Law Advisor. Certificates CPD Accredited e-Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate 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. QLS Endorsed Certificate Hard copy certificate - Included

Level 3 HR Management Diploma (with QLS Endorsed Certificate) Course
Delivered Online On Demand
£100

Critical Thinking Skills Course

3.5(2)

By Elearncollege

Description Critical Thinking Skills Diploma   Critical thinking involves judgments based on the evaluation of facts. However, critical has more than one definition, usually including unbiased, sceptical, and rational assessment or analysis of genuine evidence. It involves self-monitored, self-corrective, self-disciplined, and self-directed thinking. It necessitates the approval of meticulous quality standards and mindful awareness of usage. Critical thinking requires problem-solving and communication abilities to overcome inherent sociocentrism and egocentrism. The earliest record of problem-solving and critical thinking is considered Socrate's teachings transcribed by Plato. The transcriptions included a section of Plato's early dialogues involving Socrates' conversation with a dialogist on ethics (for example, whether or not it was ethical for him to break out from prison). An essential skill that one can instigate is the ability for critical thinking. It can help in both professional and personal life. It assists in decision-making and problem-solving, providing the instruments required for careful analysis and evaluation of a situation to develop a plan of action. Instigating critical thinking in an individual involves building a proper understanding of thinking critically and applying that understanding to practical life. This Critical Thinking Skills Diploma delves deeper into reasoning and critical thinking and its application. Critical Thinking Skills Diploma introduces the abstract instruments required for critical thinking, including a brief look into recognizing a few central problems. Knowledge is crucial to survive and thrive in present-day society. Sound reasoning and outstanding critical thinking capability can better understand the area. The Critical Thinking Skills Diploma provides its learners with the skill to critically analyze and make wise decisions and judgments in their life. Through these reasoning and critical thinking methods, one can minimize the occurrences of mistakes and reduce the chances of negatively affecting their own or others' lives. The Critical Thinking Skills Diploma will polish its learners and make them more disciplined and rational thinking. It will reduce one's bias and prejudices to understand their environment better. The Critical Thinking Skills Diploma course imparts identifying, evaluating, and differentiating between irrelevant and relevant information. This improves productivity and adds to the CV of individuals in jobs that need logical and critical thinking. Whether an individual is a student, professional, or seeker, this Diploma course in Critical Thinking can be of great value. The skills to debate, reason analytically, and think logically with excellent communication skills can be gained from this Diploma course by Elearncollege. A course with Elearncollege comes with a lot of perks. The materials for the Diploma course in Critical Thinking are delivered directly to the learners and are adaptable to suit one's way of life. It is designed by skilled professionals within the discipline, meaning that it consists of accurate and relevant information delivered in an easy-to-follow manner. The Diploma course in Critical Thinking consists of professionally designed e-Learning interactive quizzes and modules, all delivered to the learners through an unlimitedly accessible system. What you will learn  1: Critical Thinking  2: Sociology of Thinking  3: Critical Thinking and Solving Puzzles with Analogy based reasoning  4: Thinking in Circles  5: Graphical Tools 6: Constructing Knowledge  7: Critical Writing Skills  8: Effective Learning  9: Reason and Argument  10: Rhetoric  Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Critical Thinking Skills Course
Delivered Online On Demand9 days
£99

Kaizen Practitioner Course

3.5(2)

By Elearncollege

Description Kaizen Practitioner Diploma  Your gateway to mastering the renowned Japanese methodology of continuous improvement. This online course is meticulously designed for individuals who aspire to uplift their professional or personal life by embedding the principles of Kaizen into their everyday routines. The Kaizen Practitioner Diploma is not just another course; it's a transformative journey. With this diploma, participants will delve deep into the understanding of Kaizen philosophy. Rooted in Japanese culture, Kaizen signifies 'change for better'. Through this course, students will grasp the core essence of this philosophy and comprehend the essence of continuous growth and development. One of the standout features of this diploma is the comprehensive study of the Kaizen mindset. In today's dynamic world, having a mindset that is open to change and growth is paramount. The course extensively covers how to cultivate this mindset, ensuring learners adapt and thrive in varied situations, both professionally and personally. Leadership plays a pivotal role in the successful implementation of Kaizen. The Kaizen Practitioner Diploma sheds light on the significance of leadership within the Kaizen framework. Leaders are not just born; they are made. Through this course, learners will uncover the qualities and strategies that can make one an effective leader in driving continuous improvement in any setting. Armed with knowledge is one thing, but having the right tools and techniques is equally crucial. The diploma introduces a wide range of Kaizen tools and techniques tailored to enhance efficiency, reduce waste, and boost overall productivity. This is further complemented with an in-depth exploration of Kaizen events, often referred to as Kaizen Blitz. These events are intensive, short-term projects that bring about swift transformations. Life is not just about work and professional endeavours. The beauty of the Kaizen Practitioner Diploma lies in its holistic approach. Participants will uncover the magic of incorporating Kaizen into their daily routine, making every day a little better than the last. The course also highlights the magic of implementing Kaizen in personal life, ensuring that students experience growth not just at work, but at home too. Businesses and organisations around the world have long embraced Kaizen for its unparalleled advantages. Through this diploma, learners will gain insights into how Kaizen principles can revolutionise business and management practices. By adopting Kaizen, organisations can drive efficiency, boost morale, and achieve sustainable growth. However, like any methodology, Kaizen too comes with its set of challenges. But fret not, for the Kaizen Practitioner Diploma doesn't just introduce problems - it offers solutions. The course delves into potential obstacles that one might face while implementing Kaizen and provides effective strategies to overcome them. As learners approach the end of this transformative journey, the course offers a glimpse into the future. 'Kaizen: The Journey Forward' serves as a beacon, guiding learners on how to carry forward the principles of Kaizen throughout their lives, ensuring that the journey of continuous improvement never truly ends. In essence, the Kaizen Practitioner Diploma is more than just a course; it's a life-altering experience. Enrol now and embark on a journey of perpetual growth and improvement. What you will learn 1:Understanding Kaizen Philosophy 2:The Kaizen Mindset 3:The Role of Leadership in Kaizen 4:Kaizen Tools and Techniques 5:Kaizen Events (Kaizen Blitz) 6:Incorporating Kaizen in Daily Routine 7:Kaizen in Business and Management 8:Kaizen in Personal Life 9:Challenges and Solutions in Kaizen Practice 10:Kaizen: The Journey Forward Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Kaizen Practitioner Course
Delivered Online On Demand9 days
£99

Personal Development Course

3.5(2)

By Elearncollege

Description Personal Development Diploma Introducing the Personal Development Diploma, a comprehensive online course tailored for those eager to advance on their personal growth journey. This diploma offers a detailed exploration of various aspects pivotal to personal improvement, enhancing both one's professional and personal life. At the heart of the Personal Development Diploma is the module on 'The Power of Self-Awareness'. Recognising and understanding oneself is the cornerstone of all personal growth. With this module, learners will be armed with the tools and insights to grasp their strengths, weaknesses, and the facets of their character that make them unique. Goal-setting cannot be emphasised enough when discussing personal growth. The segment on 'Goal-Setting and Planning' equips participants with the strategies to set clear, achievable objectives. It guides learners on plotting their journey, ensuring that each step they take is aligned with their overarching ambitions. In a rapidly changing world, adaptability is essential. 'Embracing Change' delves into the nuances of adjusting to new circumstances. This module teaches learners not just to cope, but to thrive amidst change, using it as a launchpad for further growth. Of course, time is the most invaluable resource we have. The 'Mastering Time Management' segment offers techniques to maximise productivity while balancing work and leisure, ensuring that every moment counts. Life will invariably present challenges. With 'Cultivating Resilience', participants will learn to weather the storms, bouncing back from setbacks and emerging even stronger. Good health isn't merely the absence of illness. It's a holistic state of physical, mental, and social well-being. The 'Developing Healthy Habits' module instils in learners the significance of holistic wellness, teaching them habits that will benefit them in the long run. Interactions form a significant part of our daily lives. 'Enhancing Interpersonal Relationships' sheds light on nurturing and maintaining meaningful relationships, be it in the workplace, family, or social circles. The importance of looking inwards and caring for oneself cannot be overstated. 'Mindfulness and Self-Care' offers learners insights into the art of being present and the significance of self-nurturing practices, which are paramount for mental and emotional wellness. We often are our own harshest critics. The 'Overcoming Limiting Beliefs' section aids learners in identifying and challenging the self-imposed barriers that hamper growth. With this, they are better positioned to unlock their full potential. Lastly, every journey requires direction. 'Finding Meaning and Purpose' helps learners discover their true calling, ensuring their efforts are channelled towards what truly resonates with their core. The Personal Development Diploma is more than just a course; it's a transformative experience. Crafted meticulously for the digital age, this online course ensures flexibility, allowing learners to progress at their pace from the comfort of their spaces. Embarking on this diploma is not merely about acquiring knowledge; it's about metamorphosis into a more aware, focused, and resilient individual. Join the myriad of individuals who have chosen the Personal Development Diploma to embark on a life-altering journey of growth and enlightenment. Your future self will thank you. What you will learn 1:The Power of Self-Awareness 2:Goal-Setting and Planning 3:Embracing Change 4:Mastering Time Management 5:Cultivating Resilience 6:Developing Healthy Habits 7:Enhancing Interpersonal Relationships 8:Mindfulness and Self-Care 9:Overcoming Limiting Beliefs 10: Finding Meaning and Purpose Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Personal Development Course
Delivered Online On Demand9 days
£99

HR Management Training Level 4 - QLS Endorsed Course

By Training Express

Do you dream of being a top HR manager? Do you want to attract & hire top talent, manage employee performance, and build a positive and productive workplace? If so, then this HR management training course is perfect for you. Starting with two QLS Endorsed courses, this bundle has 30 comprehensive course that will teach you the ins & outs of HR management. From recruitment and onboarding to performance management and employee relations, our bundle has it all for you. Key Features Quality Licence Scheme (QLS) endorsed Accredited by CPD Instant e-certificate Fully online, interactive Estate Agent course with audio voiceover Self-paced learning and laptop, tablet, and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchase Don't wait any longer. Enrol now & take your people managing skills to the next level! The HR Management Training bundle is a comprehensive program that provides you with the skills and knowledge you need to succeed in a human resources career. The bundle includes 30 courses that cover all aspects of HR, from recruitment and onboarding to performance management and employee relations. This bundle includes the following courses: Course 01: Diploma in Human Resources Management at QLS Level 4 Course 02: Diploma in UK Employment Law at QLS Level 5 Course 03: Interview and Recruitment Course 04: Recruitment and Termination Course 05: Safer Recruitment Training Course 06: Employee Performance Management Course 07: Employee Relations Course 08: Corporate Governance Course 09: Online Meeting and Virtual Conference Course 10: Facilities Management Course 11: Motivation Course 12: Life Coaching and Career Counselling Course 13: Workplace Confidentiality Course 14: General Data Protection Regulation (GDPR) Awareness Course 15: Workplace Productivity Course 16: Change Management Course 17: Team Management Course 18: Stakeholder Management Course 19: Contract Analyst Course 20: Management Skills: A New Manager Course 21: Decision Making and Critical Thinking Course 22: Presentation Skills Course 23: Equality, Diversity and Discrimination Course 24: Cross-Cultural Awareness Training Course 25: Document Control Course 26: Information Management Course 27: Microsoft Word, PowerPoint & Outlook Course 28: Corporate Paralegal Course 29: Admin, Secretarial & PA Course 30: Time Management Learning outcomes The HR Management Training bundle will teach you the following: How to attract and hire top talent How to manage employee performance How to build a positive and productive workplace How to comply with employment laws How to resolve employee relations issues And much more! Certification CPD Certified: Once you've successfully completed your HR Management course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed: After successfully completing the HR Management course, learners will be able to order two endorsed certificate, titled: Diploma in Human Resources Management at QLS Level 4 for £89.00 and Diploma in UK Employment Law at QLS Level 5 for £109.00, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. Accreditation This Teaching Assistant Diploma course is Quality Licence Scheme (QLS) Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 128 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The HR Management Training bundle is for anyone who wants to learn about human resources management. This includes: HR professionals who want to stay up-to-date on the latest trends and best practices Business leaders who want to understand the HR function and how it can help their organization succeed Students who are interested in a career in HR Anyone who wants to learn more about how to manage people and build a positive and productive workplace Requirements There are no formal requirements for this bundle courses to be enrolled. Career path The career path for HR professionals in the UK varies depending on experience, skills, and qualifications. However, some common roles and salary ranges include: HR Assistant: £20,000 - £25,000 HR Coordinator: £25,000 - £30,000 HR Manager: £30,000 - £40,000 HR Director: £40,000 - £60,000 Head of HR: £60,000 - £100,000 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. QLS Endorsed Certificate Hard copy certificate - £89 Diploma in Human Resources Management at QLS Level 4 QLS Endorsed Certificate Hard copy certificate - £109 Diploma in UK Employment Law at QLS Level 5

HR Management Training Level 4 - QLS Endorsed Course
Delivered Online On Demand
£200

SQL Querying Fundamentals - Part 2

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

SQL Querying Fundamentals - Part 2
Delivered OnlineFlexible Dates
£495

Keep Going with QuickBooks

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2015, 2016 or 2018. Overview Upon completion of this course, students will be able to work with memorized transactions, customize forms, work with credit card, fixed asset, and long-term liability accounts, work with and customize reports, create graphs, track and pay sales tax, and understand how to prepare to use payroll with QuickBooks. From reporting to automating tasks, working with more advanced features and accounts, this course moves beyond the basics and enables students to work with more advanced features in QuickBooks. Memorizing Transactions Entering a New Memorized Transaction Editing a Memorized Transaction Deleting a Memorized Transaction Grouping Memorized Transactions Using a Memorized Transaction Printing the Memorized Transaction List Customizing Forms Creating a Custom Template Modifying a Template Printing Forms Using Other QuickBooks Accounts Other QuickBooks Account Types Working with Credit Card Transactions Working with Fixed Assets Working with Long-Term Liability Accounts Using the Loan Manager Creating Reports Working with QuickReports Working with Preset Reports Sharing Reports Exporting Reports to Microsoft Excel Printing Reports Creating Graphs Creating QuickInsight Graphs Using QuickZoom with Graphs Working with the Sales Graph Customizing Graphs Printing Graphs Tracking and Paying Sales Tax Using Sales Tax in QuickBooks Setting Up Tax Rates and Agencies Indicating Who and What Gets Taxed Applying Tax to Each Sale Determining What You Owe Paying Your Tax Agencies Preparing Payroll with QuickBooks Using Payroll Tracking Setting Up for Payroll Setting Up Employee Payroll Information Setting Up a Payroll Schedule Writing a Payroll Check Printing Paycheck Stubs Tracking Your Tax Liabilities Paying Payroll Taxes Preparing Payroll Tax Forms Using Online Banking Setting Up an Internet Connection Setting Up Bank Feeds for Accounts Viewing, Downloading, and Adding Online Transactions Creating Online Payments Transferring Funds Online Canceling Online Payments Managing Company Files Using QuickBooks in Multi-user Mode Setting Up Users and Passwords Setting a Closing Date Sharing Files with an Accountant Updating QuickBooks Backing Up and Restoring a Company File Condensing a Company File Estimating, Time Tracking, and Job Costing Creating Job Estimates Creating an Invoice from an Estimate Displaying Reports for Estimates Updating the Job Status Tracking Time Displaying Reports for Time Tracking Tracking Vehicle Mileage Displaying Vehicle Mileage Reports Displaying Other Job Reports Writing Letters Using the Letters and Envelopes Wizard Customizing Letter Templates

Keep Going with QuickBooks
Delivered OnlineFlexible Dates
£790