39676 Courses delivered On Demand

A TRAUMA INFORMED APPROACH TO WORKPLACE BULLYING CASES Using a trauma informed approach to workplace bullying & harassment cases reduces the risks of adding another layer of injury. We look at how workplace trauma develops, and how it is different from other traumas, and what that means for individuals in terms of the difficulties of being able to present the facts n an investigation.

Highlights of the Course Course Type: Online Learning Duration: 360 Hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about teaching and child care Understand the core competencies and principles of teaching and child care Explore the various areas of teaching and child care Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert teacher and child care worker Teaching and Child Care Courses Bundle Online Are you interested to begin your teaching and child care career or want to gain more advanced skills in teaching and child care? Then this early child development online course will help you get one step closer to your professional aspirations and develop your skills and knowledge in teaching and child care for a rewarding career. This Bundle Package Includes: The skills and knowledge that you will gain through studying the following courses will teach you the theory of effective teaching and child care practice and equip you with the essential skills, confidence and competence to assist you in the teaching and child care industry. You'll gain a solid understanding of the core competencies required to drive a successful career in teaching and child care. SEN Teaching Course Child Protection Officer PPA(Psycho-Physical Activity for Kids Paediatric First Aid Child Psychology Advanced Diploma EYFS Teaching Applied Behavioural Analysis (ABA) Early intervention for children with Autism School Shadow Support Gain teaching and child care skills and credentials that employers value. This bundle course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards to your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Master the skills you need to propel your career forward in teaching and child care. Equip yourself with the essential knowledge and skillset that make you a confident teacher and child care worker and take your career to the next level. This comprehensive bundle course is designed to help you reach your professional goals. Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This extensive course is designed for teaching and child care professionals who are aspiring to specialise in teaching and child care. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV. Enrol today and take the next step towards your personal and professional goals. Who is this Course for? This comprehensive teaching and child care course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this teaching and child care can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This teaching and child care course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This teaching and child care course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This teaching and child care course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum SEN Teaching Course Child Protection Officer PPA(Psycho-Physical Activity for Kids Paediatric First Aid Child Psychology Advanced Diploma EYFS Teaching Applied Behavioural Analysis (ABA) Early intervention for children with Autism School Shadow Support Obtain Your Certificate Order Your Certificate of Achievement 00:00:00

Tired of browsing and searching for a Purchasing & Procurement course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Purchasing & Procurement bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Purchasing & Procurement course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Purchasing & Procurement and help you along your learning journey. Advanced audio-visual learning modules of these Purchasing & Procurement courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Purchasing & Procurement, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Purchasing & Procurement Bundle Consists of the following Premium courses: Course 1: Purchasing & Procurement Course - Level 3 Course 2: Logistic Management Course 3: Retail Operations Training Level 3 Course 4: Facilities Management Level 3 Course 5: Basic Product Management Course 6: Import/Export Processing Course 7: SAP Controlling (CO) - Product Costing S4HANA Course 8: Warehouse Course 9: Freight Consultant Training Course 10: Merchandising Course 11: Manual Handling Level 2 Course 12: Supply Chain Management Course 13: Level 2 Microsoft Office Essentials Course 14: Time Management Enrol now in Purchasing & Procurement to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Purchasing & Procurement expertise and essential knowledge, which will assist you in reaching your goal. Course Curriculum: Course 1: Purchasing & Procurement Course - Level 3 Module 01: Supply Chain Basics Module 02: Role of Procurement in an Organisation Module 03: The Purchasing Cycle Module 04: Purchasing Toolkits Module 05: Managing Competitive Bids Module 06: Quality Management Module 07: Supplier Relationship Management Module 08: Analysing and Reducing Risk in the Supply Chain Module 09: Improving Efficiency and Accuracy Module 10: Category Management Module 11: Inventory Management Module 12: E-Procurement ---------- Other Courses Are --------- Course 2: Logistic Management Course 3: Retail Operations Training Level 3 Course 4: Facilities Management Level 3 Course 5: Basic Product Management Course 6: Import/Export Processing Course 7: SAP Controlling (CO) - Product Costing S4HANA Course 8: Warehouse Course 9: Freight Consultant Training Course 10: Merchandising Course 11: Manual Handling Level 2 Course 12: Supply Chain Management Course 13: Level 2 Microsoft Office Essentials Course 14: Time Management How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Purchasing & Procurement bundle. Requirements Our Purchasing & Procurement course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Purchasing & Procurement expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Purchasing & Procurement Course - Level 3) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

