15052 Open courses

Give a compliment to your career and take it to the next level. This Online Dog Training, Dog Health and Behaviour - Level 3 will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Online Dog Training, Dog Health and Behaviour - Level 3bundle will help you stay ahead of the pack. Throughout the Online Dog Training, Dog Health and Behaviour - Level 3programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Online Dog Training, Dog Health and Behaviour - Level 3 course, you will get 10 premium courses, an originalHardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Online Dog Training, Dog Health and Behaviour - Level 3 Bundle Consists of the following Premium courses: Course 01: Online Dog Training, Dog Health and Behaviour - Level 3 Course 02: Dog Groomer Training Course 03: Dog Training - Stop Dog Barking Course 04: Training for Puppies Course 05: Dog Agility Course 06: Canine Communication Course 07: Pet Business Course Course 08: Wildlife Rescue and Rehabilitation Course Course 09: Veterinary Assistant Diploma Course 10: Dog Raw Diet Training - Level 2 Course 11: Dog Walking and Training Course Level 3 Enrol now in Online Dog Training, Dog Health and Behaviour - Level 3 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 Online Dog Training, Dog Health and Behaviour - Level 3expertise and essential knowledge, which will assist you in reaching your goal. 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 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Online Dog Training, Dog Health and Behaviour - Level 3 bundle. Requirements This Online Dog Training, Dog Health and Behaviour - Level 3 course has been designed to be fully compatible with tablets and smartphones. Career path Having this 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 (Online Dog Training, Dog Health and Behaviour - 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.

Give a compliment to your career and take it to the next level. This Level 2 Certificate in Preparing to Work in Adult Social Care bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Level 2 Certificate in Preparing to Work in Adult Social Care bundle will help you stay ahead of the pack. Throughout the Level 2 Certificate in Preparing to Work in Adult Social Care programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Level 2 Certificate in Preparing to Work in Adult Social Care course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Level 2 Certificate in Preparing to Work in Adult Social Care Bundle Consists of the following Premium courses: Course 01: Safeguarding Vulnerable Adults at Risk Complete Diploma Course 02: Level 4 Diploma in Health and Social Care Management Course 03: Adult Nursing Diploma Course 04: Treating Post Traumatic Stress Disorder Course 05: Cardiac (Heart) Care Course 06: Diabetes Care Diploma Course 07: Dementia Training Course 08: Palliative and End of Life Care Training- Level 5 Course 09: Dialectical Behaviour Therapy Course 10: Mental Health with Positive Psychology Course 11: Medication Administration Level 4 Enrol now in Level 2 Certificate in Preparing to Work in Adult Social Care 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 Level 2 Certificate in Preparing to Work in Adult Social Care expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Level 2 Certificate in Preparing to Work in Adult Social Care bundle. Requirements This Level 2 Certificate in Preparing to Work in Adult Social Care course has been designed to be fully compatible with tablets and smartphones. Career path Having this 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 (Safeguarding Vulnerable Adults at Risk Complete Diploma) 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.

Highlights of the Level 1 Food Safety Catering Course Course Type: Self-paced online course Duration: 1 Hour 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 Level 1 Food Safety Catering Course? Recognise the importance of food safety and hygiene in catering sectors Illustrate the legislation that the UK has in place to ensure food safety. Detect and eliminate any hazards from the entire delivery-to-service process Minimise and control the risks associated with contamination Identify the primary causes of food poisoning and how to avoid it Develop a safety process to stop microorganisms from causing food-borne illnesses Emphasize the significance of effective pest control in avoiding and reducing food pests Learn how to maintain a clean and safe environment both within and outside catering businesses Understand how to use the skills you gained in this course in a practical setting Level 1 Food Safety Catering Course This Level 1 Food Safety Course for Catering will help you gain essential skills and knowledge to oversee the safety procedures and precautions in the food catering sector, adhere to the legislation and control the spread of foodborne illnesses. You will learn from expert instructors with experience in the field who will impart the most relevant expertise and best practices. Prevent significant food contamination Obey the legislation that safeguards food safety Recognize risks and dangers in the catering food business Monitor the spread of foodborne illnesses Implement effective premises management and pest control measures. Essential skills, confidence and competence to assist you in the food safety industry Core competencies required to drive a successful career in the food safety industry This Level 1 Food Safety - Catering 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. This Level 1 Food Safety - Catering course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Who is this course for? Supervisors and managers who are in charge of planning, directing, or monitoring the health and safety processes in the catering food businesses can take this course Kitchen porters, chefs and anyone working in the catering sector can take this course to enhance their skills and knowledge for a rewarding career in this field This course is also open to owners of food catering businesses who are considering developing appropriate food safety measures in the workplace. New employees with little to no prior experience in food safety can take this Level 1 Food Safety Course for Catering to improve their chances of being hired Anyone who wants to gain comprehensive knowledge about food safety regardless of their career can also take this Level 1 Food Safety Course for Catering Entry Requirements This Level 1 Food Safety Course for Catering has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone and a reliable internet connection. Assessment This Level 1 Food Safety Course for Catering 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 can grasp from each section. In the assessment, the pass mark is 60%. Advance Your Career This Level 1 Food Safety Course for Catering will provide you with significant opportunities to enter the relevant job market and select your desired career path. Additionally, by showcasing these skills on your resume, you will be able to develop your career, face more competitors in your chosen sector, and increase your level of competition. If you are looking for the Level 1 Food Safety Course - Retail Training, enrol into our affordable and highly informative course, which will open your door towards a wide range of opportunities within your chosen sector.  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 Module 1: Food Safety Legislation Module 2: Hazards from Delivery to Service Module 3: Risk Control (Prevention of Contamination) Module 4: Pests, Premises and People Obtain Your Certificate of Achievement Order Your Certificate of Achievement 00:00:00

Highlights of the Course Course Type: Self-paced online course Duration: 1 hour 40 minutes 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? Understand the fundamentals of lone worker personal safety Demonstrate various laws and regulations concerning lone worker safety Recognise the risks and know how to prevent them Identify the standard security measures that can be employed Discover the factors that can improve the safety of lone workers Determine the practical measures that can be taken to prevent conflict Know how to record and report lone worker accidents Transform into a competent and confident employer, manager or supervisor Understand how to use the skills you gained in this course in a practical setting Personal Safety for Lone Workers This Personal Safety for Lone Workers Training Course will provide you with the required skills and knowledge your need to guarantee your personal safety if you are exposed to lone scenarios at work premises. You will learn from expert instructors with experience in the field who will impart the most relevant expertise and best practices. Risk assessment Precautionary measures Report incidents and raise awareness Legal responsibilities of employers and employees Essential skills, confidence and competence to assist you in the workspace safety industry Core competencies required to drive a successful career in the workplace safety industry This Personal Safety for Lone Workers 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. This Personal Safety for Lone Workers course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Who is this course for? This course is open to supervisors and managers who are in charge of organising, directing, or overseeing the health and safety of their workplace Anyone who spends time alone with customers or members of the public as part of their profession can take this Personal Safety for Lone Workers Training Course Any kind of lone workers who are required to work alone at the work premises can enrol in this Personal Safety for Lone Workers Training Course Employers thinking of implementing proper safety and preventive measure within the workplace can also take this course This course can also be taken by employees who want to upgrade their skills and knowledge about workplace safety in order to keep themselves and others around them safe Entry Requirements This Personal Safety for Lone Workers Training Course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone and a reliable internet connection. Assessment This Personal Safety for Lone Workers Training 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 can grasp from each section. In the assessment, the pass mark is 60%. Advance Your Career This Personal Safety for Lone Workers Training Course will provide you with significant opportunities to enter the relevant job market and select your desired career path. Additionally, by showcasing these skills on your resume, you will be able to develop your career, face more competitors in your chosen sector, and increase your level of competition. If you are looking for Positive Handling in Schools, enrol into our affordable and highly informative course, which will open your door towards a wide range of opportunities within your chosen sector.  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 Module 1: Lone Worker Personal Safety: The Basics Module 2: The Law: Responsibilities Module 3: Assessing the Risks Module 4: Personal Safety Solutions Module 5: Practical Tips to Avoid Conflict Module 6: Reporting and Recording Incidents Obtain Your Certificate of Achievement Order Your Certificate of Achievement 00:00:00

Register on the DIY Soap Making today and build the experience, skills and knowledge you need to enhance your expert development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The DIY Soap Making course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get Out Of Studying DIY Soap Making With Janets Receive a e-certificate upon successful completion of the course Get taught by experienced, expert instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. 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 free of cost. 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 The DIY Soap Making is ideal for those who already work in this sector or are an aspiring experts . This DIY Soap Making course is designed to enhance your expertise and boost your CV. Learn key skills and gain a expert lesson to prove your newly-acquired knowledge. Requirements The DIY Soap Making is open to all students and has no formal entry requirements. To study the DIY Soap Making course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path The DIY Soap Making is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the DIY Soap Making and gain an industry-acknowledged lesson that will help you excel in finding your ideal job. Course Content Module 01: Introduction to Soap Making Introduction to Soap Making 00:16:00 Module 02: Types of Soaps Types of Soaps 00:17:00 Module 03: Soap Making Ingredients Soap Making Ingredients 00:27:00 Module 04: Equipment for Soap Making Equipment for Soap Making 00:23:00 Module 05: Different Ways to Make A Soap: Part-1 Different Ways to Make a Soap Part-1 00:15:00 Module 06: Different Ways to Make A Soap: Part-2 Different Ways to Make a Sopa Part-2 00:18:00 Module 07: Understanding Oil Choices Understanding Oil Choices 00:26:00 Module 08: Playing with Colours Playing with Colours 00:26:00 Module 09: Make Your Own Soap Bars: Part-1 Make Your Own Soap Bars Part-1 00:23:00 Module 10: Make Your Own Soap Bars: Part-2 Make Your Own Soap Bars Part-2 00:28:00 Module 11: Special Soap Recipes Special Soap Recipes 00:29:00 Module 12: Soaps for Other Purposes Soaps for Other Purposes 00:18:00 Module 13: Tips, Tricks and Precautions Tips, Tricks and Precautions 00:22:00 Module 14: Troubleshooting Troubleshooting 00:17:00 Module 15: Frequently Faced Confusions Frequently Faced Confusions 00:22:00 Module 16: Open for Business Open for Business 00:13:00 Module 17: Selling Your Beautiful Handmade Soaps Selling Your Beautiful Handmade Soaps 00:18:00 Mock Exam Mock Exam - DIY Soap Making 00:20:00 Final Exam Final Exam - DIY Soap Making 00:20:00 Assignment Assignment - DIY Soap Making 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00:00

Step into the realm of rhythm and verse with our 'Poetry Writing' course, a path that leads you through the artful intricacies of poetic expression. This course is an invitation to unlock your creative potential and weave words into impactful poetry. It begins with an introduction to poetry writing, setting the stage for a deeper understanding and appreciation of this timeless art form. As you delve into reading poetry, you gain insights not just as a reader, but as an emerging poet, understanding the nuances and depths that words can convey. As your journey progresses, you will be guided through the initial steps of crafting your own poems, exploring the important details that make poetry so evocative. The course covers the elements of poetic language, teaching you how to use metaphors, similes, and rhythm to breathe life into your verses. You'll learn about the sound of poetry - how rhyme, meter, and cadence can be harnessed to create memorable and melodious poems. The exploration deepens with lessons on open-form and closed-form poetry, providing you with a broad spectrum of styles and structures. From traditional forms of verse to the art of revision, this course prepares you not only to write poetry but also to refine and share your work, culminating in practical advice on getting published. Learning Outcomes Understand the foundational principles of poetry writing. Develop skills in reading and interpreting poetry. Learn to employ poetic language and sound techniques effectively. Explore various forms and structures of poetry. Gain knowledge in editing, refining, and publishing poetry. Why choose this Poetry Writing course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the 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. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Poetry Writing course for? Aspiring poets seeking to hone their craft. Writers wanting to explore the genre of poetry. Literature students interested in poetic forms and techniques. Creative individuals seeking a new mode of expression. Anyone with a passion for words and a desire to explore poetry. Career path Poet - Variable (depending on publication and recognition) Creative Writer - £20,000 to £40,000 Literature Teacher - £25,000 to £37,000 Editor - £24,000 to £40,000 Content Creator - £20,000 to £35,000 Literary Critic - £22,000 to £45,000 Prerequisites This Poetry Writing does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Poetry Writing 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 Module 01: Introduction to Poetry Writing Introduction to Poetry Writing 00:18:00 Module 02: Reading Poetry Reading Poetry 00:21:00 Module 03: Beginning The Journey Beginning The Journey 00:15:00 Module 04: Important Details of Poetry Important Details of Poetry 00:25:00 Module 05: Poetic Language Poetic Language 00:18:00 Module 06: The Sound of Poetry The Sound of Poetry 00:24:00 Module 07: The Poet's Craft The Poet's Craft 00:14:00 Module 08: Open-Form and Closed-Form Poetry Open-Form and Closed-Form Poetry 00:22:00 Module 09: Traditional Forms of Verse Traditional Forms of Verse 00:21:00 Module 10: Vision and Revision Vision and Revision 00:19:00 Module 11: Getting Published Getting Published 00:20:00

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

Introducing Vectorworks Flex Learning: A Comprehensive Pay-As-You-Go Training Course

***Veterinary Nursing and Veterinary Assistant Diploma*** Are you passionate about animals and their care? Have you ever thought about becoming a Vet Nurse? Our Veterinary Nursing and Veterinary Assistant Diploma is designed to provide you with the knowledge and skills required to commence your career as a veterinary nurse. Enrol Today in this Veterinary Nursing and Veterinary Assistant Diploma Bundle and Turn Your Dream to Become a Veterinary Nurse into True with Apex Learning Courses included in this Veterinary Nursing and Veterinary Assistant Course Level 4 Bundle: Course 01: Veterinary Nursing Course 02: Veterinary Assistant Diploma Course 03: Animal Science Course 04: Veterinary Physiology & Psychotherapy Course 05: Animal Behaviour and Psychology Course 06: Dog Training - Natural Remedies for Health & Dog Training Course 07: Animal Care Level 3 Course Course 08: Pet First Aid Course 09: First Aid at Work Course 10: Personal Hygiene Course 11: Coronavirus (COVID-19) Awareness So enrol now in this Veterinary Nursing and Veterinary Assistant Course Diploma to advance your career! Veterinary Nursing and Veterinary Assistant Course Course Curriculum of Veterinary Nursing and Veterinary Assistant Course Course 01: Veterinary Nursing Getting to Know the Kittens and Cats Collapse & Unconsciousness Cardiopulmonary Resuscitation Shock Treatment in Veterinary Nursing Bleeding Bandaging Fractures Seizures Choking & Drowning Heat Stroke & Hypothermia Burns & Scalds Poisoning Bites & Stings Common Emergencies Managing a First Aid Scenario Pet First Aid Kit Pet CPR ---------10 more Veterinary Nursing and Veterinary Assistant related courses------- CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Veterinary Nursing and Veterinary Assistant Course for all Requirements No requirements to enrol Veterinary Nursing and Veterinary Assistant Course Career path Having this Veterinary Nursing and Veterinary Assistant 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 (Veterinary Nursing) 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