2349 Learning & Development courses

Master the essentials of Vulnerability, Abuse & Safeguarding. Learn to protect at-risk individuals with practical skills for adult and child safeguarding, whistleblowing, and online safety.

Business Development course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Business Development. Our course starts with the basics of Business Development and gradually progresses towards advanced topics. Therefore, each lesson of this Business Development is intuitive and easy to understand. So, stand out in the job market by completing the Business Development course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Business Development course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Module 01: Business Development and Succession Planning Module 02: Process Management Module 03: Supply Chain Management Module 04: Planning & Forecasting Operations Module 05: Procurement & Purchasing Management Module 06: Project Management Module 07: Retail Pricing Module 08: Business Analysis Planning and Monitoring Module 09: Strategic Analysis and Product Scope Module 10: Quality Management Module 11: Management Skills for Leading Your Team Module 12: Selling in Multiple Channels Module 13: Representing Your Boss and Company Module 14: Preparing for Brainstorming Module 15: Generating Solutions (I) Module 16: Generating Solutions (II) Module 17: Analyzing Solutions Module 18: Selecting a Solution Module 19: Negotiation Techniques Module 20: Communication Skills Module 21: Skills of an Effective Administrator Module 22: What is Marketing? Module 23: Common Marketing Types (I) Module 24: Common Marketing Types (II) Module 25: Conflict Management Module 26: Talent Management Module 27: Time Management Module 28: Managing Risk and Recovery Module 29: Business Etiquette CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Business Development course. Requirements To enrol in this Business Development course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Business Development. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

The Culture of Feedback in Agile This presentation will discuss how and why the culture of feedback is so important in Agile. See how Amadeus has introduced gamification and role playing to foster collaboration and transparency in a safe environment based on a feedback model. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

The Culture of Feedback in Agile This presentation will discuss how and why the culture of feedback is so important in Agile. See how Amadeus has introduced gamification and role playing to foster collaboration and transparency in a safe environment based on a feedback model. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Overview UK Healthcare and Education workers need specialist training to engage with individuals with learning disabilities, which is available here and now. This essential course is specifically designed to help you support those that have challenges in learning and help their development. The Working with Individuals with Learning Disabilities Level 2 course will teach you to identify and recognise the symptoms that are indicative of learning difficulties and of being able to diagnose the issue, therefore providing the right supportive measures. You will be taught how to share this awareness and install the right care and attention across your team and in your organisation's infrastructure. How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Working with Individuals with Learning Disabilities Level 2. It is available to all students, of all academic backgrounds. Requirements Our Working with Individuals with Learning Disabilities Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 10 sections • 9 lectures • 04:20:00 total length •Module 01: Learning Support Assistant: Workplace & Works: 00:30:00 •Module 02: Teaching Methodologies: 00:30:00 •Module 03: Skills of A Learning Support Assistant: 00:20:00 •Module 04: The Role and Responsibilities of the Learning Support Assistant: 00:20:00 •Module 05: SEN Teaching: 01:00:00 •Module 06: Supporting Pupils with Special Needs (Part 01): 00:30:00 •Module 07: How to Support Pupils with Special Needs Part-2: 00:50:00 •Module 08 Safeguarding Children and Young People: 00:20:00 •Assignment - Working with Individuals with Learning Disabilities Level 2: 00:00:00