24-Hour Flash Sale! Prices Reduced Like Never Before!! In the heart of every community, family support workers serve as the guiding torch, offering support, care, and advocacy to families navigating the complexities of modern life. With recent statistics highlighting over 2.3 million families in the UK accessing child and family services last year alone, the demand for skilled professionals in this field has never been more critical. This Family Support Worker course bundle is crafted to prepare you for this rewarding career, equipping you with the knowledge and skills to make a real difference in the lives of those you serve. In this bundle course, you'll get to learn foundational Counselling Skills and Care Planning to specialised training in Domestic Violence Awareness, Safeguarding Adults and Children, and understanding Diabetes. The curriculum also discusses Child Counselling, Family Law, Autism Awareness, and also Marriage and Family Therapy, offering a holistic approach to supporting families in diverse circumstances. Through this training, you'll gain the insights and tools needed to address the challenges families face today effectively. This Family Support Worker Bundle Package includes: Course 01: Family Support Worker Course 02: Counselling Skills Training Course 03: Care Planning and Record Keeping Course 04: Family Law Course 05: Marriage and Family Therapy Course 06: Domestic Violence and Abuse Awareness Diploma Course 07: Safeguarding Adults Level 1 Course 08: Diabetes Awareness Course Course 09: Safeguarding Children Level 3 Course 10: Child Counselling and Youth Course 11: Understanding Autism Open the doors of opportunities to make a significant impact on your community. Regardless of your motive, this course bundle offers a unique opportunity to develop the expertise needed to support, empower, and advocate for families. Join us in this fulfilling journey to become a beacon of hope and change for families in need! Learning outcomes of this Family Support Worker Bundle: Develop foundational counselling skills tailored to family support. Implement effective care planning and record-keeping practices. Recognise and address domestic violence and abuse. Safeguard adults and children within legal and ethical frameworks. Understand and support individuals with diabetes and autism. Navigate family law and marriage and family therapy concepts. Why Prefer This Family Support Worker Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Curriculum Breakdown Course 01: Family Support Worker Module 01: Introduction to Family Support Work Module 02: Legislation, Policy and Guidance Module 03: Solving Family Issues: Part 1 Module 04: Solving Family Issues: Part 2 Module 05: Safeguarding & Assessing Need and Providing Help (Part 1) Module 06: Safeguarding & Assessing Need and Providing Help (Part 2) Module 07: Building Relationships Course 02: Counselling Skills Training Module 01: Counselling and Counsellors Module 02: Theories and Models of Counselling (Part 1) Module 03: Theories and Models of Counselling (Part 2) Module 04: Legal, Cultural and Ethical Issues in Professional Counselling Module 05: Forms of Psychotherapy Module 06: Engaging and Assessing the Patients Module 07: Helping the Client in Crisis Module 08: Crisis Intervention Module 09: Low-Intensity CBT Treatment Module 10: Medication and Therapy in the Treatment of Mental Illness Module 11: Communication Skills and Empathy in Counselling Course 03: Care Planning and Record Keeping Module 01: Introduction to the Care Planning Process Module 02: Planning Care With the Individual in Need Module 03: Concept Care Mapping Module 04: Implementing and Evaluating the Care Plan Module 05: Maintaining Medical Records Module 06: Care Planning Policy in the UK Module 07: Confidentiality and Record-Keeping Module 08: Safeguarding Children, Young People and Their Families =========>>>>> And 8 More Courses <<<<<========= Assessment Process Your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Mental Health Support Worker course. How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring support workers Social workers Counsellors Teachers Nurses Please note: This course doesn't entitle you to practice as a professional in this specific field. Rather, this course will assist you in understanding the fundamentals so that you can improve your knowledge in the relevant field. Requirements You will not need any prior background or expertise to enrol in this Family Support Worker Course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Family Support Worker - £20,000 to £30,000 Social Worker - £28,000 to £40,000 Child Counsellor - £25,000 to £35,000 Domestic Violence Advocate - £22,000 to £30,000 Safeguarding Officer - £25,000 to £37,000 Family Law Paralegal - £18,000 to £25,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Family Support Worker CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

