30938 Courses

SQL for Data Science, Data Analytics and Data Visualization Course Overview: This course offers a comprehensive introduction to SQL, designed for those looking to enhance their skills in data science, data analytics, and data visualisation. Learners will develop the ability to work with SQL databases, efficiently query and manage data, and apply these techniques for data analysis in both SQL Server and Azure Data Studio. By mastering SQL statements, aggregation, filtering, and advanced commands, learners will be equipped with the technical skills required to manage large datasets and extract meaningful insights. The course provides a solid foundation in data structures, user management, and working with multiple tables, culminating in the ability to perform complex data analysis and visualisation tasks. Course Description: This course covers a broad range of topics essential for anyone working with data in a professional capacity. From setting up SQL servers to mastering database management tools like SQL Server Management Studio (SSMS) and SQL Azure Data Studio, the course provides a thorough grounding in SQL. Learners will gain expertise in data structure statements, filtering data, and applying aggregate functions, as well as building complex SQL queries for data analysis. The course also includes instruction on SQL user management, group by statements, and JOINs for multi-table analysis. Key topics such as SQL constraints, views, stored procedures, and database backup and restore are also explored. The course incorporates SQL visualisation tools in Azure Data Studio, empowering learners to visualise data effectively. By the end of the course, learners will be proficient in SQL queries, data manipulation, and using Azure for data analysis. SQL for Data Science, Data Analytics and Data Visualization Curriculum: Module 01: Getting Started Module 02: SQL Server Setting Up Module 03: SQL Azure Data Studio Module 04: SQL Database Basic SSMS Module 05: SQL Statements for DATA Module 06: SQL Data Structure Statements Module 07: SQL User Management Module 08: SQL Statement Basic Module 09: Filtering Data Rows Module 10: Aggregate Functions Module 11: SQL Query Statements Module 12: SQL Group By Statement Module 13: JOINS for Multiple Table Data Analysis Module 14: SQL Constraints Module 15: Views Module 16: Advanced SQL Commands Module 17: SQL Stored Procedures Module 18: Azure Data Studio Visualisation Module 19: Azure Studio SQL for Data Analysis Module 20: Import & Export Data Module 21: Backup and Restore Database (See full curriculum) Who is this course for? Individuals seeking to enhance their data management and analysis skills. Professionals aiming to progress in data science, data analytics, or database administration. Beginners with an interest in data analysis and SQL databases. Anyone looking to gain expertise in SQL for Azure and SQL Server environments. Career Path: Data Analyst Data Scientist Database Administrator SQL Developer Business Intelligence Analyst Data Visualisation Specialist

Minute Taking is an intensive course designed to teach participants the necessary skills to record accurate notes during meetings, as well as communicate and take notes in meetings effectively.

Step into the specialized field of adolescence counselling with our in-depth course. Gain a nuanced understanding of adolescent development, psychological disorders, and the impact of external factors. Equip yourself with proven counselling techniques, and navigate ethical and legal frameworks effectively. Your path to becoming a proficient adolescent counsellor starts here.

Embark on a journey of creativity and sustainability with our Garden Design course. Learn the art of garden aesthetics, practical planting techniques, and maintenance strategies to transform any space into a thriving, beautiful garden. Ideal for aspiring garden designers and enthusiasts.

