18563 Courses

Join my face-to-face sewing classes in Milton Keynes for a day of learning and sewing. Perfect for beginners, you'll learn the basics and complete simple projects in a supportive environment. My classes are small so you get lots of personal attention and help. Start your sewing journey with confidence and hands-on guidance!

Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to learn how to use HUE when working with SQL databases. Overview Upon successful completion of this course, students will be able to operate HUE when interacting with SQL databases. In this course, students will learn how to operate HUE when interacting with SQL databases. Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query Performing a Conditional Search Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators Retrieving Data from Multiple Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Exporting Query Results Generate a Text File Generate an XML File Additional course details: Nexus Humans SQL Querying Fundamentals with HUE - Part 1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SQL Querying Fundamentals with HUE - Part 1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This Skills for Care Endorsed & CPD accredited training has been designed for existing Social care Staff in line with CQC requirements . Delivered by experienced and professional tutors and trainers with over 25 years of combined experience.

Mindful hand stitching with Linen and vintage lace fabrics to create a simple abstract piece. Adorn your piece with buttons from the plentiful button jars at Stitching Kitchen

This course focuses on the anchor point of your digital marketing strategy which is your website or micro-site. Here we’ll explore search engine optimisation ‘SEO’ and how you can use this to drive traffic to your website.

All about how to get the best out of social media in a business. Looking at business strategy, business development and the practicalities of employing people and agencies to support your social media activity.

Advanced Professional Certificate Courses These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD). Advanced Professional Certificate in International Trade Law This Advanced professional certificate course covers essential topics relating to international trade and international sales contracts. First, this course explores international trade's legal and regulatory landscape and how this practice can negatively and positively impact economies, societies, and the environment. In addition, the course introduces some fundamental concepts, reflects on relevant market theories, and then presents an in-depth analysis of complex international trade agreements and mechanisms, including GATT and WTO. Second, the course explores the English legal and regulatory landscape of the sales of goods and the principles on which law practitioners draft and negotiate these contracts. The course introduces some fundamental concepts relating to the rights and obligations of buyers and sellers in sales contracts. Moreover, the course will help participants reflect on the scope and provisions of the Vienna Convention for the international sale of goods by introducing fundamental concepts explaining the obligations of the seller and buyer under the agreement and analysing remedies offered to the buyer and seller. The course also introduces fundamental concepts such as the foreign exchange markets and various payment methods in international trade. Course Details After the successful completion of this lecture, you will be able to; Measure the impact of international trade on economies and the environment. Reflect on relevant market theories. Understand the structure, role, and function of the world trade organisation. Understand the construction of contracts of sales of goods and products in English law. Determine the rights and obligations of buyer and seller in international sales contracts. Reflect on the remedies offered to the buyer and seller in case of breach of contract. Understand the different types and effects of incoterms rules. Reflect on the scope and provisions of the Vienna Convention for the international sale of goods. Understand the obligations of the seller and buyer under the CISG. Analyse remedies offered to the buyer and seller under the CISG. Reflect on the economic foundations of international sales contracts. Understand the function of foreign exchange markets. Understand various methods of payment in international trade. Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. Legal advisors. Law practitioners. Contract specialists. Legal officers. Contract managers. Business developers. Trade advisors. Trade compliance officers. Law lecturers. Business lecturers. Legal and business researchers.

