27980 Development courses delivered Online

In this course, you will learn how to author machine learning models in Python without the aid of frameworks or libraries from scratch. Discover the process of loading data, evaluating models, and implementing machine learning algorithms.

Self Esteem: Self Esteem Online Training Self-esteem and assertiveness are two essential skills for life success. None of your life's judgments is more important than what you make about yourself. Without some sense of self-worth, life can be extremely painful and unforgiving. Through this Self Esteem: Self Esteem Course, you will learn some techniques that can dramatically change how you feel about yourself and how you approach the world to get what you want. Move past your fears, shyness, self-doubt, and negativity. Increase your self-esteem, improve your ability to influence others, and take action that will change your life for the better! Self-esteem and assertiveness are essential components of living a happy and successful life. Building self-esteem and assertiveness are essential for professional success. However, it is impossible to advance in your career without adequate training and guidance. And this Self Esteem: Self Esteem Course is perfect for you in this regard. After completing this Self Esteem: Self Esteem Course, you'll be ready to take on any challenge and start your career in your desired industries/sectors by developing your skills. This Self Esteem: Self Esteem Course will improve your existing skills by taking them to the next level and providing up-to-date knowledge for facing tomorrow's challenges. Special Offers of this Self Esteem: Self Esteem Course This Self Esteem Course includes a FREE PDF Certificate. Lifetime access to this Self Esteem Course Instant access to this Self Esteem: Self Esteem Course Get FREE Tutor Support from Monday to Friday in this Self Esteem: Self Esteem Course Courses are included in this Self Esteem and Assertiveness Course Course 01: Self Esteem and Assertiveness Skill Course 02: Level 5 Negotiation Skills Course Course 03: Level 4 Time Management Course [ Note: Free PDF certificate will provide as soon as completing the Self Esteem: Self Esteem course ] Self Esteem: Self Esteem Online Training Detailed Self Esteem course curriculum Industry Experts Designed this Self Esteem course into 4 detailed modules. Module 1: Understanding Self Esteem Module 2: Understanding Assertiveness Module 3: Assertiveness in Communication Module 4: Assertiveness in Workplace Assessment Method Of Self Esteem After completing each module of the Self Esteem: Self Esteem, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Self Esteem After completing the MCQ/Assignment assessment for this Self Esteem: Self Esteem, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Self Esteem Online Training This Self Esteem: Self Esteem is ideal for anyone who wants to understand why Self Esteem skills are important, how to develop and improve them, and how to advance their career. Requirements Self Esteem Online Training Students who intend to enrol in this Self Esteem: Self Esteem course must meet the following requirements: Self Esteem: Good command of the English language Self Esteem: Must be vivacious and self-driven Self Esteem: Basic computer knowledge Self Esteem: A minimum of 16 years of age is required Career path Self Esteem Online Training Certificates Certificate of completion Digital certificate - Included