Overview This PA - Personal Assistant course will unlock your full potential and will show you how to excel in a career in PA - Personal Assistant. So upskill now and reach your full potential. Everything you need to get started in PA - Personal Assistant is available in this course. Learning and progressing are the hallmarks of personal development. This PA - Personal Assistant will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your PA - Personal Assistant skills to help you advance your career. Acquire a comprehensive understanding of various PA - Personal Assistant topics and tips from industry experts. Learn in-demand PA - Personal Assistant skills that are in high demand among UK employers, which will help you to kickstart your career. This PA - Personal Assistant course covers everything you must know to stand against the tough competition in the PA - Personal Assistant field.  The future is truly yours to seize with this PA - Personal Assistant. Enrol today and complete the course to achieve a PA - Personal Assistant certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the PA - Personal Assistant course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the PA - Personal Assistant course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the PA - Personal Assistant course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This PA - Personal Assistant is suitable for anyone aspiring to start a career in PA - Personal Assistant; even if you are new to this and have no prior knowledge on PA - Personal Assistant, this course is going to be very easy for you to understand.  And if you are already working in the PA - Personal Assistant field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this PA - Personal Assistant course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This PA - Personal Assistant course has no prerequisite.  You don't need any educational qualification or experience to enrol in the PA - Personal Assistant course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online PA - Personal Assistant course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum PA - Personal Assistant Module 1: Introduction to Personal Assistant 00:20:00 Module 2: Business Telephone Skills 00:21:00 Module 3: Representing Your Boss and Company 00:37:00 Module 4: Mail Services and Shipping 00:28:00 Module 5: Travel Arrangements 00:27:00 Module 6: Organising Meeting and Conferences 00:28:00 Module 7: Time Management 00:38:00 Module 8: Record Keeping and Filing Systems 00:31:00 Module 9: Business Writing Skills 00:43:00 Module 10 :Organisational Skills 00:28:00 Module 11: Communication Skills 00:28:00 Module 12: Customer Service 00:19:00 Module 13: Effective Planning and Scheduling 00:49:00 Module 14: Invoicing/Petty Cash 00:30:00

Explore the intricate bond between plants and human societies in our Ethnobotany course. Uncover traditional plant uses, delve into botanical foundations, and master ethnobotanical research methods. Discover sustainability, biodiversity conservation, and future horizons in this interdisciplinary journey. Join us to deepen your understanding of the vital relationship shaping our cultural, ecological, and economic landscapes.

Duration 3 Days 18 CPD hours This course is intended for This class is ideal for business users - the people who need to learn what's possible with Salesforce functionality across the suite of products, but aren't necessarily responsible for managing the application. If you're a customer service manager, business executive, business operations manager, sales operations manager, or any other operations, management, or process analysis 'super user,' this class is just what you need to better understand the business value of the Salesforce Platform. Overview Describe the primary business value of each major Salesforce Cloud. Manage users and data. Manage basic org configuration. Create email templates. Create reports and dashboards. Apply and champion Chatter. Understand the Salesforce implementation and maintenance lifecycle. Extend Salesforce functionality beyond basic configuration. Explore what?s possible with Salesforce. In this 3-day class, our Salesforce experts will walk you through the Salesforce Platform, its specific applications, and their business values and benefits. Familiarize yourself with Salesforce Cloud, and learn about platform features and processes to more effectively support day-to-day Salesforce operations within your organization. Through interactive lectures, discussions, and hands-on exercises, you?ll recognize the core elements of the implementation lifecycle, the key considerations to drive user adoption, and the important components of ongoing management of your Salesforce environment. Introduction Understand How Salesforce Works Explore Salesforce Applications Review Salesforce Organization Data Access and Security Control Org Access Manage Who Views and Modifies Objects Unlock Access to Records Share Access to Records Lock Down Individual Fields User Management and Troubleshooting Create New Users Troubleshoot Login, Record Access, and Field Visibility Issues Salesforce Customizations Think About Your Implementation Explore Custom Fields, Picklists, Page Layouts, and Record Types Create Email Templates Business Processes Automation Review Validation Rules Review Assignment and Escalation Rules Review Web-to-Lead and Entitlements Review Lightning Process Builder and Workflow Review Approval Processes and Visual Workflow Reports Explore the Reports Tab, Folders, and Formats Explore the Report Builder Summarize Your Data Dashboards and Data Insights Get More Insight from Your Data Visualize Your Data with Dashboards Create Your Analytics Strategy Everyday Salesforce Collaborate with Chatter, Groups, and Communities Share Feedback with Chatter Answers and Ideas Go Mobile with Salesforce1 Make Salesforce Part of Your Day Data Management Create a Data Migration Strategy Ensure Data Quality Extending Salesforce Drive a Salesforce Implementation Customize Salesforce Using Custom Objects, Apps, and the Salesforce AppExchange Build It Yourself Wrap-up and Certification Review the Certification Process and Resources

