20592 Courses

Microsoft Excel assists you to perform with different programs such as calculation, macro program language, pivot tablets, graphics tools, and various applications within time. Learn much more precise use of these functions with the easiest and effective method thorough Microsoft Office 2016 Excel Beginners course. The course teaches you the basic functions of Excel. It instructs you how to open Excel files, make a simple calculation, and save it. It also teaches you how to put data, extract data, analyze actionable information, and perform in different ways. The purpose of the course is to enhance your ability to kick-start your career in a sound bite. Who is this Course for? Microsoft Office 2016 Excel Beginners is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Course Overview: Discover the vital skills needed to safeguard vulnerable adults and provide adequate first aid in the workplace with our comprehensive Counselling Course - Adult Safeguarding and First Aid Training. This course is designed to equip you with the knowledge and expertise to ensure the safety and well-being of vulnerable adults while enabling you to respond confidently to medical emergencies in the workplace.With carefully curated modules, this course provides an in-depth understanding of safeguarding legislation, identifying and preventing abuse and neglect, and the importance of effective communication in care. You will learn how to respond to disclosures and report concerns, establishing a supportive and protective environment for vulnerable adults. Furthermore, our Workplace First Aid section will guide you through incident management,primary and secondary surveys, basic first-aid techniques, and handling fractures, dislocations, and emergencies.Your journey towards a rewarding and impactful career starts here. Enrol now! Key Features of the Course: CPD certificate upon completion to enhance your professional portfolio. 24/7 learning assistance to support your learning journey. Who is This Course For? This Counselling Course - Adult Safeguarding and First Aid Training is ideal for individuals who are involved in caregiving or support roles for vulnerable adults. It is also valuable for professionals working in sectors such as healthcare, social work, education, and community services, who are responsible for the well-being and safety of adults in their care. What You Will Learn: In this Counselling Course - Adult Safeguarding and First Aid Training, you will gain a deep understanding of the legal framework surrounding safeguarding vulnerable adults, including key legislation and policies that inform and guide your practice. You will learn to identify different forms of abuse and neglect, enabling you to take proactive steps to prevent and address these issues effectively. Also, a crucial aspect of providing quality care is effective communication. You will explore the importance of clear and empathetic communication in building trust and establishing strong relationships with vulnerable adults. Additionally, you will develop the skills to handle sensitive information, respond appropriately to disclosures, and maintain confidentiality while ensuring the well-being and safety of those in your care.Moreover, the Workplace First Aid section of the course will equip you with vital life-saving techniques and knowledge. You will learn how to effectively manage incidents in the workplace, conduct primary and secondary surveys to assess the severity of injuries or illnesses, and apply basic first-aid techniques to provide immediate assistance. From minor injuries to more serious emergencies, you will gain the skills and confidence to respond swiftly and appropriately in critical situations. Why Enrol in This Course: Acquire essential skills to safeguard vulnerable adults and respond to medical emergencies. Benefit from a top-reviewed course recently updated to meet current industry standards. Gain insights into the trending field of adult safeguarding and first aid training. Enhance your employability by adding valuable skills to your professional repertoire. Boost your confidence in handling critical situations and providing timely assistance. Requirements: No prior experience or qualifications are necessary to enrol in this Counselling Course - Adult Safeguarding and First Aid Training. However, a basic understanding of care or work environments involving vulnerable adults will be beneficial. Career Path: Upon completing this course, you will have acquired valuable skills that are helpful for various career opportunities. Some potential professions related to this course in the UK include Adult Care Worker (£18,000 - £24,000 per annum) Support Worker (£16,000 - £22,000 per annum) Social Worker (£27,000 - £40,000 per annum) Healthcare Assistant (£15,000 - £23,000 per annum) Community Service Worker (£20,000 - £30,000 per annum) Counsellor (£20,000 - £40,000 per annum) First Aid Trainer (£18,000 - £30,000 per annum) Certification: Upon successfully completing the Counselling Course - Adult Safeguarding and First Aid Training, you will receive a CPD certificate as evidence of your new skills and expertise in adult safeguarding and first aid. This certification will enhance your professional profile and demonstrate your commitment to ensuring the well-being and safety of vulnerable adults. Course Curriculum 2 sections • 19 lectures • 07:39:00 total length •An Introduction to Safeguarding of Vulnerable Adults: 00:17:00 •Safeguarding Legislations: 00:26:00 •Understanding Abuse and Neglect: 00:28:00 •Safeguarding Vulnerable Adults Policy, Roles and Responsibilities: 00:30:00 •Understanding the Importance of Communication in Care: 00:21:00 •Sharing Information and Responding To a Disclosure: 00:35:00 •Reporting Your Concern: 00:28:00 •Introduction to Workplace First Aid: 00:32:00 •Legal Framework for Workplace First Aid: 00:27:00 •Incident Management at Work: 00:30:00 •Primary Survey: 00:16:00 •Secondary Survey: 00:17:00 •Basic First-Aid Techniques: 00:36:00 •Dealing with Minor Injuries at the Workplace: 00:39:00 •Secondary Illness Loss of Responsiveness and CPR: 00:14:00 •Secondary Illness Breathing Problems: 00:13:00 •Secondary Illnesses and Injuries: 00:25:00 •Dealing With Fractures and Dislocations: 00:15:00 •Call for an Emergency: 00:10:00