Description: Want to pursue your career in medication management? Or are you currently working as a nurse, midwives, clinical supporters, or home domiciliary care workers? Then Medication Management for Nurses and Midwives course is the best choice for you. Proper Medication management allows the patients optimal therapeutic outcomes from the prescription medications. Therefore, proper knowledge of medication management is a must for the people who are in responsible for giving medications to the patients. The course familiarizes you with the concepts of medication including along with the process of storage and dispensing, administration of medication and more. You will know about the legislation involved with the administration of medication. The course trains you how to minimize, reduce or eliminates medication errors. Shortly, you will gain a solid understanding of medication management. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Medication Management for Nurses and Midwives is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Medication Management for Nurses and Midwives is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. General Principles and Responsibilities Legislation 00:15:00 Key Principles 00:15:00 Five Rights of Medication Administration 00:15:00 Double-checking Medications 00:15:00 Monitoring and documentation of medication management 00:05:00 Patient/service-user Education 00:05:00 Considerations for Withholding of Medication 00:05:00 The Cycle of Medication Management Transcription of Prescription/Medication Order 00:15:00 Use of Facsimile 00:15:00 Medication Administration 00:15:00 Dispensing of Medicinal Products 00:15:00 Scheduled MDA Drugs 00:15:00 Management of MDA Schedule 2 Drugs 00:15:00 Storage of Medicinal Products 00:05:00 Safety in Medication Management Medication Errors 00:15:00 Crushing Medications 00:05:00 Immunisations and vaccinations 00:05:00 Adverse Drug Reaction 00:15:00 Incidents Involving Medical Devices 00:05:00 Medication Protocols Medication Protocols 00:15:00 Medication Protocol Framework Template 00:05:00 Appendices 00:30:00 Terms Relating to Medication Management 00:30:00 References - Medication Management 00:15:00 Assessment Assignment - Medication Management for Nurses and Midwives 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The 'Leadership Skills Training: Become an Inspiring Team Leader' course is designed to equip individuals with the essential qualities and skills of a good leader, enhancing their leadership competencies and promoting creativity in leadership. It covers topics such as communication, negotiation, emotional intelligence, inclusion, and belonging, empowering participants to evolve as effective leaders in the UK's management landscape. Learning Outcomes: Understand the fundamental concepts and importance of leadership in various contexts. Identify the qualities and characteristics of an effective and inspiring team leader. Foster creativity in leadership to encourage innovative approaches in problem-solving. Develop organizational skills to manage tasks, resources, and team members efficiently. Enhance leadership skills and competencies to build and lead successful teams. Improve communication skills for effective interaction and collaboration with team members. Learn negotiation techniques to address conflicts and reach mutually beneficial agreements. Cultivate inclusion, belonging, and engagement within the team to foster a positive work environment. Establish strong leadership foundations based on leadership theories and practices. Develop emotional intelligence to better understand and manage emotions within oneself and others. Evolve as a leader by continuously learning, adapting, and improving leadership abilities. Gain insights into the specific context of leadership and management practices in the UK. Why buy this Leadership Skills Training: Become an Inspiring Team Leader? 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 Leadership Skills Training: Become an Inspiring Team Leader 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 Leadership Skills Training: Become an Inspiring Team Leader 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 Leadership Skills Training: Become an Inspiring Team Leader does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Leadership Skills Training: Become an Inspiring Team Leader 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 Leadership Skills Training: Become an Inspiring Team Leader is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Introduction to Leadership Introduction to Leadership 00:23:00 Module 02: Qualities of a Good Leader and Leadership Qualities of a Good Leader and Leadership 00:13:00 Module 03: Creativity in Leadership Creativity in Leadership 00:19:00 Module 04: Organisational Skills Organisational Skills 00:26:00 Module 05: Leadership Skills and Competencies Leadership Skills and Competencies 00:30:00 Module 06: Communication Skills Communication Skills 00:27:00 Module 07: Negotiation Techniques Negotiation Techniques 00:15:00 Module 08: Cultivating Inclusion, Belonging, and Engagement Cultivating Inclusion, Belonging, and Engagement 00:25:00 Module 09: Leadership Foundations Leadership Foundations 00:24:00 Module 10: Emotional Intelligence Emotional Intelligence 00:19:00 Module 11: Evolve as a Leader Evolve as a Leader 00:14:00 Module 12: Leadership & Management in the UK Leadership & Management in the UK 00:17:00 Assignment Assignment - Leadership Skills Training: Become an Inspiring Team Leader! 00:00:00

