40659 Courses

About Course Inventory Management Course to optimize your Purchasing, Logistics, EOQ and Safety Stock What Is Inventory Management? Inventory management refers to the process of ordering, storing, using, and selling a company's inventory. This includes the management of raw materials, components, and finished products, as well as warehousing and processing of such items. There are different types of inventory management, each with its pros and cons, depending on a company's needs.What is Discussed in the course Welcome to our comprehensive online course on Inventory Management. This step a crucial cog in the wheel of any company's supply chain process. This course provides a deep dive into the multifaceted aspects of inventory management and control. Initially, you will learn about various factors that shape inventory management. Afterwards, you will explore an array of tools and techniques to optimize costs. Finally, you will gain insight into forecasting and planning strategies. You will explore modern inventory systems and technologies, learning the differences between centralized and decentralized control of inventory. As we delve deeper, you'll encounter warehouse management, layout optimization, and warehouse management systems to further enhance your understanding of the supply chain. This course concludes with a comprehensive look at supply chain management, incorporating all the knowledge you've gained throughout.Learning Outcomes Have a full understanding of the role and key objectives of the Inventory Manager Be able to categorise Stock Keeping Units (SKUs) / parts effectively to prioritise their activity Recognise that suppliers and supplier relationships are critical to success and to understand what they require from suppliers to optimise their position Gain a total overview of Inventory Management for your Manufacturing or Service business The goal of this course is to arm you with the knowledge and tools needed to optimize your inventory performance. This course will equip inventory and warehouse managers, and anyone involved in the supply chain process, with the skills necessary to control the flow of goods effectively and efficiently in their organization. Take your first step towards mastering inventory management and join us on this journey. Throughout this course, you will explore the factors that influence inventory management within your organization. You will gain a deep understanding of various inventory management tools and techniques aimed at minimizing costs and achieving service levels aligned with your organization's mission, vision, and goals.Supply Chain Professionals: Elevate Your Inventory Management Game Starting with an analysis of historical demand, you will learn to distinguish between independent and dependent demand for goods or services. Leveraging this analysis, you will forecast both independent and dependent demand for inventory items, enabling you to calculate the optimal inventory level that minimizes overall inventory costs while establishing reorder points to meet desired service levels. In addition to forecasting and planning, this course covers other vital aspects of inventory management. You will explore inventory systems and technologies, warehouse management and layout optimization, just-in-time management, and warehouse management systems. Furthermore, you will gain insights into supply chain management and the challenges associated with inventory control. Whether you are a warehouse manager, stockroom manager, or involved in supply chain management, this course provides a comprehensive understanding of inventory management principles and practices. Join us to enhance your knowledge, streamline operations, and achieve high stock availability while minimizing stock value. Enroll now and embark on your journey to become an effective inventory manager! What Will You Learn? Have a full understanding of the role and key objectives of the Inventory Manager Be able to categorise Stock Keeping Units (SKUs) / parts effectively to prioritise their activity Recognise that suppliers and supplier relationships are critical to success and to understand what they require from suppliers to optimise their position Gain a total overview of Inventory Management for your Manufacturing or Service business Course Content Introduction to Inventory Management Introduction to Inventory Management Types of Inventory System Types of Inventory System Inventory Forecasting & Cost Inventory Forecasting & Cost Inventory Valuation Inventory Reorder Points and Safety Stock Inventory Reorder Points and Safety Stock Inventory Planning & Managing Inventory Planning & Managing Just-in-time Management Just-in-time Management Inventory Systems and Technologies Inventory Systems and Technologies Warehouse Management and Layout Optimization Warehouse Management and Layout Optimization Warehouse Management System Warehouse Management System Supply Chain Management and Vendor Relations Supply Chain Management Vendor Relations Conclusion Career Development: Job Searching, Resume/CV, Cover Letters A course by Xpert Learning RequirementsBasic understanding of business operations and supply chain concepts Audience Anyone involved in Supply Chain, Inventory Management and finance who has an interest in the management and movement of stock, categorisation of products / Stock Keeping Units (SKUs) and ensuring optimum availability (Service Levels) whilst minimisng stock levels. Supply Chain Managers Audience Anyone involved in Supply Chain, Inventory Management and finance who has an interest in the management and movement of stock, categorisation of products / Stock Keeping Units (SKUs) and ensuring optimum availability (Service Levels) whilst minimisng stock levels. Supply Chain Managers