Course Overview: Cleanliness and sterility are paramount, particularly in the healthcare industry. The Sterile Services Technician Training Level 4 course is designed to provide learners with the essential knowledge and skills required to excel in this critical profession. This comprehensive course covers various topics, including hand washing, complete garbing, DO's and DON'Ts in sterile compounding, garbing techniques, and laminar air flow hood procedures. The curriculum is meticulously structured, offering a step-by-step approach to mastering the complexities of clean services.Enrol now and take the first step towards a rewarding career as a Sterile Services Technician! Key Features of the Course: Upon completing the Sterile Services Technician Training Level 4 course, obtain a prestigious CPD certificate, validating your expertise and enhancing your professional credibility. Benefit from round-the-clock learning assistance, ensuring you receive the support you need whenever required. Our dedicated team of experts is always just a click away. Who is This Course For? This Sterile Services Technician Training Level 4 course is designed for individuals who have an unwavering commitment to maintaining sterile environments and are eager to develop the skills required to excel as a Sterile Services Technician. Whether you're already working in the healthcare sector or planning to enter this field, this course will provide the necessary knowledge and expertise to thrive in your role. What You Will Learn: This comprehensive Sterile Services Technician Training Level 4 course takes you on an enlightening journey through essential modules, equipping you with the knowledge and skills needed to excel as a Sterile Services Technician. You'll begin by mastering the art of effective hand washing, a fundamental aspect of maintaining a sterile environment. Next, you'll delve into the intricacies of complete garbing, learning precise techniques for donning and doffing personal protective equipment (PPE) to minimise contamination risks during medical procedures. The Sterile Services Technician Training Level 4 course immerses you in the meticulous cleaning process and explores the preparation of sterile pharmaceutical products. You'll gain hands-on experience in the correct techniques and protocols for preparing medications through informative demonstrations. You'll also develop proficiency in dosage calculations, learn various methods and formulas for medication administration. You'll explore best practices, protocols, and guidelines for sterile compounding, ensuring adherence to the highest sterility and safety standards. In the final modules, you'll gain a thorough understanding of garbing procedures and the protocols for maintaining sterility while working with laminar air flow hoods. These modules provide the practical knowledge required for confident reconstitution and compounding tasks. You'll understand sterile services techniques, protocols, and best practices. This knowledge will prepare you for a successful career as a Sterile Services Technician, where you'll contribute to uncompromised sterility and patient safety in the healthcare industry. Why Enrol in This Course: By enrolling in this Sterile Services Technician Training Level 4 course, you will gain access to an exceptional learning experience that has garnered top reviews from professionals in the industry. Our course is constantly updated to align with industry trends, ensuring you receive the most relevant and up-to-date knowledge. Stay ahead of the curve and position yourself as a sought-after sterile services technician, ready to impact patient safety significantly. Requirements: Prior experience or specific qualifications are optional to enrol in this course. However, a passion for maintaining sterility and an eagerness to learn are essential. Career Path: Upon completing this Sterile Services Technician Training Level 4 course, you will unlock exciting career opportunities. Here are seven course-related professions, along with their average salaries in the UK: Sterile Services Technician: £26,000 - £32,000 per annum Sterilisation Technician: £22,000 - £28,000 per annum Operating Room Technician: £24,000 - £30,000 per annum Pharmacy Technician: £20,000 - £27,000 per annum Medical Device Reprocessing Technician: £22,000 - £28,000 per annum Quality Assurance Technician: £23,000 - £30,000 per annum Healthcare Support Worker: £18,000 - £23,000 per annum Certification: Upon completing the Sterile Services Technician Training Level 4 course, you will receive a CPD certificate, recognised and respected in the industry, affirming your competence and opening doors to new career prospects. Course Curriculum 7 sections • 21 lectures • 02:49:00 total length •Introduction: 00:01:00 •Hand Washing: 00:01:00 •Complete Garbing: 00:03:00 •Cleaning the Laminar Flow Hood: 00:02:00 •Cleaning a Horizontal Flow Hood: 00:02:00 •Cleaning a Vertical Flow Hood: 00:01:00 •Sterile Pharmaceutical Products Preparation Demo 1: 00:24:00 •Sterile Pharmaceutical Products Preparation Demo 2: 00:13:00 •Solute, Solvent, and Solution: 00:15:00 •Percentage ww, vv, wv: 00:06:00 •Alligation and Dilution: 00:04:00 •Alligation and Dilution Practice Problems: 00:17:00 •Therapeutic Dose versus Lethal Dose: 00:02:00 •Dosage Calculation: 00:08:00 •More Dosage Calculation Practice Problems: 00:07:00 •DO's and DONT's in Sterile Compounding: 00:30:00 •Part 1- Garbing: 00:03:00 •Part 2- Laminar Air Flow Hood 1: 00:01:00 •Part 3- Laminar Air Flow Hood 2: 00:04:00 •Part 4- Reconstitution and Compounding: 00:08:00 •Part 5- Compounding Continued: 00:17:00