Course Description Get instant knowledge from this bite-sized Journal Therapy: Part 1 course. This course is very short and you can complete it within a very short time. In this Journal Therapy: Part 1 course you will get fundamental ideas of journal therapy, the key understanding of journal therapy as a treatment method, the structure of journal writing and so on. Enrol in this course today and start your instant first step towards learning about journal therapy. Learn faster for instant implementation. Learning outcome  Familiarise with journal therapy Understand journal therapy as a treatment method Gain in-depth knowledge of the foundations of therapeutic writing Deepen your understanding of the structure of journal writing Requirement Our Journal Therapy: Part 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Journal Therapy: Part 1 Module 01: Introduction to Journal Therapy 00:10:00 Module 02: Writing to Heal 00:13:00 Module 03: Journal Therapy as a Treatment Method 00:22:00 Module 04: Foundations of Therapeutic Writing 00:13:00 Module 05: Structure of Journal Writing 00:21:00 Assignment Assignment - Journal Therapy: Part 1 00:00:00

Course Description Get instant knowledge from this bite-sized Journal Therapy: Part 2 course. This course is very short and you can complete it within a very short time. In this Journal Therapy: Part 2 course you will get fundamental ideas of journal therapy, the key understanding of the six windows model, journaling for a better career and so on. Enrol in this course today and start your instant first step towards learning about what people need to write. Learn faster for instant implementation. Learning outcome  Familiarise with the six windows model Understand what people need to write Gain in-depth knowledge of the writing to help you take control of your own life Deepen your understanding of therapeutic vs creative journaling Understand journaling for a better career and self Requirement Our Journal Therapy: Part 2 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Journal Therapy: Part 2 Module 01: What People Need to Write 00:10:00 Module 02: The Six Windows Model 00:21:00 Module 03: Writing to Help You Take Control of Your Own Life 00:18:00 Module 04: Therapeutic vs Creative Journaling 00:23:00 Module 05: Journaling for a Better Career and Self 00:29:00 Assignment Assignment - Journal Therapy: Part 2 00:00:00

Networking is one of the most important skills that one should have for success. Networking is like branding yourself and making others informed that you're capable. Without proper networking, your potential and capabilities remain unknown to others. So, it's important to master the skills of networking to kickstart a better career.  This Personal / Business Networking Skills For Maximum Success Course is designed to teach you the strategies and techniques of effective networking so that you can succeed in your personal and professional life.  What you'll learn Powerful Networking Tools & Strategies - Unique! Learn How the Law Of Reciprocity Can Work For You Learn the Power of the 'Likeability Factor' Hot / Targeted Places to Network Best Online Networking Strategies For Success Mentors - The Power To Transform Your Life! Who is this Course for? This course a perfect fit for anyone who is looking for learning the skills of networking and effective communication.  Requirements Basic / Simple Computer Skills. English speaking knowledge. This course fully compatible with any kind of device. Whether you are using a Windows computer, Mac, smartphone or tablet, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time, without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course and will be equipped with the necessary knowledge and skills required to succeed in this sector. All of our courses are CPD and IAO accredited, so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume.  Personal / Business Networking Skills For Maximum Success! Why Is Networking Powerful? FREE 00:05:00 Networking Paradigm Shifts FREE 00:03:00 You've Got To GIVE To GET 00:08:00 The Power Of 'Likeability' 00:09:00 Making The Connection 00:06:00 Great Places To Network 00:08:00 The Power Of Mentors 00:06:00