Dedicated Mental Health Support Worker providing compassionate assistance to individuals facing mental health challenges. Offering emotional support, fostering coping skills, and promoting well-being. Committed to creating a safe and nurturing environment for clients on their journey to recovery. Your ally in mental health empowerment.

Enhance your CV with one of the most in-demand skills in the UK. Covering all the key techniques in and understanding of providing good customer service, expert communication skills, time management and document preparation, this Office Skills and Receptionist Course has been designed to give you the skills to succeed in a variety of business areas and industries. Through video lessons, PDF handouts, mock exams and online assessments, you will learn how to improve your verbal and nonverbal communication skills, write and prepare expert documents and effectively manage your time. You also gain role-specific competencies in keeping a good telephone manner, gatekeeping and providing excellent customer service. Many of the skills you learn through this course are transferable across a range of fields, giving you even more chances to build yourself a new career. Why Choose This Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who is this course for? This Office Skills and Receptionist course is ideal for people who want to start working as a Receptionist, Office Administrator, Office Manager, Administration Assistant, or Secretary, as well as people who want to enhance their office skills in general.

Register on the Health and Social Care - Level 5 today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Health and Social Care - Level 5 course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Health and Social Care - Level 5 course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Health and Social Care - Level 5 course, all you need is a passion for learning, A good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Health and Social Care - Level 5 Module 1: Introduction to Health and Social Care Module 1: Introduction to Health and Social Care 00:19:00 Module 2: Communication and its Relevance Module 2: Communication and its Relevance 00:42:00 Module 3: Rights and Responsibilities as a Health and Social Care Worker Module 3: Rights and Responsibilities as a Health and Social Care Worker 00:38:00 Module 4: Role as A Caregiver and Healthcare Professional Module 4: Role as A Caregiver and Healthcare Professional 00:26:00 Module 5: Working in Health and Social Care; Promoting Equality, Diversity and Rights Module 5: Working in Health and Social Care; Promoting Equality, Diversity and Rights 00:49:00 Module 6: Important Principles and Policies in Health and Social Care Work Module 6: Important Principles and Policies in Health and Social Care Work 00:23:00 Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 00:50:00 Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 00:48:00 Module 9: Safeguarding Vulnerable Individuals Module 9: Safeguarding Vulnerable Individuals 00:52:00 Module 10: Health and Safety Responsibilities Module 10: Health and Safety Responsibilities 00:51:00 Module 11: Risk Management in Health and Social Care Module 11: Risk Management in Health and Social Care 00:03:00 Recommended Readings Recommended Readings - Health and Social Care - Level 5 03:10:00 Optional Assignment Optional Assignment - Health and Social Care - Level 5 2 weeks, 2 days Recommended Materials Workbooks - Health and Social Care - Level 5 01:54:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the British Sign Language (BSL) Level 1 & 2 Training today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The British Sign Language (BSL) Level 1 & 2 Training is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The British Sign Language (BSL) Level 1 & 2 Training Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the British Sign Language (BSL) Level 1 & 2 Training, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Contents British Sign Language Level 1 Introduction to BSL and Fingerspelling Exchanging Personal Information Families Numbers (Time, Calendar and Money) Colours Transports Weather Directions Activities/Hobbies and Sports Description of A Person and Clothes Animals Numbers (Money) Foods and Drinks Exam British Sign Language Level 2