Overview This comprehensive course on Diploma in Lean Leadership and Change Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Diploma in Lean Leadership and Change Management comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Diploma in Lean Leadership and Change Management. It is available to all students, of all academic backgrounds. Requirements Our Diploma in Lean Leadership and Change Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 81 lectures • 06:40:00 total length •Why 00:04:00 •What 00:04:00 •Curriculum 00:05:00 •How 00:04:00 •What is Culture: 00:06:00 •Culture Drivers: 00:08:00 •Resources: 00:05:00 •Activity 1: 00:03:00 •House of Lean: 00:03:00 •Evolution: 00:04:00 •Shingo: 00:09:00 •Honda: 00:09:00 •Activity 2: 00:02:00 •JIT: 00:07:00 •Kanban: 00:08:00 •Continuous Improvement and Leadership: 00:04:00 •Waste Intro: 00:10:00 •Forms of Waste 1: 00:06:00 •Management Waste: 00:07:00 •Activity3: 00:02:00 •Scientific Method: 00:07:00 •Gemba Walk: 00:06:00 •Heijunka: 00:05:00 •Visual Display: 00:07:00 •Activity 4: 00:02:00 •Kaizen: 00:06:00 •Lean Leadership Intro: 00:07:00 •The Mind of the Lean Leader: 00:04:00 •The Mind of the Lean Leader - Transitions: 00:07:00 •Lean Leadership1. External Challenge: 00:06:00 •Lean Leadership 2. Internal Challenge: 00:06:00 •Activity 5: 00:02:00 •Lead WSA: 00:02:00 •Be the Model: 00:03:00 •Coach Others: 00:07:00 •Motivation: 00:04:00 •Reinforce Your Strategy: 00:04:00 •Activity 6: 00:01:00 •Intrinsic Reinforcement: 00:08:00 •Paths to Lean: 00:05:00 •How You Change: 00:03:00 •Design Thinking: 00:08:00 •Design Process: 00:09:00 •Capability Analysis: 00:05:00 •Charter: 00:05:00 •Activity 7: 00:02:00 •Design Team: 00:06:00 •Discovery: 00:06:00 •Discover the Process: 00:07:00 •Dream: 00:07:00 •Design technical: 00:07:00 •Design Structure: 00:08:00 •Social Design: 00:06:00 •Activity 8: 00:03:00 •VON Case Study: 00:10:00 •WSA Summary: 00:04:00 •Activity 9: 00:02:00 •Why Teams: 00:06:00 •Types of Teams: 00:06:00 •Team Charter: 00:05:00 •Team Maturity: 00:05:00 •Team Roles and Responsibilities: 00:05:00 •Team Agenda: 00:05:00 •Activity 10: 00:02:00 •Facilitation 1: 00:06:00 •Facilitation 2: 00:04:00 •Team Scoreboard: 00:07:00 •Activity 11: 00:01:00 •Map Team's Work: 00:03:00 •Attitudes: 00:05:00 •Five Whys: 00:03:00 •PDSA 1: 00:04:00 •PDSA 2: 00:04:00 •PDCA example: 00:01:00 •Activity 12: 00:01:00 •A3: 00:06:00 •Standard Work: 00:05:00 •Leader Standard Work: 00:04:00 •Activity 13: 00:02:00 •Summary: 00:03:00 •Additional Study Materials: Diploma in Lean Leadership and Change Management: 00:00:00