Description: Confidence is the key for presenting yourself during public speaking. You have to know what to convey to the audience and be comfortable with communication skills. To learn about overcoming your stage fear and nervousness, you can get the help of the course - Public Speaking Diploma. In this course, there are contents which will teach you on how to increase your communication skills. Interpersonal skills, professionalism, controlling nervousness, handling sticky situations, etc. You will also be taught on how to understand your audience, entice them with an immaculate presentation, controlling your body language, key themes and sentences, opportunities to practice and learn from mistakes, etc. This course Is aimed to help you better present yourself and make you more confident. Learning Outcomes: Speak more confidently in a one-on-one conversation Develop more confidence while speaking socially or small Learn practice these skills in a safe and supportive setting Implement quick and easy preparation techniques which will work no matter what if you have one minute or a week for its preparation Make your preparation for questions, in case of when you don't know what those questions will be. Getting over nervousness what you may come across while speaking in front of a group, particularly when the group is not compassionate to what you have to say. Apply the presentation techniques so that you can establish your credibility as well as getting people on your side Build an affinity with your audience Get to know the methods to decrease your nervousness as well as fear Realise your areas of strength as a presenter as well as the way you can draw the attention of different types of people Locate how the visual aids can help create an influence along with attention Improvise techniques to form a professional presence Know a number of different means so that you can prepare and organise information Knowing how to prepare, practise, as well as deliver a short presentation Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Public Speaking Diploma is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Public Speaking Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 1 Good Communication Skills 00:15:00 Interpersonal Skills 00:30:00 Getting Comfortable in Conversation 00:30:00 Redesigning Yourself for Strength 00:30:00 Professionalism 00:15:00 Maximizing Meetings 00:15:00 Controlling Nervousness 00:15:00 Module 2 Getting Started 00:15:00 Planning 00:15:00 Force Field Analysis 00:15:00 Understanding Your Audience 00:30:00 Controlling Your Jitters 00:15:00 Making Your Listener Hear You 00:30:00 Key Themes 00:15:00 Structuring Ideas 00:15:00 Organization Methods 00:15:00 Expanding a Basic Plan 00:15:00 Our Body Language 00:15:00 Beginnings and Endings 00:15:00 Module 3 Communication 00:15:00 Stop! Check Your Mouth! 00:15:00 What's Your Type? How About Mine?@m 00:15:00 Positive Self-Talk 00:15:00 Rapport 00:05:00 Maximizing Meetings 00:15:00 Body Language 00:15:00 Sticky Situations 00:15:00 I Can Just Send an E-mail, Right? 00:15:00 Overcoming Nervousness 00:30:00 The Five S's 00:15:00 Start Writing! 00:15:00 Audience Profile 00:05:00 Your Speaking Voice 00:30:00 Add Punch to Your Presentation 00:15:00 Mock Exam Mock Exam- Public Speaking Diploma 00:20:00 Final Exam Final Exam- Public Speaking Diploma 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Negotiation is the key to any organizations success. No business can survive without beneficial contracts. Within any organization, negotiation skills can prompt your professional success. Master the negotiating skills through this course and improve your business prospect, employability as well as your corporate potential.This course will explain the negotiation process in detail providing the students with the negotiation skills and strategies they need to succeed in today's challenging commercial environment. Who is this course for? A businessman. For people who are looking forward to adopting good negotiation skills. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career path: The Advanced Negotiation Skills course would be beneficial for the following careers: Sales Professional. Vendor Manager. Legal Administration. Human Resource Professional. Real Estate Broker. Construction Manager. Health Service Manager. Marketing Manager. Counselling Psychologist. Lawyer. Chief Executive. Negotiation Basics How to Negotiate With Your Landlord About Problems 00:30:00 How to Negotiate With Your Family Members, and Keep the Peace 00:30:00 What is Involved When A Labor Negotiation Takes Place? 01:00:00 What is involved when negotiating a car lease? 01:00:00 What is involved when negotiating a car purchase? 01:00:00 What is involved when negotiating a real estate purchase? 01:00:00 How to use Negotiating Skills 01:00:00 How to practice negotiating skills 00:30:00 How to put your negotiating skills to work for your business 01:00:00 How to find negotiating skills that you can really use 00:30:00 How to make negotiating a habit 00:15:00 How to avoid negotiating too much 00:30:00 How you use words when negotiating 00:15:00 How to use body language when negotiating contracts 00:30:00 How to use eye contact when negotiating sales 01:00:00 How to ask for a raise, negotiation for your career 00:30:00 How to ask for better benefits, how to negotiate 00:30:00 What is the art of negotiating 01:00:00 How to negotiate your way out of paying your bill all at one time 00:30:00 How to avoid raising your voice when negotiating a problem 00:15:00 Three methods of getting someone to do what you want with the negotiation skills 01:00:00 Three Methods of avoiding a conflict while negotiating 00:30:00 Three Methods of avoiding a fight with your co-workers with negotiation skills 00:30:00 Three methods of getting someone to do what you want with the negotiation skills 01:00:00 How to realize your own negotiation skills and put them to work in your career 00:30:00 What is the top three negotiation skills needed by managers? 01:00:00 How to negotiate when trading in a car 00:30:00 How to negotiate with your boss, about anything 01:00:00 How to negotiate with your creditor about debts 00:15:00 How to negotiate when opening a new investment account 00:15:00 Developing Negotiation Skills Module One - Getting Started 01:00:00 Module Two - Understanding Negotiation 01:00:00 Module Three - Getting Prepared 01:00:00 Module Four - Laying the Groundwork 01:00:00 Module Five - Phase One - Exchanging Information 01:00:00 Module Six - Phase Two - Bargaining 01:00:00 Module Seven - About Mutual Gain 01:00:00 Module Eight - Phase Three - Closing 01:00:00 Module Nine - Dealing with Difficult Issues 01:00:00 Module Ten - Negotiating Outside the Boardroom 01:00:00 Module Eleven - Negotiating on Behalf of Someone Else 01:00:00 Module Twelve - Wrapping Up 00:30:00 Negotiation Skills Certificate- Activities 00:00:00 Handling Objections & How to Negotiate Module One - Getting Started 00:30:00 Module Two - Three Main Factors 01:00:00 Module Three - Seeing Objections as Opportunities 00:30:00 Module Four - Getting to the Bottom 01:00:00 Module Five - Finding a Point of Agreement 01:00:00 Module Six - Have the Client Answer Their Own Objection 00:30:00 Module Seven - Deflating Objections 01:00:00 Module Eight - Unvoiced Objections 01:00:00 Module Nine - The Five Steps 01:00:00 Module Ten - Dos and Don'ts 00:30:00 Module Eleven - Sealing the Deal 00:30:00 Module Twelve - Wrapping Up 01:00:00 Handling Sales Objections & Negotiating Course- Activities 00:00:00 Mock Exam Mock Exam- Advanced Negotiation Skills Course 00:30:00 Final Exam Final Exam- Advanced Negotiation Skills Course 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Do you want to be an expert in negotiating? Are you looking for to make a good command in agreement? To mitigate your inquisitiveness you may have a look at Negotiation and Agreement Training course. The course designs to minimize your quest regarding negotiation and agreement based problems. It teaches you how to prepare a strong agreement paper and negotiation pattern. It will teach to some effective method to be expert in the focusing rules of collective conciliation. It helps you to develop your analytical power considering its both positive and negative effects. The course will also allow you to develop your assessment ability. Every lesson of this course add a new dimension to your thinking based on agreement procedures, method, and rules of negotiation. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Negotiation and Agreement Training is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Negotiation and Agreement Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction and The Principles of Collaborative Negotiation Welcome and Course Overview FREE 00:06:00 Why Good Negotiation Practice Leads to Better Relationships 00:03:00 Shameless Book Plug 00:01:00 Millie's Cookie Story 00:07:00 Exercise 1: Intentions / Objectives for This Programme 00:01:00 Giving Structure to Your Negotiation Strategy Negotiation is not 00:02:00 Distinguishing Negotiation from -Haggling 00:07:00 The 7 Steps to Negotiation Success 00:06:00 Exercise 2: Giving Structure to your Negotiations 00:01:00 Step One - Preparing Yourself for Collaborative Negotiation Preparing Yourself and Your WIN Outcomes 00:06:00 Exercise 3: Securing Commitment to Negotiate 00:01:00 The 4 P's 00:01:00 The Importance of Personality 00:02:00 We, Then Me 00:02:00 Exercise 4: The 4 P's 00:01:00 Step Two - Preparation - Understanding the Power of Variables Introduction to Variables 00:04:00 Video Examples of Excellent Creativity in Variables 00:03:00 Exercise 5: Understanding the Power of Variables 00:01:00 Using the WIN Matrix 00:03:00 Exercise 6: Write Your Win Matrix 00:02:00 Step Three - Understanding Your Partner's Point of View Introduction 00:01:00 Example Story- Maps of the World - Dyl's Den 00:03:00 Exercise 7: Stepping Into Your Partner's Shoes 00:01:00 Step Four - Discussing Introduction- Stating Intentions 00:04:00 Co-Active Listening- Are You Really Listening 00:02:00 The Power of Pause 00:01:00 Exercise 8: Using Open Questions 00:01:00 Exercise 9: Going Above and Beyond Their Wildest Dreams 00:01:00 Exercise 10: Socratic Questioning 00:04:00 Exercise 11: Creating a Discussion Agreement Statement 00:01:00 Step Five - Proposing Introduction to the Propose Stage 00:05:00 Exercise 12: Putting Your Proposal into Writing 00:01:00 Step Six - Bargaining Introduction 00:02:00 Exercise 13: Creating a Bargaining Agreement Statement 00:02:00 The Power of Silence 00:04:00 Exercise 14: Developing Your Time-Out Strategy 00:01:00 Step Seven - Agreeing Introduction to Bargaining 00:04:00 The Written Columbo 00:02:00 Exercise 15: Drafting an 'Agreement In Principle' 00:01:00 Getting Yourself Out of the Way - The Human Operating System Introduction - The Missing Link 00:04:00 Exercise 16: Noticing Your Thinking 00:02:00 What Does this Mean in Your Negotiations? 00:03:00 Understanding Personality Why Personality? 00:05:00 Introducing the 4 Colours 00:04:00 Introducing the 8 Aspects 00:04:00 Inspiration v Discipline Driven 00:04:00 Exercise 17: Teddy Bear 00:01:00 Big Picture vs Down to Earth 00:03:00 Exercise 18: Football Club Trip 00:01:00 People Focused vs Outcome Focused 00:02:00 Splash App 00:02:00 Exercise 19: Completing Your Own Assessment 00:01:00 Negotiation with Different 'Personality Types' 00:04:00 Using the Seven Steps at Home Introduction 00:04:00 Avoiding Common Gambits Some Negotiators Use Nibbling - The Columbo 00:02:00 The Flinch 00:02:00 The Red Herring 00:01:00 Higher Authority 00:02:00 The Reluctant Buyer - Seller 00:01:00 The Best of a Bad Choice 00:01:00 Conclusion - Can You Really Get More by Giving More? Conclusion & Thank You 00:02:00 Bonus Lecture 00:01:00 Resources Resources - Negotiation and Agreement Training 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00