Overview This comprehensive course on Data Science & Machine Learning with Python will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Science & Machine Learning with Python comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Science & Machine Learning with Python. It is available to all students, of all academic backgrounds. Requirements Our Data Science & Machine Learning with Python is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 90 lectures • 10:24:00 total length •Course Overview & Table of Contents: 00:09:00 •Introduction to Machine Learning - Part 1 - Concepts , Definitions and Types: 00:05:00 •Introduction to Machine Learning - Part 2 - Classifications and Applications: 00:06:00 •System and Environment preparation - Part 1: 00:08:00 •System and Environment preparation - Part 2: 00:06:00 •Learn Basics of python - Assignment 1: 00:10:00 •Learn Basics of python - Assignment 2: 00:09:00 •Learn Basics of python - Functions: 00:04:00 •Learn Basics of python - Data Structures: 00:12:00 •Learn Basics of NumPy - NumPy Array: 00:06:00 •Learn Basics of NumPy - NumPy Data: 00:08:00 •Learn Basics of NumPy - NumPy Arithmetic: 00:04:00 •Learn Basics of Matplotlib: 00:07:00 •Learn Basics of Pandas - Part 1: 00:06:00 •Learn Basics of Pandas - Part 2: 00:07:00 •Understanding the CSV data file: 00:09:00 •Load and Read CSV data file using Python Standard Library: 00:09:00 •Load and Read CSV data file using NumPy: 00:04:00 •Load and Read CSV data file using Pandas: 00:05:00 •Dataset Summary - Peek, Dimensions and Data Types: 00:09:00 •Dataset Summary - Class Distribution and Data Summary: 00:09:00 •Dataset Summary - Explaining Correlation: 00:11:00 •Dataset Summary - Explaining Skewness - Gaussian and Normal Curve: 00:07:00 •Dataset Visualization - Using Histograms: 00:07:00 •Dataset Visualization - Using Density Plots: 00:06:00 •Dataset Visualization - Box and Whisker Plots: 00:05:00 •Multivariate Dataset Visualization - Correlation Plots: 00:08:00 •Multivariate Dataset Visualization - Scatter Plots: 00:05:00 •Data Preparation (Pre-Processing) - Introduction: 00:09:00 •Data Preparation - Re-scaling Data - Part 1: 00:09:00 •Data Preparation - Re-scaling Data - Part 2: 00:09:00 •Data Preparation - Standardizing Data - Part 1: 00:07:00 •Data Preparation - Standardizing Data - Part 2: 00:04:00 •Data Preparation - Normalizing Data: 00:08:00 •Data Preparation - Binarizing Data: 00:06:00 •Feature Selection - Introduction: 00:07:00 •Feature Selection - Uni-variate Part 1 - Chi-Squared Test: 00:09:00 •Feature Selection - Uni-variate Part 2 - Chi-Squared Test: 00:10:00 •Feature Selection - Recursive Feature Elimination: 00:11:00 •Feature Selection - Principal Component Analysis (PCA): 00:09:00 •Feature Selection - Feature Importance: 00:07:00 •Refresher Session - The Mechanism of Re-sampling, Training and Testing: 00:12:00 •Algorithm Evaluation Techniques - Introduction: 00:07:00 •Algorithm Evaluation Techniques - Train and Test Set: 00:11:00 •Algorithm Evaluation Techniques - K-Fold Cross Validation: 00:09:00 •Algorithm Evaluation Techniques - Leave One Out Cross Validation: 00:05:00 •Algorithm Evaluation Techniques - Repeated Random Test-Train Splits: 00:07:00 •Algorithm Evaluation Metrics - Introduction: 00:09:00 •Algorithm Evaluation Metrics - Classification Accuracy: 00:08:00 •Algorithm Evaluation Metrics - Log Loss: 00:03:00 •Algorithm Evaluation Metrics - Area Under ROC Curve: 00:06:00 •Algorithm Evaluation Metrics - Confusion Matrix: 00:10:00 •Algorithm Evaluation Metrics - Classification Report: 00:04:00 •Algorithm Evaluation Metrics - Mean Absolute Error - Dataset Introduction: 00:06:00 •Algorithm Evaluation Metrics - Mean Absolute Error: 00:07:00 •Algorithm Evaluation Metrics - Mean Square Error: 00:03:00 •Algorithm Evaluation Metrics - R Squared: 00:04:00 •Classification Algorithm Spot Check - Logistic Regression: 00:12:00 •Classification Algorithm Spot Check - Linear Discriminant Analysis: 00:04:00 •Classification Algorithm Spot Check - K-Nearest Neighbors: 00:05:00 •Classification Algorithm Spot Check - Naive Bayes: 00:04:00 •Classification Algorithm Spot Check - CART: 00:04:00 •Classification Algorithm Spot Check - Support Vector Machines: 00:05:00 •Regression Algorithm Spot Check - Linear Regression: 00:08:00 •Regression Algorithm Spot Check - Ridge Regression: 00:03:00 •Regression Algorithm Spot Check - Lasso Linear Regression: 00:03:00 •Regression Algorithm Spot Check - Elastic Net Regression: 00:02:00 •Regression Algorithm Spot Check - K-Nearest Neighbors: 00:06:00 •Regression Algorithm Spot Check - CART: 00:04:00 •Regression Algorithm Spot Check - Support Vector Machines (SVM): 00:04:00 •Compare Algorithms - Part 1 : Choosing the best Machine Learning Model: 00:09:00 •Compare Algorithms - Part 2 : Choosing the best Machine Learning Model: 00:05:00 •Pipelines : Data Preparation and Data Modelling: 00:11:00 •Pipelines : Feature Selection and Data Modelling: 00:10:00 •Performance Improvement: Ensembles - Voting: 00:07:00 •Performance Improvement: Ensembles - Bagging: 00:08:00 •Performance Improvement: Ensembles - Boosting: 00:05:00 •Performance Improvement: Parameter Tuning using Grid Search: 00:08:00 •Performance Improvement: Parameter Tuning using Random Search: 00:06:00 •Export, Save and Load Machine Learning Models : Pickle: 00:10:00 •Export, Save and Load Machine Learning Models : Joblib: 00:06:00 •Finalizing a Model - Introduction and Steps: 00:07:00 •Finalizing a Classification Model - The Pima Indian Diabetes Dataset: 00:07:00 •Quick Session: Imbalanced Data Set - Issue Overview and Steps: 00:09:00 •Iris Dataset : Finalizing Multi-Class Dataset: 00:09:00 •Finalizing a Regression Model - The Boston Housing Price Dataset: 00:08:00 •Real-time Predictions: Using the Pima Indian Diabetes Classification Model: 00:07:00 •Real-time Predictions: Using Iris Flowers Multi-Class Classification Dataset: 00:03:00 •Real-time Predictions: Using the Boston Housing Regression Model: 00:08:00 •Resources - Data Science & Machine Learning with Python: 00:00:00