Overview This comprehensive course on Amazon Web Services (AWS) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Amazon Web Services (AWS) comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Amazon Web Services (AWS). It is available to all students, of all academic backgrounds. Requirements Our Amazon Web Services (AWS) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 9 sections • 66 lectures • 08:58:00 total length •Introduction to AWS - Cloud Computing: 00:11:00 •Introduction to AWS - Cloud Computing Continue: 00:10:00 •Launching a Server: 00:10:00 •Launching a Server Continues: 00:08:00 •Adding Tags: 00:09:00 •Launching a Windows Instance: 00:08:00 •Data storage Using S3: 00:07:00 •Data storage Using S3 Continues: 00:07:00 •AWS - EBS Part A: 00:07:00 •AWS - EBS Part B: 00:08:00 •AWS - EBS Part C: 00:06:00 •Running Instance: 00:08:00 •Terminate Instances: 00:02:00 •RDS and Dynamo DB Overview: 00:08:00 •Delete DB Instance: 00:06:00 •AWS - EFS Demo: 00:08:00 •More on AWS - EFS Demo: 00:10:00 •S3 Java API: 00:12:00 •More on S3 Java API: 00:11:00 •Dynamo DB Java API: 00:08:00 •Dynamo DB Java API Continues: 00:05:00 •Connecting to RDS - MySql: 00:11:00 •My SQL Driver: 00:09:00 •S3 using CLI: 00:10:00 •S3 using CLI Continues: 00:08:00 •AWS - Syn Command: 00:08:00 •Amazon DynamoDB Using: 00:09:00 •Amazon DynamoDB Using Continue: 00:10:00 •Amazon RDS Using CL: 00:12:00 •Amazon RDS Using CL Continue: 00:06:00 •More on Amazon RDS Using CL: 00:07:00 •Static website Using S3: 00:06:00 •AWS - Set Permission: 00:06:00 •Point your Domain to S3 Static Website: 00:07:00 •Point your Domain to S3 Static Website Continues: 00:09:00 •Name Servers: 00:07:00 •Create Record Set: 00:08:00 •Security Pre Work: 00:09:00 •IAM in AWS: 00:07:00 •IAM in AWS Continues: 00:06:00 •Creating New User: 00:07:00 •Storage C3: 00:10:00 •AWS - MFA in AWS: 00:07:00 •AWS - MFA in AWS Continues: 00:06:00 •Source Vs Destination: 00:07:00 •Infrastructure as Code: 00:08:00 •Infrastructure as Code Continues: 00:07:00 •Resources Name - AWSCF Bucket: 00:07:00 •Deployment Cloud Formation: 00:09:00 •Changing Access Control: 00:11:00 •Key Name - Key Val: 00:06:00 •Deployment Elastic Beanstalk: 00:06:00 •Creating Sample ENV: 00:06:00 •Deployment Ops Works Demo: 00:08:00 •Cloud Front Demo: 00:08:00 •Cloud Front Demo Continues: 00:10:00 •Security Groups: 00:08:00 •More on Security Groups: 00:08:00 •Creating a VPC: 00:09:00 •Virtual Private Cloud: 00:09:00 •Elastic IP: 00:07:00 •Allocate New Address: 00:08:00 •ELB Demo: 00:10:00 •ELB Demo Continues: 00:10:00 •Elastic Map Reduce: 00:11:00 •Amazon Cluster Running: 00:11:00