SQL programming is the programming that manages data in the Relational Database Management System. The Mastering SQL Programming course aims to teach you how to optimise the accessibility and maintenance of data with the Structured Query Language SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This SQL Programming course will provide you the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. You will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Learn what SQL is and how to create, manipulate, and create reports from database tables from the best SQL courses. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Enrol Now to start boosting your SQL skills! Key topics to be covered Stored Procedures Returning Data Testing and Debugging SQL CLR Code Dynamic SQL Column sets Learning Outcomes Know the tools for creating views with examples, columns and indexed views, creating stored procedures, testing and debugging. Learn how to create triggers, execute with result sets, use inline table valued functions, and use the multi statement function. Learn about transaction concepts, explicit transactions, and structured error handling. Understanding of different functions, data tools, database management, comparing database schemas, offline database management and much more. Master partitioning, managing partitions, querying partitions, complex querying, table expressions, efficient queries and complex queries. 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 supplies Mock tests Multiple-choice evaluation 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 £119. 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 To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Anyone who wants to gain extensive knowledge, potential experience and expert skills in SQL programming. Those who have an interest in production planning. Students from any academic backgrounds

In today's digital age, mastering the art of virtual interviewing is crucial for attracting and hiring top talent from anywhere in the world. Our Virtual Interviewing Training course is designed to equip you with the essential skills and knowledge to conduct seamless and effective virtual interviews. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access The Virtual Interviewing Training course is designed to teach you how to conduct successful virtual interviews. You will learn the basics of virtual interviewing and how to choose the right technology for your needs. The course covers essential preparation steps, ensuring you are ready and confident for the interview. You will gain insights from the interviewer's perspective, helping you to understand what to look for in candidates and how to assess their suitability. Additionally, you will learn strategies to attract and hire top talent. The course concludes with guidance on making final hiring decisions and effective onboarding processes. By the end of the course, you will be well-equipped to handle virtual interviews professionally and effectively, ensuring you find the best candidates for your organization. Course Curriculum Module 01: Introduction to the Course Module 02: An Introduction to Virtual Interviewing Module 03: Picking a Tech to Use Module 04: Interview Preparation Module 05: Interviewer's Perspective Module 06: Attract and Hire the Best Talents Module 07: Final Thoughts and Onboarding Learning Outcomes: Understand the basics of virtual interviewing techniques and best practices. Identify and select the appropriate technology for virtual interviews. Prepare effectively for conducting virtual interviews. Gain insight into the interviewer's perspective during virtual interviews. Learn strategies to attract and hire top talents. Implement effective onboarding practices for new hires. CPD 10 CPD hours / points Accredited by CPD Quality Standards Virtual Interviewing Training 1:27:42 1: Module 01: Introduction to the Course 11:09 2: Module 02: An Introduction to Virtual Interviewing 09:01 3: Module 03: Picking a Tech to Use 14:16 4: Module 04: Interview Preparation 18:54 5: Module 05: Interviewer's Perspective 08:24 6: Module 06: Attract and Hire the Best Talents 08:12 7: Module 07: Final Thoughts and Onboarding 16:46 8: CPD Certificate - Free 01:00 Who is this course for? Hiring managers conducting virtual interviews. HR professionals transitioning to virtual recruitment. Recruitment consultants in online hiring processes. Team leaders responsible for virtual hiring. Business owners conducting virtual interviews. Career path Recruitment Specialist Human Resources Manager Talent Acquisition Coordinator Hiring Manager HR Consultant Recruitment Agency Staff Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Dyslexia Online This Dyslexia course was designed with meticulous care and research. This course will take you to step by step through the entire learning process, making it easy and enjoyable for you. The Dyslexia course will teach you about the various types of dyslexia and learning disabilities and how to identify them. It will teach you about the most common dyslexic behaviours among school children. You can learn how to deal with and cope with dyslexia by using cognitive strategies. This Dyslexia course is broken down into ten modules, each of which teaches you everything you need to know about dyslexia. With the knowledge you will gain from each module, you will be able to identify when an adult has dyslexia and assist them in receiving the assistance they require. Experts craft this Dyslexia course to enable you to learn quickly and efficiently and at your own pace and convenience. This comprehensive Dyslexia course is the perfect way to kickstart your career. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. Learning Outcomes After completing the Dyslexia course, you will be able to: Describe dyslexia and other common learning disabilities. Demonstrate a comprehensive understanding of dyslexia in school-aged children, including forms, signs, and treatment processes. Recognize the different forms of dyslexia in children of school age. Describe expert-developed cognitive approaches to coping with dyslexia. Help dyslexic children succeed in school. Examine the dyslexia laws and rules, as well as how they are applied in the classroom. Dyslexia Course Curriculum of Dyslexia Module 01: An Overview of Dyslexia Module 02: Learning Difficulties Due to Dyslexia Module 03: Impact of Dyslexia in the Educational Setting Module 04: Helping Adults with Dyslexia Module 05: Dyslexia in the Workplace Module 06: Approaches in Dyslexia Module 07: Dyslexia Strengths and Rewards Module 08: Assessment and Evaluation of Dyslexia Module 09: Dyslexia Friendly Learning Environment Module 10: Relevant Laws for Dyslexia Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Dyslexia course. Dyslexia 1:20:00 1: Dyslexia 1:20:00 PDF Who is this course for? Dyslexia This Dyslexia course is ideal for - Job Seekers Teachers Fresh Graduates Teaching Assistants Child Minders Psychologists Parents Requirements Dyslexia There are no specific requirements for this Dyslexia course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Training course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Dyslexia Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Operations Management Now Give a compliment to your career and take it to the next level. This Operations Management will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Operations Management will help you keep ahead of the pack. The Operations Management incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this Operations Management will add extra value to your resume to stand out to potential employers. Along with this Operations Management course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Operations Management? Course 1: Compliance Training Level 2 Course 2: Merchandising Course 3: Warehouse Course 4: Performance Management Course 5: Diploma in Lean Process and Six Sigma Course 6: Ecommerce Management Course 7: Level 3 Tax Accounting Course 8: Network Security Level 2 Course 9: Commercial Law 2021 Course 10: Decision Making and Critical Thinking As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Operations Management to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Operations Management: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum of this Operations Management Bundle Course 1: Operations Management Module 01: Introduction to Operations Management Module 02: Project Management Module 03: Business Development and Succession Planning Module 04: Process Management Module 05: Supply Chain Management Module 06: Planning & Forecasting Operations Module 07: Procurement & Purchasing Management Module 08: Manufacturing & Delivery Operations Module 09: Quality Management xcvxcv Module 10: Managing Risk and Recovery Module 11: Performance Management Module 12: Talent Management Module 13: Communication Skills Module 14: Negotiation Techniques Module 15: Conflict Management Module 16: Stress Management Module 17: Time Management Module 18: Business Environment Module 19: Business Writing Skills -------- 9 More Courses ---------- How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Requirements There is no time limit for completing this Operations Management course, it can be studied in your own time at your own pace. Career path Having these Operations Management expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

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