Advanced Professional Certificate Courses These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD). Advanced Professional Certificate in Company Law This Advanced professional certificate course covers concepts, evolution, and mechanisms of English company law. The course covers rules framing the activities of sole traders, public limited companies, private companies limited by shares, companies limited by guarantee, and unlimited companies. In addition, the course provides insight into various types of partnerships. On a practical level, the course explains the role and components of the articles of association and addresses the controversial issue of the corporate veil. Also, the course is designed to cover companies' duties, rights, and liquidation. The course covers the general duties of a company and the role and rights of majority and minority shareholders. This includes rules framing their rights to vote and act against the company and thus remedies available for minority shareholders. In addition, the course provides insight into the role and duties of auditors and the liability of directors. The course explains the process and effects of a liquidation process on a procedural level. Course Details After the successful completion of this lecture, you will be able to; Understand the evolution of English company law. Understand the concept of a sole trader. Reflect on different types of companies under UK Laws. Understand the concept and types of partnerships. Understand the role and components of the articles of association. Understand the concept of the corporate veil. Reflect on different types of companies under EU Laws. Understand the general duties of a company. Understand the role and rights of shareholders. Reflect on the rights and remedies available for minority shareholders. Understand the role and duties of auditors. Understand the duties and liability of directors. Understand the process and effects of a liquidation process. Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. Legal advisors. Legal advisors. Law practitioners. Contract specialists. Legal officers. Contract managers. Business developers. Law lecturers. Business lecturers. Legal and business researchers.

Advanced Professional Certificate Courses These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD). Advanced Professional Certificate in Industrial and Intellectual Property Law This Advanced professional certificate course explains the concept and evolution of intellectual property law and the rationale behind intellectual property rules and regulations. The course provides insight into different types of intellectual property while exploring the relationship between these legal mechanisms and other fundamental rights. The course presents an in-depth and detailed analysis of rules relating to confidential information as one of the most controversial elements in business negotiations.  In addition, this course has been designed to cover rules and regulations framing the ownership and protection of intellectual property rights. In addition to some conceptual elements, the course explores the foundational UK, and U.S. legislations practitioners use to prevent copyright infringement and protect a trademark and patent ownership. The course also presents an in-depth and detailed analysis of the impact of Brexit on intellectual property. Moreover, this course will explain intellectual property rights' complex and risky enforcement landscape. The course covers various remedies for victims, both in private civil and criminal actions. In addition to critical procedural elements, the course explores intellectual property rights violations and remedies under UK and U.S. laws. Course Details After the successful completion of this lecture, you will be able to; Understand the concept and evolution of intellectual property law. Understand the rationale behind intellectual property laws. Understand different types of intellectual property. Understand the relationship between Intellectual property and public interest. Understand the breach of confidential information in the context of intellectual property law. Understand copyright ownership and protection. Analyse trademark ownership and protection. Understand different types of trademarks. Analyse the legal framework of a patent. Analyse the impact of Brexit on intellectual property. Understand the enforcement landscape of intellectual property rights. Understand various remedies in private civil actions. Analyse intellectual property rights violations and remedies under UK laws. Analyse Intellectual Property Rights Violations and Remedies Under US Laws. Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. Legal advisors. Legal advisors. Law practitioners. Contract specialists. Legal officers. Contract managers. Business developers. Law lecturers. Business lecturers. Legal and business researchers.

Advanced Professional Certificate Courses These are short online certificate courses of a more advanced nature designed to help you develop professionally and achieve your career goals, while you earn a professional certificate which qualifies you for the appropriate continuous professional development (CPD). Advanced Professional Certificate in Business Research Methods The Advanced Professional Certificate in Business Research Methods aims to enable the learner to conduct effective business research by understanding the fundamentals of information search, Analysis and critique skills, data collection methods and professional business report drafting. The course aims to introduce the learner to the business research process by enabling the learner to gain skills such as choosing a topic, crafting a research question, reviewing literature, citations and references. The learner will be able to produce professional business research reports after learning different research philosophies, research methods and data analysis techniques. Learning Outcomes After the successful completion of the certificate, the student will be able to learn: Fundamentals of Research Philosophy and Principles Types of research, Researcher personality, Types of data and sources Selecting and developing a Topic Into a Research Question Research Paradigms, approaches and types of methodologies Creating and approving an effective research proposal Writing arguments in the research report. Report Structure, Content and Critique Literature review structure, searching and mapping, Critical review Developing research conceptual framework Research Methodology, Types of research methods, evaluating and using the secondary data Research sampling, techniques and types Research Analysis; Quantitative and Qualitative Data Analysis Methods Citations and referencing and drafting the research report Accreditation All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Business professional Business Researcher Research report writer Research and Development Manager