Overview This comprehensive course on Ionic & Angular JS: Principles Of Mobile and Web Development will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Ionic & Angular JS: Principles Of Mobile and Web Development comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Ionic & Angular JS: Principles Of Mobile and Web Development. It is available to all students, of all academic backgrounds. Requirements Our Ionic & Angular JS: Principles Of Mobile and Web Development is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 4 sections • 18 lectures • 02:39:00 total length •Introduction to the Course: 00:04:00 •Setup: 00:13:00 •iOS Debug: 00:05:00 •Testing For Desktop & Android: 00:11:00 •Header & Sub Header: 00:05:00 •Footer: 00:06:00 •Buttons: 00:15:00 •List: 00:14:00 •Cards: 00:10:00 •Forms: 00:15:00 •Toggle: 00:08:00 •Checkbox: 00:06:00 •Radio Button List: 00:04:00 •Range/Slider: 00:09:00 •Select/Dropdown: 00:03:00 •Tabs: 00:15:00 •Grid: 00:16:00 •Resource: 00:00:00

Overview Mechanical engineering stands as a pillar of innovation and development. As the world becomes more technologically advanced, the demand for these professionals is evident globally, making 'Crack Your Mechanical Engineer Interview' an essential step toward success. From the essentials of basic mechanical engineering to the complexities of thermodynamics, each module is designed to enhance the candidate's interview preparedness. Topics such as the significance of tolerance in engineering, the intricacies of fits, and the principles underlying manufacturing and material science are intricately explored.  The curriculum further delves into the strength of materials, the theory of machines, nuances of automobile engineering, and the pivotal principles of fluid mechanics and thermodynamics. It is a comprehensive compass for aspiring professionals eager to navigate the rigorous terrains of mechanical engineering interviews. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Crack Your Mechanical Engineer Interview. It is available to all students, of all academic backgrounds. Requirements Our Crack Your Mechanical Engineer Interview is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 52 lectures • 02:22:00 total length •Scope of the course: 00:03:00 •Introduction to Basic Mechanical Engineering: 00:02:00 •Explain the term torque: 00:03:00 •State Archimedes Principle: 00:02:00 •What is the importance of tolerance in engineering?: 00:04:00 •Explain different types of fits: 00:03:00 •Introduction to Manufacturing & Material Science: 00:01:00 •Define pitting: 00:03:00 •Distinguish Between A Jig And Fixture: 00:03:00 •Explain knurling: 00:03:00 •Why is heat treatment of steel metal crucial?: 00:03:00 •What is extruded aluminium?: 00:02:00 •What do you mean by annealing?: 00:04:00 •How is martensite structure formed in steel?: 00:04:00 •Introduction to Strength Of Material: 00:01:00 •Define a uniformly distributed load: 00:04:00 •Define Buckling Factor: 00:02:00 •Is it the stress that produces strain or vice-versa: 00:04:00 •What is the value of modulus of elasticity of steel?: 00:03:00 •What is Stress Concentration?: 00:03:00 •Introduction to Theory Of Machine: 00:01:00 •What is gear ratio?: 00:01:00 •What do you mean by cotter joint: 00:04:00 •What are the advantages of Gear drive?: 00:04:00 •What are the benefits of cycloidal gears?: 00:03:00 •Introduction to automobile engineering: 00:01:00 •What are the various types of brakes?: 00:03:00 •Differentiate between scavenging and supercharging: 00:03:00 •In IC engine, which part is known as column?: 00:03:00 •What causes white smoke in two-stroke locomotive engines?: 00:03:00 •What is the difference between turbochargers and superchargers?: 00:02:00 •Introduction to Fluid Mechanics: 00:01:00 •Explain The Difference Between Rotational And Irrotational Flow?: 00:03:00 •Navier Stokes Equation Represents The Conservation Of Which Quantity?: 00:03:00 •What are major and minor head losses in a fluid flow system?: 00:03:00 •What is a Newtonian fluid?: 00:05:00 •What are the differences between elbows and bends? Which has greater head losses?: 00:05:00 •What is the ratio of the thickness of TBL to the thickness of HBL?: 00:03:00 •Introduction to Thermodynamics: 00:01:00 •What is the second law of thermodynamics?: 00:04:00 •What is the difference between the heat engine & heat pump?: 00:05:00 •Introduction to RAC & HMT: 00:01:00 •What is Refrigeration? What is the unit of refrigeration?: 00:03:00 •Which Cycle is used in Air Refrigeration System?: 00:02:00 •What do you mean by emissive power?: 00:02:00 •What is Under-cooling or Sub-cooling of refrigeration system?: 00:03:00 •Explain mechanical refrigeration: 00:02:00 •What is heat transfer co-efficient?: 00:01:00 •What is the advantage of using pneumatic?: 00:03:00 •Define least count and how to calculate for vernier callipers?: 00:02:00 •Why do you need a biological shield in nuclear plants?: 00:03:00 •What Is The Value Of Coefficient Of Friction For Ball Bearing?: 00:02:00

Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