Unlock the gateway to effective project management and collaboration with 'Basic Jira and Confluence'. Immerse yourself in a meticulously structured course that starts by acquainting you with the foundational facets of Jira. Progressing through the modules, one is guided in crafting user stories, designing test cases, efficiently identifying and assigning bugs, and generating comprehensive reports. As a grand finale, the course introduces Confluence, Atlassian's robust collaborative platform, beautifully complementing Jira's functionalities. Learning Outcomes Acquire a foundational understanding of Jira's interface and capabilities. Learn to craft compelling user stories for product backlogs. Master the art of designing precise test cases for rigorous testing scenarios. Develop skills to identify, log, and assign bugs effectively. Gain proficiency in generating detailed reports and using Confluence for team collaboration. Why choose this Basic Jira and Confluence course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Basic Jira and Confluence Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Basic Jira and Confluence course for? Novices keen on exploring project management tools. Teams aiming to improve collaboration and workflow. Individuals aspiring to roles in software project management. Product managers desiring enhanced backlog management. QA professionals aiming for improved bug tracking. Career path Jira Administrator - £35,000 - £60,000 Confluence Specialist - £32,000 - £57,000 Agile Project Manager - £40,000 - £75,000 Software Product Manager - £40,000 - £80,000 QA Lead - £45,000 - £70,000 Technical Documentation Specialist - £30,000 - £55,000 Prerequisites This Basic Jira and Confluence does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Basic Jira and Confluence 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Basic Jira and Confluence Module 01: Introduction to Jira 00:51:00 Module 02: Creation of User Stories 00:44:00 Module 03: Creation of Test Cases 00:58:00 Module 04: Creation of Bugs and assigning to respective owner 00:57:00 Module 05: Creation of Reports 00:48:00 Module 06: Introduction on Confluence 00:44:00 Assignment Assignment - Basic Jira and Confluence 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