Safeguarding Children, Child Protection & Child Care Diploma Delve into the critical field of Safeguarding with our comprehensive diploma designed to equip you with the essential skills and knowledge needed for safeguarding children. This diploma serves as a vital step in your career, making you a proficient expert in the realm of Safeguarding. Learning Outcomes: Comprehend the indispensable role of Safeguarding in child welfare. Recognise the signs of child abuse and the imperative of Safeguarding from such abuse. Understand the specific requirements for Safeguarding disabled children. Familiarise yourself with the legal framework, laws, and regulations that guide Safeguarding. Gain a foundational understanding of Child Protection basics in the context of Safeguarding. Address the challenges of child sexual exploitation within the broader Safeguarding framework. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules: Importance of Safeguarding: Gain a profound understanding of why Safeguarding is a cornerstone in child care and welfare. Safeguarding from Child Abuse: Learn how to identify, report, and prevent child abuse, emphasising the critical role of Safeguarding. Safeguarding Disabled Children: Specialise in the unique needs and challenges faced by disabled children and the responsibilities in Safeguarding them. Laws and Regulations in Safeguarding: Equip yourself with the legal knowledge necessary for ensuring best practices in Safeguarding. Child Protection Basics in Safeguarding: Dive into the core concepts of child protection and how they align with Safeguarding practices. Child Sexual Exploitation in Safeguarding: Master the skills to detect and address child sexual exploitation, another vital aspect of Safeguarding.

Throughout this course, you will learn how to operate and maintain laboratory equipment and perform laboratory technician tasks.

Course Overview Learn the Latest Skills | Accredited by CPD | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  Mental health is just as important as physical health. However, a healthy body will not do you good if your mental health is abysmal. And the sad thing is that many people struggle with their mental health. And most people don't even realise that they need professional help. Therefore, we created this Mental Health Support Worker Training - Level 3 course. If you want to learn about mental health and help people suffering from mental health issues, this course is for you. You will gain the skills to understand various mental health conditions and how to work with and provide treatment for people struggling with their mental health. Get started with our course now and get proper mental support worker training to help people with their mental health. Enrol now and get certified! Please note: This course only gives you the theoretical knowledge you need to excel in this field. This Mental Health Support Worker Training - Level 3 doesn't entitle you to practise as a professional in this field. What Will You Learn? Overview of mental health support worker Learn about different anxiety and mood disorders How to treat various mental illness Laws and policies concerning mental health Have a strong, flexible mental aptitude and adapt to unpredictable situations What classes are included in this package? Earn a digital Certificate upon successful completion accredited by UK and internationally recognised accredited qualification There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Lifetime Access Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? Mental Health Support Worker Training - Level 3 is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all students from any academic background to learn more about this subject. Career Path Training offered by the Mental Health Support Worker Training - Level 3 could potentially benefit a range of roles but would particularly enhance careers in: Health Care Assistant Support Worker Home care support worker Clinical Psychiatrist Nurse Neuropsychologist Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Method of Assessment On successful completion of the Mental Health Support Worker Training - Level 3, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. The assessment will be evaluated automatically and the results will be given to you immediately. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Module 1: Introduction to Mental Health Module 2: Overview of Mental Health Support Worker Module 3: Childhood and Adolescent Psychiatric Disorders Module 4: Stress and Anxiety Disorders Module 5: Schizophrenia Module 6: Personality Disorders Module 7: Mood Disorders Module 8: Eating & Sleeping Disorders Module 9: Self-Harm and Suicide Module 10: Medication and Therapy in the Treatment of Mental Illness Module 11: Mental Health Legislation and Services Module 12: Community Mental Health Teams (CMHTs) Module 13: The Participation of the Service User