Overview This comprehensive course on The #1 LinkedIn Marketing & Sales Lead Generation Blueprint will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This The #1 LinkedIn Marketing & Sales Lead Generation Blueprint comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this The #1 LinkedIn Marketing & Sales Lead Generation Blueprint. It is available to all students, of all academic backgrounds. Requirements Our The #1 LinkedIn Marketing & Sales Lead Generation Blueprint is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 20 lectures • 01:42:00 total length •Introduction to Linkedin: 00:08:00 •Linkedin Platform Walkthrough: 00:13:00 •Linkedin Marketing Solutions: 00:09:00 •How To Create Linkedin Company Pages: 00:08:00 •Linkedin Groups: 00:04:00 •How To Create a Killer Profile that Converts: 00:03:00 •How To Create a Headline That Get's You Noticed: 00:03:00 •How To Write a Compelling Profile Summary: 00:02:00 •Linkedin Lead Generation System Walkthrough: 00:04:00 •Linkedin 3 Step Sales Funnel: 00:02:00 •3 Step Linkedin Sales Funnel Indirect Method: 00:06:00 •3 Step Linkedin Sales Funnel Semi-Direct Method: 00:08:00 •Linkedin Basic Search: 00:05:00 •Linkedin Sales Navigator Overview: 00:04:00 •How To Get Instant Credibility: 00:04:00 •How To Get FREE Leads Sent To Your Inbox: 00:03:00 •The Magic Sales Formula: 00:15:00 •Linkedin Course Sales Video: 00:01:00 •Resources - The #1 LinkedIn Marketing & Sales Lead Generation Blueprint: 00:00:00 •Assignment - The #1 LinkedIn Marketing & Sales Lead Generation Blueprint: 00:00:00