Buy Big. Save Big! Save Now: £403! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Course might help you get there! Expand your expertise with high-quality training - study the Gemology and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through this online training course. This course is endorsed by The Quality Licence Scheme and accredited by CPD (with 120 CPD points) to make your skill development and career progression related to Recreational Gemology substantial and easier than ever! This course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. Key Topics to Be Covered on this course: Understanding the qualities of a gemstone and its formation Measuring and altering the colour of a gem Cutting, grinding, and polishing gemstones Checking and costing the value of gems Exploring the differences between each type of gemstone With this comprehensive course, you can achieve your dreams and train for your ideal career. This course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. This training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join this course today - gear up with the essential skills to set yourself up for excellence! Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPD after completing this Recreational course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging contents and activities Assessments that measure higher-level thinking and skills Complete this program in your own time, at your own pace Each of our students gets full tutor support on weekdays (Monday to Friday) **** Course Curriculum **** Here is the curriculum breakdown of the course: Certificate in Gemology at QLS Level 3 Module 01: Introduction to Gemology What is a Gem? The essential qualities of a gem Appearance of Gemstone Module 02: Formation of Gems Rock Cycle Formation of Gems Module 03: Colour Physics of colour Colour Grade Colour Measuring Apparatus Colour Alteration Module 04: Fashioning What is Gem Fashioning? The Brilliant Cut Ideal Brilliants Step Cut Polishing and Grinding Faceting Module 05: Gem Testing Gem Testing Step of Gem Testing Loupe Spectroscope Testing Methods Module 06: Weight and Measurement What Is a Carat? Size versus carat weight Cost per Carat Points Spread Specific Gravity Density Module 07: Precious Gemstones Diamond Opal Emerald Ruby Pearl Amber Topaz Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All is welcome to take this course. There are no prerequisites for enrollment, and you can access the course materials from any location in the world. Requirements This course does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This Recreational Gemology course allows you to study at your own speed while earning an industry-recognized certification. Career path This course allows you to kickstart or take your career in the related sector to the next stage. Our whole course assists in achieving a position of respect and dignity, as well as allowing you to gain an advantage over your competitors. This certificate will strengthen your CV and assist you in finding work in the related industry. Certificates CPD Accredited Certificate Digital certificate - £10 Certificate in Gemology at QLS Level 3 Hard copy certificate - £89 After successfully completing the Certificate in Gemology at QLS Level 3, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 89 GBP inside the UK 99 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Are you looking to improve your current abilities or make a career move? Our unique DevOps Fundamentals: Maven and SonarQube for Engineers course might help you get there! Expand your expertise with high-quality training - study the DevOps Fundamentals: Maven and SonarQube for Engineers course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the DevOps Fundamentals: Maven and SonarQube for Engineers online training course. This Diploma in DevOps Fundamentals: Maven and SonarQube for Engineers at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer This DevOps Fundamentals: Maven and SonarQube for Engineers Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the DevOps Fundamentals: Maven and SonarQube for Engineers course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. The DevOps Fundamentals: Maven and SonarQube for Engineers course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the DevOps Fundamentals: Maven and SonarQube for Engineers course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This DevOps Fundamentals: Maven and SonarQube for Engineers training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the DevOps Fundamentals: Maven and SonarQube for Engineers course: DevOps Fundamentals: Maven and SonarQube for Engineers Course Module 01: Introduction Module 02: Setup Maven Environment on Windows Module 03: Maven Goals, Repositories Module 04: Maven on Linux Module 05: Maven in DevOps workflow Module 06: Additional Resources Module 07: SonarQube Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam.Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Diploma in DevOps Fundamentals: Maven and SonarQube for Engineers at QLS Level 4 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 120 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 DevOps Fundementals: Maven and SonarQube for Engineers course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates Certificate of completion Digital certificate - £10 99 Hard copy certificate - £99 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in DevOps Fundamentals: Maven and SonarQube for Engineers at QLS Level 4, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 99 GBP inside the UK 109 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

Overview of Recruitment Training Course Join our Recruitment Training Course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Recruitment Training Course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Recruitment Training Course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a Quick Look at The Course Content: This Recruitment Training Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Recruitment Training Course. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Recruitment Training Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Recruitment Training Course is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education.   Requirements You don't need any educational qualification or experience to enrol in the Recruitment Training Course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Recruitment Training Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Frequently Asked Questions (FAQ's) Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. Can I do the courses from outside UK? We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Course Curriculum Module 1 - Introduction to Recruitment: Importance and Implications Module 1 - Introduction to Recruitment: Importance and Implications 00:17:00 Module 2 - An Overview of the Recruitment Industry Module 2 - An Overview of the Recruitment Industry 00:26:00 Module 3 - The UK Recruitment Legislation Module 3 - The UK Recruitment Legislation 00:19:00 Module 4 - Sales and Selling in the Recruitment Industry Module 4 - Sales and Selling in the Recruitment Industry 00:11:00 Module 5 - The Recruitment Process Module 5 - The Recruitment Process 00:47:00 Module 6 - Key Performance Indicators for the Recruitment Industry Module 6 - Key Performance Indicators for the Recruitment Industry 00:25:00 Module 7 - Candidate Attraction for Recruitment Module 7 - Candidate Attraction for Recruitment 00:35:00 Module 8 - Candidate Management Module 8 - Candidate Management 00:22:00 Module 9 - Candidate Interview Processes Module 9 - Candidate Interview Processes 00:24:00 Module 10 - Client Acquisition Module 10 - Client Acquisition 00:36:00 Module 11 - Client Strategy in the Recruitment Sector Module 11 - Client Strategy in the Recruitment Sector 00:25:00 Module 12: Client Management Module 12: Client Management 00:27:00 Module 13 - Steps to Starting and Running a Successful Recruiting Service Module 13 - Steps to Starting and Running a Successful Recruiting Service 00:23:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Child Development and Care Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Child Development and Care Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Child Development and Care Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Child Development and Care Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Child Development and Care? 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 Child Development and Care 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Child Development and Care 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 Child Development and Care does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Child Development and Care 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 Child Development and Care is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Understanding Child Development Understanding Child Development 00:54:00 Module 02: Care for Children Care for Children 00:25:00 Module 03: Healthy Food, Healthy Living Healthy Food, Healthy Living 00:25:00 Module 04: Keeping Children Healthy and Safe Keeping Children Healthy and Safe 00:32:00 Module 05: Child Protection Child Protection 00:23:00 Module 06: Play, Imagination and Creativity Play, Imagination and Creativity 00:26:00 Module 07: Factors That Influence Development Factors That Influence Development 00:36:00 Module 08: Cognitive Development Cognitive Development 00:25:00 Module 09: Social and Emotional Development Social and Emotional Development 00:43:00 Module 10: Personality and Intellectual Development in Children Personality and Intellectual Development in Children 00:36:00 Module 11: Language Development in Children Language Development in Children 00:32:00 Module 12: Problems in Childhood & Adolescence Problems in Childhood & Adolescence 00:41:00 Assignment Assignment - Child Development and Care 00:00:00

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  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 Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. 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 Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00