Overview Learn about The 100 Most Common Verbs in French from industry experts and boost your professional skill. This The 100 Most Common Verbs in French course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of The 100 Most Common Verbs in French. You'll also gain the skills of The 100 Most Common Verbs in French to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of The 100 Most Common Verbs in French professionals and gain first-hand experience of The 100 Most Common Verbs in French problem-solving. The The 100 Most Common Verbs in French  is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the The 100 Most Common Verbs in French, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This The 100 Most Common Verbs in French will provide you with the latest information and updates of The 100 Most Common Verbs in French. It will keep you one step ahead of others and increase your chances of growth. Why buy this The 100 Most Common Verbs in French? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the The 100 Most Common Verbs in French there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This The 100 Most Common Verbs in French does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This The 100 Most Common Verbs in French was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This The 100 Most Common Verbs in French is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum The 100 Most Common Verbs in French Etre - to be 00:02:00 Avoir - to have 00:02:00 Devoir - to must 00:02:00 Falloir - to have to 00:02:00 Vouloir - to want 00:02:00 Savoir - to know 00:01:00 Penser - to think 00:02:00 Faire - to do 00:02:00 Venir - to come 00:02:00 Prendre - to take 00:02:00 Parler - to speak 00:02:00 Commencer - to start 00:02:00 Essayer - to try 00:02:00 Aller - to go 00:02:00 Entendre - to wait 00:02:00 Sortir - to go out 00:02:00 Attendre - to wait 00:02:00 Permettre - to allow 00:02:00 Compter - to count 00:02:00 Donner -to give 00:02:00 Comprendre - to understand 00:02:00 Connaitre - to know 00:02:00 Empecher - to stop 00:02:00 Reprendre - to take back 00:02:00 Appeler - to call 00:02:00 Mener - to lead 00:02:00 Permettre - to allow 00:02:00 Appartenir - to belong to 00:02:00 Occuper - to occupy 00:03:00 Toucher - to touch 00:02:00 Risquer - to risk 00:02:00 Aimer - to like 00:02:00 Devenir - to become 00:02:00 Concerner - to concern 00:01:00 Retrouver - to find back 00:02:00 Apprendre - to learn 00:02:00 Partir - to leave 00:02:00 Perdre - to loose 00:02:00 Rencontrer - to meet 00:02:00 Tenir - to keep 00:02:00 Decider - to decide 00:02:00 Creer - to create 00:02:00 Expliquer - to explain 00:02:00 Arriver - to arrive 00:02:00 Obtenir - to obtain 00:02:00 Ouvrir - to open 00:02:00 Considerer - to consider 00:03:00 Chercher - to look for 00:02:00 Assurer - to ensure 00:02:00 Servir - to serve 00:02:00 Entrer - to enter 00:02:00 Porter - to carry 00:02:00 Sembler - to seem 00:02:00 Gagner - to win 00:02:00 Presenter - to present 00:02:00 Proposer - to propose 00:02:00 Revenir - to come back 00:02:00 Exister - to exist 00:02:00 Changer - to change 00:02:00 Accepter - to accept 00:02:00 Produire - to produce 00:02:00 Montrer - to show 00:02:00 Apporter - to bring 00:02:00 Laisser - to let 00:02:00 Voir - to see 00:02:00 Agir - to act 00:02:00 Preparer - to prepare 00:02:00 Refuser - to refuse 00:02:00 Continuer - to continue 00:02:00 Recevoir - to receive 00:02:00 Utiliser - to use 00:02:00 Demander - to ask 00:02:00 Poser - to put 00:02:00 Relever - to raise 00:02:00 Repondre - to answer 00:02:00 Lire - to read 00:02:00 Atteindre - to reach 00:02:00 Trouver - to find 00:02:00 Ecrire - to write 00:02:00 Jouer - to play 00:02:00 Travailler - to work 00:02:00 Passer - to pass 00:02:00 Rappeler - to call back 00:03:00 Tenter - to tempt 00:02:00 Suivre - to follow 00:02:00 Defendre - to defend 00:02:00 Representer - to represent 00:02:00 Reconnaitre - to recognize 00:02:00 Ajouter - to add 00:02:00 Rendre - to give back 00:02:00 Vivre - to live 00:02:00 Tirer - to pull 00:03:00 Choisir - to choose 00:02:00 Reussir - to succeed 00:02:00 Importer - to import 00:02:00 Rester - to stay 00:02:00 Croire - to beleive 00:02:00 Manger - to eat 00:02:00 Boire - to drink 00:02:00 Dormir - to sleep 00:02:00 Assignment Assignment - The 100 Most Common Verbs in French 00:00:00

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00