Office admin, the heart of an organization, plays a vital role in office administration. A good administrative skill enhances individual as well as organizational growth. Learn every single important aspect to kick-start your career in this field through our Office Admin and Customer Service Diploma course. The precise contents of the course teach you how to deal with administrative functions, different letter writing, documentation, reporting, recordkeeping, documentation. The course also teaches you how to manage customer, speak with them in a sound bite, and serve them with their demand. At the end of the course, you will become an efficient admin knowing all the lurid aspects of administrative procedures. Who is the course for? Professionals, employees or businessmen who want to improve the administration and customer service department of their company. People who want to know how administrative management and customer service work. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 00:05:00 Module Three - Getting Organized (II) 00:05:00 Module Four - Managing Time 00:05:00 Module Five - Getting It All Done On Time 00:05:00 Module Six - Special Tasks 00:05:00 Module Seven - Verbal Communication Skills 00:05:00 Module Eight - Non-Verbal Communication Skills 00:05:00 Module Nine - Empowering Yourself 00:05:00 Module Ten - The Team of Two 00:05:00 Module Eleven - Taking Care of Yourself 00:05:00 Module Twelve - Wrapping Up 00:05:00 Administrative Management Module One - Getting Started 00:05:00 Module Two - Why Your Office Needs Administrative Procedures 00:05:00 Module Three - Gathering the Right Tools 00:05:00 Module Four - Identifying Procedures to Include 00:05:00 Module Five - Top Five Procedures to Record 00:05:00 Module Six - What to Include in Your Binder (I) 00:05:00 Module Seven - What to Include in Your Binder (II) 00:05:00 Module Eight - Organizing Your Binder 00:05:00 Module Nine - What Not to Include in the Procedure Guide 00:05:00 Module Ten - Share Office Procedure Guide 00:05:00 Module Eleven - Successfully Executing the Guide 00:05:00 Module Twelve - Wrapping Up 00:05:00 Organisational Skills Module One - Getting Started 00:05:00 Module Two - Remove the Clutter 00:05:00 Module Three - Prioritize 00:05:00 Module Four - Scheduling Your Time 00:05:00 Module Five - To Do Lists 00:05:00 Module Six - Paper and Paperless Storage 00:05:00 Module Seven - Organization in Your Work Area 00:05:00 Module Eight - Tools to Fight Procrastination 00:05:00 Module Nine - Organizing Your Inbox 00:05:00 Module Ten - Avoid the Causes of Disorganization 00:05:00 Module Eleven - Discipline is the Key to Stay Organized 00:05:00 Module Twelve - Wrapping Up 00:05:00 Organisational Skills Course for Administrator- Activities 00:00:00 Customer Relations and Dealings Module One - Getting Started 00:05:00 Module Two - The Right Attitude Starts with You 00:05:00 Module Three - Stress Management (Internal Stressors) 00:05:00 Module Four - Stress Management (External Stressors) 00:05:00 Module Five - Transactional Analysis 00:05:00 Module Six - Why are Some Customers Difficult 00:05:00 Module Seven - Dealing with the Customer Over the Phone 00:05:00 Module Eight - Dealing with the Customer In Person 00:05:00 Module Nine - Sensitivity in Dealing with Customers 00:05:00 Module Ten - Scenarios of Dealing with a Difficult Customer 00:05:00 Module Eleven - Following up With a Customer Once You Have Addressed Their Issue 00:05:00 Module Twelve - Wrapping Up 00:05:00 Customer Service: Telephone Etiquette Module One - Getting Started 00:30:00 Module Two - Aspects of Phone Etiquette 01:00:00 Module Three - Using Proper Phone Language 01:00:00 Module Four - Eliminate Phone Distractions 01:00:00 Module Five - Inbound Calls 01:00:00 Module Six - Outbound Calls 01:00:00 Module Seven - Handling Rude or Angry Callers 01:00:00 Module Eight - Handling Interoffice Calls 01:00:00 Module Nine - Handling Voicemail Messages 01:00:00 Module Ten - Methods of Training Employees 01:00:00 Module Eleven - Correcting Poor Telephone Etiquette 01:00:00 Module Twelve - Wrapping Up 00:30:00 Customer Relationship Management Customer Relationship Management 00:10:00 What CRM Is and Who It Serves 00:15:00 Checklist for Success 00:15:00 Requirement Driven Product Selection 00:15:00 Considerations in Tool Selection 00:15:00 Strategies for Customer Retention 00:15:00 Building the Future 00:15:00 Homegrown vs. Application Service Provider 00:15:00 Evaluating and Reviewing Your Program 00:15:00 The Development Team 00:15:00 Microsoft Office Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Office Powerpoint Module One - Getting Started 00:30:00 Module Two - Opening PowerPoint 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 01:00:00 Module Six - Formatting Text and Paragraphs 01:00:00 Module Seven - Adding Pictures 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Setting Up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Office Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Mock Exam Mock Exam- Office Admin and Customer Service Diploma 00:30:00 Final Exam Final Exam- Office Admin and Customer Service Diploma 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00